Previous Month - Variable

[Former Member]

Matez,

I use variable 0RMA_FIP(Fiscal Year/Period) to get User Input for a Current Month.

Now, using this user-input variable for Current Month, the Report is expected to also display a values of <b>Previous Month</b>

Is there any standard variable given by SAP for this Previous Month ? Or if there isn`t could you explain how can I create this variable to be "Current Month -1" ?

[Former Member]

Hi,

To display the values for the previous month of user enterd month , you do not need any user exit variable. USe same user entry varible with offset value -1.

With rgds,

Anil Kumar Sharma.P

[Former Member]

Hi Anil,

How do I set the Offset Value ?

[former_member188975]

Hi JOhn,

This post has detailed instructions on how to use the offset setting:

Hope this helps...

[Former Member]

Hi,

There is no SAP standerd variable for last month but there is an variable by which u can get up to last month.

From help.sap:

Variable: Cumulated up to Last Month

Technical name: 0CYTLM

Use

This variable denotes an interval from month 1 of the current calendar year to the month before the current calendar month.

Integration

This variable belongs to InfoObject 0CALMONTH.

For current month

Variable: Cumulated up to Current Month

Technical name: 0CYTCM

Use

This variable denotes an interval from month 1 of the current calendar year to the current calendar month.

Integration

This variable belongs to InfoObject 0CALMONTH.

Regards-

Siddhu

Message was edited by: sidhartha

[Former Member]

Hi Siddhu,

Okay, so now I have to bring 0CALMONTH Info Object into my ODS.

I have made 0CALMONTH as part of my Data Field of ODS and activated.

Now, I attempted to maintain the Transfer Rule of my InfoSource 0CO_OM_CCA_9. When I attempted to map the 0CALMONTH Info Object in my Transfer Rule to InfoObject 0CALMONTH , I obtain the following error

InfoObject 0CALMONTH does not exist in the InfoSource 0CO_OM_CCA_9

Please advice.

[Former Member]

John,

use the variable 0RMA_FIP to get the user input for the current month and then use offset of -1 for the same variable to get the previous month.

[Former Member]

Hi,

I hope, there is no relevent field for 0CALMONTH in DS 0CO_OM_CCA_9. So you can use BLDAT or BUDAT(relevent BW objects) as the source field in the update rule by the use of 'Automatic time conversion'.

With rgds,

Anil Kumar Sharma. P

[Former Member]

Hi,

Search this forum with word offset, you can find lot of postings like:

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi John,

In transfer or update rules of your ODS you can yse formula

DATE_MONTH(YourIncomingDate) - resulting in YYYYMM month format

or

DATE_MONTH2(YourIncomingDate) - resulting in month format.

As YourIncomingDate you can choose either BLDAT (Document date) or BUDAT (Posting date).

Best regards,

Eugene

[Former Member]

Hi there,

I specified 2 Selection Characteristic in a single Structure.

First Selection " CURRENT MONTH",

- I Restricted Info Object 0FISPER(Period/Fiscal Year) with Variable 0P_FPER

Second Selection " PREVIOUS MONTH",

- I Restricted Info Object 0FISPER(Period/Fiscal Year) with Variable 0P_FPER

- Specified Variable 0P_FPER with OFFSET = -1

I obtain the following error :-

<b> Not possible possible to move variables 0P_FPER</b>

[Former Member]

John Mcluskey

i am getting the same error. are you able to solve this?