Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have the following table .
Material , Vendor , Plant ,Valid from , Valid to ,Price.
form the above table i have to create qvd Year wise Price for Material ,Vendor ,Plant combination ie. as follows
Material , Vendor,Plant , Year ,Price
Thanks in Advance
Hi,
You can follow below steps:
1. Temp table with only Year dimension;
2. for loop till no of rows of tep table.
3. peek year from temp table, store it in a varaible.
4. Use varaible to store the qvd.