Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

ABAP Programs in SAP BI

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

5 comments:

  1. Great compilation-
    You can add
    RSDDS_AGGREGATES_MAINTAIN
    RSDG_TRFN_ACTIVATE
    RSDRI_CLOSE_APO_REQUEST

    ReplyDelete
  2. Thanks. I have added those :)

    ReplyDelete
  3. Nice information..
    Odi 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

    ReplyDelete
  4. It is nice blog Thank you provide important information and I am searching for the same information
    Tableau Online Training

    ReplyDelete
  5. Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time
    datastage online training
    datastage online training India
    datastage online training Hyderabad

    ReplyDelete

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget