Load 0MATL_GROUP to DSO

[Former Member]

Hi,

I've created a generic data-source based on table MARM with the fields MATNR, MEINH and UMREZ.

Then I created a DataStore object and set the source of the transformation to the data-source created in the first step.

The point is that I need to add one fourth info-object to the DSO, this is 0MATL_GROUP. This information is not available in the data-source, so I can not map this field in transformation.

How can I do to load 0MATL_GROUP into my DSO?

Any help would be appreciated.

Best regards.

[former_member202718]

Hi Carlos,

You have Material-MATNR....and i assume that you are loading the Material as master Object.

So you can do a look upon 0MATERIAL which is there in the source and Stamp the Material Group by Reading Master data.

Rgds

SVU

[sander_vanwilligen]

Hi Carlos,

There are two options.

Option 1: You can enhance the DataSource with the field Material Group and write a small piece of coding to enrich the extracted records with the Material Group (MARA-MATKL).

Option 2: You can add the Material Group in the Transformation in BW. You have to make sure that  proper loading sequence is guaranteed, i.e. first Material master data and after that your new data flow.

Best regards,
Sander