Listed below are some of the used ABAP Programs in SAP BI (NW 2004).
Program name
| |
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 Objects
|
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 InfoObjects
|
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
SAP_CONVERT_NORMAL_TRANS |
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. Convert BasisCube to Transactional Cube and the opposite way around. |
RSDDS_AGGREGATES_MAINTAIN RSDG_TRFN_ACTIVATE RSDRI_CLOSE_APO_REQUEST |
Listed below are some of used Function Modules within BW.
Function Module
|
Description (Function Group RRMX)
| ||
RRMX_WORKBOOK_DELETE
|
Delete BW Workbooks permanently from Roles & Favourites
| ||
RRMX_WORKBOOK_LIST_GET
|
Get list of all Workbooks
| ||
RRMX_WORKBOOK_QUERIES_GET
|
Get list of queries in a workbook
| ||
RRMX_QUERY_WHERE_USED_GET
|
Lists where a query has been used
| ||
RRMX_JUMP_TARGET_GET
|
Get list of all Jump Targets
| ||
RRMX_JUMP_TARGET_DELETE
|
Delete Jump Targets
| ||
Function Module
|
Description
| ||
MONI_TIME_CONVERT
|
Used for Time Conversions.
| ||
CONVERT_TO_LOCAL_CURRENCY
|
Convert Foreign Currency to Local Currecny.
| ||
CONVERT_TO_FOREIGN_CURRENCY
|
Convert Local Currency to Foreign Currency.
| ||
TERM_TRANSLATE_TO_UPPER_CASE
|
Used to convert all texts to UPPERCASE
| ||
UNIT_CONVERSION_SIMPLE
|
Used to convert any unit to another unit. (Ref. table : T006)
| ||
TZ_GLOBAL_TO_LOCAL
|
Used to convert timestamp to local time
| ||
FISCPER_FROM_CALMONTH_CALC
|
Convert 0CALMONTH or 0CALDAY to Financial Year or Period
| ||
RSAX_BIW_GET_DATA_SIMPLE
|
Generic Extraction via Function Module
| ||
RSAU_READ_MASTER_DATA
|
Used in Data Transformations to read master data InfoObjects
| ||
RSDRI_INFOPROV_READ RSDRI_INFOPROV_READ
_DEMO RSDRI_INFOPROV
_READ_RFC
|
Used to read Infocube or ODS data through RFC
| ||
DATE_COMPUTE_DAY DATE_TO_DAY
|
Returns a number what day of the week the date falls on.
| ||
DATE_GET_WEEK
|
Will return a week that the day is in.
| ||
RP_CALC_DATE_IN_INTERVAL
|
Add/Subtract Years/Months/Days from a Date.
| ||
RP_LAST_DAY_OF_THE_MONTHS SLS_MISC_GET
_LAST_DAY_OF_MONTH
|
Determine Last Day of the Month.
| ||
RSARCH_DATE_CONVERT
|
Used for Date Converstions. We can use in Info Package routines.
| ||
RSPC_PROCESS_FINISH
|
To trigger an event in process chain
| ||
DATE_CONVERT_TO_FACTORYDATE
|
Returns factory calendar date for a date
| ||
CONVERSION_EXIT_PDATE_OUTPUT
|
Conversion Exit for Domain GBDAT: YYYYMMDD -> DD/MM/YYYY
| ||
CONVERSION_EXIT_ALPHA_INPUT
|
Conversion exit ALPHA, external->internal
| ||
CONVERSION_EXIT_ALPHA_OUTPUT
|
Conversion exit ALPHA, internal->external
| ||
RSPC_PROCESS_FINISH
|
Finish a process (of a process chain)
| ||
RSAOS_METADATA_UPLOAD
|
Upload of meta data from R/3
| ||
RSDMD_DEL_MASTER_DATA
|
Deletion of master data
| ||
RSPC_CHAIN_ACTIVATE_REMOTE
|
To activate a process chain after transport
|
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 a transformations rule version f
|
Great compilation-
ReplyDeleteYou can add
RSDDS_AGGREGATES_MAINTAIN
RSDG_TRFN_ACTIVATE
RSDRI_CLOSE_APO_REQUEST
Thanks. I have added those :)
ReplyDeleteNice information..
ReplyDeleteOdi Trainings providing Online IT Training by real time experts, who is having minimum 6 years of experience in various technologies like ODI, OWB, MSBI, OBIEE, Ab Initio, DataStage, Informatica, Cognos TM1, Cognos 10 BI, MicroStrategy, Pentaho, QlikView, SAP BO (BO BI), SAP BW (BW BI), Tableau, Jaspersoft, SAP BODS, Datamanger, SAS BI, Talend, R Analytics etc...
Contact us:+919949376222
Mail id: trainings@odionlinetrainings.com
www.odionlinetrainings.com
It is nice blog Thank you provide important information and I am searching for the same information
ReplyDeleteTableau Online Training
Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time
ReplyDeletedatastage online training
datastage online training India
datastage online training Hyderabad