SAP BW Variables for Date Month September 26, 2011
Posted by Ajay in Uncategorized.trackback
To install go to BI Content–> Query Elements-> Variable
| 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_CUM | 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_CUM | 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 Calendar Day |
Hi
Thanks for the information.
After install these varibles in bussiness content how can we use them.(directly can i assign it ot my existing variable)?
Thanks,
Nani