SAP ABAP Table /TDAG/CPS_SIM_PRO_STRUCT (CP: Produktstruktur (Simulation))

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_SIM_PRO_STRUCT	Table Relationship Diagram
Short Description	CP: Produktstruktur (Simulation)

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	SPEC_TYPE	☐	ESESUBCAT	ESDSUBCAT	CHAR	10	0	Specification Type	*
7	ID	☐	/TDAG/CPE_OBJID	CHAR40	CHAR	40	0	Object ID
8	SPEC_ID	☐	ESESUBID	ESDSUBID	CHAR	12	0	Specification
9	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
10	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
11	GROUP	☐	/TDAG/CPE_ALTGR	CHAR2	CHAR	2	0	Alternative Group
12	FLG_PREFERRED	☐	/TDAG/CPE_FLG_PREF	ESDBOOLE	CHAR	1	0	Preferred Object
13	SUPPL_NO	☐	/TDAG/CPE_SUPPLIER	LIFNR	CHAR	10	0	Supplier	*
14	SUPPL_NAME	☐	/TDAG/CPE_SUPPLNAME	TEXT132	CHAR	132	0	Supplier Name
15	CUST_NO	☐	/TDAG/CPE_CUSTOMER	KUNNR	CHAR	10	0	Customer	*
16	RECNVA	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
17	ACTNVA	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
18	RECNVP	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
19	ACTNVP	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
20	CALC_MASS	☐	/TDAG/CPE_MASS_CALC	FLOAT1	FLTP	16	16	Calculated Mass of Part
21	MASS_UNIT	☐	/TDAG/CPE_MASS_UNIT	MEINS	UNIT	3	0	Unit of Mass	*
22	FLG_AMPL_HEAD	☐	/TDAG/CPE_FLG_SUPPL	ESDBOOLE	CHAR	1	0	Multiple Suppliers
23	FLG_MULT_SUPPL	☐	/TDAG/CPE_FLG_SUPPL	ESDBOOLE	CHAR	1	0	Multiple Suppliers
24	FLG_PLANTS_ONLY	☐	/TDAG/CPE_FLG_PLANTS_ONLY	ESDBOOLE	CHAR	1	0	Plant Components Only
25	PROPERTY	☐	ESEESTCAT	ESDESTCAT	CHAR	30	0	Value Assignment Type	*
26	LEVEL	☐	/TDAG/CPE_LEVEL	NUMC3	NUMC	3	0	Level
27	VARIANT	☐	ESERVLID	ESDRVLID	CHAR	10	0	Validity Area	*
28	.INCLUDE	☐				0	0	CP: Usages used for product variant support
29	PLANT	☐	/TDAG/CPE_RVLID_PLANT	ESDRVLID	CHAR	10	0	Plant	TCG91
30	USAGE	☐	/TDAG/CPE_RVLID_USAGE	ESDRVLID	CHAR	10	0	Usage	TCG91
31	ALTERNATE	☐	/TDAG/CPE_RVLID_ALT	ESDRVLID	CHAR	10	0	Alternative	TCG91
32	SUPPLIER_LIST	☐	/TDAG/CPE_RVLID_SUPP_LIST	ESDRVLID	CHAR	10	0	Supplier List	TCG91
33	CUSTOMER_LIST	☐	/TDAG/CPE_RVLID_CUST_LIST	ESDRVLID	CHAR	10	0	Customer List	TCG91
34	CUSTOM	☐	/TDAG/CPE_RVLID_CUSTOM	ESDRVLID	CHAR	10	0	Custom	TCG91
35	PLANT_NAME	☐	/TDAG/CPE_PLANTNAME	TEXT132	CHAR	132	0	Plant Name
36	FLG_HAS_COMP	☐	/TDAG/CPE_FLG_COMP	ESDBOOLE	CHAR	1	0	Components Exist
37	MAT_NO	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
38	MAT_NO_COMP	☐	/TDAG/CPE_MATNRVP	MATNR	CHAR	18	0	Material Number of Component	*
39	IDENT_1	☐	/TDAG/CPE_OBJIDENT	TEXT132	CHAR	132	0	Object Description
40	IDENT_2	☐	/TDAG/CPE_OBJIDENT	TEXT132	CHAR	132	0	Object Description
41	IDENT_3	☐	/TDAG/CPE_OBJIDENT	TEXT132	CHAR	132	0	Object Description
42	QUANT_AVG	☐	/TDAG/CPE_QUANT_AVG	FLOAT1	FLTP	16	16	Average Quantity
43	QUANT_UNIT	☐	/TDAG/CPE_QUANT_UNIT	MEINS	UNIT	3	0	Unit	*
44	QUANT_AVG_DEC	☐	ESECOMPNUMDEC	INT4	INT4	10	0	Decimal Places for the Concentration of a Component
45	NORMQ_AVG	☐	/TDAG/CPE_NORMQ_AVG	FLOAT1	FLTP	16	16	Average Normalized Quantity
46	NORMQ_UNIT	☐	/TDAG/CPE_NORMQ_UNIT	MEINS	UNIT	3	0	Unit of Normalization Quantity	*
47	EXIST_RES	☐	/TDAG/CPE_SIM_DB_EXIST_RES	CHAR10	CHAR	10	0	Specification Exists in Database
48	CHECK_STATUS_1	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
49	CHECK_STATUS_2	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
50	CHECK_STATUS_3	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
51	CHECK_STATUS_4	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
52	CHECK_STATUS_5	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
53	CHECK_STATUS_6	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
54	CHECK_STATUS_7	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
55	CHECK_STATUS_8	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
56	CHECK_STATUS_9	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
57	CHECK_STATUS_10	☐	/TDAG/CPE_CHECKRES	/TDAG/CPD_CHECKRES	CHAR	1	0	Check Result
58	CUST_ADD_INFO_1	☐	/TDAG/CPE_CUST_ADD_INF	CHAR132	CHAR	132	0	Additional Information
59	CUST_ADD_INFO_2	☐	/TDAG/CPE_CUST_ADD_INF	CHAR132	CHAR	132	0	Additional Information
60	CUST_ADD_INFO_3	☐	/TDAG/CPE_CUST_ADD_INF	CHAR132	CHAR	132	0	Additional Information
61	CUST_ADD_INFO_4	☐	/TDAG/CPE_CUST_ADD_INF	CHAR132	CHAR	132	0	Additional Information
62	CUST_ADD_INFO_5	☐	/TDAG/CPE_CUST_ADD_INF	CHAR132	CHAR	132	0	Additional Information
63	FLG_COMPA_CONSIDERED	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value

Foreign Keys

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

History

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