Data Source
SAP source tables powering Batch-Lot Traceability. All cells are editable.
7 sources · 13 rows
1. Goods Receipt (Raw Material)
Inbound receipt of raw materials from vendor
Module: SAP EWM + SAP MM / Inventory ManagementTables:
/SCWM/HUHDR, /SCWM/HUITM, MARA, MARC, MSEG, MATDOC, MCH1, MCHA, MKPF| Pallet / SU # | Material | Plant | Received Qty | Vendor Lot | SAP Batch # | Posting Date | Mfg Date | |
|---|---|---|---|---|---|---|---|---|
2. Batch Record (Raw)
Batch created after raw material receipt
Module: SAP MM / Batch Management / Vendor MasterTables:
MARA, MARC, MCHB, LFA1, MCH1, MCHA, MKPF, AUSP, CABN| Material | Plant | Qty | Vendor # | Vendor Lot | SAP Batch # | Received Date | Mfg Date | |
|---|---|---|---|---|---|---|---|---|
3. Consumption Document (Raw → HALB)
Goods Issue to production order (Movement Type 261)
Module: SAP PP / PP-PI / Inventory ManagementTables:
RESB, MSEG, AUFK, AFKO, MKPF| Material (Raw) | Plant | Qty Consumed | SAP Batch # | Posting Date | Process Order # | Mvt Type | |
|---|---|---|---|---|---|---|---|
4. Batch Record (HALB / Semi-Finished)
Semi-finished goods batch (Movement Type 101)
Module: SAP PP / Batch ManagementTables:
MARA, MARC, MCHB, MCHA, MCH1, AUSP| Material (HALB) | Plant | Qty | SAP Batch # | Mfg Date | |
|---|---|---|---|---|---|
5. Consumption Document (HALB → FERT)
Semi-finished consumed into finished goods (Movement Type 261). Batch trace often stops here.
Module: SAP PP / PP-PITables:
RESB, MSEG, AFKO, MKPF| Material (HALB) | Plant | Qty Consumed | Batch | Posting Date | Process Order | Mvt Type | |
|---|---|---|---|---|---|---|---|
6. Finished Goods / Ship-WIP Goods Receipt
Final production output (Movement Type 101 — GR from production)
Module: SAP PP / MMTables:
MARA, MARC, MSEG, AFPO, MKPF, AFKO, AUFK| Material (FERT) | Plant | Qty Produced | SAP Batch # | Production Date | Process Order | Mvt Type | |
|---|---|---|---|---|---|---|---|
7. Full Batch Traceability Chain
End-to-end genealogy linking Raw → HALB → FERT via CHARG, MATNR, WERKS, AUFNR, MBLNR
Module: Derived from MSEG + MKPF + AFKO + MCH1 (often reconstructed, not stored)Tables:
MARA, MARC, MSEG, MKPF, MCH1, MCHA, MCHB, AFKO, RESB, /SCWM/HUHDR| Raw Batch | HALB Order | HALB Batch | FERT Order | FERT Batch | Material Doc (MBLNR) | Plant | |
|---|---|---|---|---|---|---|---|