Quantity four day before

[Former Member]

Hi guru

I need your help.

My cube contain: document date, material and order quantity.

I would like the order quantity by material at the 4 days before the document day

Exemple :

Doc date Material Order qty

25/03/2008 0033000001 100

22/03/2008 0033000001 20

21/03/2008 0033000001 50

25/03/2008 0033000003 100

22/03/2008 0033000003 60

21/03/2008 0033000003 40

If I execute report the 25/03/2008 I would like to see :

Material Order Qty(j-4)

0033000001 70

0033000003 100

And not

Material Order Qty

0033000001 170

0033000003 200

We do not have a user variable

Could you help me please

Best regards

Eric

[Former Member · Accepted solution]

Hi

thank for yours reply. I solved my issue using a user exit...

Eric

[Former Member]

Do you have any user entry variable to enter date?

If yes, create a restriction of date based on range [Entered Date - 4, Entered Date - 1] (use offset on date).

If you dont have user entry varaible and u need to pick current system date when the report is run... use SAP Exit for current date and create a restriction range based on [Current Date - 4, Current Date - 1].

I hope i m clear in this..

[Former Member]

how about creating structure

create chars structure in rows

bring selection 1 and assign doc. date to it and name it as doc date

selection 2, bring material and name it as material

selection 3

bring material and order quantity and assign time as calday and set its offset as 4

can u try and see what it shows