SAP MPES_RTGV_HDR Table in S/4 HANA - Shop Floor Routing Header Data and View
MPES_RTGV_HDR is a standard SAP Table which is used to store Shop Floor Routing Header Data and View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP MPES_RTGV_HDR table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
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: MPES_RTGV_HDR
MPES_RTGV_HDR table structure field list
Below is the full MPES_RTGV_HDR 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 |
PLNTY | Task List Type | PLNTY | CHAR | 1(0) | PLNTY | PTY | H_TCA01 | PLNTY | ||
PLNNR | Routing Group | MPE_RTG_ROUTING_GROUP | CHAR | 8(0) | PLVK | ALPHA | PLNNR | |||
PLNAL | Group Counter | MPE_RTG_ROUTING_VARIANT | CHAR | 2(0) | PLVK | ALPHA | ALTNR | |||
VERSN | Routing Version | PLNVERSN | CHAR | 4(0) | PLVK | ALPHA | PLNVERSN | |||
STATUS | Processing Status for Routing Version | PLNVERSN_STATUS | CHAR | 2(0) | PLNVERSN_STATUS | |||||
NUM_SUC | Number of direct successors to a BOO version | PLNVERSN_NUM_SUC | INT4 | 10(0) | ||||||
AUFNR | Order Number | CP_AUFNR | CHAR | 12(0) | ALPHA | AUFNR | ||||
CPX_LVL | Boolean (space=false, X=true) | CP_BOOLEAN | CHAR | 1(0) | CP_BOOLEAN | |||||
LAST_VERSN | Task List Version: Last Release Version | PLNVERSN_LAST_IND | CHAR | 1(0) | PLNVERSN_LAST_IND | |||||
CREATED_BY | Created By User | VDM_CREATEDBYUSERID | CHAR | 12(0) | XUBNAME | |||||
CREATED_AT | Creation Date and Time | MPE_RTG_CREATED_AT | DEC | 15(0) | TZNTSTMPS | |||||
CHANGED_BY | Last Changed By User | VDM_LASTCHANGEDBYUSERID | CHAR | 12(0) | XUBNAME | |||||
CHANGED_AT | Change Date and Time | MPE_RTG_CHANGED_AT | DEC | 15(0) | TZNTSTMPS | |||||
SOURCE_PLNTY | Task List Version: Type of Source | PLNVERSN_SOURCE_PLNTY | CHAR | 1(0) | PLNTY | |||||
SOURCE_PLNNR | Task List Version: Number of Source | PLNVERSN_SOURCE_PLNNR | CHAR | 8(0) | ALPHA | PLNNR | ||||
SOURCE_PLNAL | Task List Version: Group Counter of Source | PLNVERSN_SOURCE_PLNAL | CHAR | 2(0) | ALPHA | ALTNR | ||||
SOURCE_VERSN | Source Routing Version | PLNVERSN_SOURCE_VERSN | CHAR | 4(0) | ALPHA | PLNVERSN | ||||
DUMMY_PLVK_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 1(0) | ||||||
DATUV | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
TECHV | Technical status from | TECHV | CHAR | 12(0) | TECHS | |||||
AENNR | Change Number | AENNR | CHAR | 12(0) | AENR | AENNR | AENNR | AEN | ||
LOEKZ | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
PARKZ | Indicator: inactive changes | PARKZ | CHAR | 1(0) | XFELD | |||||
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 | |||||
VERWE | Routing Usage | MPE_RTG_USAGE | CHAR | 3(0) | T411 | PLN_VERWE | ||||
WERKS | Production Plant in Planned Order | PWWRK | CHAR | 4(0) | T001W | WERKS | ||||
STATU | Overall Status | MPE_RTG_ROUTING_STATUS | CHAR | 3(0) | T412 | PLNST | ||||
PLNME | Routing Unit of Measure | MPE_RTG_UNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LOSVN | Minimum Lot Size | MPE_RTG_LOTSIZE_MIN | QUAN | 13(3) | MENG13 | |||||
LOSBS | Maximum Lot Size | MPE_RTG_LOTSIZE_MAX | QUAN | 13(3) | MENG13 | |||||
VAGRP | Responsible Planner Group or Department | MPE_RTG_PLANNER_GROUP | CHAR | 3(0) | T024A | VAGRP | ||||
AESZN | Document change number (without document management system) | AESZN | CHAR | 6(0) | AENUM | |||||
KTEXT | Description of the Routing Version | MPE_RTG_VERSION_DESCRIPTION | CHAR | 40(0) | TEXT40 | |||||
TXTSP | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
ABDAT | Date of the Last Call | ABRUFDAT | DATS | 8(0) | DATUM | |||||
ABANZ | Number of Calls | MPE_RTG_NUM_CALLS | DEC | 4(0) | ABRUFANZ | |||||
PROFIDNETZ | Profile | PROFID_STD | CHAR | 7(0) | TCA41 | PROFID | PIN | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4(0) | TKA01 | CACCD | CAC | |||
QVEWERKS | Plant of Selected Set for Automatic Usage Decision | QVEWERKS | CHAR | 4(0) | T001W | WERKS | WRK | |||
QVEMENGE | Selected Set for Usage Decision | QVEMENGE | CHAR | 8(0) | QAUSWAHLMG | AWM | ||||
QVEVERSION | Code Version Used for an Automatic Usage Decision | QVEVERSION | CHAR | 6(0) | ALPHA | QVERSNR | ||||
QVEDATUM | Date when Usage Decision Was Recorded | QVEDATUM | DATS | 8(0) | DATUM | |||||
QVEGRUPPE | Code Group for Automatic Usage Decision | QVEGRUPPE | CHAR | 8(0) | QCODEGRP | CGP | ||||
QVECODE | Code for Automatic Usage Decision | QVECODE | CHAR | 4(0) | QCODE | |||||
QDYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3(0) | QDDR | QDYNREGEL | QDR | |||
QDYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | QDYNHEAD | CHAR | 1(0) | TQ39A | QDYNHEAD | ||||
QPRZIEHVER | Sample-Drawing Procedure | QPRZIEHVER | CHAR | 8(0) | QPRVK | QPRZIEHVER | QPV | |||
QVERSNPRZV | Version No. of the Sample-Drawing Procedure | QVERSNPRZV | CHAR | 6(0) | ALPHA | QVERSNR | ||||
QKZRASTER | Inspection Point | QKZRASTER | CHAR | 1(0) | QKZ | |||||
QDYNSTRING | String for Dynamic Modification Criteria (Database Relevant) | QDYNSTRING | CHAR | 10(0) | QDYNSTRING | |||||
STRAT | Maintenance Strategy | STRAT | CHAR | 6(0) | T351 | WSTRA | STR | STRAA | STRAT | |
PPOOL | Maintenance package pool | PPOOL | CHAR | 6(0) | PPOOL | |||||
ISTRU | Assembly | ISTRU | CHAR | 40(0) | MARA | MATN1 | MATNR | |||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4(0) | WERKS | IWK | ||||
ANLZU | System Condition | ANLZU | CHAR | 1(0) | T357M | ANLZU | ||||
ARBID | Work center group with planning function | IGEWERK | NUMC | 8(0) | NUM08 | |||||
EXTNUM | External Numbering of Units to Be Inspected | QEXTNUM | CHAR | 1(0) | TQ12 | QEXTNUM | ||||
DELKZ | Indicator: Delete completely in reorganization run | CP_DELKZ | CHAR | 1(0) | FLAG | |||||
ARBTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2(0) | CR_OBJTY | |||||
STUPR | Setup recipe | STUPR | CHAR | 8(0) | ALPHA | PLNNR | ||||
CLNDR | Clean-out recipe | CLNDR | CHAR | 8(0) | ALPHA | PLNNR | ||||
PRTYP | Process type | C2_PRTYP | NUMC | 1(0) | C2_PRTYP | |||||
REODAT | Archive date | REODAT | DATS | 8(0) | DATS | |||||
NETID | Object ID of the resource | CR_OBJID | NUMC | 8(0) | CRID | CR_OBJID | ||||
FLG_CHK | Ind: Task list was submitted for consistency check | FLG_CHKED | CHAR | 1(0) | XFELD | |||||
PSPNR | Standard WBS element | PS_SPS_ELE | NUMC | 8(0) | PRPSS | KONPT | PS_SPSNR | |||
TTRAS | Task lists: Internal representation of the period pattern | CP_TTRAS | NUMC | 6(0) | CP_TTRAS | |||||
KZKFG | Ind: Configurable object | CP_KZKFG | CHAR | 1(0) | XFELD | |||||
PLNNR_ALT | Old Number | CP_PLNNR_A | CHAR | 20(0) | CP_PLNNR_A | |||||
FLG_CAPO | Recalculate standard values at order creation using CAPP | FLG_CAPO | CHAR | 1(0) | FLG_CAPO | |||||
STLTY | BOM category | STLTY | CHAR | 1(0) | STLTY | |||||
STLNR | Bill of Material | STNUM | CHAR | 8(0) | NUMCV | STNUM | STLNR | STLNR | ||
STLAL | Alternative BOM | STLAL | CHAR | 2(0) | ALPHA | ALTNR | ||||
SLWBEZ | Identifier for Inspection Point Field Combination | QSLWBEZ | CHAR | 3(0) | TQ79 | QSLWBEZ | QBK | |||
PPKZTLZU | Partial Lot Assignment in an Inspection During Production | QPPKZTLZU | CHAR | 1(0) | QPPKZTLZU | |||||
CHRULE | Change Rule | R_CHRULE | CHAR | 1(0) | R_CHRULE | |||||
CCOAA | Change Type for Object | CCOAA | NUMC | 3(0) | TCC13 | CCOAA | ||||
ST_ARBID | Object ID | OBJEKTID | NUMC | 8(0) | NUM08 | PON | ||||
MEINH | Unit of measure for activity | VORME | UNIT | 3(0) | CUNIT | MEINS | ||||
UMREZ | Numerator for Converting Routing and Operation UoM | CP_UMREZ | DEC | 5(0) | UMBSZ | |||||
UMREN | Denominator for Converting Routing and Operation UoM | CP_UMREN | DEC | 5(0) | UMBSN | |||||
BMSCH | Base Quantity | BMSCH | QUAN | 13(3) | BMSCH | |||||
ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40(0) | ADDCOMPARE_CORE | ADCP | ADPSP | |||
LONG_TEXT_EXIST | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
DELETED_BY_PARAM_ECN | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
VALID_TO | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
LOEKZ_INHERITED | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
MS_FLAG | Indicator: Multiple Specifications | Q_MS_FLG | CHAR | 1(0) | Q_MS_FLG | |||||
TSTMP_BW | Time Stamp for BI Delta Extraction | TSTMP_BW_EXT | DEC | 16(0) | RKE_TSTMP | |||||
MES_ROUTINGID | Key of a Routing from an ME System | CO_MES_INT_ROUTINGID | CHAR | 64(0) | CHAR64 | |||||
DATUB | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
AENNR_AUS | To change number | CPCS_ECN_TO | CHAR | 12(0) | AENNR | AENNR | ||||
KAP_ARBPL | Work Center for Capacity Planning | KAP_ARBPL | CHAR | 8(0) | ARBPL | AGR | ||||
ST_ARBPL | Work center for a work center operation set | ST_ARBPL | CHAR | 8(0) | ARBPL | |||||
STAUFG | Indicator: Work center operation set | STAUFG | CHAR | 1(0) | FLAG | |||||
LINE | Line Hierarchy | LD_LINE | CHAR | 8(0) | ARBPL | LDH | ||||
AEUZEIT | Time of last change made to the task list | AEUZEIT | TIMS | 6(0) | SYTIME | |||||
BUSINESS_PROCESS | Serialized | MPE_BUSINESS_PROCESS | CHAR | 1(0) | MPE_BUSINESS_PROCESS | |||||
DUMMY_PLKO_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 1(0) | ||||||
FLG_CAPO_TXT | Description of standard values at order creation | CWB_FLG_CAPO_TXT | CHAR | 60(0) | DDTEXT | |||||
VAGRP_TXT | Responsible Planner Group Description | DISPTXT | CHAR | 30(0) | TEXT30 | |||||
PPKZTLZU_TXT | Description of the partial lot assignment | CWB_PPKZTLZU | CHAR | 60(0) | DDTEXT | |||||
QPRVKT_KURZTEXT | Text for Sample-Drawing Procedure | PRZIEHVERF_KTEXT | CHAR | 40(0) | CHAR40 | |||||
QDDRT_KURZTEXT | Description of the dynamic modification rule | QDDRT_QKURZTEXT | CHAR | 40(0) | CHAR40 | |||||
STATU_TXT | Description of the Status | STTEXT | CHAR | 40(0) | TEXT40 | |||||
TQ12T_KURZTEXT | Description of external numbering | TQ12T_TXT | CHAR | 40(0) | CHAR40 | |||||
TQ39L_KURZTEXT | Description of dynamic modification level (TQ39A) | TQ39L_QKURZTEXT | CHAR | 40(0) | CHAR40 | |||||
TQ79T_KURZTEXT | Description of key words for inspection point user fields | TQ79T_TXT | CHAR | 40(0) | CHAR40 | |||||
VERWE_TXT | Description of usage | CWB_VERWE_TXT | CHAR | 20(0) | TEXT20 | |||||
PLNTX | Description of the Task List Type | PLNTX | CHAR | 30(0) | TEXT30 | |||||
TXT | Responsible Planner Group Description | DISPTXT | CHAR | 30(0) | TEXT30 | |||||
VTEXT | Description | VTEXT | CHAR | 20(0) | TEXT20 | |||||
STTEXT | Description of the Status | STTEXT | CHAR | 40(0) | TEXT40 | |||||
NAME1 | Name | NAME1 | CHAR | 30(0) | TEXT30 | |||||
LINE_KTEXT | Work Center Description | KTXT40 | CHAR | 40(0) | TEXT40 | |||||
KAP_ARBPL_TXT | Work Center Description | KTXT40 | CHAR | 40(0) | TEXT40 | |||||
STRAT_TEXT | Description of maintenance strategy | TXWSTRA | CHAR | 30(0) | TXT30 | |||||
SOURCE_VERSN_TXT | Description | PLANTEXT | CHAR | 40(0) | TEXT40 | |||||
.INCLU-_MR | 0(0) | |||||||||
PLNTY_MR | Task List Type | PLNTY | CHAR | 1(0) | PLNTY | PTY | H_TCA01 | PLNTY | ||
PLNNR_MR | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
PLNAL_MR | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
VERSN_MR | Routing Version | PLNVERSN | CHAR | 4(0) | ALPHA | PLNVERSN | ||||
MASTER_ROUTING | Master Routing for Order-specific Routing | MPE_MASTER_ROUTING | CHAR | 40(0) | ||||||
MASTER_ROUTING_TEXT | Description | PLANTEXT | CHAR | 40(0) | TEXT40 | |||||
SUBTYPE | Version Profile | PLNSUBTYPE | CHAR | 1(0) | TCA01_SUBTYPE | PLNSUBTYPE | H_TCA01_SUBTYPE | SUBTYPE | ||
ALTEXT | Description of the Routing | MPE_RTG_ROUTING_DESCRIPTION | CHAR | 40(0) | TEXT40 | |||||
SUBTYPE_TXT | Version Profile Desccription | PLNSUBTX | CHAR | 30(0) | TEXT30 | |||||
ECM_OBJECT_GUID | ECM Object GUID | MPE_RTGV_ECM_OBJECT_GUID | RAW | 16(0) | SYSUUID | |||||
EFF_STRING | Concatenated parameter effectivity information | MPE_RTGV_EFFECTIVITY_STRING | CHAR | 255(0) | MPE_RTGV_EFFECTIVITY_STRING | |||||
REWORK | Rework Routing | MPE_REWORK_ROUTING | CHAR | 1(0) | XFELD | |||||
RELAXED | Flexible Processing | MPE_FLEXIBLE_PROCESSING | CHAR | 1(0) | XFELD | |||||
AENNR_REL_CHECK | Change Number | AENNR | CHAR | 12(0) | AENNR | AENNR | AEN |
Search for further information about these or an SAP related objects