Attribute to attrbiute

[Former Member]

Hello All,

Material A has an attribute A1.

Material B has an attrbiute B1.

The value of B1 needs to be dervied based on value coming for A1. How can this be achieved?

Eg: If material A1 = A or C then value of B1 should be Accesory and

if A1 = G then B1 = Genuine part.

Please inform.

Thanks in advance.

Regards,

NIKEKAB

[Former Member]

Alternately, you can put an InfoSource in between. Lookup the needed attribute of A1 in the transformation into the InfoSource using the Read Master Data ruletype. Then you can map it in the transformation from the InfoSource to the destination.

Or, you can use one transformation. Do the select to the master data tables to grab the attribute of A1 and then do your decision logic. You can do this all in the field routine assuming it is not large data. Otherwise you will want to do the select in the start routine into an internal table.

[former_member222556]

Hi Dear,

in Transformation, map the A1 attribute source fields to B1 and

Write code in Field Level Routine:-

if source_fields-A1 = 'A' or Source_fields-A1 = 'C'.

Result = 'ACCESSORY'.

else if source_fields-A1 = 'G'.

Result = 'GENUINE'.

endif.

Best Regards

Obaid

[Former Member]

HI,

you can write field level routine in the Transformation level.By doing the masterdata look up into A1 and update the B1 field.

Thanks