Adding attributes to a data source

[Former Member]

Hi all,

I need to add fields PRAT1, PRAT2, PRAT3, PRAT4, PRAT5, KONDM as an attribute of 0material. These fields are in the MVKE table which has the key of Sales org and Distribution channel.

How should I go about this ?

is there any documentation available on this customisation.

Thanks

OJB

[Former Member · Accepted solution]

The steps are:

1. Find out what field do you need from R/3 and what table it's sitting.

2. Add this new field into your data source.( for eg: Logistics (T-code-LBWE), click on the relevant datasource. look into the extract structure.some times,the field you want may be hided in the extract structure.

3. Go to CMOD and choose a project. choose for which u want to enhance (Master data or transaction data)

4. Check in RSA3 if you get the correct record or not.

5. Replicate this into bw.

6. Map this new field with appropriate Info Object in Transfer rules.

7. Add this new infoObject into your comm structure.

Hope it helps.

Regards

[Former Member · Accepted solution]

Hi Paulo,

Thanks for your quick response.

I have 2 questions.

1. KONDM ( material pricing group ) is hidden in the Billing extractor and I can move this. PRAT1... 5 are not available in the Billing extract structure

How Should I get PRAT1... 5 in the extractor.

2. SAP has not provided an info object for material pricing group . So I will have to create a custom infoobject like ZKONDM but I need to make this a navigational attribute of 0material .

what steps do i need to follow to populate ZKONDM

Thanks,

OJB

[Former Member · Accepted solution]

1) Trx RSA6, position the curson on your datasource and choose change datasource botton; here you can unhide KONDM than save end exit. Then chose Enhance Extraction structure, add your 5 field and activate append structure and exit.

Than chose Function Enhancement, insert your project, press change than Components, choose EXIT_SAPLRSAP_002 for master data and write the code to fill your added field.

2) Create your custom infoobject, add them to 0material attribute and activate.

In R3, trx RSO2 create your custom datasource based on the table that contain attribute of KONDM you need, activate it and than replicate datasource in BW.

Regards