How to Extract SAP Tables from SAP System at BusinessObjects Data Services using R3 Data Flow
Aim: - To extract SAP Tables from SAP system using R3 Data Flow.
Steps:-
1) Identify the Tables to be extracted from SAP System.
2) Create Project Say PRJ_TEST at BOBJ – DS.
3) Create a Work Flow say WF_TEST with in PRJ_TEST.
4) Create a Data Flow say DF_TEST_EXTRACT with in WF_TEST.
5) Now within the Scope of DF_TEST_EXTRACT, create a R3 data flow with the name say RDF_TEST_EXTRACT.
6) Now at RDF_TEST_EXTRACT take the source table from SAP source schema and take a Query Transform to perform any business logic (conditions/filters/logical mapping).Let the Query Transform have the source as the SAP Source table.
7) Now take a Data Transport Transform and map the output of the Query Transform to the Data Transport Transform.
😎 Once we take the SAP source table, Query Transform and Data Transport at RDF_TEST_EXTRACT, get back to the DF_TEST_EXTRACT which has the R3 data flow with in its scope (RDF_TEST_EXTRACT).
9) Now at Data Flow DF_TEST_EXTRACT create a Temp table say SAP_Extract and Map the output of the R3 Data Flow to it.
10) Finally we will have SAP_Extract table as the new source table from SAP system after performing the required filtration on the actual source table from SAP System.
Result:-
1) SAP_EXTRACT will be the SAP source filter table as per the business requirement which can be further used for any transformation logic, mapping or Post/Pre Load validation at Business Objects Data Services.
2) R3 Data Flow is basically used when we need to do any extract from SAP system and also when the extracted data volume is comparatively high.
