S/4 HANA – BW/4HANA Integration through ODP – ABAP CDS views as Data Provisioning
SAP has provided multiple approaches to integrate S/4 HANA with standalone BW4HANA/BW. Here we are going to see how data from S/4 HANA can be extracted to BW4HANA through ODP-ABAP CDS views. This document will provide step by step technical guidance to integrate the S4HANA with standalone BW system through ODP – ABAP CDS views as extraction method.
|Extraction Method||BW Version||S/4 HANA Version|
|ODP ABAP CDS Views||BW4 HANA||1511 FPS02|
Follow the below steps to develop the model
Step 1: Check the connection (ODP – ABAP CDS Views) is established between the source system and BW4HANA.
Step 2: Once the connection is established open your BW Modeling perspective in Eclipse/HANA studio and follow the mentioned process.
Go to the required application component in BW Modeling perspective and then replicate the ABAP CDS Views under the required application component. Replicated CDS views will act as data sources for BW4HANA for extraction purpose. Here we are using Billing CDS view (ISDBILLGDOCITEM) for illustration purpose.
Step 3: Select the required Data source name which is generated based on the CDS views replication (step 2) as per your business requirements.
Replication job will be created and you can check this job in T-code SM37.
Step 4: Create the Dataflow by dragging the CDS views from the left pane.
Step 5: Use the required modeling objects which is required for the business requirement. Here for illustration we are taking ADSO as staging layer. Drag and drop the modeling object from the right pane.
Step 6: Right click in the transformation icon and create the transformation which will navigate to the RSA1 and mapping for the source and target field are proposed. If you need any logic implementation then the same can be implemented in start, rule level or end routine as required.
Follow the step 6 for DTP creation as well.
Step 7: Run the DTP load.
Step 8: Loaded data can be visible in the active table of the DSO.
Step 9: Create a Composite Provider by adding the created ADSO.
Step 10: Create a Bex Query in the eclipse.
Maintain the general properties which are required for the query.
If any filters are required add in the Filters tab.
BeX level local/global CKF’s and RKF’s can be created by Right click in the key figure.
Step 11: Query Output: