December 14, 2011

Some of the useful ABAP Programs in SAP BI

Below are the some mostly used ABAP program in SAP BI

RSCDS_NULLELIM


Delete fact table rows where all Key Figure values are zero. See Note 619826. 

RSDG_CUBE_ACTIVATE
Activation of InfoCubes 

RSDG_CUBE_COPY
Make InfoCube Copies 

RSDG_CUBE_DELETE
Delete InfoCubes 

RSDG_DODS_REPAIR
Activation of all ODS Objects with Navigation Attributes

RSDG_ODSO_ACTIVATE
Activation of all ODS Object

RSDG_IOBJ_ACTIVATE
Activation of all InfoObjects

RSDG_IOBJ_DELETE
Deletion of InfoObjects

RSDG_IOBJ_REORG
Repair InfoObjects

RSDG_IOBJ_REORG_TEXTS
Reorganization of Texts for InfoObject

RSDG_MPRO_ACTIVATE
Activating Multiproviders 

RSDG_MPRO_COPY
Make Multiprovider Copies 

RSDG_MPRO_DELETE
Deleting Multiproviders 

RS_COMSTRU_ACTIVATE_ALL
Activate all inactive Communication Structures 

RS_TRANSTRU_ACTIVATE_ALL
Activate Transfer Structure 

RSAU_UPDR_REACTIVATE_ALL
Activate Update Rules 

RRHI_HIERARCHY_ACTIVATE
Activate Hierarchies 

SAP_AGGREGATES_ACTIVATE_FILL
Activating and Filling the Aggregates of an InfoCube 

SAP_AGGREGATES_DEACTIVATE
Deactivating the Aggregates of an InfoCube 

RS_PERS_ACTIVATE
Activating Personalization in Bex(Inactive are highlighted) 

RSSM_SET_REPAIR_FULL_FLAG
Convert Full Requests to Repair Full Requests 

SAP_INFOCUBE_DESIGNS
Print a List of Cubes in The System and Their Layouts 

SAP_ANALYZE_ALL_INFOCUBES
Create DB Statstics for all InfoCubes 

SAP_CREATE_E_FACTTABLES
Create Missing E-Fact Tables for InfoCubes and 
Aggregates 

SAP_DROP_EMPTY_FPARTITIONS
Locate/Remove Unused or Empty partitions of F-Fact Table 

SAP_DROP_TMPTABLES
Remove Temperory Database Objects 

SAP_RSADMIN_MAINTAIN
Add, change, delete RSADMIN table entries 

CUBE_SAMPLE_CREATE
A fast way to put some "sample" records in a InfoCube. No need to use Flatfiles, just enter the value in a ALV-Grid or let fill the Cube with random value. 

SAP_CONVERT_NORMAL_TRANS
Convert BasisCube to Transactional Cube and the opposite way around.

No comments:

Post a Comment