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 |
|
|
