One record per item: the global identity, the descriptions, the classification, and the plant-level data that planning and purchasing need.
Tables are read in place through the SAP connector, using released read interfaces and change capture where the basis team allows it. The rows stay in SAP.
| Object | Read from | Fields the domain uses | Freshness |
|---|---|---|---|
| Material general data | MARA · MAKT | MATNR · MTART · MATKL · MEINS · MAKTX · EAN11 · MFRPN · MFRNR | live; change capture where enabled |
| Plant data | MARC | WERKS · DISMM · DISPO · PLIFZ · EISBE · BSTMI | live; change capture where enabled |
| Sales data | MVKE | VKORG · VRKME · MTPOS | live; change capture where enabled |
| Stock | MARD · MATDOC | LGORT · LABST | live; change capture where enabled |
The first object above carries the strong keys; the standardised attributes come from the same rows. Attribute-based matching compares the physical attributes (dimensions, material, rating) so two descriptions of the same resistor match even when the words differ.
Writes go through released BAPIs and IDocs. Each call returns a document number or an error message, and Lima records both beside the change.
| Interface | Used for | Result |
|---|---|---|
BAPI_MATERIAL_SAVEDATA · IDoc MATMAS | golden values approved for write-back: identity; classification; physical | the id or error SAP S/4HANA returns, stored beside the change |
Write-back is off per object until a test write succeeds, and approval rules can require a person per object. Reconciliation compares the source row with the golden value on a schedule.
SAP roles are mapped to Lima access policies once. A steward who sees purchasing organisation 1000 in SAP sees the same rows here.
| Object | On SAP S/4HANA | On SAP ECC |
|---|---|---|
| Material general data | MARA · MAKT | same tables; classification in AUSP/KSSK |
| Plant data | MARC | same objects |
| Sales data | MVKE | same objects |
| Stock | MARD · MATDOC | same objects |
Material and product on
Other domains on SAP S/4HANA
The golden record reads the objects above in place. History the pivot needs at scale is landed in your lake by the Backbone, under the same keys, security and audit.
Grant the read access and the write interfaces listed above and agree the refresh method. Nothing is installed in SAP S/4HANA.
Yes. Write-back stays off per object until a test write succeeds; the golden view, the API and the pivots work from day one on reads.
Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.