Standard Variables in BEX related to Time Charcteristics

[Former Member]

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