SAP ABAP Table /TDAG/CPS_PSTRDATA (CP: Struktur eines Knotens der Produktstruktur-Daten)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP (Package) Compliance for products

Basic Data

Table Category	INTTAB	Structure
Structure	/TDAG/CPS_PSTRDATA	Table Relationship Diagram
Short Description	CP: Struktur eines Knotens der Produktstruktur-Daten

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	NODE_KEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
2	PARENT_NODE_KEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
3	NEXT_NODE_KEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
4	ORD	☐	/TDAG/CPE_SORT	INT4	INT4	10	0	Serial Number
5	NODE_TYPE	☐	/TDAG/CPE_OBJCLASS	INT4	INT4	10	0	Type of a Node in Product Structure
6	PHAN_TYPE	☐	/TDAG/CPE_PHAN_TYPE	/TDAG/CPD_PHAN_TYPE	CHAR	1	0	Phantom Node Type
7	SPEC_TYPE	☐	ESESUBCAT	ESDSUBCAT	CHAR	10	0	Specification Type	*
8	ID	☐	/TDAG/CPE_OBJID	CHAR40	CHAR	40	0	Object ID
9	IDENT1	☐	/TDAG/CPE_OBJIDENT	TEXT132	CHAR	132	0	Object Description
10	IDENT2	☐	/TDAG/CPE_OBJIDENT	TEXT132	CHAR	132	0	Object Description
11	SPEC_ID	☐	ESESUBID	ESDSUBID	CHAR	12	0	Specification
12	MAT_NO	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
13	MAT_NO_COMP	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
14	FLG_HAS_COMP	☐	/TDAG/CPE_FLG_COMP	ESDBOOLE	CHAR	1	0	Components Exist
15	FLG_AMPL_HEAD	☐	/TDAG/CPE_FLG_SUPPL	ESDBOOLE	CHAR	1	0	Multiple Suppliers
16	FLG_MULT_SUPPL	☐	/TDAG/CPE_FLG_SUPPL	ESDBOOLE	CHAR	1	0	Multiple Suppliers
17	FLG_PREFERRED	☐	/TDAG/CPE_FLG_PREF	ESDBOOLE	CHAR	1	0	Preferred Object
18	FLG_BLOCKED	☐	/TDAG/CPE_FLG_BLOCKED	ESDBOOLE	CHAR	1	0	Object Blocked
19	FLG_PLANTS_ONLY	☐	/TDAG/CPE_FLG_PLANTS_ONLY	ESDBOOLE	CHAR	1	0	Plant Components Only
20	FLG_SALEABLE	☐	/TDAG/CPE_SALEABLE	/TDAG/CPD_SALEABLE	CHAR	1	0	Product is Saleable
21	FLG_ACTIVE	☐	/TDAG/CPE_FLG_ACTIVE	CHAR1	CHAR	1	0	Active
22	STATUS	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
23	PROPERTY	☐	ESEESTCAT	ESDESTCAT	CHAR	30	0	Value Assignment Type	*
24	.INCLUDE	☐				0	0	CP: Usages used for product variant support
25	PLANT	☐	/TDAG/CPE_RVLID_PLANT	ESDRVLID	CHAR	10	0	Plant	TCG91
26	USAGE	☐	/TDAG/CPE_RVLID_USAGE	ESDRVLID	CHAR	10	0	Usage	TCG91
27	ALTERNATE	☐	/TDAG/CPE_RVLID_ALT	ESDRVLID	CHAR	10	0	Alternative	TCG91
28	SUPPLIER_LIST	☐	/TDAG/CPE_RVLID_SUPP_LIST	ESDRVLID	CHAR	10	0	Supplier List	TCG91
29	CUSTOMER_LIST	☐	/TDAG/CPE_RVLID_CUST_LIST	ESDRVLID	CHAR	10	0	Customer List	TCG91
30	CUSTOM	☐	/TDAG/CPE_RVLID_CUSTOM	ESDRVLID	CHAR	10	0	Custom	TCG91
31	GROUP	☐	/TDAG/CPE_ALTGR	CHAR2	CHAR	2	0	Alternative Group
32	PLANT_NAME	☐	/TDAG/CPE_PLANTNAME	TEXT132	CHAR	132	0	Plant Name
33	SUPPL_NO	☐	/TDAG/CPE_SUPPLIER	LIFNR	CHAR	10	0	Supplier	*
34	SUPPL_NAME	☐	/TDAG/CPE_SUPPLNAME	TEXT132	CHAR	132	0	Supplier Name
35	CUST_NO	☐	/TDAG/CPE_CUSTOMER	KUNNR	CHAR	10	0	Customer	*
36	RECNVA	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
37	ACTNVA	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
38	RECNVP	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
39	ACTNVP	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
40	CALC_MASS	☐	/TDAG/CPE_MASS_CALC	FLOAT1	FLTP	16	16	Calculated Mass of Part
41	MASS_UNIT	☐	/TDAG/CPE_MASS_UNIT	MEINS	UNIT	3	0	Unit of Mass	*
42	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
43	MATCAT	☐	/TDAG/CPE_MATCAT	/TDAG/CPD_MATCAT	CHAR	12	0	Material Category	*
44	LEVEL	☐	/TDAG/CPE_LEVEL	NUMC3	NUMC	3	0	Level
45	COMP_GROUP	☐	/TDAG/CPE_COMP_GRP	/TDAG/CPD_COMP_GRP	CHAR	10	0	Composition Group
46	GENERATED	☐	/TDAG/CPE_FLG_GENERATED	ESDBOOLE	CHAR	1	0	Generated Entry
47	MATNR_TAB	☐	/TDAG/RCST_MATNR		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/TDAG/CPS_PSTRDATA	ALTERNATE	TCG91	RVLID	REF	1	CN
2	/TDAG/CPS_PSTRDATA	CUSTOM	TCG91	RVLID	REF	1	CN
3	/TDAG/CPS_PSTRDATA	CUSTOMER_LIST	TCG91	RVLID	REF	1	CN
4	/TDAG/CPS_PSTRDATA	PLANT	TCG91	RVLID	REF	1	CN
5	/TDAG/CPS_PSTRDATA	SUPPLIER_LIST	TCG91	RVLID	REF	1	CN
6	/TDAG/CPS_PSTRDATA	USAGE	TCG91	RVLID	REF	1	CN

History

Last changed by/on	SAP	20141109
SAP Release Created in	0207B0406C