Former Member

September 20, 2013 2 minute read

Standard Variables in BEX related to Time Charcteristics

Hi,

This blog will shows list of standard bex variables Specifically Date Based Scenarios.

Path : Modelling —> Business Content—-> Query elements —-> Variable.

Below is the List of Standard variables available for date based logics.

Characteristic	Variable	Description
0CALDAY	0CWD	Current Workday (SAP Exit)
0CALDAY	0CYTCD	Cumulated to Current Day (SAP Exit)
0CALDAY	0DAT	Current Calendar Day (SAP Exit)
0CALDAY	0DAY_***	Cumulation of all Values to Key Date (SAP-Exit)
0CALDAY	0LYTCLD	Cumulated to Current Day of Previous Year
0CALDAY	0LYTCLD	Previous Year Cumulated to Current Day (SAP Exit)
0CALDAY	0L_DATE	Last Calendar Date
0CALDAY	0P_LY_R	Comparative Period for Last Year
0CALDAY	0P_TY_R	Period for Current Year up to Yesterday
0CALDAY	0S_KDATE	Key Date Interval for Previous Year (SAP Exit)
0CALDAY	0S_KDAY	Key Date Interval Current Year (SAP Exit)
0CALMONTH	0CMCMLY	Current Month of Previous Year
0CALMONTH	0CMCQUAR	Current Quarter
0CALMONTH	0CMCQULY	Current Quarter in Previous Year
0CALMONTH	0CML12CM	Last 12 Months Including Current Month
0CALMONTH	0CML12LM	Last 12 Months Excluding the Current Month
0CALMONTH	0CML3CM	Last 3 Months Including Current Month
0CALMONTH	0CML3LM	Last 3 Months Excluding the Current Month
0CALMONTH	0CMLMLY	Last Month of Previous Year
0CALMONTH	0CMLMON	Last Month
0CALMONTH	0CMLYTCM	Previous Year Cumulated to Current Month
0CALMONTH	0CMLYTLM	Previous Year Cumulated to Last Month
0CALMONTH	0CMONTH	Current Calendar Month
0CALMONTH	0CYTCM	Cumulated to current month
0CALMONTH	0CYTLM	Cumulated to last month
0CALMONTH	0I_CMY01	Current Year Cumulated to Current Month (SAP Exit
0CALMONTH	0LYM_***	Cumulation of all Values to End of Previous Year
0CALQUARTER	0CQUART	Current Quarter
0CALQUARTER	0P_PRQUA	Previous Calendar Quarter (SAP Exit)
0CALWEEK	0CWEEK	Current calendar week
0CALWEEK	0PREVWK	Previous Week
0CALYEAR	0CYEAR	Current calendar year
0CRM_EXPEND	0I_CMDEX	Current Month
0CRM_EXPEND	0I_MP1EX	Current Month + 1
0CRM_EXPEND	0I_MP2EX	Current Month + 2
0CRM_EXPEND	0I_MP3EX	Current Month + 3
0CRM_EXPEND	0I_MP4EX	Current Month + 4
0CRM_EXPEND	0I_MP5EX	Current Month + 5
0ORGUNIT	0ORGUNIT	Organizational Unit for a Report User (Hierarchy node)
0TCTUSERNM	0TCTUSEE	User in the Business Information Warehouse
1FORMULA	0F_ADAY	Formula Variable for Current Calenda

Some more useful Standard Varibles Related to FISCPER,FISCYEAR .

Variable	Description
0I_CUFYE	All Periods of Current Fiscal Year (SAP Exit)
CALDAY	cal day text
DAY	Calendar Date
0S_CADAY	Calendar Day
MONTH	Calendar Month
0CYTCD	Cumulated to Current Day (SAP Exit)
0CYTCM	Cumulated to current month
0CYTLM	Cumulated to last month
0FYTCFP	Cumulated up to Current Fiscal Year/Period (SAP Exit
0I_BA107	Cumulated Up To End of Prior Year (SAP Exit for 0P_FPER)
0I_BA106	Cumulated Up To Prior FY Period (SAP Exit for 0P_FPER
0I_BA104	Cumulated Up To Period (SAP Exit for 0P_FPER)
0LYM_***	Cumulation of all Values to End of Previous Year
0I_BA105	Cumulated Up To Prior Period (SAP Exit for 0P_FPER
0DAY_***	Cumulation of all Values to Key Date (SAP-Exit)
0DAT	Current Calendar Day (SAP Exit)
0DATT	Current calendar day (T)
0CMONTH	Current Calendar Month
0CWEEK	Current calendar week
0CYEAR	Current calendar year
0CDFY	Current Fiscal Year
0P_ACTD6	Current Date (SAP Exit)
0FPER	Current Fiscal Year/Period (SAP Exit)
OP_RTFPM	Current Month of Fiscal Year
0F_CUFPE	Current Period of Fiscal Year (Formula Variable)
0P_RTFPQ	Current Quarter of Fiscal Year
0I_P2FQU	Current Quarter of Fiscal Year – 2 (SAP Exit)
0I_P3FQU	Current Quarter of Fiscal Year – 3 (SAP Exit)
0P_RTFPW	Current Week of Fiscal Year
0CWD	Current Workday (SAP Exit)
0I_VD3	day count til key date (quart)
0I_PD02	Day Count Until Key Date (Month, Posting Date)
0P_1DOW	Day of Week
0FI_YEAR	Financial year
0P_PD04	First Day in Month (Posting Date)
0P_VD01	First Day in Week (Value Date)
0P_VD01	First Day in Week (Value Date)
0P_PD10	First Day in Year (Posting Date)
0L12MTDY	Last 12 Month to current day
0F_NUMM	Number of Months (from Variable 0I_FPER)
0F_ANZPE	Number of Periods
0T_CMONV	Text Variable 0CALMONTH From Value (Name)
0T_DAYTX	Text Variable Replaced by 0CALDAY

Regards,

Giri

26 Comments

You must be Logged on to comment or reply to a post.

Former Member

September 21, 2013 at 4:01 pm

Instead of creating offset variables we can use directly Standard variables for year , Year+1 Very much helpful in YTD, MTD Scenarios.

Martin Grob

September 21, 2013 at 6:47 pm

nice to know you don't need to code everything yourself

Former Member

September 22, 2013 at 2:48 pm

Thank you Martin

Former Member

September 21, 2013 at 8:56 pm

Great Work

Former Member

September 22, 2013 at 2:51 pm

thank you Rajeev

Kamal Mehta

September 25, 2013 at 4:14 am

Thanks for sharing.

Nice.

Former Member

September 25, 2013 at 5:26 am

Good 1.

Satendra Mishra

October 1, 2013 at 11:32 am

Good help.

Former Member

October 1, 2013 at 11:33 am

Thank you Mishra

Raman Korrapati

October 1, 2013 at 11:36 am

Good job and useful list. All useful variable listed at one place.Thanks for your efforts.

Thanks

Anshu Lilhori

October 1, 2013 at 11:54 am

Very useful information..Thanks for sharing.

Regards,

Sandeep a

October 3, 2013 at 10:41 am

Thanks for sharing .

Regards

Sandeep

Former Member

October 3, 2013 at 10:45 am

Nice Doc..

karthick Ravichandran

October 3, 2013 at 11:18 am

Helpful .Thanks for Posting

Former Member

October 4, 2013 at 4:16 am

Reallly helpful.

Thanks a lot giri

Former Member

October 4, 2013 at 9:26 am

Already someone posted this document anyway thanks.

http://webcache.googleusercontent.com/search?q=cache:5c6PRcN5LCoJ:zodano.wordpress.com/2011/09/26/sap-bw-variables-for-date-month/+&cd=4&hl=en&ct=clnk&gl=in

Former Member

October 4, 2013 at 4:36 pm

Correct kalpana. Now we have a quick shot cut also. Better to add more variables now.

Former Member

October 5, 2013 at 4:05 am

i am doing that work only adding some additional info related to standard variables fisper,fiscal year.once it is completed i will update here only.

Former Member

October 12, 2013 at 5:19 am

Yes giri, Good with additional information.

Former Member

October 7, 2013 at 4:59 am

Good work Giri..

Thanks for sharing and Keep doing!!

Regards

Kiran N

Former Member

October 1, 2013 at 4:15 pm

Good info giri. Saves time when we require variables, you can add FISCPER, FISCYEAR etc as well - it will be helpful.

Ganesh Bothe

November 9, 2013 at 6:48 pm

Hi SG,

Its very useful information. Thanks for sharing.

Former Member

January 23, 2014 at 12:02 pm

Great work,

Former Member

January 28, 2014 at 9:45 am

Hi SG,

very nice post! Thank you for sharing...

Regards

Venkat...

Former Member

September 19, 2014 at 6:20 pm

Hi,

Good one.....

Somesh.

Rama Shankar

December 22, 2015 at 8:41 pm

Nice handy list Giri - thanks.

Standard Variables in BEX related to Time Charcteristics

Assigned Tags