To know the list of SAP exit varaibles in our BW system
Follow the below steps
1)se11/16
2) table RSGLOBV
3)enter version -"A" and Processing Type -"4(sap exit) --> execute.
There are around 77 SAP Exit variables in SAP BW.
Below is the list of SAP Exit variable available in our SAP BW system
0P_KEYD2
0DAY_CUM
0CYMONTH
0CMCQUAR
0CMCQULY
0I_24CTS
0P_SYSID
0CQUART
0CQUARTT
DAYSPER
0FPERT
0CML12CM
0CMONTH
0CML12LM
0CWEEK
0P_KEYD4
0S_RQMRC
0I_48CTS
0P_PCSTP
0P_KEYD5
0PLANDAT
0RSTTCD2
0RSTTTA
0RSTTCW1
0RSTTCW2
0RSTTLG
0RSTTCY1
0RSTTCM1
0RSTTCW3
0RSTTCW4
0RSTTSP
0RSTTCW
0LYMONTH
0DAT
0S_BIOBJ
0FYTCFP
0P_PPER3
0FYTLFP
0P_KEYD3
0CMLYTCM
0CYEAR
0P_CTPCA
0CYTCM
0CYTLM
0CMLYTLM
0CYTCD
0LYTCLD
0LYM_CUM
0CML3LM
0P_PRFP1
0CML3CM
0I_P2FQU
0I_CUFQU
0P_CCOEX
0CWD
0S_IFPRV
0I_P3FQU
0I_PRFQU
0P_COAPP
0P_SPRDE
0P_SAPYR
0FYEAR
0P_FVAEX
0F_ADAY
0S_BISOB
0P_CSHF
0P_KEYDT
0P_CSHT
0FPER
0CMONTHT
0CYEART
0CMCMLY
0CWEEKT
0CMLMLY
0DATT
0FYEART
0P_CHAEX
Thursday, July 28, 2011
Wednesday, February 23, 2011
How to use Replacement Path Variables to perform Date Calculations in the BEx Analyzer
Step by step procedure is available.
the useful link which I refered :
http://teklink.co.uk/sap/sap-bi-bw-how-to-use-replacement-path-variables-to-perform-date-calculations-in-the-bex-analyzer/\\
http://www.sd-solutions.com/SAP-HCM-BW-Replacement-Path-Variables.html
the useful link which I refered :
http://teklink.co.uk/sap/sap-bi-bw-how-to-use-replacement-path-variables-to-perform-date-calculations-in-the-bex-analyzer/\\
http://www.sd-solutions.com/SAP-HCM-BW-Replacement-Path-Variables.html
Add workbooks to user menu Favorites
This steps will help you , how to add the work books to User Menu Favorites
Add workbooks to user menu Favorites RRMX -> Open workbooks -> Find a workbook ->Right-click ->Choose Properties-> click Information tab -> Get the Workbook ID field.
SE37 -> Execute FAVOS_EVENT_ADD_TO_USER_SHELF function module.
Enter user_name.
Reporttype = TR
report_name= rrmx
SAP_GUID = the workbook ID
Enter your TEXT you wanna see in the favorites.
See all workbooks associated to an user:SE16 -> SMEN_BUFFC -> REPORTTYPE=TR Workbooks are stored in BW in RSRWBSTORE table or BDS. In RSRWBINDEX table, RSRWBSTORE=T, then the workbook is customer-created workbook, stored in RSRWBSTORE.
BDS workbooks:
T-code BDN1
CLASS NAME=BW_CATALOG->CLASS TYPE = OT (OTHER OBJ) ->
OBJECT KEY= A_[WORKBOOK ID] ->DOCUMENT TYPE = bw_xlwb_xl
I have refered from : http://yangchuang.com/wp22/?p=21
Add workbooks to user menu Favorites RRMX -> Open workbooks -> Find a workbook ->Right-click ->Choose Properties-> click Information tab -> Get the Workbook ID field.
SE37 -> Execute FAVOS_EVENT_ADD_TO_USER_SHELF function module.
Enter user_name.
Reporttype = TR
report_name= rrmx
SAP_GUID = the workbook ID
Enter your TEXT you wanna see in the favorites.
See all workbooks associated to an user:SE16 -> SMEN_BUFFC -> REPORTTYPE=TR Workbooks are stored in BW in RSRWBSTORE table or BDS. In RSRWBINDEX table, RSRWBSTORE=T, then the workbook is customer-created workbook, stored in RSRWBSTORE.
BDS workbooks:
T-code BDN1
CLASS NAME=BW_CATALOG->CLASS TYPE = OT (OTHER OBJ) ->
OBJECT KEY= A_[WORKBOOK ID] ->DOCUMENT TYPE = bw_xlwb_xl
I have refered from : http://yangchuang.com/wp22/?p=21
Multiprovider Activation in Production System
Is it Possible to Activate the MultiProvider in the Production system?
The important thing is without affecting the Reports.
Yes you can Activate the Multiprovider in the Production system Directly without affting the Reports.
Use this Function Module : RSDG_MPRO_ACTIVATE
You try first it on Sandbox, development system before attempting on production environment.
The important thing is without affecting the Reports.
Yes you can Activate the Multiprovider in the Production system Directly without affting the Reports.
Use this Function Module : RSDG_MPRO_ACTIVATE
You try first it on Sandbox, development system before attempting on production environment.