SAP table MAKV (Material Cost Distribution)

SAP table MAKV has 4 primary key fields being MANDT,MATNR,WERKS,CSPLIT.

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 CSPLIT
SCTYP Structure Type CHAR 1 0 CO_SCTYP
C Splitting Structure
U Source Structure
SCNAM Structure CHAR 2 0 TSC0A CO_SCNAM
KTEXT Text (20 Characters) CHAR 20 0 TEXT20

MAKV foreign key relationships

Table Field Check Table Check Field
0 MAKV MANDT T000 Clients MANDT
1 MAKV MATNR MARC Plant Data for Material MANDT
1 MAKV MATNR MARC Plant Data for Material MATNR
1 MAKV MATNR MARC Plant Data for Material WERKS
0 MAKV SCNAM TSC0A Table of Structures MANDT
0 MAKV SCNAM TSC0A Table of Structures SCTYP
1 MAKV WERKS T001W Plants/Branches MANDT
1 MAKV WERKS T001W Plants/Branches WERKS