SAP table MAKZ (Material cost distribution equivalence numbers)

SAP table MAKZ has 8 primary key fields being MANDT,MATNR,WERKS,CSPLIT,SCZUO,KUPPL,BWART,DATUB.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARC MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
CSPLIT Apportionment Structure CHAR 4 0 MAKV CSPLIT
SCZUO Assignment CHAR 3 0 TSC0D CO_SCZUO
KUPPL Co-product CHAR 40 0 MARC KUPPELPROD
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
DATUB Valid-to date DATS 8 0 DATUB
ZIFFR Equivalence Numbers DEC 3 0 AEQUI
BMENG Base quantity QUAN 13 3 MAKZ_BMENG
BMEIN Base unit of measure UNIT 3 0 T006 MAKZ_BMEIN

MAKZ foreign key relationships

Table Field Check Table Check Field
0 MAKZ BMEIN T006 Units of Measurement MANDT
1 MAKZ BWART T156 Movement Type MANDT
1 MAKZ BWART T156 Movement Type BWART
0 MAKZ CSPLIT MAKV Material Cost Distribution MANDT
0 MAKZ CSPLIT MAKV Material Cost Distribution WERKS
1 MAKZ KUPPL MARC Plant Data for Material MANDT
1 MAKZ KUPPL MARC Plant Data for Material MATNR
1 MAKZ KUPPL MARC Plant Data for Material WERKS
0 MAKZ MANDT T000 Clients MANDT
1 MAKZ MATNR MARC Plant Data for Material MANDT
1 MAKZ MATNR MARC Plant Data for Material MATNR
1 MAKZ MATNR MARC Plant Data for Material WERKS
0 MAKZ SCZUO TSC0D Assignment Table MANDT
0 MAKZ SCZUO TSC0D Assignment Table SCZUO
1 MAKZ WERKS T001W Plants/Branches MANDT
1 MAKZ WERKS T001W Plants/Branches WERKS