UMD04 SAP (Default Values for Planning Table in Repetitive Mfg) Table details
Description: Default Values for Planning Table in Repetitive Mfg
Table field list including key, data, relationships and ABAP select examples
UMD04 is a standard SAP Table which is used to store Default Values for Planning Table in Repetitive Mfg data and is available within R/3 SAP systems depending on the version and release level.
The UMD04 table consists of various fields, each holding specific information or linking keys about Default Values for Planning Table in Repetitive Mfg data available in SAP. These include UNAME (User Name), MDAKT (Activity types in materials planning), NETPL (Net requirements segment in the planning table), BRTPL (Gross requirements planning in the planning table).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP UMD04 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
UNAME | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
MDAKT | Activity types in materials planning | MDAKT | CHAR | 1 | MDAKT | ||||
NETPL | Net requirements segment in the planning table | NETPL | CHAR | 1 | CHAR1 | ||||
BRTPL | Gross requirements planning in the planning table | BRTPL | CHAR | 1 | CHAR1 | ||||
LGOR1 | Storage location MRP in the planning table | LGOR1 | CHAR | 1 | CHAR1 | ||||
LGOR2 | Excluded storage locations in the planning table | LGOR2 | CHAR | 1 | CHAR1 | ||||
KNDPL | Make-to-order planning in the planning table | KNDPL | CHAR | 1 | CHAR1 | ||||
PROPL | Planning individual projects in the planning table | PROPL | CHAR | 1 | CHAR1 | ||||
MSTPL | Direct Production in Planning Table | MSTPL | CHAR | 1 | CHAR1 | ||||
VORPL | Planning without final assembly in the planning table | VORPL | CHAR | 1 | CHAR1 | ||||
LELIW | Only select materials with production | LELIW | CHAR | 1 | CHAR1 | ||||
ONLRQ | Only select materials with requirements | ONLRQ | CHAR | 1 | CHAR1 | ||||
ANZKA | Only display capacity categories relevant to scheduling | ANZKA | CHAR | 1 | CHAR1 | ||||
KPFLG | Indicator: Capacity planning active | KPFLG | CHAR | 1 | CHAR1 | ||||
ERWMD | Disable extended material data in REM planning table | ERWMD | CHAR | 1 | CHAR1 | ||||
SELH1 | Selection period for the planning table | SA_SELH1 | DEC | 3 | DEC03 | ||||
SELH2 | Selection period for the planning table | SA_SELH1 | DEC | 3 | DEC03 | ||||
SKBED | Row sort ID for requirements in the planning table | SA_SKBED | NUMC | 2 | NUMC2 | ||||
SKVER | Row Sort ID for 'Available Quantity' in Planning Table | SA_SKVER | NUMC | 2 | NUMC2 | ||||
SKREI | Row sort ID for coverage in the planning table | SA_SKREI | NUMC | 2 | NUMC2 | ||||
SKAND | Row sort ID for other versions in the planning table | SA_SKAND | NUMC | 2 | NUMC2 | ||||
SKNZU | Row sort ID for 'to be assigned' in the planning table | SA_SKNZU | NUMC | 2 | NUMC2 | ||||
SKVPB | Row sort ID for planned indep. reqmts in the planning table | SA_SKVPB | NUMC | 2 | NUMC2 | ||||
SKSUZ | Row sort ID for 'total receipts' in the planning table | SA_SKSUZ | NUMC | 2 | NUMC2 | ||||
SKSUB | Row sort ID for 'total requirements' in the planning table | SA_SKSUB | NUMC | 2 | NUMC2 | ||||
SKPRD | Row sort ID for production in the planning table | SA_SKPRD | NUMC | 2 | NUMC2 | ||||
SKSZU | Row sort ID for 'other receipts' in the planning table | SA_SKSZU | NUMC | 2 | NUMC2 | ||||
SKLFP | Row sort IS for long-term planning in the planning table | SA_SKLFP | NUMC | 2 | NUMC2 | ||||
SKREW | Row Sort ID for Range of Coverage in Planning Table | SKREW | NUMC | 2 | NUMC2 | ||||
MATSK | Material selection appears when accessing the planning table | SA_MATSK | CHAR | 1 | CHAR1 | ||||
LINSK | Line selection appears when accessing the planning table | SA_LINSK | CHAR | 1 | CHAR1 | ||||
PERIO | Time bucket | SA_PERIO | CHAR | 1 | SA_PERIO | ||||
PRDPL | Production dates or basic dates ? | PRDPL | CHAR | 1 | PRDPL | ||||
PATVR | Scheduling strategy in the planning table | PATVR | CHAR | 1 | PATVR | ||||
ABBED | Display requirements rows | ABBED | CHAR | 1 | CHAR1 | ||||
ABVER | Display availability | ABVER | CHAR | 1 | CHAR1 | ||||
ABREI | Display coverage | ABREI | CHAR | 1 | ABREI | ||||
ABAND | Display other versions | ABAND | CHAR | 1 | CHAR1 | ||||
ABNZU | Display quantities still to be assigned | ABNZU | CHAR | 1 | CHAR1 | ||||
ABVPB | Display planned independent reqmts in the planning table | ABVPB | CHAR | 1 | CHAR1 | ||||
ABSUZ | Display total production in the planning table | ABSUZ | CHAR | 1 | CHAR1 | ||||
ABSUB | Display total requirments in the planning table | ABSBE | CHAR | 1 | CHAR1 | ||||
ABUEZ | Display the user exit row in the planning table | ABUEZ | CHAR | 1 | CHAR1 | ||||
ABSZU | Display other receipts | ABSZU | CHAR | 1 | CHAR1 | ||||
ABLFP | Display information from long-term planning | ABLFP | CHAR | 1 | CHAR1 | ||||
SKTPT | Sort in the planning table: By material - by line | SKZPT | CHAR | 1 | SKZPT | ||||
SVIEW | View selection for the repetitive mfg planning table | SVIEW | CHAR | 1 | SVIEW | ||||
PFEXL | Path for accessing EXCEL in the planning table (MF50) | PFEXL | CHAR | 100 | CHAR100 | ||||
TEEKZ | Determines the scheduling level in the planning table | TEEKZ | CHAR | 1 | TEEKZ | ||||
SMEKZ | Standard unit of measure | UNIKZ | NUMC | 2 | SMEKZ | ||||
DSTRI | Quantities display in the planning table | DSTRI | CHAR | 1 | DSTRI | ||||
DSPHZ | Period in days for automatically dispatching in MF50 | DSPHZ | NUMC | 3 | NUM03 | ||||
ABKOM | REM-PT: MRP segment aggregation | ABKOM | CHAR | 1 | ABKOM | ||||
SKUE1 | Row sort ID for user exit rows in planning table | SA_SKUEZ | NUMC | 2 | NUMC2 | ||||
ABUE2 | Display the user exit row in the planning table | ABUEZ | CHAR | 1 | CHAR1 | ||||
SKUE2 | Row sort ID for user exit rows in planning table | SA_SKUEZ | NUMC | 2 | NUMC2 | ||||
ABUE3 | Display the user exit row in the planning table | ABUEZ | CHAR | 1 | CHAR1 | ||||
SKUE3 | Row sort ID for user exit rows in planning table | SA_SKUEZ | NUMC | 2 | NUMC2 | ||||
JVIEW | View of dispatched orders | SP_GJVIEW | CHAR | 1 | SP_GJVIEW | ||||
DETLI | Detailed information (restrictions) on production line | DETAIL_LINE | CHAR | 1 | XFLAG | ||||
DETDI | Detailed information (restriction) on MRP controller | DETAIL_DISPONENT | CHAR | 1 | XFLAG | ||||
TABST | REM PT: Active tabstrip (set in initial screen) | ACTIVE_TAB_STRIP | CHAR | 4 | CHAR4 | ||||
DAYDE | Indicates whether day's description displayed for periods | DAY_DESCRIBTION | CHAR | 1 | CHAR1 | ||||
COLTX | Column width | COLWIDTH | NUMC | 2 | NUMC2 | ||||
COLMA | Column width | COLWIDTH | NUMC | 2 | NUMC2 | ||||
ERGBZ | Selection rule | ERGBZ | CHAR | 8 | CHAR8 |
Key field | Non-key field |
How do I retrieve data from SAP table UMD04 using ABAP code
The following ABAP code Example will allow you to do a basic selection on UMD04 to SELECT all data from the tableDATA: WA_UMD04 TYPE UMD04.
SELECT SINGLE *
FROM UMD04
INTO CORRESPONDING FIELDS OF WA_UMD04
WHERE...
How to access SAP table UMD04
Within an ECC or HANA version of SAP you can also view further information about UMD04 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects