jump to navigation

SAP BW – Transfer Rules missing in transport September 26, 2011

Posted by Ajay in Uncategorized.
add a comment

I’ve transported transfer rules and communication structure successfully but I cant see transfer rules in QA. Later I found that that Source System assignment for the DB connect was uncheked.

I’ve checked the assignment and was able to collect the :

Communication structure
DataSource Replica
Transfer Rules
InfoSource transaction data
Transfer structure
Routine
BW Formula

Steps:

Go To  Transport Connection –>Edit –>Source System Assignment –> check the source system you are connecting in Transfer Rules

Hurray you can transport the transfer rules now .

Advertisements

SAP BW Variables for Date Month September 26, 2011

Posted by Ajay in Uncategorized.
1 comment so far

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