ebook img

Ariba Buyer Procurement User Guide pdf PDF

191 Pages·2021·1.65 MB·English
by  
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview Ariba Buyer Procurement User Guide pdf

Ariba® Procurement Solutions Integration Guide for SAP Ariba Procure-to-Order™ Ariba Procure-to-Pay™ Release 12s December 2014 Copyright © 1996–2014 Ariba, Inc. All rights reserved. This documentation, as well as the Ariba software and/or services described in it, contain proprietary information. They are provided under a license or other agreement containing restrictions on use and disclosure and are also protected by copyright, patent and/or other intellectual property laws. Except as permitted by such agreement, no part of the document may be reproduced or transmitted in any form by any means, electronic, mechanical or otherwise, without the prior written permission of Ariba, Inc. Ariba, Inc. assumes no responsibility or liability for any errors or inaccuracies that may appear in the documentation. The information contained in the documentation is subject to change without notice. Ariba, the Ariba logo, AribaLIVE, SupplyWatch, Ariba.com, Ariba.com Network and Ariba Spend Management. Find it. Get it. Keep it. and PO-Flip are registered trademarks of Ariba, Inc. Ariba Procure-to-Pay, Ariba Buyer, Ariba eForms, Ariba PunchOut, Ariba Services Procurement, Ariba Travel and Expense, Ariba Procure-to-Order, Ariba Procurement Content, Ariba Sourcing, Ariba Savings and Pipeline Tracking, Ariba Category Management, Ariba Category Playbooks, Ariba StartSourcing, Ariba Spend Visibility, Ariba Analysis, Ariba Data Enrichment, Ariba Contract Management, Ariba Contract Compliance, Ariba Electronic Signatures, Ariba StartContracts, Ariba Invoice Management, Ariba Payment Management, Ariba Working Capital Management, Ariba Settlement, Ariba Supplier Information and Performance Management, Ariba Supplier Information Management, Ariba Discovery, Ariba Invoice Automation, Ariba PO Automation, Ariba Express Content, Ariba Ready, and Ariba LIVE are trademarks or service marks of Ariba, Inc. All other brand or product names may be trademarks or registered trademarks of their respective companies or organizations in the United States and/or other countries. Ariba Sourcing solutions (On Demand and software) are protected by one or more of the following patents, including without limitation: U.S. Patent Nos. 6,199,050; 6,216,114; 6,223,167; 6,230,146; 6,230,147; 6,285,989; 6,408,283; 6,499,018; 6,564,192; 6,871,191; 6,952,682; 7,010,511; 7,072,061; 7,130,815; 7,146,331; 7,152,043;7,225,152; 7,277,878; 7,249,085; 7,283,979; 7,283,980; 7,296,001; 7,346,574; 7,383,206; 7,395,238; 7,401,035; 7,407,035; 7,444,299; 7,483,852; 7,499,876; 7,536,362; 7,558,746; 7,558,752; 7,571,137; 7,599,878; 7,634,439; 7,657,461; and 7,693,747. Patents pending. Other Ariba product solutions are protected by one or more of the following patents: U.S. Patent Nos. 6,199,050, 6,216,114, 6,223,167, 6,230,146, 6,230,147, 6,285,989, 6,408,283, 6,499,018, 6,564,192, 6,584,451, 6,606,603, 6,714,939, 6,871,191, 6,952,682, 7,010,511, 7,047,318, 7,072,061, 7,084,998; 7,117,165; 7,225,145; 7,324,936; and 7,536,362. Patents pending. Certain Ariba products may include third party software or other intellectual property licensed from a third party. For information regarding software or other intellectual property licensed from a third party, go to http://www.ariba.com/copyrights.cfm. Ariba Procurement Solutions Integration Guide for SAP iii Revision History The following table provides a brief history of the updates to this guide. Ariba updates the technical documentation for its On Demand solutions if • software changes delivered in service packs or hot fixes require a documentation update to correctly reflect the new or changed functionality; • the existing content is incorrect or user feedback indicated that important content is missing. Ariba reserves the right to update its technical documentation without prior notification. Most documentation updates will be made available in the same week as the software service packs are released, but critical documentation updates may be released at any time. Document Version Month/Year of Update Updated Chapter/Section Short Description of Change 1 August 2012 N/A Reset revision history for release 12s 2 November 2012 Integrating Data Using Web-Services and Chapter 10 - Integrating Transactional Data Using Files Added information about the Import Invoice Status integration event that pulls information about the success or failure of an invoice in your SAP ERP system. 3 June 2013 Configuring Parameters Added information about support for BAPI_PO_CREATE1 that you can use to create purchase orders in the SAP ERP system. 4 July 2013 Integrating Data Using the Web Services Channel Added information about configuring WSDL in SAP NetWeaver PI. 5 August 2013 All Updated some chapters as a result of defect fixes 6 December 2013 Integrating Transactional Data Using File Channel Added some limitations to exporting POs, change POs and Invoices. 7 February 2014 SAP Integration - Overview Added SAP NetWeaver PI 7.4 to the list of supported versions. 8 May 2014 Integrating Transactional Data Using File Channel Added information about time-out settings for invoice exports. Also updated the section heading for time-out settings specified for receipts (Ch. 8). 9 June 2014 Account Assignment Categories In the section about account assignment category imports, added a note that the requirement setting for the default required entries is fixed. Ariba Procurement Solutions Integration Guide for SAP iv Revision History 10 August 2014 Document Type for Creating Purchase Orders Added information about creating custom document types for purchase orders. 11 December 2014 Parameters Added information about the BAPI_PO_PUSH_SECONDS_TO_WAIT and Z_ARIBA_RECEIPT_DOC_DATE parameters. Document Version Month/Year of Update Updated Chapter/Section Short Description of Change Ariba Procurement Solutions Integration Guide for SAP v Table of Contents Revision History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii Part I Introduction to Ariba Procurement Solutions - SAP Integration Chapter 1 SAP Integration - Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 About SAP Integration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Chapter 2 Configuring Ariba Procurement Solution . . . . . . . . . . . . . . . . 17 Verifying Connection Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Receiving Tolerances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Receiving System Parameters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Enabling Generation of an ERP Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Specifying the Preferred Ordering Method . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Specifying a Unique Number for Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Enabling Cancel Order Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Enabling Creation of Split Orders Based on Currency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Chapter 3 Configuring SAP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Setting Up Ariba Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Creating a User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Installing the SAP Transports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Downloading the Transport Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Installing Transport Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Running Directory Management Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Creating a Directory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Moving Files to a Directory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Renaming a Directory. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Configuring Time-out Intervals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Verifying Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Bank Selling Rate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Blank Descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Vendor Restrictions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Vendor ERS Tax Status. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Catalog Item Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Testing Connections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Ariba Procurement Solutions Integration Guide for SAP vi Table of Contents Chapter 4 Configuring NetWeaver XI/PI. . . . . . . . . . . . . . . . . . . . . . . . . . 28 Configuring the System Landscape Directory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Importing Ariba SN Product and Component Definitions . . . . . . . . . . . . . . . . . . . . . . . . 29 Configuring Technical and Business Landscape for Procurement Solutions . . . . . . . . . . 29 Configuring Technical and Business Landscape for SAP R/3 . . . . . . . . . . . . . . . . . . . . . 30 Configuring Transaction Processes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Importing the Design Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Configuring R/3 Connectivity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Configuring SAP NetWeaver XI/PI Value Mapping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Configuring Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 About Configuring Integration Scenarios in the Integration Directory . . . . . . . . . . . . . . . . . . 35 Configuring an Integration Scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Transferring Integration Scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Configuring the Integration Scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Configuring Communication Channels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Transferring the Integration Scenario in SAP NetWeaver PI 7.1 and 7.11. . . . . . . . . . . . 38 Configuring the Integration Scenario in SAP NetWeaver PI 7.1 and 7.11 . . . . . . . . . . . . 38 Integration Scenario Parameter Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 Configuring NetWeaver XI/PI for Web Services Integration. . . . . . . . . . . . . . . . . . . . . . . . . . 41 Generation of keys for signing of NetWeaver XI/PI messages. . . . . . . . . . . . . . . . . . . . . 41 Configuration for Inbound Messages Received by NetWeaver XI/PI . . . . . . . . . . . . . . . 42 Part II Integrating Master Data Chapter 5 Integrating Master Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 About Master Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Importing Master Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Required Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Importing Payment Terms. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Company Code Import RFC Example. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 Customizing RFC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 About Extension Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Adding Fields to Extension Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 Typical Extension Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 Filtering Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Static Filtering. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 ABAP Filtering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 Post-Hook Filtering. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 Master Data Integration Events . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Understanding the Master Data Import. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Running the Master Data Import Event . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Checking Output CSV Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Importing Data in Multiple Languages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Master Data Integration Through Web Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 Enabling Master Data Integration Through Web Services . . . . . . . . . . . . . . . . . . . . . . . . 63 Chapter 6 Configuring Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 About ZARIBTVARV . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Ariba Procurement Solutions Integration Guide for SAP vii Table of Contents Parameter Descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Days Past Parameter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Minority Vendor Head Offices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Currency Conversion Rates. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Internal Order Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Vendor Pull Filtering. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Using General Ledger Balance Sheet Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Language for Texts Parameter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Allow Duplicates for Invoice . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Document Type for Creating Expense Report Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Document Type for Creating OK-to-Pay Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Chapter 7 Account Assignment Categories. . . . . . . . . . . . . . . . . . . . . . . 71 About Account Assignment Categories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 Account Assignment Category Imports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Configuring Account Assignment Categories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Understanding Ariba Procurement Solutions Accounting Types . . . . . . . . . . . . . . . . . . . 72 Configuring SAP Accounting Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Understanding Field Status Group Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Viewing Field Status Group Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Importing New Accounting Objects From SAP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Part III Integrating Transactional Data Using Web Services Chapter 8 Integrating Data Using the Web Services Channel . . . . . . . . . 79 About Transaction Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Typical Integration Event Process Flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Understanding SOAP URLs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 Understanding WSDLs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 Configuring WSDL in SAP NetWeaver PI. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Formatting Dates. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 Components of an Integration Event . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Advanced Pricing Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 Scheduled Task for PurchaseOrdHeaderStatusImport . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Scheduled Task for RemittanceImport . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Scheduled Task for ReceiptExport . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Integrating Purchase Orders. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Payment Terms Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Integrating Changed and Canceled Purchase Orders. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Importing Requisitions Using Web Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92 Enabling Import of Requisitions Using Web Services . . . . . . . . . . . . . . . . . . . . . . . . . . . 92 Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Using Import of Requisitions Through Web Services . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Managing Import of Requisitions Through Web Services . . . . . . . . . . . . . . . . . . . . . . . . 95 Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Ariba Procurement Solutions Integration Guide for SAP viii Table of Contents Integrating Receipts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 About Filtering and Customer Exit Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 Modifying Customer Packages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98 Extension Structures for Export Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98 Understanding Screen Field Mappings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98 Mapping Fields for Receipts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Changing and Removing Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102 Integrating Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 About Payment Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Integration Events for Exporting Payment Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Importing Payment Terms. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 Integrating Remittance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 Integrating Amount-Based Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 Customizing Existing Integration Events. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 Chapter 9 Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 System-Level Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108 Part IV Integrating Transactional Data Using File Channel Chapter 10 Integrating Transactional Data Using File Channel. . . . . . . 112 Transactional Data Integration Event Process Flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112 Configuration Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 Configuring the Options File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 Scheduling Data Transfer Tool . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 Transaction Data Integration Event Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 Advanced Pricing Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 Exporting Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Running the Purchase Order Export Event. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120 Exporting Change Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120 Running the Change Purchase Order Export Event . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Payment Terms Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Exporting Cancel Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 Running the Cancel Purchase Order Export Event. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 Importing Purchase Order Header Status. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Running the Purchase Order Header Status Import . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Exporting Receipts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Running the Receipts Export Event . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Filtering and Customer Exit Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 Exporting Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Understanding Payments Export . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Running the Payment Export . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128 Program Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129 Accommodating Custom Fields. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130 Ariba Procurement Solutions Integration Guide for SAP ix Table of Contents Calling the SAP BAPI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130 Checking for Duplicate Invoices. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130 Posting Special Charges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130 Jurisdiction Codes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Document Type Determination. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Custom Process Invoice Routine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Scheduling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Program Limitation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Exporting Invoice. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132 Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132 Running the Payments Export Event . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132 Accommodating Custom Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 Calling the SAP RFC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134 Scheduling. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 Exporting Expense Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 Understanding the Expense Report Export . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 Running the Expense Report Export . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137 Program Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138 Accommodating Custom Fields. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 Calling the SAP BAPI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 Checking for Duplicate Invoices. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 Determining Document Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 Offset Entry for Company Paid expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Calculating the Gross Amount . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Changing INVOICE_IND. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Custom Process ER Routine. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Scheduling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 Importing Remittance Advice . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 Understanding the Remittance Data Pull . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 Running the Remittance Data Import Event. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 Checking Output CSV Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142 Additional Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 Accommodating Custom Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 Chapter 11 Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144 Part V Reference Information Appendix A Integration Events Reference . . . . . . . . . . . . . . . . . . . . . . . 148 Common Integration Events . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 Integration Events . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 Appendix B Ariba SAP Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152 Naming Conventions for Ariba SAP Objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153 Summary of Ariba SAP Packages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153 Ariba Procurement Solutions Integration Guide for SAP x Table of Contents ZAR6 Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154 Function Groups and Modules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 Data Elements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 Message Class. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 ZARC Package. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159 Function Groups and Modules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159 Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160 ZARIBA_SSP_INVOICE Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Function Groups and Modules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 Includes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 ZARIBA_SSP_CUSTINVOICE Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 Dictionary Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 Includes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 ZARIBA_SSP_REMITTANCE Package. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Dictionary Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Includes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 ZARIBA_SSP_CUST_REMITTANCE Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Dictionary Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Includes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 ZARIBTVARV RFC Reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166 ZARIBA_MASTER_DATA Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 ZARIBA_MASTER_DATA Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 ZARIBA_MASTER_DATA Data Elements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 ZARIBA_MASTER_DATA Message Class. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 ZARIBA_PO_PUSH Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170 ZARIBA_PO_PUSH Function Group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170 ZARIBA_PO_PUSH Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170 ZARIBA_CUST_PO_PUSH Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 ZARIBA_CUST_PO_PUSH Function Group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 ZARIBA_CUST_PO_PUSH Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 ZARIBA_CHANGEORDER Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172 ZARIBA_CHANGEORDER Function Group. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172 ZARIBA_CHANGEORDER Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172 ZARIBA_CUST_CHANGEORDER Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 ZARIBA_CUST_CHANGEORDER Function Group. . . . . . . . . . . . . . . . . . . . . . . . . . 173 ZARIBA_CUST_CHANGEORDER Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 ZARIBA_GR_PUSH Package. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 ZARIBA_GR_PUSH Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 ZARIBA_CUST_GR_PUSH Function Group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175 ZARIBA_ER_PUSH Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176 ZARIBA_ER_PUSH Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176 ZARIBA_ER_CUST_PUSH Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177 ZARIBA_ER_CUST_PUSH Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177 ZARIBA_INVOICE Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178 ZARIBA_INVOICE Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178 Ariba Procurement Solutions Integration Guide for SAP xi Table of Contents ZARIBA_CUST_INVOICE Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179 ZARIBA_CUST_INVOICE Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179 ZARIBA_FILE_CHANNEL Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180 ZARIBA_FILE_CHANNEL Function Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180 ZARIBA_CUST_FILE_CHANNEL Package. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 182 Appendix C About SAP Transports . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 Overview of SAP Transports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 Delivered Transport Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 Location of Transport Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 Transport Installation Instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184 Import Considerations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184 Transport Description Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 Base Functionality Transport . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186 Ariba Procurement Solutions Integration Guide for SAP 12 Part I Introduction to Ariba Procurement Solutions - SAP Integration Part I of this book provides information that is common to - SAP integration using Web Services as well as File based integration. Part 1 includes the following chapters: • Chapter 1, “SAP Integration - Overview” • Chapter 2, “Configuring Ariba Procurement Solution” • Chapter 3, “Configuring SAP” • Chapter 4, “Configuring NetWeaver XI/PI” Ariba Procurement Solutions Integration Guide for SAP 13 Chapter 1 SAP Integration - Overview • “About SAP Integration” on page 13 About SAP Integration The integration between Ariba procurement solutions and SAP system supports the exchange of both master and transaction data. You can enable this integration of data either through file or Web Services. File-Based Integration File-based integration is enabled using Ariba Integration Toolkit that allows integration of master data and transactional data with the SAP R/3 system. Ariba Integration Toolkit is an Ariba-developed middleware that consists of the Data Transfer Tool and DB Connector. The Ariba Integration Toolkit enables data exchange in the following scenarios: Ariba Procurement Solutions to SAP R/3 1 The Data Transfer Tool downloads transactional data from Ariba procurement solutions to the configured location on your file system. The data from Ariba procurement solutions is exported in the form of CSV files that are generated for each integration event that you run. 2 When the ABAP program provided by Ariba is scheduled to run in SAP, it reads the downloaded CSV files from the file system and uploads the data to the SAP R/3 system. SAP R/3 to Ariba Procurement Solutions 1 When the ABAP program provided by Ariba is scheduled to run in SAP, it downloads master and transaction status data from the SAP R/3 system to the configured location on your file system. The data is downloaded in the form of CSV files. 2 The Data Transfer Tool reads the downloaded CSV files from the file system and uploads the data to the Ariba procurement solutions database. The following graphics illustrate the integration of master and transactional data on file-based integration. Ariba Procurement Solutions Integration Guide for SAP 14 Chapter 1 SAP Integration - Overview About SAP Integration Master Data - File-Based Integration 1 The ABAP program provided by Ariba downloads master data from SAP R/3 in the form of CSV files. 2 The Data Transfer Tool then reads these CSV files and uploads data into Ariba Procurement Solutions. Transactional Data - File-Based Integration 1 The Data Transfer Tool exports data from Ariba Procurement Solutions in the form of CSV files. 2 The ABAP program provided by Ariba then read these CSV files and transfers data to the SAP R/3 system. 3 The ABAP program provided by Ariba then retrieve the status of each export transaction from the SAP R/3 system. 4 The Data Transfer tool reads these CSV files and uploads the status into Ariba procurement solutions. Ariba Procurement Solutions Integration Guide for SAP 15 Chapter 1 SAP Integration - Overview About SAP Integration Web Services Based Integration Web Services based integration also allows integration of master data and transactional data. However, master data integration is not complete and allows you to import only some master data. The following diagram illustrates the integration between Ariba procurement solutions and SAP R/3 using Web Services. • The Web Services provide for real-time integration of the Ariba procurement solutions with SAP R/3 systems using NetWeaver XI/PI. The integration using NetWeaver XI/PI is built out of the box. If you want to use any other application system through a SOA supporting middleware, then you will have to build your integration. • When an object is created in a procurement solution, which is configured to be sent to SAP, the Web Services generate a SOAP message based on the WSDL and dispatches it to a Web Services server such as NetWeaver XI/PI using the URL configured through the Ariba Administrator. • NetWeaver XI/PI is configured to receive SOAP messages using the SOAP adapter. It transforms the data using the messaging mapping and converts the SOAP message to SAP format (typically RFC). The RFC adapter then transmits the information to SAP R/3 system based on the configuration. • In SAP R/3, data is created using RFC/BAPI and the response (Success or failure) is sent back to XI, which again transforms the data and sends it back to the Ariba procurement solutions through the Web Services. The response is then updated in the respective procurement solution. Supported Versions and Integration Landscape The integration of Ariba procurement solutions is supported with the following SAP R/3 versions: • 4.7 • 5.0 • 6.0 In case of web services-based integration between Ariba Procurement Solutions and SAP R/3, the following SAP NetWeaver PI versions are supported: • 7.0 • 7.1 • 7.3 • 7.4

See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.