XML and XBRLcompliant SAP R/3 Systems Paul Sheldon Foote California State University, Fullerton SAP Congress, February 2001 Paul Sheldon Foote
Paul Sheldon Foote Department of Accounting California State University, Fullerton PO Box 6848 Fullerton, CA 92834 -6848 (714) 278 -2682 pfoote@fullerton. edu http: //business. fullerton. edu/pfoote http: //business. fullerton. edu/sap SAP Congress, February 2001 Paul Sheldon Foote 2
Focus w Identify how SAP and third party vendors are implementing XML and XBRL-compliant systems w Suggest research opportunities SAP Congress, February 2001 Paul Sheldon Foote 3
SAP Congress, February 2001 Paul Sheldon Foote 4
XML w Extensible Markup Language w In 1999, SAP added XML as a format for data interchange across its SAP Business Framework w XML, a meta language, provides developers with a standard way to describe data containers, enabling exchanges with non-SAP applications SAP Congress, February 2001 Paul Sheldon Foote 5
XML 2 w Eliminates the need for custom translation code w Capable of accessing SAP’s Business APIs (BAPIs) w SAP will enable all of its major interfaces with XML w SAP Business-to-Business Procurement: example of product using XML SAP Congress, February 2001 Paul Sheldon Foote 6
XML 3 w SAP’s goal is to make all IDOCS available in XML format w With IDOCS in XML format, it will be easier to integrate SAP R/3 with legacy and with non-SAP systems SAP Congress, February 2001 Paul Sheldon Foote 7
SAP’s XML SEC filing www. secinfo. com - <filer>- <company-data> <conformed-name>SAP AKTIENGESELLSCHAFT SYSTEMS APPLICATIONS PRODUCTS IN DATA</conformed-name> <cik>000184</cik> <assigned-sic>7372</assigned-sic> <irsnumber>00000</irs-number> <state-ofincorporation>I 8</state-of-incorporation> <fiscalyear-end>1231</fiscal-year-end> SAP Congress, February 2001 Paul Sheldon Foote 8
IBM’s Visual Age for Java w SAP has agreed to use IBM’s Visual Age for Java development tool for implementing business-to-business data interchange w This will provide Java. Bean interfaces into SAP’s BAPIs w Server-side Java and XML integration for SAP R/3 systems SAP Congress, February 2001 Paul Sheldon Foote 9
IBM’s Visual Age for Java 2 w With SAP’s BAPIs available through IBM Component Broker middleware, many tool vendors will be able to connect to SAP R/3 systems via open rather than proprietary systems SAP Congress, February 2001 Paul Sheldon Foote 10
SAP Congress, February 2001 Paul Sheldon Foote 11
XBRL w Extensible Business Reporting Language w Custom markup language based upon XML w Being added to accounting and financial reporting software SAP Congress, February 2001 Paul Sheldon Foote 12
XBRL 2 w XBRL-compliant software automatically and transparently translates numbers and words for viewing of segments in Web browsers, spreadsheets, and in other application software SAP Congress, February 2001 Paul Sheldon Foote 13
XBRL 3 w Faster distribution of financial information w Eliminate rewrites of financial reports w Faster and better Internet searches – Find desired XBRL-tagged data, not thousands of useless “hits” w Drill down w Minimize reentering data SAP Congress, February 2001 Paul Sheldon Foote 14
XBRL Components w XBRL taxonomy w Database tables and maps w Customized XBRL tags w XBRL instance documents SAP Congress, February 2001 Paul Sheldon Foote 15
XBRL Security w Security features are not built into XBRL SAP Congress, February 2001 Paul Sheldon Foote 16
XBRL Steering Committee w Not-for-profit corporation started by the American Institute of Certified Public Accountants (AICPA) w SAP is a member w XBRL specifications w http: //www. xbrl. org SAP Congress, February 2001 Paul Sheldon Foote 17
w XBRL Taxonomy Viewer w XBRL Taxonomy Builder w XBRL Instance Validator w XBRL Instance Creator w XBRL Extractor w XBRL DOM – A DLL SAP Congress, February 2001 Paul Sheldon Foote 18
w XBRL Lists and Enumeration Services w Training w XBRL Taxonomy Creation w XBRL Financial Statement Creation w XBRL Style Sheet Creation w Financial Information Conversion and Financial Reporting SAP Congress, February 2001 Paul Sheldon Foote 19
w http: //xbrlsolutions. com w Web site includes additional documentation authored by Charles Hoffman SAP Congress, February 2001 Paul Sheldon Foote 20
SAP Congress, February 2001 Paul Sheldon Foote 21
SAP R/3 Before the Internet w Within a single firm, SAP R/3 ended the problem of “islands of information. ” SAP Congress, February 2001 Paul Sheldon Foote 22
SAP Business Framework w SAP supports XML as a data format for data interchange across the entire SAP Business Framework w Support of XML enables SAP R/3 to use the Internet to pass messages to receiving applications having no prior knowledge of the data formats contained in the messages SAP Congress, February 2001 Paul Sheldon Foote 23
SAP’s Business APIs (BAPIs) w XML enables access to SAP’s Business APIs (BAPIs) without custom translation code SAP Congress, February 2001 Paul Sheldon Foote 24
SAP Congress, February 2001 Paul Sheldon Foote 25
SAP Business-to-Business Procurement w Web-based “requisition-order-payment” solution w Use as part of R/3 or as a stand-alone component interfacing to R/3 or to legacy systems w Little or no training to use Web front end w Real-time supplier integration SAP Congress, February 2001 Paul Sheldon Foote 26
SAP OLAP Consolidation w SAP has no current plans to build XBRL functionality into applications w Instead, all XBRL-tagged data will be collected in SAP’s Business Information Warehouse (BW) for use by applications w XBRL support will be in SAP’s OLAP Consolidation Tool (Cons. Tool), a tool built into SAP-BW SAP Congress, February 2001 Paul Sheldon Foote 27
SAP’s XBRL Templates (a future possibility? ) w Reporting w Financial Consolidation w Modeling w Simulation w Planning w Budgeting SAP Congress, February 2001 Paul Sheldon Foote 28
SAP Congress, February 2001 Paul Sheldon Foote 29
w Java and XML-Based wireless applications for SAP R/3 w EPIConnect: Warehouse Edition w Developed using Epic Data’s e. Xpresso development environment (XML and Java technologies) w Operating system independence for servers and mobile devices SAP Congress, February 2001 Paul Sheldon Foote 30
w Development for all major server operating systems, including: Windows, Unix, Linux w Development for all major mobile device operating systems, including: DOS, Windows CE, Palm SAP Congress, February 2001 Paul Sheldon Foote 31
w Automatic data collection (ADC) solutions for SAP R/3 customer installations w EPIConnect controls the flow of material from the receiving dock to the shipping bay w Workers with no SAP R/3 training can enter data into SAP R/3 SAP Congress, February 2001 Paul Sheldon Foote 32
Intermec Technologies Corporation w RF Hand Held Data Collection Computer used by Epic Data w Weighs under 1 pound w European and Asian character sets available SAP Congress, February 2001 Paul Sheldon Foote 33
Intermec Technologies Corporation 2 w Send and receive real time data with 2. 4 GHz radio w Develop applications with Microsoft C/C++ SAP Congress, February 2001 Paul Sheldon Foote 34
Intermec Technologies Corporation 3 w Configurations – Terminal emulation – Client/server – Web-enabled for integration into HTML applications SAP Congress, February 2001 Paul Sheldon Foote 35
Intermec Technologies Corporation 4 w Data collection applications – Time & Attendance – Shipping/Receiving – Picking and Pricing SAP Congress, February 2001 Paul Sheldon Foote 36
SAP Congress, February 2001 Paul Sheldon Foote 37
w “We want to put ERP into every facet of our business from development through manufacturing to the maintenance, repair, and overhaul market. ” --Mike Paul, Pratt &Whitney ERP director SAP Congress, February 2001 Paul Sheldon Foote 38
w SAP host computer in Connecticut w Epic Data’s ADC server in Singapore w Intermec hand held w Data travels 14, 000 miles each way in less than 2 seconds SAP Congress, February 2001 Paul Sheldon Foote 39
w Aircraft engines worth more than $5 million can be assembled from more than 2, 000 unique part numbers in 8 days, instead of 6 weeks w Single instance of SAP R/3 SAP Congress, February 2001 Paul Sheldon Foote 40
w All worldwide data now resides in one location w Over 20 – 30 years for each engine have: – How part manufactured – Tests performed – Quality issues SAP Congress, February 2001 Paul Sheldon Foote 41
w Manufacturer of highquality plumbing fixtures w Fine furniture w Cabinetry and tile w Small engines and generators SAP Congress, February 2001 Paul Sheldon Foote 42
w SAP R/3 w Epic Data for automated data collection for SAP R/3 w Intermec Antares hand -held terminals SAP Congress, February 2001 Paul Sheldon Foote 43
w At month-end processing, pull data from SAP via Epic Data system to work offline with Intermec terminals while SAP R/3 is unavailable w Can continue to pack and close shipments SAP Congress, February 2001 Paul Sheldon Foote 44
SAP Congress, February 2001 Paul Sheldon Foote 45
Continuous Auditing w Real-time processing of transactions w Real-time auditing SAP Congress, February 2001 Paul Sheldon Foote 46
Continuous Auditing 2 w Reduce time for existing audits? w Increase audits in same amount of time? w Reduce insurance costs for liabilities of CPA firms? w Less overtime to meet reporting deadlines? SAP Congress, February 2001 Paul Sheldon Foote 47
Value Added Services w Direct communication to stakeholders – – – Shareholders Analysts Investors Employees General information on Web sites w Regulatory reporting (SEC) w Tax reporting (IRS) SAP Congress, February 2001 Paul Sheldon Foote 48
my. SAP. com Internet-Business Framework w Open Internet standards (such as XML and HTTP) combined with SAP R/3’s scalable, high-performance architecture w SAP’s Web. Flow technology for business communities is based upon XML-enabled Business Objects w Information exchange between companies via XML messages SAP Congress, February 2001 Paul Sheldon Foote 49
my. SAP. com Marketplace w Instead of using independent buying and selling systems, companies may purchase or use my. SAP. com Marketplace w An example of a live marketplace using my. SAP. com Marketplace is http: //www. neoforma. com SAP Congress, February 2001 Paul Sheldon Foote 50
w Global electronic business-to-business supply chain exchange for the healthcare industry w Supply chain processes cost the medical industry $23 billion annually w Automating the supply chain could reduce annual costs by $12 billion SAP Congress, February 2001 Paul Sheldon Foote 51
SAPMarkets, Inc. w SAPMarkets, Inc. is SAP’s subsidiary for evolving my. SAP. com e-business applications into e-marketplace services w Covisint, an XML-based buying system started by General Motors, Ford, and by Daimler. Chrysler, has encountered selling side automotive exchanges led by Robert Bosch GMBH and others SAP Congress, February 2001 Paul Sheldon Foote 52
SAPMarkets, Inc. 2 w With Commerce One, SAPMarkets is already offering Market. Set and Enterprise. Buyer w Commerce One and NEON (New Era of Networks, Inc. ) are delivering an XMLbased connector for SAP R/3 integrating Commerce One’s Buysite 6. 0 SAP Congress, February 2001 Paul Sheldon Foote 53
my. SAP. com Strategic Enterprise Management (SEM) w Original foundations: – my. SAP. com Internet-Business Framework – Business Application Programming Interface (BAPI) SAP Congress, February 2001 Paul Sheldon Foote 54
my. SAP. com Strategic Enterprise Management (SEM)2 w Business Planning and Simulation w Business Consolidation and Sourcing w Business Information Collection w Corporate Performance Monitor w Stakeholder Relationship Management SAP Congress, February 2001 Paul Sheldon Foote 55
SAP SRM w SAP SRM (Stakeholder Relationship Management) function w Value-based management via communications with employees, investors, analysts, customers, and suppliers SAP Congress, February 2001 Paul Sheldon Foote 56
my. SAP. com Business Intelligence w Real-time Web-enabled analytical reporting w Reporting Agent runs queries in the background with exceptional conditions reported as HTML elements SAP Congress, February 2001 Paul Sheldon Foote 57
Custom Markup Languages w Mathematical Markup Language (Math. ML) w Chemical Markup Language (CML) w Wireless Markup Language (WML) w Synchronized Multimedia Markup Language (SMIL) w Scalable Vector Graphics Markup Language (SVG) SAP Congress, February 2001 Paul Sheldon Foote 58
Custom Markup Languages 2 w Bean Markup Language (BML) w Extensible 3 D (X 3 D) w Bank Internet Payment System (BIPS) w Electronic Business XML (eb. XML) w Visa XML Invoice Specification w Commerce XML (c. XML) w Legal. XML SAP Congress, February 2001 Paul Sheldon Foote 59
Custom Markup Languages 3 w News. ML w Open e. Book Publication Structure w Extensible User Interface Language (XUL) w Research Information Exchange Markup Language (RIXML) w Voice. XML w Vector Markup Language (VML) SAP Congress, February 2001 Paul Sheldon Foote 60
Custom Markup Languages 4 w Product Data Markup Language (PDML) w Financial Products Markup Language (Fp. ML) w XML Metadata Interchange (XMI) w Trading Partner Agreement Markup Language (tpa. ML) SAP Congress, February 2001 Paul Sheldon Foote 61
Custom Markup Languages 5 w Small to Medium Business XML (SMBXML) w Financial Information Exchange Markup Language (Fix. ML) SAP Congress, February 2001 Paul Sheldon Foote 62
Скачать презентацию XML and XBRLcompliant SAP R 3 Systems Paul Sheldon
51f5358504e79906ac316ad7c3b50cfa.ppt