Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to derive calmonth from number of days

Hi Experts,

My customer has the following requirement. They want a actual Vs Plan sales report,

with user input being the calmonth (Eg: 06/2010)

The format is as follows:

material | actual sales | Plan sales | material delivery (days) | plan calmonth

10 200 150 90 mar10

20 100 160 135 feb10

Here the plan sales should be restricted by calmonth, which should be calculated by deducting the number of material delivery days from the user input month. Eg: If the customer enters 06/2010 as the input, then the report should show actual sales for 06/2010, and plan sales for 'mar10' if the delivery days are 90 for material 10 (06/2010 - 90 days = 03/2010) and 'feb10' if the delivery days are 135 (06/2010 - 135 = 02/2010) for material 20.

Can you please help me out in arriving at the solution for this.

Thanks & Regards,


Edited by: Ramana Kumar on Jun 24, 2010 3:00 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question