SAP ABAP Table QPCPS_NODE_DATA (Data for a Node in the Structure)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ QM-PT-CP (Application Component) Control Plan
     ⤷ QPCP (Package) QM: Control Plan

Basic Data

Table Category	INTTAB	Structure
Structure	QPCPS_NODE_DATA	Table Relationship Diagram
Short Description	Data for a Node in the Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
2	.INCLUDE	☐				0	0	General Node Data
3	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
4	OBJTYPE	☐	QPCP_OBJTYPE		NUMC	3	0	Data Element for Object Type
5	SHORTTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	CREATED_BY	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
8	CREATED_ON	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
9	CHANGED_BY	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
10	CHANGED_ON	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
11	VALID_FROM	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
12	VALID_TO	☐	DATUB	DATUM	DATS	8	0	Valid-to date
13	.INCLUDE	☐				0	0	Node Data for Control Plan
14	SELECTION_DATE	☐	QPCP_SELECTION_DATE	DATUM	DATS	8	0	Date for Master Data Selection for Control Plan
15	PLANTYPE	☐	QPCP_PLANTYPE	QPCP_PLANTYPE	CHAR	3	0	Control Plan Type	*
16	PLAN_ID	☐	QPCP_PLAN_ID	QPCP_PLAN_ID	CHAR	24	0	External ID of Control Plan
17	.INCLUDE	☐				0	0	Node Data for Items in the Control Plan
18	ITEM_ID	☐	QPCP_ITEM_ID	NUMC8	NUMC	8	0	External ID of Control Plan Item
19	PART_NUMBER	☐	QPCP_PART_NUMBER	CHAR24	CHAR	24	0	Part Number
20	.INCLUDE	☐				0	0	Node Data for FMEA
21	FMEA_TYPE	☐	PLMT_TV_FMEA_TYPE	PLM_AUDIT_TYPE	CHAR	2	0	FMEA Type	*
22	FMEA_ID	☐	PLMT_TV_FMEA_ID	CGPL_EXTID	CHAR	24	0	Key for FMEA
23	PROC_STATUS	☐	PLMT_PROC_STATUS	PLM_PROC_STATUS	CHAR	1	0	Processing Status of the Audit Component
24	.INCLUDE	☐				0	0	Node Data for BOM
25	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	T416
26	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
27	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
28	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
29	.INCLUDE	☐				0	0	Node Data for Inspection Plan / Task List
30	PLNTY	☐	PP_PLNTY	PP_PLNTY	CHAR	1	0	Task List Type
31	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
32	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
33	VERWE	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	*
34	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
35	STATU	☐	PLNST	PLNST	CHAR	3	0	Status	*
36	STTAG	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
37	.INCLUDE	☐				0	0	Node Data for Work Center
38	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
39	AP_VERWE	☐	AP_VERWE	AP_VERWE	CHAR	4	0	Work Center Category	*
40	.INCLUDE	☐				0	0	Node Data for Plan Operations
41	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
42	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	*
43	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
44	QRASTZFAK	☐	QRASTZFAK	QPROBEFAK	DEC	5	2	Time Factor
45	QRASTZEHT	☐	QRASTZEHT	MEINS	UNIT	3	0	Time Unit	*
46	QRASTMENG	☐	QRASTMENG	MENG13	QUAN	13	3	Quantity Between Two Inspections
47	QRASTEREH	☐	QRASTEREH	MEINS	UNIT	3	0	Grid Unit of Measure	*
48	.INCLUDE	☐				0	0	Node Data for Characteristics
49	MERKNR	☐	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
50	VERWMERKM	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	*
51	MKVERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
52	TARGET_VAL	☐	QTARGET_VA	QIFLTP	CHAR	22	0	Target Value
53	UP_TOL_LMT	☐	QUPTOL_LMT	QIFLTP	CHAR	22	0	Upper Tolerance Limit
54	LW_TOL_LMT	☐	QLWTOL_LMT	QIFLTP	CHAR	22	0	Lower Tolerance Limit
55	MEAS_UNIT	☐	QMEAS_UNIT	TEXT6	CHAR	6	0	Unit of Measurement (Internal Code)
56	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic	*
57	QSPCMK	☐	QSPCMK	QKZ	CHAR	1	0	SPC Characteristic
58	RES_PLAN	☐	QP_RESPLAN	QP_RESPLAN	CHAR	3	0	Response Plan	*
59	CTRMETH	☐	QP_CTRMETH	QP_CTRMETH	CHAR	3	0	Control Method	*
60	CHAORIG_GUID	☐	QP_CHAORIG_GUID	PLM_AUDIT_GUID_AUD	RAW	16	0	Reference to Characteristic That Was Adopted
61	CHAORIG	☐	QP_CHAORIG	QP_CHAORIG	CHAR	3	0	Inspection Characteristic Origin	*
62	CHAORIG_REF	☐	QP_CHAORIG_REF	CHAR24	CHAR	24	0	Link to Characteristic That Was Copied into Plan/List
63	CHAR_TYPE	☐	PLMT_TV_CHAR_TYPE	PLMT_TV_CHAR_TYPE	CHAR	1	0	Characteristic Type
64	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	*
65	FMEA_CHAR_ID	☐	QPCP_FMEA_CHAR_ID	CGPL_EXTID	CHAR	24	0	Characteristic ID in FMEA
66	TXTZ1	☐	TXTZ1	TEXT40	CHAR	40	0	First line of text for production resources/tools
67	.INCLUDE	☐				0	0	Node Data for Notifications
68	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
69	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
70	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
71	QM_STAT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
72	.INCLUDE	☐				0	0	Node Data for Documents
73	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
74	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
75	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
76	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
77	STABK	☐	STABK	CHAR2	CHAR	2	0	Status of a document (language-dependent)
78	DOKST	☐	DOKST	DOKST	CHAR	2	0	Document Status	TDWS
79	.INCLUDE	☐				0	0	Node Data for Quality Info Record
80	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
81	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
82	FREIDAT	☐	QFREIDAT	QFREIDAT	DATS	8	0	Date Until Which the Release Is Valid
83	EXT_STATUS	☐	QESTAT1	TEXT30	CHAR	30	0	Individual Status of Object (Short Form)
84	SPERRGRUND	☐	QSPERRGR	QKURZTEXT	CHAR	40	0	Blocking reason
85	QINF_ZAEHL	☐	Q_COUNT	Q_COUNT	NUMC	6	0	Internal Counter for DB Objects

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QPCPS_NODE_DATA	DOKAR	TDWA	DOKAR
2	QPCPS_NODE_DATA	DOKST	TDWS	DOKST
3	QPCPS_NODE_DATA	QMART	TQ80	QMART
4	QPCPS_NODE_DATA	STLAN	T416	STLAN

History

Last changed by/on	SAP	20110901
SAP Release Created in	603