Skip to Content

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

To report this post you need to login first.

26 Comments

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

  1. SG Sg Post author

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

    (0) 
  2. SG Sg Post author

    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.

    (0) 
  3. Kumar S

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

    (0) 

Leave a Reply