Material ageing report

[former_member223861]

Hi Experts,

I need material ageing report on inventory cube.it should show from how many days material has been in storage location.

the report format should be like

0-30days   valuefor30days   31-60days  valuefor31-60days -----------  totalvalue.

please provide logic how to do this.

Regards,

Naveen

[former_member199945]

Hi,

For doing ageing reports need to have 2 dates ,

Do  u have date field which contains relevant info  , difference will be based on system date or fixed date.

Regards,

Seshu.P

[former_member223861]

Hi Seshu,

In my cube I am having posting date.

Regards,

Naveen

[former_member199945]

Hi,

Kindly refere bwlow doc : http://scn.sap.com/docs/DOC-45143

instead of student dob mention posting date .

[former_member202718]

Hi Naveen,

You are having posting date ..say 01-Oct-2014 and you need to used variable 0DAT(Which is calday..i.e Today)..And the difference between that will give you the Age of the Material. 01012015-01102104 ...here in this case its aprox 90 Days..We need to use Formula Var to find the difference for dates.

rgds

SVU

[former_member223861]

Hi SVU,

I am clear with your solution. I am able to create formula variable on 0calday. and iam not able to get 0calday variable in to formula variable screen for doing calculation as below.

given date(0calday variable) - postingdate(0calday).

Regards,

Naveen

[former_member202718]

Hi Naveen,

Okay, Use the Standard Date Variable (Check for the variable in the Formaula Var Screen)

or create a variable and write CMOD code as SYS-DATUM.

rgds

SVU

[Former Member]

Hi Navneet,

Check in the infocube, There is a dimension 'NET DUE DATE'.

Make selection for key figure you want to show and use 'NET DUE DATE VARIABLE'.

For example-0S_NETDUEDATE_R0

0S_NETDUEDATE_R1

0S_NETDUEDATE_R2

0S_NETDUEDATE_R3

0S_NETDUEDATE_R4.

Regards

Devesh

[former_member223861]

Hi Devesh,

Thanks for your response.

There was no net due date in my cube.

Regards,

Naveen