SKIP transaction data records basis dimension property values

[Former Member]

Hi,

Following is my requirement.

While loading transaction data from a flat file, I need to compare the UOM mentioned in the flat file against a Material code, and the UOM property of the Dimension Material. So if the UOM of flat file matches the UOM of master data then the record should be loaded, else the record should be skipped.

Any help how this can be achieved. I would like to keep BADI as the last option so i'm looking at the standard functionalities first (if available).

Thanks in advance.

Cheers,

Nitin

[Shrikant_Jadhav]

Hi Nitin,

As far as I know you can not do this without BADI.

Either you have to maintain that UOM property of the Dimension Material in source file or use BADI to read it from master.

Shrikant

[gajendra_moond]

Hi Nitin

There is a way to avoid BADI for your requirement. However a little adjustment would be needed.

If your material dimension contains ID as the concatenation of Material and UOM - say MATERIAL_UOM then you can avoid BADI.

Let us assume that your Material Dimension has ID with both Material and UOM concatenated. Now while loading transaction data flat file, you can concatenate the Material and UOM there as well for your Material Dimension of the model. Put the parameter MAXREJECTCOUNT=-1 in your transformation file.

Your load will then complete successfully with a Warning. It will reject all the records where the ID is not found in Material dimension and load the desired ones.

Hope this helps.