1. Home
  2. Resources
  3. SAP Tables
  4. MKAL - Production Versions of Material

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
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
E In-house production
F External procurement
NULL No procurement
X Both procurement types
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
0 Percentage Between 0 and 100
VERTO Distribution key for quantity produced SA_VERTO T437V CHAR 4 0
SERKZ Repetitive manufacturing allowed for version SA_VERSI CHAR 1 0
X Yes
NULL No
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
1 Backflush components during goods receipt
2 Backflush all components during goods receipt
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
NULL Not yet checked
1 Last check o.k.
2 Last check with warning
3 Last check with error
PRDAT Date of last check of production version MKPRDAT DATS 8 0
MKSP Production version is locked MKSP CHAR 1 0
NULL Not locked
1 Locked for any usage
PRFG_R Rate-based planning - Check status of production version PRFG_R CHAR 1 0
NULL Not yet checked
1 Last check o.k.
2 Last check with warning
3 Last check with error
PRFG_G Preliminary planning - Check status of production version PRFG_G CHAR 1 0
NULL Not yet checked
1 Last check o.k.
2 Last check with warning
3 Last check with error
PRFG_S BOM - check status of production version PRFG_S CHAR 1 0
NULL Not yet checked
1 Last check o.k.
2 Last check with warning
3 Last check with error
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 MANDT T001L Storage Locations MANDT
MKAL ALORT MKAL WERKS T001L Storage Locations WERKS
MKAL ALORT MKAL ALORT T001L Storage Locations LGORT
MKAL CSPLT MKAL WERKS MAKV Material Cost Distribution WERKS
MKAL CSPLT MKAL CSPLT MAKV Material Cost Distribution CSPLIT
MKAL CSPLT MKAL MANDT MAKV Material Cost Distribution MANDT
MKAL CSPLT MKAL MATNR MAKV Material Cost Distribution MATNR
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 MATNR MARA General Material Data MATNR
MKAL MATNR MKAL MANDT MARA General Material Data MANDT
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 MANDT T460A Special procurement key MANDT
MKAL SOBSL MKAL WERKS T460A Special procurement key WERKS
MKAL SOBSL MKAL SOBSL T460A Special procurement key SOBSL
MKAL STLAN MKAL STLAN T416 BOM Usage - Item Statuses STLAN
MKAL STLAN MKAL MANDT T416 BOM Usage - Item Statuses MANDT
MKAL VERTO MKAL WERKS T437V Distribution key in MRP WERKS
MKAL VERTO MKAL VERTO T437V Distribution key in MRP VERTL
MKAL VERTO MKAL MANDT T437V Distribution key in MRP MANDT
MKAL WERKS MKAL MANDT T001W Plants/Branches MANDT
MKAL WERKS MKAL WERKS T001W Plants/Branches WERKS