Question Re: 0CALMONTH attributes in Technology Q&A

0CALMONTH attributes

former_member316788 — Tue, 23 Oct 2012 04:28:31 GMT

Hi there

We display the Number of Days attribute successfully from 0CALMONTH in our BeX queries, and I now need to use it in a routine for an Open Hub. But- when I look at the /BI0/PCALMONTH table, it only has one entry. Where can I read this data from?

Thanks

Re: 0CALMONTH attributes

anshu_lilhori — Tue, 23 Oct 2012 05:39:47 GMT

Hi,

Kindly check the below note and link.

http://scn.sap.com/message/8892308

Note 1136142

Hope it helps.

Regards,

Re: 0CALMONTH attributes

former_member316788 — Tue, 23 Oct 2012 05:52:42 GMT

Thanks Anshu. If I read this note correctly in terms of 0NUMDAYS, it is an explanation of how to control the calculation.

I am looking to extract the information already calculated via a routine. All I need is the table name where this is stored, as I incorrectly assumed it would be on the P table of 0CALMONTH.

Re: 0CALMONTH attributes

anshu_lilhori — Tue, 23 Oct 2012 06:28:30 GMT

Hi,

Kindly check this

http://www.stechno.net/sap-notes.html?view=sapnote&id=1387166

Hope this helps.

Regards,

Re: 0CALMONTH attributes

former_member316788 — Tue, 23 Oct 2012 07:27:36 GMT

Thanks. A bit more complex than I was hoping for. No idea how to make use of classes.

I think I will just make use of the FM LAST_DAY_IN_PERIOD_GET to calculate number of days.

I would have been able to use table T009B, if it wasn't for the fact that February has 29 days assigned to it.

Re: 0CALMONTH attributes

anshu_lilhori — Tue, 23 Oct 2012 09:08:29 GMT

Hi,

Yes true indeed even i was hoping for some simple mechanism behind it but its other way around.

You can call some standard function which will give you number of days in a month may be based on month input or fiscal year period.

Regards,

Re: 0CALMONTH attributes

former_member316788 — Tue, 23 Oct 2012 09:12:49 GMT

Yes thanks. I found /SDF/RBE_GET_DAYS_PER_MONTH wich will be most useful