Applies to 3.x / 7.x
Listed below are some of the frequently used ABAP Programs in SAP BW.
Program name |
|
|---|---|
Delete fact table rows where all Key Figure values are zero. See Note 619826. | |
Activation of InfoCubes | |
Make InfoCube Copies | |
Delete InfoCubes | |
Activation of all ODS Objects with Navigation Attributes | |
Activation of all ODS Objects | |
Activation of all InfoObjects | |
Deletion of InfoObjects | |
Repair InfoObjects | |
Reorganization of Texts for InfoObjects | |
Activating Multiproviders | |
Make Multiprovider Copies | |
Deleting Multiproviders | |
Activate all inactive Communication Structures | |
Activate Transfer Structure | |
Activate Update Rules | |
Activate Hierarchies | |
Activating and Filling the Aggregates of an InfoCube | |
Deactivating the Aggregates of an InfoCube | |
Activating Personalization in Bex(Inactive are highlighted) | |
Convert Full Requests to Repair Full Requests | |
Print a List of Cubes in The System and Their Layouts | |
Create DB Statstics for all InfoCubes | |
Create Missing E-Fact Tables for InfoCubes and Aggregates | |
Locate/Remove Unused or Empty partitions of F-Fact Table | |
Remove Temperory Database Objects | |
Add, change, delete RSADMIN table entries | |
A fast way to put some "sample" records in a InfoCube. No need to use Flatfiles, | |
Convert BasisCube to Transactional Cube and the opposite way around. | |
Handle change runs; same functionality as the function 'Tools -> Hierarchy/Attribute changes' | |
Handle change runs; same functionality as the function 'Tools -> Hierarchy/Attribute changes' | |
| RSDS_DATASOURCE_ACTIVATE_ALL | Activates DataSources |
| RSDG_TRFN_ACTIVATE | Activate Transformation and DTP |
| RSSM_OLTP_INIT_DELTA_UPDATE | Init-delta settings written from rssdlinit/sel to OLTP |
| RSBKDTPREPAIR | Repair DTP |
Listed below are some of the frequently used Function Modules within BW.
Function Module | Description (Function Group RRMX) |
|---|---|
RRMX_WORKBOOK_DELETE | Delete BW Workbooks permanently from Roles & Favourites |
Get list of all Workbooks | |
Get list of queries in a workbook | |
Lists where a query has been used | |
Get list of all Jump Targets | |
Delete Jump Targets |
Function Module | Description |
|---|---|
Used for Time Conversions. | |
Convert Foreign Currency to Local Currecny. | |
Convert Local Currency to Foreign Currency. | |
Used to convert all texts to UPPERCASE | |
Used to convert any unit to another unit. (Ref. table : T006) | |
Used to convert timestamp to local time | |
Convert 0CALMONTH or 0CALDAY to Financial Year or Period | |
Generic Extraction via Function Module | |
Used in Data Transformations to read master data InfoObjects | |
Used to read Infocube or ODS data through RFC | |
Returns a number what day of the week the date falls on. | |
Will return a week that the day is in. | |
Determine Last Day of the Month. Marked as obsolete. Out of maintenance since 2005. | |
Used for Date Converstions. We can use in Info Package routines. | |
To trigger an event in process chain | |
Returns factory calendar date for a date | |
Conversion Exit for Domain GBDAT: YYYYMMDD -> DD/MM/YYYY | |
Conversion exit ALPHA, external->internal | |
Upload of meta data from R/3 | |
Deletion of master data | |
To activate a process chain after transport | |
| ARCHIVFILE_CLIENT_TO_SERVER | Transfer a File from an applicatioserver to a client |
| RSPC_API_CHAIN_START | Apis and Bapis for Process Chains |
| FACTORYDATE_CONVERT_TO_DATE | Calendar function: Returns date for a factory calendar date |
| HOLIDAY_CHECK_AND_GET_INFO | Public holiday check with information |
USEFUL ABAP-CLASS in NW 7 - BI to fix problems with Transformation
Class CL_RSTRAN_STAT | Description |
|---|---|
DELETE_VERSION_FROM_DB (Static Method) | For deleting the transformation version from database, helpful if the transformation metadata are corrupted. |
DELETE_RULE_FROM_DB | For deleting a given rule of transformation |
15 Comments
Unknown User (98c1jx6t)
Big 10xs. How about NW 2004s...
Unknown User (syp8buw)
Good resource.
Unknown User (10122natr)
I just wanted to add to Jame's comment above.
This is an excellent resource! I find myself periodically using the programs/function modules to reactivate transfer rules or datasources. However, I don't perform those actions enough to commit the program/fm names to memory. This wiki definitely help those of us who occasionally use these very useful programs.
Yogesh Patil
Definitely, this is good source of information. Great work..!
One finding is that the FM RP_CALC_DATE_IN_INTERVAL is not exist in BI 7.0. Do you know any program/FM equivalent to this FM?
Unknown User (k30remv)
I just wanted to add to Jame's above.
Excellent Resource
Former Member
Dear team,
Do agree with the Martin, Jame about the resource is helpfull.....
Regards,
Gaurav Patwari
Paramesh Kumar Bada
This is the information I was trying to consolidate for late hours . This comprehensive list of programs and function modules has really saved my time.
Thanks & Regards
Paramesh
Unknown User (kn7e4kp)
a lot of useful date methods in class "CL_RSAR_FUNCTION", use SE24 to test and play around
CALL METHOD CL_RSAR_FUNCTION=>DATE_FISCPER(
EXPORTING I_DATE = l_calday
I_PER = 'K4'
IMPORTING E_FISCPER = l_fiscper ).
Anjali S Kumar
Just wanted to add to the content another Function Module
ARCHIVFILE_CLIENT_TO_SERVER - To upload file from presentation server to application server.
Regards,
Anjali
Unknown User (gej2z09)
Thanks a lot!
Harshil Joshi
RSBM_GUI_CHANGE_USTATE: manually change the status of the old request to red or green by using this function module
for more
Change Status of DTP Request
Former Member
Thank you very much!
Former Member
Very useful document..
Thanks,
Rk
Kunal Shukla
Very good and useful collection.
Thank you.
Kunal
Frank Rühle
Great collection. Thanks.