SAP Table MKAL
Production Versions of Material
MKAL (Production Versions of Material) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MKAL to other SAP tables.
MKAL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||
|
VERID
Production Version
|
VERID |
CHAR
|
4 | 0 | ||||||||||||
|
BDATU
Run-time end: production version
|
BDATM |
DATS
|
8 | 0 | ||||||||||||
|
ADATU
Valid-from date of production version
|
ADATM |
DATS
|
8 | 0 | ||||||||||||
|
STLAL
Alternative BOM
|
STALT |
CHAR
|
2 | 0 | ||||||||||||
|
STLAN
BOM Usage
|
STLAN | T416 |
CHAR
|
1 | 0 | |||||||||||
|
PLNTY
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||
|
PLNNR
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||
|
ALNAL
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||||
|
BESKZ
Procurement Type
|
BESKZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SOBSL
Special procurement type
|
SOBSL | T460A |
CHAR
|
2 | 0 | |||||||||||
|
LOSGR
Lot Size for Product Costing
|
CK_LOSGR |
QUAN
|
13 | 3 | ||||||||||||
|
MDV01
Production line for repetitive manufacturing
|
SA_LINE1 |
CHAR
|
8 | 0 | ||||||||||||
|
MDV02
Planning identification
|
MDV | T437P |
CHAR
|
8 | 0 | |||||||||||
|
TEXT1
Short text on the production version
|
VERS_TEXT |
CHAR
|
40 | 0 | ||||||||||||
|
EWAHR
Usage Probability with Version Control
|
CK_EWAHR |
DEC
|
3 | 0 | ||||||||||||
|
||||||||||||||||
|
VERTO
Distribution key for quantity produced
|
SA_VERTO | T437V |
CHAR
|
4 | 0 | |||||||||||
|
SERKZ
Repetitive manufacturing allowed for version
|
SA_VERSI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
BSTMI
Lower value of the lot-size interval
|
SA_LOSVN |
QUAN
|
13 | 3 | ||||||||||||
|
BSTMA
Upper value of the lot-size interval
|
SA_LOSBS |
QUAN
|
13 | 3 | ||||||||||||
|
RGEKZ
Indicator: backflush for RS header
|
SA_RGEKZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ALORT
Receiving storage location for repetitive manufacturing
|
ALORT | T001L |
CHAR
|
4 | 0 | |||||||||||
|
PLTYG
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||
|
PLNNG
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||
|
ALNAG
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||||
|
PLTYM
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||
|
PLNNM
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||
|
ALNAM
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||||
|
CSPLT
Apportionment Structure
|
CSPLIT | MAKV |
CHAR
|
4 | 0 | |||||||||||
|
MATKO
Other material for which BOM and task list are maintained
|
MKAL_MATKO | MARA |
CHAR
|
18 | 0 | |||||||||||
|
ELPRO
Proposed issue storage location for components
|
SA_ELPRO | T001L |
CHAR
|
4 | 0 | |||||||||||
|
PRVBE
Default supply area for components
|
SA_PRVBE |
CHAR
|
10 | 0 | ||||||||||||
|
PRFG_F
Check status of production version
|
PRFG_F |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PRDAT
Date of last check of production version
|
MKPRDAT |
DATS
|
8 | 0 | ||||||||||||
|
MKSP
Production version is locked
|
MKSP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PRFG_R
Rate-based planning - Check status of production version
|
PRFG_R |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PRFG_G
Preliminary planning - Check status of production version
|
PRFG_G |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PRFG_S
BOM - check status of production version
|
PRFG_S |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
UCMAT
Reference Material for Original Batches
|
VBOB_OB_RFMAT |
CHAR
|
18 | 0 | ||||||||||||
|
PPEGUID
Internal Identification for PVS Objects
|
PVS_GUID |
RAW
|
16 | 0 | ||||||||||||
MKAL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MKAL | ALORT | MKAL | ALORT |
T001L
Storage Locations
|
LGORT |
| MKAL | ALORT | MKAL | MANDT |
T001L
Storage Locations
|
MANDT |
| MKAL | ALORT | MKAL | WERKS |
T001L
Storage Locations
|
WERKS |
| MKAL | CSPLT | MKAL | MANDT |
MAKV
Material Cost Distribution
|
MANDT |
| MKAL | CSPLT | MKAL | MATNR |
MAKV
Material Cost Distribution
|
MATNR |
| MKAL | CSPLT | MKAL | WERKS |
MAKV
Material Cost Distribution
|
WERKS |
| MKAL | CSPLT | MKAL | CSPLT |
MAKV
Material Cost Distribution
|
CSPLIT |
| MKAL | ELPRO | MKAL | MANDT |
T001L
Storage Locations
|
MANDT |
| MKAL | ELPRO | MKAL | WERKS |
T001L
Storage Locations
|
WERKS |
| MKAL | ELPRO | MKAL | ELPRO |
T001L
Storage Locations
|
LGORT |
| MKAL | MANDT | MKAL | MANDT |
T000
Clients
|
MANDT |
| MKAL | MATKO | MKAL | MANDT |
MARA
General Material Data
|
MANDT |
| MKAL | MATKO | MKAL | MATKO |
MARA
General Material Data
|
MATNR |
| MKAL | MATNR | MKAL | MANDT |
MARA
General Material Data
|
MANDT |
| MKAL | MATNR | MKAL | MATNR |
MARA
General Material Data
|
MATNR |
| MKAL | MDV02 | MKAL | MANDT |
T437P
Planning IDs for Repetitive Manufacturing
|
MANDT |
| MKAL | MDV02 | MKAL | WERKS |
T437P
Planning IDs for Repetitive Manufacturing
|
WERKS |
| MKAL | MDV02 | MKAL | MDV02 |
T437P
Planning IDs for Repetitive Manufacturing
|
PLAN_ID |
| MKAL | PLNTY | MKAL | MANDT |
TCA01
Task list types
|
MANDT |
| MKAL | PLNTY | MKAL | PLNTY |
TCA01
Task list types
|
PLNTY |
| MKAL | PLTYG | MKAL | MANDT |
TCA01
Task list types
|
MANDT |
| MKAL | PLTYG | MKAL | PLTYG |
TCA01
Task list types
|
PLNTY |
| MKAL | PLTYM | MKAL | MANDT |
TCA01
Task list types
|
MANDT |
| MKAL | PLTYM | MKAL | PLTYM |
TCA01
Task list types
|
PLNTY |
| MKAL | SOBSL | MKAL | SOBSL |
T460A
Special procurement key
|
SOBSL |
| MKAL | SOBSL | MKAL | MANDT |
T460A
Special procurement key
|
MANDT |
| MKAL | SOBSL | MKAL | WERKS |
T460A
Special procurement key
|
WERKS |
| MKAL | STLAN | MKAL | MANDT |
T416
BOM Usage - Item Statuses
|
MANDT |
| MKAL | STLAN | MKAL | STLAN |
T416
BOM Usage - Item Statuses
|
STLAN |
| MKAL | VERTO | MKAL | MANDT |
T437V
Distribution key in MRP
|
MANDT |
| MKAL | VERTO | MKAL | WERKS |
T437V
Distribution key in MRP
|
WERKS |
| MKAL | VERTO | MKAL | VERTO |
T437V
Distribution key in MRP
|
VERTL |
| MKAL | WERKS | MKAL | WERKS |
T001W
Plants/Branches
|
WERKS |
| MKAL | WERKS | MKAL | MANDT |
T001W
Plants/Branches
|
MANDT |