Master Data Transformation Rule

[Former Member]

Hello,

I have datapackage coming from a DataSource with this structure :

CostElement     Type    Group

NC1                  T1         AS

NC1                  T2         AS

NC2                  T1         Purc

We want to make a transformation to a MasterData with this structure :

CostElment  T1        T2       Group

NC1            Yes       Yes       AS

NC2            Yes       --           Purc

Actual transformation is not managing double costelement, one of them is deleted.

Shall we add an end routine to this and if you have some code ?

Thanks

[former_member186445 · Accepted solution]

can be done in the end routine. the logic of the code would look like below.

copy the result itab to a result_t1 itab

copy the result itab to a result_t2 itab

in the result_t1 delete all lines where the type NE T1.

in the result_t2 delete all lines where the type NE T2.

loop over result itab

read table result_t1. if entry found --> T1 = 'YES'. else. blank.

read table result_t2. if entry found --> T2 = 'YES'. else. blank.

endloop.

M.

[former_member223526]

Hi Soufs,

Kinldy find the below link will be help full as we have a concept called the RETURN table concept which deals with similar work.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c07161ee-afa6-2c10-06bd-f1c864355...

Thanks,

Madhu.

[Former Member]

using rule group is a simpler option. You can create two infoobjects and then map them with the same filed in two different rule group. The filter should be on type value.

Regards,

Anupama

[Former Member]

Use Rule group

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d085fa63-f54c-2c10-b5ba-cc4ac2315...

Not sure how you will extend info objects in Target for each characteristic value of type.

Regards,

Sandeep