December 14, 2011

Useful functional modules in SAP BI

Below the some of the useful functional modules in SAP BI


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 
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 Used to read Infocube or ODS data through RFC 
RSDRI_INFOPROV_READ_DEMO 
RSDRI_INFOPROV_READ_RFC 
DATE_COMPUTE_DAY  Returns a number what day of the week the date falls on. 
DATE_TO_DAY 
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  Determine Last Day of the Month. 
SLS_MISC_GET_LAST_DAY_OF_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 

No comments:

Post a Comment