1. Home
  2. Resources
  3. SAP Tables
  4. MKAL_EXPAND - For Buffer and Internal Tables of Production Version

SAP Table MKAL_EXPAND

For Buffer and Internal Tables of Production Version

MKAL_EXPAND (For Buffer and Internal Tables of Production Version) 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_EXPAND to other SAP tables.

Source: MKAL_EXPAND (For Buffer and Internal Tables of Production Version)

MKAL_EXPAND 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
AENNR Change Number AENNR CHAR 12 0
DATUV Valid-From Date DATUV DATS 8 0
DATUB Valid-to date DATUB DATS 8 0
ANDAT Date record created on ANDAT DATS 8 0
ANNAM User who created record ANNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
VBKZ Update indicator VBKZ CHAR 1 0
I Insert
U Update
D Delete
MARK Indicator: posting line selected? MARK CHAR 1 0
X Yes
NULL No
ZAEHL Count parameters NUMC4 NUMC 4 0
REM Status indicator of run schedule header in prod. version FV_STATS_REM CHAR 1 0
RECIPE Status indicator for recipe in production version FV_STATS_RECIPE CHAR 1 0
NEW_AENR Change Number AENNR CHAR 12 0
MEINS Base Unit of Measure MEINS UNIT 3 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
PRFG_X 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
MESSAGE Display Whether Message Exists FV_STATS_MEASSAGE CHAR 1 0
EXT_SCREEN_SET Single-Character Indicator CHAR1 CHAR 1 0

MKAL_EXPAND foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MKAL_EXPAND ALORT MKAL_EXPAND WERKS T001L Storage Locations WERKS
MKAL_EXPAND ALORT MKAL_EXPAND ALORT T001L Storage Locations LGORT
MKAL_EXPAND ALORT MKAL_EXPAND MANDT T001L Storage Locations MANDT
MKAL_EXPAND CSPLT MKAL_EXPAND MANDT MAKV Material Cost Distribution MANDT
MKAL_EXPAND CSPLT MKAL_EXPAND CSPLT MAKV Material Cost Distribution CSPLIT
MKAL_EXPAND CSPLT MKAL_EXPAND WERKS MAKV Material Cost Distribution WERKS
MKAL_EXPAND CSPLT MKAL_EXPAND MATNR MAKV Material Cost Distribution MATNR
MKAL_EXPAND ELPRO MKAL_EXPAND MANDT T001L Storage Locations MANDT
MKAL_EXPAND ELPRO MKAL_EXPAND WERKS T001L Storage Locations WERKS
MKAL_EXPAND ELPRO MKAL_EXPAND ELPRO T001L Storage Locations LGORT
MKAL_EXPAND MANDT MKAL_EXPAND MANDT T000 Clients MANDT
MKAL_EXPAND MATKO MKAL_EXPAND MANDT MARA General Material Data MANDT
MKAL_EXPAND MATKO MKAL_EXPAND MATKO MARA General Material Data MATNR
MKAL_EXPAND MATNR MKAL_EXPAND MANDT MARA General Material Data MANDT
MKAL_EXPAND MATNR MKAL_EXPAND MATNR MARA General Material Data MATNR
MKAL_EXPAND MDV02 MKAL_EXPAND MDV02 T437P Planning IDs for Repetitive Manufacturing PLAN_ID
MKAL_EXPAND MDV02 MKAL_EXPAND WERKS T437P Planning IDs for Repetitive Manufacturing WERKS
MKAL_EXPAND MDV02 MKAL_EXPAND MANDT T437P Planning IDs for Repetitive Manufacturing MANDT
MKAL_EXPAND PLNTY MKAL_EXPAND MANDT TCA01 Task list types MANDT
MKAL_EXPAND PLNTY MKAL_EXPAND PLNTY TCA01 Task list types PLNTY
MKAL_EXPAND PLTYG MKAL_EXPAND MANDT TCA01 Task list types MANDT
MKAL_EXPAND PLTYG MKAL_EXPAND PLTYG TCA01 Task list types PLNTY
MKAL_EXPAND PLTYM MKAL_EXPAND MANDT TCA01 Task list types MANDT
MKAL_EXPAND PLTYM MKAL_EXPAND PLTYM TCA01 Task list types PLNTY
MKAL_EXPAND SOBSL MKAL_EXPAND SOBSL T460A Special procurement key SOBSL
MKAL_EXPAND SOBSL MKAL_EXPAND WERKS T460A Special procurement key WERKS
MKAL_EXPAND SOBSL MKAL_EXPAND MANDT T460A Special procurement key MANDT
MKAL_EXPAND STLAN MKAL_EXPAND STLAN T416 BOM Usage - Item Statuses STLAN
MKAL_EXPAND STLAN MKAL_EXPAND MANDT T416 BOM Usage - Item Statuses MANDT
MKAL_EXPAND VERTO MKAL_EXPAND MANDT T437V Distribution key in MRP MANDT
MKAL_EXPAND VERTO MKAL_EXPAND WERKS T437V Distribution key in MRP WERKS
MKAL_EXPAND VERTO MKAL_EXPAND VERTO T437V Distribution key in MRP VERTL
MKAL_EXPAND WERKS MKAL_EXPAND MANDT T001W Plants/Branches MANDT
MKAL_EXPAND WERKS MKAL_EXPAND WERKS T001W Plants/Branches WERKS