Ariba ITK Supplier's export file format

[former_member482003]

Dear experts,

we are implementing the switch-off of the SRM to adopt Ariba Procurement platform.

In order to do this we need to export supplier from ECC using Ariba ITK report /ARBA/MASTER_DATA_EXPORT .

We installed CI8 but we didn't get SupplierConsolidated.csv and SupplierLocationConsolidated.csv with the expected file format.

expected file header

1) SupplierConsolidated.csv

VendorID,SystemID,NetworkID,DUNS,CustomDomainName,CustomDomainValue,Name,Name,PurchasingUnits,AmountRoundingForInvExceptionCalculation,PaymentModel,AddressID,Street,City,Country,State,PostalCode,CorporateEmailAddress,CorporateFax,CorporatePhone,CorporateURL,PreferredCurrency,PreferredLanguage,HasSyncRelationship,HasTradingRelationship,AnnualRevenueMaximum.Amount,AnnualRevenueMaximum.Currency.UniqueName,AnnualRevenueMinimum.Amount,AnnualRevenueMinimum.Currency.UniqueName,MinorityOwned,MinorityInfo,WomanOwned,NumberOfEmployees,OrganizationType,StateOfIncorporation,YearFounded,ImportCtrl

2) SupplierLocationConsolidated.csv

VendorID,LocationID,Name,City,Street,PostalCode,Region,Country,Phone,Fax,EmailAddress,ContactName,ANPayEnabled,ContactID,PreferredOrderingMethod,PCardAcceptanceLevel,GhostPCardNumber,ChangeOrderRestrictions,AribaNetworkId,SplitOrderOnShipTo,PaymentModel,Locale

ariaba ITK result

1) SupplierConsolidated.csv

VendorID,Name,AddressID,City,Street,PostalCode,State,Country,CorporatePhone,CorporateURL,CorporateFax,PreferredCurrency,PreferredLanguage,CorporateEmailAddress,SystemID

2) SupplierLocationConsolidated.csv

VendorID,LocationID,Name,City,Street,PostalCode,Region,Country,Phone,Fax,EmailAddress

could you please suggest me about this issue?

thanks

laura

[Harish]

Hi Laura,

Please check the Ariba document

https://connect.ariba.com/connect/Downloads/HAA/docs/procurement/en/training/ext_procure/sap_integra...

as per guide (page 49)

Vendor Export Task

By default, Ariba RFCs pull only those vendors from SAP they have found associated with at least one purchasing

organization.

The parameter /ARBA/VENDOR_ONLY_COUNTPORGS provides a filtering parameter for vendor pulls. Valid settings

are 1 or 0. The default setting is 1.

● If the parameter is set to 1, the RFC selects only vendors assigned to at least one purchasing organization.

● If the parameter is set to 0, the RFC pulls all vendors without regard to any assigned purchasing organizations.

The default setting of 1 pulls a smaller set of data by executing two select statements within the RFC code. The 0

setting pulls more data, which the RFC refines further through a single selection query.

The Vendor Export task downloads information on the following:

● Supplier

● Supplier location

● Payment terms

● Remittance location

● User data

regards,

Harish

[former_member482003]

Dear Harish ,

thanks for your advice but this parameter does not affect the supplier's file edit.

best regards

Laura