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