Create a qvd by year

gauravgg — Sat, 16 Nov 2024 06:03:55 GMT

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

Re: Create a qvd by year

miskinmaz — Tue, 16 Apr 2019 05:18:30 GMT

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.