SAP MPES_RTGV_PRT Table in S/4 HANA - Shop Floor Routing PRT Data and View
MPES_RTGV_PRT is a standard SAP Table which is used to store Shop Floor Routing PRT 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_PRT 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_PRT
MPES_RTGV_PRT table structure field list
Below is the full MPES_RTGV_PRT 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 | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
PLNAL | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
VERSN | Routing Version | PLNVERSN | CHAR | 4(0) | ALPHA | PLNVERSN | ||||
PLNFL | Sequence | PLNFOLGE | CHAR | 6(0) | ALPHA | PLNFOLGE | ||||
PLNKN | Number of the Task List Node | PLNKN | NUMC | 8(0) | KNTNR | |||||
PZLFH | Item Counter for Production Resources/Tools | PZLFH | NUMC | 8(0) | PZLFH | |||||
DATUV | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
TECHV | Technical status from | TECHV | CHAR | 12(0) | TECHS | |||||
LOEKZ | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
PARKZ | Indicator: inactive changes | PARKZ | CHAR | 1(0) | XFELD | |||||
AENNR | Change Number | AENNR | CHAR | 12(0) | AENR | AENNR | AENNR | AEN | ||
DATUI | Date Record Created On | ANDAT | DATS | 8(0) | DATUM | |||||
USERI | User who created record | ANNAM | CHAR | 12(0) | USNAM | |||||
DATUC | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
USERC | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2(0) | CR_OBJTY | |||||
OBJID | Object ID of the resource | CR_OBJID | NUMC | 8(0) | CRID | CR_OBJID | ||||
OBJCT | Object of a task list | OBJCT_D | CHAR | 1(0) | OBJKT | |||||
PSNFH | Item Number for Production Resource/Tool | PSNFH | NUMC | 4(0) | PSNFH | |||||
STEUF | Control Profile for Management of Production Resources/Tools | STEUF | CHAR | 4(0) | TCF10 | STEUF | ||||
KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR | 1(0) | XFELD | |||||
BZOFFB | Reference Date for Start of Production Resource/Tool Usage | BZOFFB | CHAR | 2(0) | TCA54 | CP_BZOFF | ||||
OFFSTB | Offset to start of production resource/tool usage | OFFSTB | QUAN | 5(0) | VNZTV | |||||
EHOFFB | Offset Unit for Start of Prodn Resource/Tool Usage | EHOFFB | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
BZOFFE | Reference date for end of production resource/tool usage | BZOFFE | CHAR | 2(0) | TCA54 | CP_BZOFF | ||||
OFFSTE | Offset to finish of production resource/tool usage | OFFSTE | QUAN | 5(0) | VNZTV | |||||
EHOFFE | Offset Unit for End of Production Resource/Tool Usage | EHOFFE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
MGEINH | Unit for Quantity of Production Resources/Tools | MGEINH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
MGVGW | Standard Value for Quantity of Production Resources/Tools | MGVGW | QUAN | 9(3) | MENG9 | |||||
MGFORM | Formula for Calculating the Total Quantity of PRT | CF_MGFORM | CHAR | 6(0) | TC25 | AP_FORMEL | ||||
EWEINH | Usage Value Unit of the Production Resource/Tool | EWEINH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
EWVGW | Standard Usage Value for Production Resources/Tools | EWVGW | QUAN | 9(3) | MENG9 | |||||
EWFORM | Formula for Calculating the Total Usage Value of PRT | CF_EWFORM | CHAR | 6(0) | TC25 | AP_FORMEL | ||||
TXTSP | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
KTSCH | Standard Text Key for Production Resources/Tools | CF_KTSCH | CHAR | 7(0) | T435 | KTSCH | ||||
TXTZ1 | First Line of Text for Production Resources/Tools | TXTZ1 | CHAR | 40(0) | TEXT40 | |||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18(0) | KNOBJ | |||||
GP_KRIT1 | Planning object | PLOBJ | CHAR | 18(0) | CHAR18 | |||||
VPLTY | Type of the referenced task list | VPLNTY | CHAR | 1(0) | PLNTY | |||||
VPLNR | Group of the referenced task list | VPLNNR | CHAR | 8(0) | ALPHA | PLNNR | ||||
VPLAL | Group counter of the referenced task list | VPLNAL | CHAR | 2(0) | ALPHA | ALTNR | ||||
IDENT | Operation ID | OPRID | CHAR | 8(0) | CHAR8 | |||||
IDENT_REF | Operation ID of the referenced operation | OPR_REFID | CHAR | 8(0) | CHAR8 | |||||
HERKUNFT | Origin of an operation | OPR_HER | CHAR | 1(0) | OPR_HER | |||||
MGSOL | Total Planned Quantity of Production Resource/Tool | MGSOL | QUAN | 9(3) | MENG9 | |||||
MGIST | Actual Quantity of Production Resource/Tool | MGIST | QUAN | 9(3) | MENG9 | |||||
MGRST | Remaining Quantity of the Production Resource/Tool | MGRST | QUAN | 9(3) | MENG9 | |||||
MGAUS | Quantity of checked-out production resources/tools | MGAUS | QUAN | 9(3) | MENG9 | |||||
EWSOL | Total Planned Usage Value of Production Resource/Tool | EWSOL | QUAN | 9(3) | MENG9 | |||||
EWIST | Actual Usage Value for Production Resource/Tool | EWIST | QUAN | 9(3) | MENG9 | |||||
EWRST | Remaining Usage Value of the Production Resource/Tool | EWRST | QUAN | 9(3) | MENG9 | |||||
FHMAR | Production Resources/Tools Category | FHMAR | CHAR | 1(0) | TCF02 | FHMAR | FHMAR | FHA | ||
FHMNR | Production resource/tool number | FHMNR | CHAR | 40(0) | FHMNR | |||||
FHWRK | Production Resources/Tools in Plant | FHWRK | CHAR | 4(0) | WERKS | WRK | ||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
SFHNR | Production resources and tools | SFHNR | CHAR | 18(0) | ALPHA | SFHNR | FHS | FHMS | SFHNR | |
DOKAR | Document Type | DOKAR | CHAR | 3(0) | DOKAR | CV2 | ||||
DOKNR | Document number | DOKNR | CHAR | 25(0) | ALPHA | DOKNR | CV1 | |||
DOKTL | Document part | DOKTL_D | CHAR | 3(0) | DOKTL | CV4 | ||||
DOKVR | Document version | DOKVR | CHAR | 2(0) | DOKVR | CV3 | ||||
EQUNR | Equipment Number | EQUNR | CHAR | 18(0) | ALPHA | EQUNR | EQN | EQUI | EQUNR | |
EQWPL | Maintenance Plan | WARPL | CHAR | 12(0) | ALPHA | WARPL | MPL | MPLAL | WARPL | |
EQWTX | Maintenance Plan Text | WPTXT | CHAR | 40(0) | TEXT40 | |||||
EQPNT | Measuring Point | IMRC_POINT | CHAR | 12(0) | ALPHA | IMRC_POINT | IPT | IMPM | POINT | |
EQPTX | Description of Measuring Point | IMRC_PTTXT | CHAR | 40(0) | TEXT40 | |||||
ATNAM | Characteristic Name | ATNAM | CHAR | 30(0) | ATNAM | FEA | ||||
ATVOR | Indicator: Negative Values Allowed | IMRC_INEGV | CHAR | 1(0) | X | |||||
MSEHI | Unit of Measurement | MSEHI | UNIT | 3(0) | CUNIT | MEINS | ||||
ATDIM | Exponent display | ATDIM | INT2 | 5(0) | EXP10 | |||||
ANZDZ | Number of Decimal Places | ANZDZ | INT2 | 5(0) | ANZDZ | |||||
FHKTX | Description of the Production Resource/Tool | FHKTX | CHAR | 40(0) | TEXT40 | |||||
BASEH | Base unit of measure for production resources/tools | CF_BASEH | UNIT | 3(0) | CUNIT | MEINS | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
FGRU1 | Grouping Key 1 for Production Resources/Tools | FGRUA | CHAR | 4(0) | FGRUA | |||||
FGRU2 | Grouping Key 2 for Production Resources/Tools | FGRUB | CHAR | 4(0) | FGRUA | |||||
STOWK | Plant location of the production resource/tool | CF_STOWK | CHAR | 4(0) | WERKS | WRK | ||||
STORT | Location of a production resource or tool | CF_STORT | CHAR | 10(0) | AP_STAND | |||||
STEUF_REF | Control key cannot be changed | CF_STKZR | CHAR | 1(0) | XFELD | |||||
KTSCH_REF | Reference Key Cannot be Changed | CF_KTKZR | CHAR | 1(0) | XFELD | |||||
BZOFFB_REF | Start reference date cannot be changed | CF_BBKZR | CHAR | 1(0) | XFELD | |||||
OFFSTB_REF | Offset to start cannot be changed | CF_OBKZR | CHAR | 1(0) | XFELD | |||||
BZOFFE_REF | End reference date cannot be changed | CF_BEKZR | CHAR | 1(0) | XFELD | |||||
OFFSTE_REF | Offset to end cannot be changed | CF_OEKZR | CHAR | 1(0) | XFELD | |||||
MGFORM_REF | Formula for calculating the total quantity cannot be changed | CF_MFKZR | CHAR | 1(0) | XFELD | |||||
EWFORM_REF | Formula to calculate entire usage value cannot be changed | CF_EFKZR | CHAR | 1(0) | XFELD | |||||
DATUB | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
AENNR_AUS | To change number | CPCS_ECN_TO | CHAR | 12(0) | AENNR | AENNR | ||||
TXTKZ | Long Text Exists | CF_TXTKZ | CHAR | 1(0) | FLAG | |||||
CF_KZSVS | Indicator for start of PRT usage: Offset to Operation start | CF_KZSVS | CHAR | 1(0) | XFELD | |||||
CF_KZSVE | Indicator for start of PRT usage: Offset to op. finish | CF_KZSVE | CHAR | 1(0) | XFELD | |||||
CF_KZEVS | Indicator for end of PRT usage: Offset to operation start | CF_KZEVS | CHAR | 1(0) | XFELD | |||||
CF_KZEVE | Indicator for end of PRT usage: Offset to operation finish | CF_KZEVE | CHAR | 1(0) | XFELD | |||||
VORNR | Operation Number | MPE_RTG_OPERATION | CHAR | 4(0) | NUMCV | VORNR | ||||
LONG_TEXT_EXIST | General Flag | FLAG | CHAR | 1(0) | FLAG | |||||
VERSN_SOURCE | Source Routing Version | PLNVERSN_SOURCE_VERSN | CHAR | 4(0) | ALPHA | PLNVERSN | ||||
VERSN_SOURCE_PZLFH | Task List Version: Item counter Source production res./tools | PLNVERSN_SOURCE_PZLFH | NUMC | 8(0) | PZLFH | |||||
OAN_ID | Identifies an Operation Activity Network | MPE_OAN_ID | INT8 | 19(0) | MPE_OAN_ELEMENT_ID | |||||
OAN_VERSION_NO | Object Version Number | MPE_OAN_OBJECT_VERSION_NO | INT4 | 10(0) | ||||||
OAN_ELEMENT_NUMBER | Internal OAN Element Number | MPE_OAN_ELEMENT_NUMBER | INT4 | 10(0) | ||||||
OAN_SEGMENT_TYPE | OA Segment Type (Setup, Produce, or Teardown) | MPE_OAN_SEGMENT_TYPE | NUMC | 1(0) | MPE_OAN_SEGMENT_TYPE | |||||
OA_ID | Identifies an Operation Activity | MPE_OA_ID | INT8 | 19(0) | MPE_OAN_ELEMENT_ID | |||||
OA_VERSION_NO | Number of an Operation Actiivity Version | MPE_OA_VERSION_NO | INT4 | 10(0) | ||||||
OAN_ELEMENT_NUMBER_EXT | Element Number | MPE_OAN_ELEMENT_NUMBER_EXT | CHAR | 10(0) | ALPHA | MPE_OAN_ELEMENT_NUMBER_EXT | ||||
OAN_ELEMENT_AENNR | Change Number | AENNR | CHAR | 12(0) | Assigned to domain | AENNR | AENNR | AEN | ||
OAN_SEGMENT_TYPE_TEXT | OA Segment Type Name (Setup, Produce, or Teardown) | MPE_OAN_SEGMENT_TYPE_NAME | CHAR | 60(0) | TEXT60 | |||||
OAN_GROUP_TYPE | OAN Group Type | MPE_OAN_GROUP_TYPE | INT1 | 3(0) | MPE_OAN_GROUP_TYPE | |||||
OA_SOURCE_ID | Identifes the Source Operation Activity | MPE_SOURCE_OA_ID | INT8 | 19(0) | MPE_OAN_ELEMENT_ID | |||||
OA_ACTIVITY_SASNAME | SAS for Operation Activity | MPE_SASNAME_OA | CHAR | 40(0) | MPE_OBJECT_NAME_TYPE | |||||
OA_SFI_SASNAME | SAS for Serialized Material in Operation Activity | MPE_SASNAME_SFIOA | CHAR | 40(0) | MPE_OBJECT_NAME_TYPE | |||||
OA_TEXT | Operation Activity Description | MPE_OA_DESCRIPTION | CHAR | 60(0) | MPE_OAN_OBJECT_DESCRIPTION | |||||
OA_ORIGINAL_COUNT | Change Alert Count | MPE_CA_ORIGINAL_COUNT | NUMC | 2(0) | MPE_CA_COUNT | |||||
OA_PRED_ELEMENT_NUMBER | Internal OAN Element Number | MPE_OAN_ELEMENT_NUMBER | INT4 | 10(0) | ||||||
OA_GROUP_ELEMENT_NUMBER | Internal OAN Element Number | MPE_OAN_ELEMENT_NUMBER | INT4 | 10(0) | ||||||
OA_LINKED_TO_PRED | Linked to Previous Group Element | MPE_LINKED_TO_PREVIOUS_ELEMENT | CHAR | 1(0) | XFELD | |||||
OA_WI_EMB_UUID | NodeID | /BOBF/CONF_KEY | RAW | 16(0) | /BOBF/CONF_KEY | |||||
OA_PROCESS_SEQUENCE | Assembly Sequence for Components Required | MPE_RTGV_PROC_SEQ | CHAR | 1(0) | XFELD | |||||
OA_DISPLAY_ORDER_IN_SEGMENT | Display order of OAN elements in OAN | MPE_OAN_ELEMENT_DISPLAY_ORDER | INT4 | 10(0) | ||||||
OA_EXECUTION_STATUS | Operation Activity Status | MPE_OA_STATUS_TYPE | CHAR | 40(0) | MPE_OBJECT_NAME_TYPE | |||||
OA_EXECUTION_STATUS_DESCR | Description of Action in Status and Action Schema | MPE_STATUS_DESCRIPTION | CHAR | 40(0) | MPE_OBJECT_DESCRIPTION_TYPE | |||||
FAV_GUID | 16 Byte UUID in 32 Characters (Hexadecimal Encoded) | SYSUUID_C32 | CHAR | 32(0) | SYSUUID_C32 | |||||
FAV_VERSN | Template Version | MPE_RTG_TEMPLATE_VERSN | NUMC | 10(0) | ||||||
TEMPLATE_REFERENCE_OBJECT | Referenced Object Indicator | MPE_TEMPLATE_REFERENCE_OBJECT | CHAR | 1(0) | MPE_TEMPLATE_REFERENCE | |||||
TEMPLATE_REFERENCE_OBJECT_DISP | Referenced Object | MPE_TEMPLATE_REFERENCE_DISP | CHAR | 1(0) | ||||||
EFFECTIVITY_TYPE | Effectivity Type | CC_EFFT | CHAR | 10(0) | CC_CHAR10 | |||||
EFF_STRING | Concatenated parameter effectivity information | MPE_RTGV_EFFECTIVITY_STRING | CHAR | 255(0) | MPE_RTGV_EFFECTIVITY_STRING | |||||
CREATED_BY | Created By | MPE_CREATE_USER | CHAR | 12(0) | USNAM | |||||
CREATED_AT | Date and Time of Creation | MPE_CREATE_TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
CHANGED_BY | Changed By | MPE_LCHANGE_USER | CHAR | 12(0) | USNAM | |||||
CHANGED_AT | MPE Last Change Timestamp | MPE_LCHANGE_TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
HAS_COMPONENTS | Components Exist | MPE_RTG_HAS_COMPONENTS | CHAR | 1(0) | XFELD | |||||
HAS_PRT | Production Resource/Tools Exist | MPE_RTG_HAS_PRT | CHAR | 1(0) | XFELD | |||||
HAS_DOC | Documents Exist | MPE_RTG_HAS_DOC | CHAR | 1(0) | XFELD | |||||
HAS_INSPCHAR | Inspection Characteristics Exist | MPE_RTG_HAS_INSPCHAR | CHAR | 1(0) | XFELD | |||||
HAS_WORKINSTR | Work Instructions Exist | MPE_RTG_HAS_WORKINSTR | CHAR | 1(0) | XFELD | |||||
HAS_CERTIF | Certifications Exist | MPE_RTG_HAS_CERTIF | CHAR | 1(0) | XFELD | |||||
HAS_QUALIF | Qualifications Exist | MPE_RTG_HAS_QUALIF | CHAR | 1(0) | XFELD | |||||
HAS_REFMAT | Reference Materials Exist | MPE_RTG_HAS_REFMAT | CHAR | 1(0) | XFELD | |||||
HAS_BUYOFF | Buyoffs Exist | MPE_RTG_HAS_BUYOFF | CHAR | 1(0) | XFELD | |||||
HAS_PREDECESSORS | Predecessors Exist | MPE_RTG_HAS_PREDECESSORS | CHAR | 1(0) | XFELD | |||||
HAS_LCOMP | Logical Components Exist | MPE_RTG_HAS_LCOMP | CHAR | 1(0) | XFELD | |||||
HAS_SUCCESSORS | Successors Exist | MPE_RTG_HAS_SUCCESSORS | CHAR | 1(0) | XFELD | |||||
NOT_CHANGEABLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
INSERT_BEFORE_NOT_POSSIBLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
INSERT_AFTER_NOT_POSSIBLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
DUMMY_MPE_OA_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 1(0) |
Search for further information about these or an SAP related objects