SAP Assignment 1 Walkthrough

Useful ABAP Programs and Function Modules in SAP BI

Listed below are some of the frequently used ABAP Programs in SAP BI (NW 2004).

Program name	Description
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 Statistics 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 Temporary 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 Flat files, just enter the value in a ALV-Grid or let fill the    Cube with random value.
SAP_CONVERT_NORMAL_TRANS	Convert Basis Cube to Transactional Cube and the opposite way around.

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 & Favorites
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 Currency.
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 the transformation version from database, helpful if the transformation metadata are corrupted.
DELETE_RULE_FROM_DB	For deleting a given rule of transformation

Introducing SAP BusinessObjects Explorer Demonstration (RKT Teaser)

How to Manage BW Transports

How to Manage BW Transports

SAP BW Query Performance Tuning With Aggregates

SAP BW Query Performance Tuning With Aggregates

New Features in SAP BW7.3

New Features in SAP BW7.3

1000 SAP ABAP Interview Questions And Answers

1000-sap-interview-qa

Selective deletion in Process chains

Selective deletion in Process chains

Using Process Chains in SAP Business Information

Using Process Chains in SAP Business Information

SAP BW T-CODES

T-Code Description

01. RSA1:- Administrator Work Bench
02. RSA11:- Calling up AWB with the IC tree
03. RSA12:- Calling up AWB with the IS tree
04. RSA13:- Calling up AWB with the LG tree
05. RSA14:- Calling up AWB with the IO tree
06. RSA15:- Calling up AWB with the ODS tree
07. RSA2:- OLTP Metadata Repository
08. RSA3:- Extractor Checker
09. RSA5:- Install Business Content
10. RSA6:- Maintain DataSources
11. RSA7:- BW Delta Queue Monitor
12. RSA8:- DataSource Repository
13. RSA9:- Transfer Application Components
14. RSBBS:- Maintain Query Jumps (RRI Interface)
15. RSD1:- Characteristic maintenance
16. RSD2:- Maintenance of key figures
17. RSD3:- Maintenance of units
18. RSD4:- Maintenance of time characteristics
19. RSDBC:- DB connect
20. RSDCUBE:- Start: InfoCube editing
21. RSDCUBED:- Start: InfoCube editing
22. RSDCUBEM:- Start: InfoCube editing
23. RSDDV:- Maintaining
24. RSDIOBC:- Start: InfoObject catalog editing
25. RSDIOBCD:- Start: InfoObject catalog editing
26. RSDIOBCM:- Start: InfoObject catalog editing
27. RSDL:- DB Connect - Test Program
28. RSDMD:- Master Data Maintenance w.Prev. Sel.
29. RSDMD_TEST:- Master Data Test
30. RSDMPRO:- Initial Screen: MultiProvider Proc.
31. RSDMPROD:- Initial Screen: MultiProvider Proc.
32. RSDMPROM:- Initial Screen: MultiProvider Proc.
33. RSDMWB:- Customer Behavior Modeling
34. RSDODS:- Initial Screen: ODS Object Processng
35. RSDS:- Data Source Repository
36. RSIMPCUR:- Load Exchange Rates from File
37. RSINPUT:- Manual Data Entry
38. RSIS1:- Create InfoSource
39. RSIS2:- Change InfoSource
40. RSIS3:- Display InfoSource
41. RSISET:- Maintain InfoSets
42. RSKC:- Maintaining the Permittd Extra Chars
43. RSLGMP:- Maintain RSLOGSYSMAP
44. RSMO:- Data Load Monitor Start
45. RSMON:- BW Administrator Workbench
46. RSOR:- BW Metadata Repository
47. RSORBCT:- BI Business Content Transfer
48. RSORMDR:- BW Metadata Repository
49. RSPC:- Process Chain Maintenance
50. RSPC1:- Process Chain Display
51. RSPCM:- Monitor daily process chains
52. RSRD_ADMIN:- Broadcasting (7.x) Administration
53. RSRCACHE:- OLAP: Cache Monitor
54. RSRT:- Start of the report monitor
55. RSRT1:- Start of the Report Monitor
56. RSRT2:- Start of the Report Monitor
57. RSRTRACE:- Set trace configuration
58. RSRTRACETEST:- Trace tool configuration
59. RSRV: Analysis and Repair of BW Objects
60. SE03:- Transport Organizer Tools
61. SE06:- Set Up Transport Organizer
62. SE07:- CTS Status Display
63. SE09:- Transport Organizer
64. SE10:- Transport Organizer
65. SE11:- ABAP Dictionary
66. SE18:- Business Add-Ins: Definitions
67. SE18_OLD:- Business Add-Ins: Definitions (Old)
68. SE19:- Business Add-Ins: Implementations
69. SE19_OLD:- Business Add-Ins: Implementations
70. SE21:- Package Builder
71. SE24:- Class Builder
72. SE80:- Object Navigator
73. SE91:- Create News classes
74. SE93:- Transaction Overview
75. RSCUSTA:- Maintain BW Settings
76. RSCUSTA2:- ODS Settings
77. RSCUSTV*
78. RSSM:- Authorizations for Reporting
79. SM04:- User List
80. SM12:- Display and Delete Locks
81. SM21:- Online System Log Analysis
82. SM37:- Overview of job selection
83. SM50:- Work Process Overview
84. SM51:- List of SAP Systems
85. SM58:- Asynchronous RFC Error Log
86. SM59:- RFC Destinations (Display/Maintain)
87. SU20:- Authorization Fields
88. SU21:- Authorization Objects
89. LISTCUBE:- List viewer for InfoCubes
90. LISTSCHEMA:- Show InfoCube schema
91. WE02:- Display IDoc
92. WE05:- IDoc Lists
93. WE06:- Active IDoc monitoring
94. WE07:- IDoc statistics
95. WE08:- Status File Interface
96. WE09:- Search for IDoc in Database
97. WE10:- Search for IDoc in Archive
98. WE11:- Delete IDocs
99. WE12:- Test Modified Inbound File
100. WE14:- Test Outbound Processing
101. WE15:- Test Outbound Processing from MC
102. WE16:- Test Inbound File
103. WE17:- Test Status File
104. WE18:- Generate Status File
105. WE19:- Test tool
106. WE20:- Partner Profiles
107. WE21:- Port definition
108. WE23:- Verification of IDoc processing
109. DB02:- Tables and Indexes Monitor
110. DB14:- Display DBA Operation Logs
111. DB16:- Display DB Check Results
112. DB20:- Update DB Statistics
113. KEB2:- DISPLAY DETAILED INFO ON CO-PA DATA SOURCE R3
114. RSD5:- Edit InfoObjects
115. SM66:- Global work process Monitor
116. SM12:- Display and delete locks
117. OS06:- Local Operating System Activity
118. RSKC:- Maintaining the Permitted Extra Chars
119. SMQ1:- qRFC Monitor (Outbound Queue)
120 Changerunmoni
121. RSREP: - Reporting Agent maintenance screen

Introduction to Process Chains in Sap Bi 7

Introduction to Process Chains in Sap Bi 7

SAP BI Executive Ppt

SAP BI Executive Ppt

SAP BI Data Warehousing

SAP BI Data Warehousing

SAP BW 7.0 Enterprise Reporting &Enterprise Reporting &Analysis WorkshopAnalysis Workshop

SAP BI Reporting

Using-SAP-BI-in-Universe Designer

Using SAP BI in Universe

How to Find Where Used List of a Query Program

How to Find Where Used List of a Query Program

SAP BI Data Warehousing Workbench

SAP BI Data Warehousing Workbench - Modeling

How to Load Master Data in BI 7.0

How to Load Master Data in Bi7

SAP BI 7 Developers Guide

SAP BI 7 Developers Guide