Master Data Reconcilitaion from ECC to BI

[Former Member]

Hi,

How can the master data be validated between ECC and BI.

Appreciate any inputs.

Thanks,

Chaitu

[Former Member]

you can check the data in the master data tables on the ECC side with the content in infocube or dso or any other data target on the bw side.you can also use created on field present on the ecc side if reconciliation of data has to be done for a certain period of time may be from may to july or something like this.

[Former Member]

You can check the data in underline tables through Se12 transcation or give the name of the datasource in RSA3 transcation & extarct the data in R3

[Former Member]

Resolved

[Former Member]

hi Chaitu,

very generic question. you can get details from SAP Help documentation or by searching the forums.

MD in BW could be reconciled against MD tables in ECC like KNA1 (cust MD), LFA1 (Vendor MD), MARA (Material MD), CSKS (Cost Center MD), SKA1 (GL Account MD).

[Former Member]

Hi Chaitu,

Please check the forum before posting, to save on effort.

You can validate the data by extracting data in RSA3 (Ecc side) for the extractor you want. So take out the extractor name go to RSA3 in ECC side, after extracting data here you can cross check with the data in PSA or Infoproviders for consistency with business logic.You can also search help.sap.com for Tables .

Regards

Raj