Extraction of Master Data

[Former Member]

Hi Experts,

How to extract master data like 0material,0customer etc from R/3 and How to initialize the master data for delta..?

Thanx in advance.

Vasu.

[Former Member · Accepted solution]

Hi Vasu,

not all datasources are delta enabled, you need to check it out in the source system. Basically you will find the relevant datasources starting with the name of the infoobject:

0MATERIAL_ATTR (Attributes for 0MATERIAL)

0MATERIAL_TEXT (language dependent texts)

0CUSTOMER_ATTR (Atrtributes for 0CUSTOMER).....

If the option is available in the infopackage then initialize the delta with the first load and you will get your deltas.

Hope this helps!

regards

Siggi

[Former Member · Accepted solution]

Thanx all.

Regards,

Vasu.

[edwin_harpino]

hi Vasu,

in r/3 side

- rsa5, transfer business content datasources 0material_text, 0material_attr, 0customer_text and 0customer_attr.

- you can check if the datasource has delta capability or not here, 'delta'.

in bw side

- replicate datasource

- install business content 0material and 0customer with 'in dataflow' and make sure the datasources are assigned.

- run infopackage with option 'initialize' if available, or 'full'.

- schedule delta to run periodically.

hope this helps.

[Former Member]

Hi Vasu,

First you have to activate the Datasource for Master data. You can do this from RSA5. Then replicate the Datasource in relevant application component in BW side.

Then create a Infopackage, choose Initialize delta if you want to do Delta update . Then schedule the infopackge for Init Load. Then create one more Infopackage with Delta load option.

Hope it helps.

Bye

Jayasudha