SAP Table
MAKV Material Cost Distribution
SAP table MAKV has 4 primary key fields being MANDT,MATNR,WERKS,CSPLIT.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
MAKV columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| KeyMATNR | Material Number | CHAR | 40 | 0 | MARC | MATNR | |||||
| KeyWERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||
| KeyCSPLIT | Apportionment Structure | CHAR | 4 | 0 | CSPLIT | ||||||
| SCTYP | Structure Type | CHAR | 1 | 0 | CO_SCTYP | ||||||
|
|||||||||||
| SCNAM | Structure | CHAR | 2 | 0 | TSC0A | CO_SCNAM | |||||
| KTEXT | Text (20 Characters) | CHAR | 20 | 0 | TEXT20 | ||||||
/ Relationships
MAKV foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| MAKV | MANDT | T000 | Clients | MANDT |
| MAKV | MATNR | MARC | Plant Data for Material | MANDT |
| MAKV | MATNR | MARC | Plant Data for Material | MATNR |
| MAKV | MATNR | MARC | Plant Data for Material | WERKS |
| MAKV | SCNAM | TSC0A | Table of Structures | MANDT |
| MAKV | SCNAM | TSC0A | Table of Structures | SCTYP |
| MAKV | WERKS | T001W | Plants/Branches | MANDT |
| MAKV | WERKS | T001W | Plants/Branches | WERKS |