SAP ABAP View VD_TCOOPC_ITEM2 (OPC: Database View of Item Table)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PP-PI-PMA (Application Component) Process Management
     ⤷ COOPC (Package) OPC Interface (Open Process Control)

Basic Data

View Type	D	Database View
Database View	VD_TCOOPC_ITEM2
Short Description	OPC: Database View of Item Table
Root table	TCOOPC_ITEM	OPC: Plant-Specific Custom. Table for OPC Item Definition

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TCOOPC_ITEM	TCOOPC_ITEM
2	TCOOPC_ITEMT
3	TCOOPC_SERVER

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TCOOPC_ITEM	MANDT	JL	EQ				0	0
2	TCOOPC_ITEMT	MANDT	JR	EQ			AND	0	0
3	TCOOPC_ITEM	PLANT	JL	EQ				0	0
4	TCOOPC_ITEMT	PLANT	JR	EQ			AND	0	0
5	TCOOPC_ITEM	ITEMALIAS	JL	EQ				0	0
6	TCOOPC_ITEMT	ITEMALIAS	JR	EQ			AND	0	0
7	TCOOPC_SERVER	MANDT	JL	EQ				0	0
8	TCOOPC_ITEM	MANDT	JR	EQ			AND	0	0
9	TCOOPC_SERVER	PLANT	JL	EQ				0	0
10	TCOOPC_ITEM	PLANT	JR	EQ			AND	0	0
11	TCOOPC_SERVER	SERVERALIAS	JL	EQ				0	0
12	TCOOPC_ITEM	SERVERALIAS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TCOOPC_ITEM	MANDT		☐	MANDT	☐	Client
2	PLANT	TCOOPC_ITEM	PLANT		☐	WERKS_D	☐	Plant
3	ITEMALIAS	TCOOPC_ITEM	ITEMALIAS		☐	COOPC_ITEMALIAS	☐	OPC: Name of OPC Item
4	LANGUAGE	TCOOPC_ITEMT	LANGUAGE		☐	SPRAS	☐	Language Key
5	ITEMDESCR	TCOOPC_ITEMT	ITEMDESCR		☐	COOPC_ITEMTXT	☐	OPC: Description for OPC Item
6	IF_DA_SYNC	TCOOPC_SERVER	IF_DA_SYNC		☐	COOPC_SERVER_IF	☐	OPC: Server Interfaces (Values See Type Pool CTOPC)
7	IF_DA_ASYNC	TCOOPC_SERVER	IF_DA_ASYNC		☐	COOPC_SERVER_IF	☐	OPC: Server Interfaces (Values See Type Pool CTOPC)

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	110