BAPI_ORDER_PROD_REL_TOOLS SAP (Production resources and tools data) Structure details
Description: Production resources and tools data
Related tables to BAPI_ORDER_PROD_REL_TOOLS
Access table BAPI_ORDER_PROD_REL_TOOLS
Structure field list including key, data, relationships and ABAP select examples
BAPI_ORDER_PROD_REL_TOOLS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Production resources and tools data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_BAPI_ORDER_PROD_REL_TOOLS TYPE BAPI_ORDER_PROD_REL_TOOLS.
The BAPI_ORDER_PROD_REL_TOOLS table consists of various fields, each holding specific information or linking keys about Production resources and tools data data available in SAP. These include COUNTER (Internal counter), PRT_ITEM_COUNT (Item counter for production resources/tools), DELETION_INDICATOR (Deletion Indicator), TASK_LIST_TYPE (Task List Type).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BAPI_ORDER_PROD_REL_TOOLS structure 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 |
ROUTING_NO | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
COUNTER | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PRT_ITEM_COUNT | Item counter for production resources/tools | PZLFH | NUMC | 8 | PZLFH | ||||
DELETION_INDICATOR | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
TASK_LIST_TYPE | Task List Type | PLNTY | CHAR | 1 | Assigned to domain | PLNTY | PTY | H_TCA01 | |
TASK_LIST_GROUP | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
CTRL_KEY | Control key for management of production resources/tools | STEUF | CHAR | 4 | Assigned to domain | STEUF | |||
EARL_SCHED_START_DATE | Earliest scheduled start (date) for PRT usage | CF_FSFHD | DATS | 8 | DATUM | ||||
EARL_SCHED_START_TIME | Earliest scheduled start (time) for PRT usage | CF_FSFHZ | TIMS | 6 | UZEIT | ||||
EARL_SCHED_FINISH_DATE | Earliest scheduled finish (date) of PRT usage | CF_FEFHD | DATS | 8 | DATUM | ||||
EARL_SCHED_FINISH_TIME | Earliest scheduled end (time) of PRT usage | CF_FEFHZ | TIMS | 6 | UZEIT | ||||
LATEST_SCHED_START_DATE | Latest scheduled start (date) for PRT usage | CF_SSFHD | DATS | 8 | DATUM | ||||
LATEST_SCHED_START_TIME | Latest scheduled start (time) for PRT usage | CF_SSFHZ | TIMS | 6 | UZEIT | ||||
LATEST_SCHED_FINISH_DATE | Latest scheduled finish (date) of PRT usage | CF_SEFHD | DATS | 8 | DATUM | ||||
LATEST_SCHED_FINISH_TIME | Latest scheduled end (time) for PRT usage | CF_SEFHZ | TIMS | 6 | UZEIT | ||||
ACTUAL_START_DATE | Actual start (date) of PRT usage | CF_ISFHD | DATS | 8 | DATUM | ||||
ACTUAL_START_TIME | Actual start (time) of PRT usage | CF_ISFHZ | TIMS | 6 | UZEIT | ||||
ACTUAL_FINISH_DATE | Actual finish (date) of PRT usage | CF_IEFHD | DATS | 8 | DATUM | ||||
ACTUAL_FINISH_TIME | Actual finish (time) of PRT usage | CF_IEFHZ | TIMS | 6 | UZEIT | ||||
DURATION | Duration of PRT usage | CF_DAUFL | FLTP | 16(16) | CX_ZEIT | ||||
DURATION_UNIT | Time unit for duration of PRT usage | CF_DAUEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DURATION_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
STD_VALUE_FOR_PRT_QTY | Standard value for the PRT quantity | MGVGW | QUAN | 9(3) | MENG9 | ||||
STD_VALUE_UNIT | Quantity unit of production resource/tool | MGEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STD_VALUE_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
TOTAL_QUANTITY | Total planned quantity of production resource/tool | MGSOL | QUAN | 9(3) | MENG9 | ||||
QUANTITY_UNIT | Quantity unit of production resource/tool | MGEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUANTITY_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
FORMULA_TOT_QTY | Formula for calculating the total quantity of PRT | CF_MGFORM | CHAR | 6 | Assigned to domain | AP_FORMEL | |||
STD_USAGE_VALUE_FOR_PRT | Standard usage value for production resources/tools | EWVGW | QUAN | 9(3) | MENG9 | ||||
STD_USAGE_VALUE_UNIT | Usage value unit of the production resource/tool | EWEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STD_USAGE_VALUE_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
USAGE_VALUE | Total planned usage value of production resource/tool | EWSOL | QUAN | 9(3) | MENG9 | ||||
USAGE_VALUE_UNIT | Usage value unit of the production resource/tool | EWEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USAGE_VALUE_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
FORMULA_TOT_USAGE | Formula for calculating the total usage value of PRT | CF_EWFORM | CHAR | 6 | Assigned to domain | AP_FORMEL | |||
ORDER_NUMBER | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
PRT_CATEGORY | Production resources/tools category | FHMAR | CHAR | 1 | Assigned to domain | FHMAR | FHMAR | FHA | |
PRT_NUMBER | Production resource/tool number | FHMNR | CHAR | 33 | FHMNR | ||||
PRT_PLANT | Production resources/tools in plant | FHWRK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
DOCUMENT_TYPE | Document Type | DOKAR | CHAR | 3 | Assigned to domain | DOKAR | CV2 | ||
DOCUMENT_NUMBER | Document number | DOKNR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | CV1 | |
DOCUMENT_VERSION | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
DOCUMENT_PART | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
EQUIPMENT | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
MEASURING_POINT | Measuring Point | IMRC_POINT | CHAR | 12 | Assigned to domain | ALPHA | IMRC_POINT | IPT | IMPM |
DESCRIPTION_MEASURING_POINT | Description of Measuring Point | IMRC_PTTXT | CHAR | 40 | TEXT40 | ||||
DESCRIPTION | Description of the production resource/tool | FHKTX | CHAR | 40 | TEXT40 | ||||
BASE_UNIT | Base unit of measure for production resources/tools | CF_BASEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BASE_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
SYSTEM_STATUS | System Status | CO_STTXT | CHAR | 40 | CHAR40 | ||||
MATERIAL_EXTERNAL | Long Material Number for MATERIAL Field | MGV_MATERIAL_EXTERNAL | CHAR | 40 | MATNR_EXT | ||||
MATERIAL_GUID | External GUID for MATERIAL Field | MGV_MATERIAL_GUID | CHAR | 32 | MATNR_EGUID | ||||
MATERIAL_VERSION | Version Number for MATERIAL Field | MGV_MATERIAL_VERSION | CHAR | 10 | MATNW | MATNR_VERS |
Key field | Non-key field |
How do I retrieve data from SAP structure BAPI_ORDER_PROD_REL_TOOLS using ABAP code?
As BAPI_ORDER_PROD_REL_TOOLS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BAPI_ORDER_PROD_REL_TOOLS as there is no data to select.How to access SAP table BAPI_ORDER_PROD_REL_TOOLS
Within an ECC or HANA version of SAP you can also view further information about BAPI_ORDER_PROD_REL_TOOLS 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