SAP TIP

Applies to 3.x / 7.x

Listed below are some of the frequently used ABAP Programs in SAP BW.

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	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.
RSDDS_AGGREGATES_MAINTAIN	Handle change runs; same functionality as the function 'Tools -> Hierarchy/Attribute changes'
RSDDS_AGGREGATES_MAINTAIN	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
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_TARGETS_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	Used to read Infocube or ODS data through RFC
DATE_COMPUTE_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.
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
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
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

트랜잭션을 이용한 InfoPackage 직접 접근방법 (0)	2014.10.27
Query 결과 출력 함수 "RRW3_GET_QUERY_VIEW_DATA" (0)	2014.10.27
RRW3_GET_QUERY_VIEW_DATA – Execution of BEx Query in ABAP (0)	2014.10.27
How to use FM RRW3_GET_QUERY_VIEW_DATA / RS_VC_GET_QUERY_VIEW_DATA_FLAT ? (0)	2014.10.27
Tables in SAP BW which give information related to Queries, Work Books and Web Templates (0)	2014.10.27

SAP TIP

Useful ABAP Programs and Function Modules in SAP BI

Applies to 3.x / 7.x

47 Child Pages

'ERP-SAP > BW' 카테고리의 다른 글

티스토리툴바

Useful ABAP Programs and Function Modules in SAP BI

Applies to 3.x / 7.x

47 Child Pages

'ERP-SAP > BW' 카테고리의 다른 글

관련글

티스토리툴바