Ariba Buyer Procurement User Guide pdf

191 Pages·2021·1.65 MB·English

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