Master data and governance on S/4HANA

Data quality issue remediation on SAP S/4HANA

Runs quality rules on live master data, routes each failing record to its steward with the fix options, and writes the correction back to the ERP.

SCREENSDATA HANDLERSS/4HANA · READ IN PLACES01 IssuesS02 Record fixS03 Ask the ownerS04 Mass fixS05 RulesS06 Boarddh_material_masterMaterial masterMARA · MARC · MAKTdh_supplier_masterSupplier masterLFA1 · LFB1 · LFM1 (business partner inS/4)dh_customer_masterCustomer masterKNA1 · KNB1 · KNVVdh_purchase_order_linePurchase order lineEKKO · EKPO · EKET · EKBEWRITE BACK TO S/4HANAMaterial master → BAPI_MATERIAL_SAVEDATASupplier master → BAPI_BUPA_CREATE_FROM_DATA · BAPI_VENDOR_*Customer master → BAPI_BUPA_* · BAPI_CUSTOMER_CHANGEFROMDATA1rows stay in S/4HANA · access rules applied at read time · each write acknowledged and logged
The screens of the app, the data handler behind each, and the S/4HANA object it reads in place. Writes below the line go through released interfaces with an acknowledgement.
4
objects read in place from S/4HANA
catalogue
6
screens on those rows
catalogue
5 days
to production-grade
estimate
3
objects written back
catalogue
0
rows copied to build it
product
What the app reads

The S/4HANA objects behind each handler

Tables are read in place through the SAP connector, using released read interfaces; changed rows arrive through change capture where the basis team allows it. The rows stay in SAP.

ObjectRead fromFields the app usesFreshness
Material masterMARA · MARC · MAKTMARC.MMSTA (status) · MARC.PLIFZ (lead time) · MARA.MATNR (id) · MAKT.MAKTX (desc)live; change capture where enabled
Supplier masterLFA1 · LFB1 · LFM1 (business partner in S/4)LFM1.ZTERM (terms) · LFA1.LIFNR (id) · LFA1.NAME1 (name) · LFA1.LAND1 (country)live; change capture where enabled
Customer masterKNA1 · KNB1 · KNVVKNVV.VKORG (sales org) · KNA1.KUNNR (id) · KNA1.NAME1 (name) · KNA1.LAND1 (country)live; change capture where enabled
Purchase order lineEKKO · EKPO · EKET · EKBEEKKO.EBELN (number) · EKPO.EBELP (line) · EKKO.LIFNR (vendor) · EKPO.MATNR (material)live; change capture where enabled
The trigger

The start criterion in S/4HANA's own fields

In plain words: A record that fails one of the active quality rules, such as an active material with a lead time of 0, a supplier with empty payment terms, or a customer with an empty sales organisation.

The criterion runs in S/4HANA through the data handler, so only the matching rows return. The editor shows the rows it selects, and their count, as it is written.

# start criterion in S/4HANA fields
(MARC.MMSTA = 'active' and MARC.PLIFZ = 0) or LFM1.ZTERM = '' or KNVV.VKORG = ''

# the same criterion in canonical fields
({material.status} = 'active' and {material.lead_time} = 0) or {vendor.terms} = '' or {customer.sales_org} = ''
What the app writes back

Through released interfaces

Writes go through released BAPIs and IDocs. Each call returns a document number or an error message, and the app records both beside the decision.

ObjectWhat changesInterface
Material masterfield corrected through the material interface; exception flag recorded beside the recordBAPI_MATERIAL_SAVEDATA
Supplier masterpayment terms, country or purchasing data corrected; duplicate flagged for deletionBAPI_BUPA_CREATE_FROM_DATA · BAPI_VENDOR_*
Customer mastersales organisation data completed or correctedBAPI_BUPA_* · BAPI_CUSTOMER_CHANGEFROMDATA1
Acknowledged and logged

Each write stores the identifier S/4HANA returns beside the decision, the person and the time, so the log answers who changed what, and the reconciliation shows it arrived.

Access and prerequisites

What is in place before the first build

SAP roles are mapped to Lima access policies once. A buyer who sees purchasing organisation 1000 in SAP sees the same rows in the app.

  • An SAP user for the connector with read authorisation on the objects the app uses
  • The BAPIs the app writes with, enabled for that user
  • Network path to the application server (PrivateLink or VPN)
  • Change capture switched on for the objects that should refresh within minutes
Register the handlers4 objects from the catalog; each shows its rows at once.
Also on SAP ECC

The same app on SAP ECC

On SAP ECC the same objects live in the classic tables named beside each row; MATDOC becomes MKPF and MSEG, ACDOCA becomes BKPF and BSEG. The BAPIs are the same.

ObjectOn S/4HANAOn SAP ECC
Material masterMARA · MARC · MAKTsame tables
Supplier masterLFA1 · LFB1 · LFM1 (business partner in S/4)LFA1/LFB1/LFM1 vendor master, XK01 via BAPI
Customer masterKNA1 · KNB1 · KNVVsame tables
Purchase order lineEKKO · EKPO · EKET · EKBEsame tables
Nearby

This app on other systems, and other apps on S/4HANA

Data quality issue remediation on

Other apps on S/4HANA

Terms on this page

Quality ruleA condition a record should meet, written in plain words and tested on live data.
Data stewardThe person responsible for the records of one object in one area, such as materials in a plant.
Read in placeThe rows stay in S/4HANA; the handler sends the filter and the columns and S/4HANA returns the matching rows.
Questions

Does this app copy data out of S/4HANA?

The screens read through handlers that leave the rows in S/4HANA. History the app needs at scale is landed in the lake by the Backbone, which is the exception by design.

What does S/4HANA need to allow?

The prerequisites above: an integration identity with read rights on the objects listed and write rights on the interfaces named, connectivity, and the scopes agreed with the process owner.

Can I run it on SAP ECC as well?

Yes. The screens, criteria and roles stay; the handlers are re-bound to the other system's objects, listed above.

See this app on your data

Bring the process and the systems it touches. In the first session we register the data handlers, draw the levels or the lanes and run the first screen on your live rows.