QPCPS_NODE_DATA SAP (Data for a Node in the Structure) Structure details
Dictionary Type: Structure
Description: Data for a Node in the Structure
Description: Data for a Node in the Structure
ABAP Code to SELECT data from QPCPS_NODE_DATA
Related tables to QPCPS_NODE_DATA
Access table QPCPS_NODE_DATA
Related tables to QPCPS_NODE_DATA
Access table QPCPS_NODE_DATA
QPCPS_NODE_DATA 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 "Data for a Node in the Structure" 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_QPCPS_NODE_DATA TYPE QPCPS_NODE_DATA.
The QPCPS_NODE_DATA table consists of various fields, each holding specific information or linking keys about Data for a Node in the Structure data available in SAP. These include WERKS (Plant), OBJTYPE (Data Element for Object Type), SHORTTEXT (Short Text), MATNR (Material Number)... 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. .
QPCPS_NODE_DATA structure Technical Details:
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP QPCPS_NODE_DATA 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 |
| LANGU | Language Key | LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| OBJTYPE | Data Element for Object Type | QPCP_OBJTYPE | NUMC | 3 | |||||
| SHORTTEXT | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
| MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| CREATED_BY | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
| CREATED_ON | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | DATUM | ||||
| CHANGED_BY | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
| CHANGED_ON | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
| VALID_FROM | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
| VALID_TO | Valid-to date | DATUB | DATS | 8 | DATUM | ||||
| SELECTION_DATE | Date for Master Data Selection for Control Plan | QPCP_SELECTION_DATE | DATS | 8 | DATUM | ||||
| PLANTYPE | Control Plan Type | QPCP_PLANTYPE | CHAR | 3 | Assigned to domain | QPCP_PLANTYPE | QPCP_PLAN_TYPE | ||
| PLAN_ID | External ID of Control Plan | QPCP_PLAN_ID | CHAR | 24 | ALPHA | QPCP_PLAN_ID | CPLAN_ID | ||
| ITEM_ID | External ID of Control Plan Item | QPCP_ITEM_ID | NUMC | 8 | NUMC8 | ||||
| PART_NUMBER | Part Number | QPCP_PART_NUMBER | CHAR | 24 | CHAR24 | ||||
| FMEA_TYPE | FMEA Type | PLMT_TV_FMEA_TYPE | CHAR | 2 | Assigned to domain | PLM_AUDIT_TYPE | |||
| FMEA_ID | Key for FMEA | PLMT_TV_FMEA_ID | CHAR | 24 | CGPL_EXTID | PLM_FMEA | |||
| PROC_STATUS | Processing Status of the Audit Component | PLMT_PROC_STATUS | CHAR | 1 | PLM_PROC_STATUS | ||||
| STLAN | BOM Usage | STLAN | CHAR | 1 | T416 | STLAN | CSV | ||
| STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
| STLAL | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
| STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
| PLNTY | Task List Type | PP_PLNTY | CHAR | 1 | PP_PLNTY | PTY | |||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
| PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
| VERWE | Task list usage | PLN_VERWE | CHAR | 3 | Assigned to domain | PLN_VERWE | H_T411 | ||
| AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
| STATU | Status | PLNST | CHAR | 3 | Assigned to domain | PLNST | H_T412 | ||
| STTAG | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
| ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
| AP_VERWE | Work Center Category | AP_VERWE | CHAR | 4 | Assigned to domain | AP_VERWE | CRA | H_TC30 | |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
| STEUS | Control key | STEUS | CHAR | 4 | Assigned to domain | STEUS | |||
| PLNKN | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
| QRASTZFAK | Time Factor | QRASTZFAK | DEC | 5(2) | QPROBEFAK | ||||
| QRASTZEHT | Time Unit | QRASTZEHT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| QRASTMENG | Quantity Between Two Inspections | QRASTMENG | QUAN | 13(3) | MENG13 | ||||
| QRASTEREH | Grid Unit of Measure | QRASTEREH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | QMERKNRP | ||||
| VERWMERKM | Master Inspection Characteristics | QMERKNR | CHAR | 8 | Assigned to domain | ALPHA | QMERKNR | PMK | |
| MKVERSION | Version Number of the Master Inspection Characteristic | QVERSNRMK | CHAR | 6 | ALPHA | QVERSNR | |||
| TARGET_VAL | Target Value | QTARGET_VA | CHAR | 22 | QIFLTP | ||||
| UP_TOL_LMT | Upper Tolerance Limit | QUPTOL_LMT | CHAR | 22 | QIFLTP | ||||
| LW_TOL_LMT | Lower Tolerance Limit | QLWTOL_LMT | CHAR | 22 | QIFLTP | ||||
| MEAS_UNIT | Unit of Measurement (Internal Code) | QMEAS_UNIT | CHAR | 6 | TEXT6 | ||||
| STICHPRVER | Sampling Procedure in Inspection Characteristic | QSTICHVERF | CHAR | 8 | Assigned to domain | QSTPRVER | |||
| QSPCMK | SPC Characteristic | QSPCMK | CHAR | 1 | QKZ | ||||
| RES_PLAN | Response Plan | QP_RESPLAN | CHAR | 3 | Assigned to domain | ALPHA | QP_RESPLAN | ||
| CTRMETH | Control Method | QP_CTRMETH | CHAR | 3 | Assigned to domain | ALPHA | QP_CTRMETH | ||
| CHAORIG_GUID | Reference to Characteristic That Was Adopted | QP_CHAORIG_GUID | RAW | 16 | PLMAM | PLM_AUDIT_GUID_AUD | |||
| CHAORIG | Inspection Characteristic Origin | QP_CHAORIG | CHAR | 3 | Assigned to domain | ALPHA | QP_CHAORIG | Q_IP_CHAORIG | |
| CHAORIG_REF | Link to Characteristic That Was Copied into Plan/List | QP_CHAORIG_REF | CHAR | 24 | CHAR24 | ||||
| CHAR_TYPE | Characteristic Type | PLMT_TV_CHAR_TYPE | CHAR | 1 | PLMT_TV_CHAR_TYPE | ||||
| MERKGEW | Weighting of the Characteristic | QMERKGEW | CHAR | 2 | Assigned to domain | QMERKKLAS | |||
| FMEA_CHAR_ID | Characteristic ID in FMEA | QPCP_FMEA_CHAR_ID | CHAR | 24 | CGPL_EXTID | ||||
| TXTZ1 | First line of text for production resources/tools | TXTZ1 | CHAR | 40 | TEXT40 | ||||
| QMART | Notification Type | QMART | CHAR | 2 | TQ80 | QMART | QMR | ||
| QMNUM | Notification No | QMNUM | CHAR | 12 | Assigned to domain | ALPHA | QMNUM | IQM | |
| QMDAB | Date for Notification Completion | QMDAB | DATS | 8 | DATUM | ||||
| QM_STAT | System status line | J_STEXT | CHAR | 40 | TEXT40 | ||||
| DOKNR | Document number | DOKNR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | CV1 | |
| DOKAR | Document Type | DOKAR | CHAR | 3 | TDWA | DOKAR | CV2 | ||
| DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
| DOKVR | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
| STABK | Status of a document (language-dependent) | STABK | CHAR | 2 | CHAR2 | ||||
| DOKST | Document Status | DOKST | CHAR | 2 | TDWS | DOKST | |||
| REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
| VENDOR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
| FREIDAT | Date Until Which the Release Is Valid | QFREIDAT | DATS | 8 | QFREIDAT | ||||
| EXT_STATUS | Individual Status of Object (Short Form) | QESTAT1 | CHAR | 30 | TEXT30 | ||||
| SPERRGRUND | Blocking reason | QSPERRGR | CHAR | 40 | QKURZTEXT | ||||
| QINF_ZAEHL | Internal Counter for DB Objects | Q_COUNT | NUMC | 6 | Q_COUNT |
| Key field | Non-key field |
How do I retrieve data from SAP structure QPCPS_NODE_DATA using ABAP code?
As QPCPS_NODE_DATA 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 QPCPS_NODE_DATA as there is no data to select.How to access SAP table QPCPS_NODE_DATA
Within an ECC or HANA version of SAP you can also view further information about QPCPS_NODE_DATA 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