SAP MPES_RTGV_COMP_DATA_DOC Table in S/4 HANA - Compare results view data for Documents
MPES_RTGV_COMP_DATA_DOC is a standard SAP Table which is used to store Compare results view data for Documents 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_COMP_DATA_DOC 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 (Deep)
Dictionary Type: Structure
Database Table: MPES_RTGV_COMP_DATA_DOC
MPES_RTGV_COMP_DATA_DOC table structure field list
Below is the full MPES_RTGV_COMP_DATA_DOC 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 Documents | PZLFH_DOC | 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 Documents | PSNFH_DOC | NUMC | 4(0) | PSNFH | |||||
STEUF | Control Profile for Management of Documents | STEUF_DOC | 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 Documents | MGEINH_DOC | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
MGVGW | Standard Value for Quantity of Documents | MGVGW_DOC | QUAN | 9(3) | MENG9 | |||||
MGFORM | Formula for Calculating the Total Quantity of Doc | CF_MGFORM_DOC | CHAR | 6(0) | TC25 | AP_FORMEL | ||||
EWEINH | Usage Value Unit of the Documents | EWEINH_DOC | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
EWVGW | Standard Usage Value for Documents | EWVGW_DOC | QUAN | 9(3) | MENG9 | |||||
EWFORM | Formula for Calculating the Total Usage Value of Doc | CF_EWFORM_DOC | 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 Document | CF_KTSCH_DOC | CHAR | 7(0) | T435 | KTSCH | ||||
TXTZ1 | First Line of Text for Document | TXTZ1_DOC | 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) | Assigned to domain | 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 | Document Category | FHMAR_DOC | CHAR | 1(0) | TCF02 | FHMAR | FHMAR | FHA | ||
FHMNR | Document Number | FHMNR_DOC | CHAR | 40(0) | FHMNR | |||||
FHWRK | Documents in Plant | FHWRK_DOC | CHAR | 4(0) | Assigned to domain | WERKS | WRK | |||
MATNR | Material Number | MATNR | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
SFHNR | Documents | SFHNR_DOC | CHAR | 18(0) | ALPHA | SFHNR | FHS | FHMS | SFHNR | |
DOKAR | Document Type | DOKAR | CHAR | 3(0) | Assigned to domain | DOKAR | CV2 | |||
DOKNR | Document number | DOKNR | CHAR | 25(0) | Assigned to domain | 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) | Assigned to domain | 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) | Assigned to domain | CUNIT | MEINS | |||
ATDIM | Exponent display | ATDIM | INT2 | 5(0) | EXP10 | |||||
ANZDZ | Number of Decimal Places | ANZDZ | INT2 | 5(0) | ANZDZ | |||||
FHKTX | Description of the Document | FHKTX_DOC | CHAR | 40(0) | TEXT40 | |||||
BASEH | Base Unit of Measure for Documents | CF_BASEH_DOC | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
FGRU1 | Grouping Key 1 for Production Resources/Tools | FGRUA | CHAR | 4(0) | Assigned to domain | FGRUA | ||||
FGRU2 | Grouping Key 2 for Production Resources/Tools | FGRUB | CHAR | 4(0) | Assigned to domain | FGRUA | ||||
STOWK | Plant location of the production resource/tool | CF_STOWK | CHAR | 4(0) | Assigned to domain | WERKS | WRK | |||
STORT | Location of a production resource or tool | CF_STORT | CHAR | 10(0) | Assigned to domain | 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) | Assigned to domain | 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 Documents | PLNVERSN_SOURCE_PZLFH_DOC | 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) | ||||||
CHANGE_IND_AB | Change Indicator | MPE_RTGV_COMP_CHANGE_IND | CHAR | 1(0) | CHAR1 | |||||
KEY_TXT | KEY | MPE_RTGV_COMP_KEY_TXT | STRG | 0(0) |
Search for further information about these or an SAP related objects