Skip to Content
0
Former Member
Apr 11, 2010 at 02:39 PM

Add information from item level into header level

89 Views

Hi Expert,

I'm facing an issue about how to make a coding in feedback loop in one DSO "ZSD_O01" (sales nr.and sales Item both are key field). Currently all value of data field: "Reference nr" are blank on header level, it should be filled from the first item of the sales found, but it should not be filled from bacth split item. Any suggestion how to make it in start routine or char. routine or end routine in BI 7.0 transformation by using feedback loop of ZSD_O01 in a more simply way.

One example data in ZSD_O01:(Currently all reference nr. are blank on the header level)

Sales nr.;Item;Reference nr;

80000;00;blank value; - Header level

80000;10;20000; -Item level

80000;20;20001; -Item level

80000;30;20002; -Item level

80000;70001;20003;-Item level

It should be filled from the first item of the sales found, but it should not be filled from bacth split item like 70001. The result should be like below:

Sales nr.;Item;Reference nr;

80000;00;20001;-> In this case the value "20001" of reference nr. is equal the value of first item "10" of sales found.

80000;10;20001;

80000;20;20002;

80000;30;20003;

80000;70001;20004;

In other example case

Sales nr.;Item;Reference nr;

82001;00;20002;-> In this case the value "20002" of reference nr. is equal the value of first item "20" of sales found.

82000;20;20002;

82000;30;20003;

82000;70001;20003;

82000;70002;20003;

Your useful suggestion will be high appreciated.

Sudree