SAP Writeback Configuration Setup For Writeback from Flat to Classification table Mapping

Scenario: Writeback from Flat to Classification table Mapping

Step 1:

In Order to Writeback to SAP Table using DB Source, First Verify the Record Identifiers are set for the SAP Table by Navigating to Profiling > Selected SAP Table > More Actions > Edit Configuration as shown below


Now Verify the Record Identifier’s in the below location. If the Record Identifier’s are not set, please set them here and Save. mceclip1.png

Step 2:

Now, navigate to the DB Source Table (Ex: DVSUM.VW_ZMAT_ATTRIBUTE_FLAT) as shown below for which User wants to create a rule and do the writeback to SAP Table (Ex: ZMAT_ATTRIBUTE).mceclip2.png

Step 3:

Verify the Record Identifiers are same as the SAP Table. If not, please select the record Identifiers for DB Source Table (Ex: DVSUM.VW_ZMAT_ATTRIBUTE_FLAT)mceclip3.png

Step 4:

Select the SAP Table (Ex: ZMAT_ATTRIBUTE) To which user needs to writeback using DB source Table (Ex: DVSUM.VW_ZMAT_ATTRIBUTE_FLAT) as shown below, and Click on “Next”mceclip4.png

Step 5:

Map the Key Identifier columns and Write-back columns of DB Table and SAP Table by using below screen. Perform the mapping as shown the below screens.

Here, As there are two Key Identifier’s(MATNR, ATTRIBUTE) in the Target (ZMAT_ATTRIBUTE) table, and in the source we have only one key identifier (MATNR_ARTICLE), The Field “ATTRIBUTE” is by default selected as Qualifier.

In Case of ZMAT_ATTRIBUTE_FLAT table, there will be only One Writeback Column. That Field Needs to be selected under “Write Back Column Mapping Selection”.mceclip5.png

The “Qualifier Column Value” will be the “ATTRIBUTE” Column Value Where the Writeback will be performed in ZMAT_ATTRIBUTE table.

Once the mapping is completed for the Required/All columns that are used in the rule, Save the mapping by clicking on “Save” button.mceclip6.png

Addition configuration for Custom Query

Step 6:

Starting from creating a custom query rule, go to Manage Rules, click on Add Rule button, select Process Quality from drop down options and lastly click on Custom Query as shown in image belowmceclip7.png

Step 6:

User will be redirected to Add Rule detail page. In Basic Input section, under Custom Query box you will see the Enable Write-back check box as shown in image below:

Provide all the details for the Rule and Enable Write-back by clicking on the check box. Save the rule by clicking on “Save” buttonmceclip8.png

Step 7:

Run the Rule First, then to setup the Writeback Configuration Fields.mceclip9.png

After running the rule, User will see the rule as below.mceclip10.png

Step 8:

Setup the Record identifiers mapping by navigating to “Writeback Configuration” tab as shown below and click on “Next”mceclip11.png

Step 9:

Setup the mapping for remaining columns as shown below. Click on check box under “Enable Write-back” column for the columns where we need to writeback the data. After Enabling Writeback, User can verify the configuration where the field is going to writeback if SAP configuration is available. mceclip12.png

Click on “Save” to save the configuration as shown belowmceclip13.png

Step 10:

Re-Run the Rule after Saving to see the Editable Fields and Cleanse Button.mceclip14.png

After the running the rule, now user can see the Cleanse button and Writeback Fields marked with colour.mceclip15.png

Step 11:

Now, click on Cleanse Button, Modify the Data as shown below.


After Modifying, Save the data. Here, user can see the Writeback is going to Perform on SAP Table (ZMAT_ATTRIBUTE)mceclip17.png

Step 12:

Once the Save is done. Click on “Commit” button to writeback data into SAP Table.mceclip18.png

As soon as commit is pressed, user can see Job(s) are scheduled to perform the operation.mceclip19.pngmceclip20.png

Wait for the Jobs to complete by Navigating to Scheduler Page.mceclip21.png

13: Verify the changes on the Rule Page by refreshing the page Once the Job(s) are completed.mceclip22.png

Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk