How to add factory calendar to display in Bex query report?

[Former Member]

Hi Experts,

I have a specific requirement to design a report that show daily sale, MTD, YTD compare with Budget and they want to show factory date such as

May 28 2009

may-2009 - day 20 off 22

Product --- D --- MTD --- YTD -

---

Budget day

Sweet A --- 22 --- 565 --- 58854 --- 32

Sweet B --- 22 --- 500 --- 50054 --- 16

My questions are:

1. I can figured out sales by day, MTD, YTD but budget day I have to calculate using factory calendar, how can I get calendar becasue there is no carlendar factory char. in the cube?

2. I also cannot figure out how to get the calendar display as above.

Any of your idea is my highly appreciate.

BSTOMS

[Former Member · Accepted solution]

While create MTD, YTD calculation you must be refering to Normal yearly cal for these calculations (no of days, from date-to date etc) suggest to refer to factory cal in your variable user exit code.

Suggest to check out this document as well -

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/25d98cf6-0d01-0010-0e9b-edcd4597...

Hope it helps.

[Former Member · Accepted solution]

Hi Agrawal,

Thanks for you reply. The issued is solved by Abapper and the link you gave is useful.

Regards,

BSTOMS