SAP MKAL_EXPAND Table in S/4 HANA - For Buffer and Internal Tables of Production Version
MKAL_EXPAND is a standard SAP Table which is used to store For Buffer and Internal Tables of Production Version data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MKAL_EXPAND table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MKAL_EXPAND
MKAL_EXPAND table structure field list
Below is the full MKAL_EXPAND field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
| WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
| VERID | Production Version | VERID | CHAR | 4(0) | Assigned to domain | VERID | VER | |||
| BDATU | Valid-To Date of Production Version | BDATM | DATS | 8(0) | DATUM | |||||
| ADATU | Valid-From Date of Production Version | ADATM | DATS | 8(0) | DATUM | |||||
| STLAL | Alternative BOM | STALT | CHAR | 2(0) | ALPHA | ALTNR | ||||
| STLAN | BOM Usage | STLAN | CHAR | 1(0) | T416 | STLAN | CSV | |||
| PLNTY | Task List Type | PLNTY | CHAR | 1(0) | TCA01 | PLNTY | PTY | H_TCA01 | PLNTY | |
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
| ALNAL | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
| BESKZ | Procurement Type | BESKZ | CHAR | 1(0) | BESKZ | MBS | ||||
| SOBSL | Special procurement type | SOBSL | CHAR | 2(0) | T460A | SOBSL | ||||
| LOSGR | Lot Size for Product Costing | CK_LOSGR | QUAN | 13(3) | MENG13 | |||||
| MDV01 | Production Line for Repetitive Manufacturing | SA_LINE1 | CHAR | 8(0) | ARBPL | AGR | RMLINE | ARBPL | ||
| MDV02 | Planning identification | MDV | CHAR | 8(0) | T437P | MDVXX | ||||
| TEXT1 | Short Text for Production Version | VERS_TEXT | CHAR | 40(0) | TEXT40 | |||||
| EWAHR | Usage Probability with Version Control | CK_EWAHR | DEC | 3(0) | CK_EWAHR | |||||
| VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4(0) | T437V | SA_VERTL | ||||
| SERKZ | Repetitive Manufacturing Allowed for Version | SA_VERSI | CHAR | 1(0) | XFELD | |||||
| BSTMI | Minimum Lot Size Quantity | SA_LOSVN | QUAN | 13(3) | MENG13 | |||||
| BSTMA | Material Maximum Lot Size Quantity | SA_LOSBS | QUAN | 13(3) | MENG13 | |||||
| RGEKZ | Indicator: backflush for RS header | SA_RGEKZ | CHAR | 1(0) | CO_RGEKZ | |||||
| ALORT | Receiving storage location for repetitive manufacturing | ALORT | CHAR | 4(0) | T001L | LGORT | ||||
| PLTYG | Task List Type | PLNTY | CHAR | 1(0) | TCA01 | PLNTY | PTY | H_TCA01 | PLNTY | |
| PLNNG | -INVALID FOR S/4- Task list group for rate-based planning | RATENPLAN | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
| ALNAG | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
| PLTYM | Task List Type | PLNTY | CHAR | 1(0) | TCA01 | PLNTY | PTY | H_TCA01 | PLNTY | |
| PLNNM | -INVALID FOR S/4- Task list group for rough-cut planning | GROBPLAN | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
| ALNAM | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
| CSPLT | Apportionment Structure | CSPLIT | CHAR | 4(0) | MAKV | CSPLIT | ||||
| MATKO | Other material for which BOM and task list are maintained | MKAL_MATKO | CHAR | 40(0) | MARA | MATN1 | MATNR | |||
| ELPRO | Proposed issue storage location for components | SA_ELPRO | CHAR | 4(0) | T001L | LGORT | ||||
| PRVBE | Default Supply Area for Components | SA_PRVBE | CHAR | 10(0) | Assigned to domain | PRVBE | PVB | |||
| PRFG_F | Check Status of Production Version | PRFG_F | CHAR | 1(0) | PRFG | |||||
| PRDAT | Date of last check of production version | MKPRDAT | DATS | 8(0) | DATUM | |||||
| MKSP | Production Version Lock | MKSP | CHAR | 1(0) | MKSP | |||||
| PRFG_R | Rate-based planning - Check status of production version | PRFG_R | CHAR | 1(0) | PRFG | |||||
| PRFG_G | Preliminary planning - Check status of production version | PRFG_G | CHAR | 1(0) | PRFG | |||||
| PRFG_S | BOM - check status of production version | PRFG_S | CHAR | 1(0) | PRFG | |||||
| UCMAT | Reference Material for Original Batches | VBOB_OB_RFMAT | CHAR | 40(0) | MATN1 | MATNR | MAT1 | MATNR | ||
| VERSIND | Indicator: BOM and Routing Version Exists | MPE_PV_VERSIND | CHAR | 1(0) | BOOLE | |||||
| DIFFPLANEXEMSTR | Planning and Execution Master Differ | MPE_PV_DIFFPLANEXEMSTR | CHAR | 1(0) | BOOLE | |||||
| EWM_LGNUM | Warehouse Number/Warehouse Complex | /SCWM/LGNUM | CHAR | 4(0) | /SCWM/LGNUM | /SCWM/LGN | /SCWM/SH_LGNUM | LGNUM | ||
| EWM_LGPLA | Destination Storage Bin | /SCWM/LTAP_NLPLA | CHAR | 18(0) | Assigned to domain | /SCWM/LGPLA | ||||
| EXE_STLAL | Shop Floor BOM Alternative | MPE_PV_EXE_STLAL | CHAR | 2(0) | ALPHA | ALTNR | ||||
| EXE_STLAN | Shop Floor BOM Usage | MPE_PV_EXE_STLAN | CHAR | 1(0) | Assigned to domain | STLAN | ||||
| EXE_PLNTY | Shop Floor Routing Task List Type | MPE_PV_EXE_PLNTY | CHAR | 1(0) | Assigned to domain | PLNTY | ||||
| EXE_PLNNR | Shop Floor Routing Tasklist Group | MPE_PV_EXE_PLNNR | CHAR | 8(0) | ALPHA | PLNNR | ||||
| EXE_ALNAL | Shop Floor Routing Tasklist Group Counter | MPE_PV_EXE_ALNAL | CHAR | 2(0) | ALPHA | ALTNR | ||||
| .INCLU--AP | 0(0) | |||||||||
| PPEGUID | Internal Identification for PVS Objects | PVS_GUID | RAW | 16(0) | SYSUUID | |||||
| AENNR | Change Number | AENNR | CHAR | 12(0) | AENNR | AENNR | AEN | |||
| DATUV | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
| DATUB | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
| ANDAT | Date Record Created On | ANDAT | DATS | 8(0) | DATUM | |||||
| ANNAM | User who created record | ANNAM | CHAR | 12(0) | USNAM | |||||
| AEDAT | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
| AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
| VBKZ | Update indicator | VBKZ | CHAR | 1(0) | VERBUCHER | |||||
| MARK | Indicator: Posting Line Selected? | MARK | CHAR | 1(0) | XFELD | |||||
| ZAEHL | Count parameters | NUMC4 | NUMC | 4(0) | NUMC4 | |||||
| REM | Status indicator of run schedule header in prod. version | FV_STATS_REM | CHAR | 1(0) | FV_VB_FLAG | |||||
| RECIPE | Status indicator for recipe in production version | FV_STATS_RECIPE | CHAR | 1(0) | FV_VB_FLAG | |||||
| NEW_AENR | Change Number | AENNR | CHAR | 12(0) | AENNR | AENNR | AEN | |||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
| MAKTX | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
| PRFG_X | Check Status of Production Version | PRFG_F | CHAR | 1(0) | PRFG | |||||
| MESSAGE | Display Whether Message Exists | FV_STATS_MEASSAGE | CHAR | 1(0) | FV_VB_FLAG | |||||
| EXT_SCREEN_SET | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 |
Search for further information about these or an SAP related objects