Skip to Content
0
Former Member
Oct 24, 2012 at 02:01 PM

Return Table in Transformation -End Routine

79 Views

Hello all,

I have a situation where I have data coming in by Inforecord, customer, customer group and discount. But at times the customer group is populated but has no customer for it and all discount is applied to the whole group in ECC. The thing is that when it gets into BI, we want to report on customers only hence I need to get the values of customers I have for the customer group I am extracting.

I load data into 1st level DSO and from there into the second level DSO (Key- InfoRecord/ Customer/Customer Grp), here in the End Routine, I tried to attempt something like a return table back in 3.X version,based on the How TO Paper... But wasnt very successful. I have attached the ST22 screenshot too.

I want to get customer from 0CUSTOMER where cust grp matches. Also I Don't want the discount amount to be divided.So if it is the same inforecord/customer group I want the discount amount to be the same.

Incoming Data:

Incoming Data

InfoRecord C_Grp Customer Discount 1001 AB
20%- 1002 BC 891 25%-


I need:

InfoRecord C_Grp Customer Discount 1001 AB 123 20%- 1001 AB 456 20%- 1001 AB 789 20%- 1002 BC 891 25%-

Please see my code (attachment) that I had written and the error that it gives me.

I need your inputs please as it is an important requirement for me to fulfill.

Thank you,

Krrish.

Attachments