Skip to Content

 Process to Cleanse or Validate the data in R/3(ECC) andLoad it back to R/3 tables using Data Services.

One can perform R3 data validation and cleansing using Data Services, with one of the following methods:-

1. ABAP PROGRAM

2. USING IDOC

3. USING BAPI

In this example i have used the first method, i. e ABAP Program. 

To handle this i have created custom table in ECC and stored few records into it. Then using Data Services extracted the data from ECC and did the required transformation and finally uploaded into the ECC table with ABAP Progarm.

Following is the step by step approach to handle R3/ECC table data.

 

1. Create a DataStore with R3/ECC Credentials.

image

 

2. Create a Project (Ex: PROJECT_R3_EXTRACT).

 image

3. Create a Batch Job (Ex: R3JOBRUN).

 

image

 4. Now the screen will look like below.

 

 image

 5. Under the Job add a WorkFlow.

image

 6. Under WorkFlow add a DataFlow.

image

 7.Double click on DataFlow.

8. Drag and Drop the R/3 Flow from the palate.

9. Provide the Source DataStore Name, ABAP file name to be generated , ABAP program name in R/3 and the Job Name. Follow the 8 character naming convention.

image

 10. Drag and Drop aTemplate Table for staging purpose. Then Drag and drop the transformation in Between R/3 Flow and Template Table and Map Accordingly.

image

 11. Map the R/3 flow with transformation and then to the Template Table.

image

 12. Double click on the R/3 Flow to Add the source table , transformation and transporter. 

image

 13. Drag and Drop the Source R3/ECC table and transformation.

image 

14. Drag and Drop the Transport from the right palate.

 image

15. Map the Source table with Query(Transformation) then the query to Transport.

16. Double click on the Transport and provide the data file name (the output file where the final data will be stored after Validation and Cleansing).

 

 image

 

17. Double click on the Query, Drag and Drop the required source fields into the Query. Here we can apply the required transformation (Validation, Quality and Cleansing Techniques).

image

 18. Double click on the Transport to view whether the required fields to transfer are mapped or not.

 

image

 

19. Go back to the DataFlow Level and double click on the template table (Staging Table) to confirm the mapping, look into the transformation in between.

image

 

20. Save the Project. image

 

21. Execute the Batch Job.

 image

 22.In  the below screen the Job execution is showing errors but once you map the template table with transformation you will not get any errors.

 image

 

23. After successful Execution of the Job Check the Data File and the ABAP Program File generated in the Provided Path at the time os DataStore Creation. (R/3 credentials path, In my Ex: D:\USR\SAP)

24. Once the DataFile is generated , We can upload the DataFile into the target table using a ABAP Program (Ex: ZFILEUPLOAD Program).

 image

 image

 image

 image

 

image

 

25. Execute the above Sample Program in SE38, which is used for file uplaod. Change the Code according to your file structure.

26. After execution the input screen will pop-up, where we have to provide the DatafFile path and name. (Select browse for selection DataFile).

image

 

image

 

 27. After execution or Run, the qualitative data will be uploaded into the R3/ECC tables.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member
    It’s possible to run an ABAP program that fetches the records from SAP table, sends the data to a Data Services real-time job, and the recieved cleansed data can be updated back into the SAP table.
    Need to explore in these lines…
    (0) 

Leave a Reply