Skip to Content
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:

https://help.sap.com/viewer/2954d1bdf6b21014bd37819088d5b210/2008/en-US/edb18a5507b04126bc7f580063c227b2.html

 

2 Comments
You must be Logged on to comment or reply to a post.
    • 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