/ARBA/MASTER_DATA_EXPORT using this program we can upload master data to ARIBA Cloud from ECC
- The program /ARBA/MASTER_DATA_EXPORT should be set up to run on a desired schedule to extract information from the relevant SAP tables for the objects
- The output of the program is a .CSV file containing the information necessary for the update
- The file automatically transmitted to the Ariba on -Demand application through an HTTP post
- The file is received by the Ariba on-demand application processed by a receiving job that is triggered at the time the data is transmitted( Immediate processing in Ariba)
- The values in Ariba on -Demand are updated with any errors noted in the processing log of the Ariba on-Demand administration console
- Full load
- Incremental Load
Following data can be transferred to Ariba Cloud
- General ledger
- InternalOrder
- Costcenter
- Wbselement
- Asset
- Supplier related data
- Remittance location
- Purchaseorg
- User related data
- User and User group
- Companycode
Overview for multiple systems:
To differentiate Master Data from all the ERP(ECC) systems , We have to do prefix specific to system for the following data
Example : Supplier Number : 123456 , if we add prefix to suppplier it will be – ERP1_123456 like wise , we have to do for each and every system..
- General ledger
- InternalOrder
- Costcenter
- Wbselement
- Asset
- Supplier related data
- Remittance location
- Purchaseorg
- User related data
- User and User group
- Companycode
- Plant
How to do a prefix for master data ?
Following BADI will be implemented, prefix will be added in the runtime, send the data to Ariba
This Badi has multiple methods
each method is relevant for specific data like Company code , Plant …using this methods we can enhance and prefix the master data
Example : prefixing Vendor Purchase group information
Code :
Data :lt_SYSTID_MAP type STANDARD TABLE OF /ARBA/SYSTID_MAP,
ls_SYSTID_MAP type /ARBA/SYSTID_MAP,
ls_vendor_info type /arba/vendor,
ls_vendor_PORG_INFO type /arba/vendor_Po,
lv_lifnr(20) type c,
lv_lifnr1(20) type c,
lv_ekorgx(20) type c,
lv_namex(50) type c,
lv_purcsx(20) type c,
lv_sidx(20) type c,
lv_tbix type sy-tabix,
lv_system(4) type c,
lv_value TYPE tvarv_val,
lv_name TYPE rvari_vnam VALUE 'ERP_ID'.
SELECT SINGLE low " will read value from buffer
INTO lv_value
FROM tvarvc
WHERE name = lv_name.
IF sy-subrc = 0.
lv_system = lv_value.
ENDIF.
CLEAR : lv_lifnr,lv_namex.
LOOP AT vendor_info[] INTO ls_vendor_info.
lv_tbix = sy-tabix.
CONCATENATE lv_system ls_vendor_info-lifnr INTO
lv_lifnr.
CONCATENATE lv_system ls_vendor_info-name1 INTO
lv_namex.
CONCATENATE lv_system ls_vendor_info-systemid INTO
lv_sidx.
ls_vendor_info-lifnrx = lv_lifnr.
ls_vendor_info-namex = lv_namex.
ls_vendor_info-sidx = lv_sidx.
MODIFY vendor_info from ls_vendor_info INDEX lv_tbix.
ENDLOOP.
LOOP AT vendor_PORG_info[] INTO ls_vendor_porg_info.
lv_tbix = sy-tabix.
CONCATENATE lv_system ls_vendor_porg_info-lifnr INTO
lv_lifnr.
CONCATENATE lv_system ls_vendor_porg_info-ekorg INTO
lv_ekorgx.
ls_vendor_porg_info-lifnrx = lv_lifnr.
ls_vendor_porg_info-ekorgx = lv_ekorgx.
MODIFY vendor_porg_info from ls_vendor_porg_info INDEX lv_tbix.
ENDLOOP
Conclusion : This way , We can send multiple ERP system data to ARIBA Cloud .