Technical Articles
How to find the SAP ECC database table related to ARIBA Master data extraction files
Objective:
Often when we start to make build plan for ARIBA master data setup we struggle to find the related database tables in SAP ECC . In this blog we will learn how to find the SAP ERP database table for ARIBA master data extraction. Here our requirement is to extract company codes master data into ARIBA Procurement solution relevant to specific countries. Our motive is to restrict company code master extract to particular countries: United States(US) and Canada(CA).
Background information:
Master data consists of general information from SAP ECC that is used in the Ariba procurement solutions to construct business documents such as requisitions, receipts, and invoices.
There are several integration scenarios possible but here we consider the direct connectivity:
Integrate master data through the Direct Connectivity Integration method from an SAP system to an Ariba procurement solution system more efficiently using the interface in the /ARBA/MASTER_DATA_EXPORT program. This program offers static filter as one of the ways to restrict the data included in a data import. Other ways are ABAP filtering and Post-hook filtering.
Static filtering:
Performing static filtering on data pulls through TVARV-like selection options. It allows us to construct conditional searches of SAP ERP tables according to the values of specified fields. The table/view /ARBA/TVARV (ARBCIG_TVARV) allows you to construct queries to limit the data you import from SAP ERP into the Ariba Procurement Solution.
The following table lists the SAP remote function calls (RFCs) and the CSV files they generate for each data import task.
Note: In case you have ARIBA CIG implemented replace /ARBA/ with ARBCIG_ while searching for the RFC function:
RFC Function Used in SAP ECC | Generated CSV File in ARIBA |
/ARBA/COMPANY_CODE_EXPORT | CompanyCode.csv |
/ARBA/PLANT_EXPORT | Plant.csv |
ARBA/PURCHASE_ORG_EXPORT | PurchaseOrg.csv |
ARBA/PURCHASE_GROUP_EXPORT | PurchaseGroup.csv |
/ARBA/PLANT_PURCHASE_EXPORT | PlantPurchaseOrgCombo.csv |
/ARBA/ASSET_EXPORT | Asset.csv |
/ARBA/COST_CENTER_EXPORT | CostCenter.csv |
/ARBA/GENERAL_LEDGER_EXPORT | GeneralLedger.csv |
/ARBA/INTERNAL_ORDER_EXPORT | InternalOrder.csv |
/ARBA/WBS_EXPORT | WBSElement.csv |
/ARBA/ACCOUNT_CATEGORY_EXPORT | AccountCategory.csv |
/ARBA/ACCOUNT_FIELD_EXPORT | AccCategoryFieldStatus Combo.csv |
/ARBA/INTERNAL_ORDER_EXPORT | CompanyCodeIOCombo.csv |
/ARBA/WBS_EXPORT | CompanyCodeWBSCombo.csv |
/ARBA/MATERIAL_GROUP_EXPORT | ERPCommodityCode.csv |
/ARBA/CURRENCY_CONVERT_EXPORT | CurrencyConversion Rate.csv |
/ARBA/VENDOR_EXPORT | PurchaseOrgSupplierCombo.csv |
SupplierConsolidated.csv | |
SupplierLocationConsolidated.csv | |
RemittanceLocationConsolidated.csv | |
/ARBA/SUPPLIER_LOCATION_EXPORT | SupplierLocationConsolidated.csv |
/ARBA/PAYMENT_TERM_EXPORT | PaymentTermsConsolidated.csv |
/ARBA/REMITTANCE_LOCATION_EXPORT | RemittanceLocationConsolidatedExport.csv |
/ARBA/USER_EXPORT | UserConsolidated.csv |
/ARBA/USER_GROUP_EXPORT | GroupConsolidated.csv |
/ARBA/TAX_CODE_EXPORT | TaxCode.csv |
Overall Process:
You have to collect the information you need to build your static filter restricting the master data export:
- Step1: The Ariba Procurement Solution RFC that imports the company code master data
/ARBA/COMPANY_CODE_EXPORT
- Step2: The column that contains the data (and the table)
T001
- Step3: Build the query for the data set you want to return
(LAND1 = “US”) OR (LAND1 = “CA”)
Detailed Steps:
Step1: To find the table name which is relevant to extract company code information using RFC function as the start point.
Go to TCODE: SE37 Enter function name: /ARBA/COMPANY_CODE_EXPORT
We found Database Table used is T001
Step2: To find the field name to restrict the data set with country key from table found in Step 1.
Go to TCODE: SE16 Enter Table Name: T001
Double click the table name “t001” in the select statement from step 2 or use TCODE: SE16) to open the data dictionary information. When we check the table structure T001 it contains an entry called LAND1 which holds the country code.
Step3: To Build the query for the data set you want to return
In this example, we want to import rows where country or LAND1 is equal to US or CA.
We would denote query as: (LAND1 = “US”) OR (LAND1 = “CA”)
Now we are ready to with our static filter query and save the entries in table view /ARBA/TVARV (ARBCIG_TVARV)
Go to TCODE: SM30 Enter View Name: /ARBA/TVARV
Click on New Entries option and fill the following information:
Variable Name | Field name | Selection cat. | Number | INCL/EXCL | Option | Selection value |
COMPANY_CODE_EXPORT | LAND1 | S | 1 | I | EQ | US |
COMPANY_CODE_EXPORT | LAND1 | S | 2 | I | EQ | CA |
The fields in the VARIABLE NAME column indicate this filter is for the data imported by the RFC ARBCIG_ COMPANY_CODE_EXPORT.
The fields in the FIELD NAME column indicate you are importing data from the LAND1 column.
The fields in the SELECTION CATEGORY column specify to the calling function that the row is for filtering, or selecting, data. In this case, the S specifies static filtering.
The fields in the NUMBER column include more than one row of the same filtering table in the condition. It starts at zero, or 0000. The order is not significant.
The fields in the INCL/EXCL column indicate whether to exclude the condition from the statement or include it, signified by I or E. I to indicate include
The fields in the OPTION column determine that you’re selecting for a condition of equality (EQ).
The fields in the SELECTION VALUE column determine that you’re selecting for a particular value of the field specified in FIELD NAME, US and CA in our case
Resources:
Hi
Thanks for blog, can you help me on how or from where i can download /ARBA/MASTER_DATA_EXPORT program.
HI Satheesh,
Please go to your SAP ECC system, depending on whether you have CIG(ARBCIG_MASTER_DATA_EXPORT) or CI (/ARBA/MASTER_DATA_EXPORT ) you can search the program in Tcode: SE38.
Thanks
Manidipa
Hi Manidipa,
are you familiar with this issue? /ARBA/MASTER_DATA_EXPORT it is failing after SAP refresh. We restored missing RFCs in SM59 and corrected SLDAPICUST.
thanks
Hi Manidipa,
So far I saw many blogs talking about sending data from ECC/S4 to ARIBA, But my requirement is to get data from ARIBA to BW. Some people talked about SAP DI,CPI etc, We don't have license for that, So is it possible to extract the data from ARIBA to BW/ECC using ABAP. Could you please help to shed some light here?