SAP ABAP View VD_TCOOPC_ITEM (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_ITEM
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	LANGUAGE	TCOOPC_ITEMT	LANGUAGE		☐	SPRAS	☐	Language Key
4	ITEMALIAS	TCOOPC_ITEM	ITEMALIAS		☐	COOPC_ITEMALIAS	☐	OPC: Name of OPC Item
5	ITEMDESCR	TCOOPC_ITEMT	ITEMDESCR		☐	COOPC_ITEMTXT	☐	OPC: Description for OPC Item
6	RFCDEST	TCOOPC_SERVER	RFCDEST		☐	COOPC_RFCDEST	☐	OPC: RFC Destination of SAP ODA Connector
7	SERVERID	TCOOPC_SERVER	SERVERID		☐	COOPC_SERVERID	☐	OPC: ID of the OPC Server
8	IF_DA_SYNC	TCOOPC_SERVER	IF_DA_SYNC		☐	COOPC_SERVER_IF	☐	OPC: Server Interfaces (Values See Type Pool CTOPC)
9	IF_DA_ASYNC	TCOOPC_SERVER	IF_DA_ASYNC		☐	COOPC_SERVER_IF	☐	OPC: Server Interfaces (Values See Type Pool CTOPC)
10	UPDATERATE	TCOOPC_SERVER	UPDATERATE		☐	COOPC_UPDATERATE	☐	OPC: Update Rate of the OPC Server in Milliseconds
11	BUFFERTIME_SRVR	TCOOPC_SERVER	BUFFERTIME		☐	COOPC_BUFFERTIME	☐	OPC: Buffer Time of the OPC Server in Milliseconds
12	ATTEMPTS	TCOOPC_SERVER	ATTEMPTS		☐	COOPC_ATTEMPTS	☐	OPC: Maximum Number of Attempts to Access a Server
13	ATTPTTIME	TCOOPC_SERVER	ATTPTTIME		☐	COOPC_ATTPTTIME	☐	OPC: Time Interval Between Two Attempts to Access a Server
14	SERVERALIAS	TCOOPC_ITEM	SERVERALIAS		☐	COOPC_SERVERALIAS	☐	OPC: Name of OPC Server
15	ITEMID	TCOOPC_ITEM	ITEMID		☐	COOPC_ITEMID	☐	OPC: Fully Qualified OPC Item ID
16	BUFFERTIME_ITEM	TCOOPC_ITEM	BUFFERTIME		☐	COOPC_ITEMBUFFERTIME	☐	OPC: Buffer Time of OPC Items
17	CONVEXIT	TCOOPC_ITEM	CONVEXIT		☐	CONVEXIT	☐	Conversion Routine
18	DEADBAND	TCOOPC_ITEM	DEADBAND		☐	COOPC_DEADBAND	☐	OPC: Percentage Deadband

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	46C