SAP ABAP Table CMX_POC_S_INSTRUCTION_SHEET (List Line Overview of PI Sheets and Work Instructions)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PP-PI-PMA-PMC (Application Component) Browser-Based PI Sheet / Cockpit
     ⤷ CMX_POC (Package) Manufacturing Execution: Browser-Based PI Sheet

Basic Data

Table Category	INTTAB	Structure
Structure	CMX_POC_S_INSTRUCTION_SHEET	Table Relationship Diagram
Short Description	List Line Overview of PI Sheets and Work Instructions

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	.INCLUDE	☐				0	0	Process Management: Control Recipe Header
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	CRID	☐	CO_CRID	CO_CRID	NUMC	18	0	Control recipe number	*
4	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	BID	☐	CO_BID	CO_BID	CHAR	12	0	Process order
6	PHSEQ	☐	PHSEQ	PHSEQ	CHAR	2	0	Control Recipe Destination	TC52
7	ADRES	☐	ADR	CHAR32	CHAR	32	0	Address of the Control Recipe Destination
8	COTYP	☐	COMTY	COMTY	CHAR	1	0	Type of Control Recipe Destination
9	TSTKZ	☐	TSTKZ	FLAG	CHAR	1	0	Indicator: Message or Control Recipe for Test Purposes
10	CRSTAT	☐	CO_CRSTAT	CO_CRSTAT	CHAR	5	0	Control recipe status	*
11	ANDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
12	ANUZT	☐	ANUZT	UZEIT	TIMS	6	0	Time when the record was created
13	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	KTXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
15	MATNR	☐	PI_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
16	MATXT	☐	PI_MATXT	TEXT40	CHAR	40	0	Material Description
17	PRUEFLOS	☐	PI_QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
18	ERRKZ	☐	CO_ERRKZ	CHAR1	CHAR	1	0	Processing status of the process message/the control recipe
19	ARFCIPID	☐	ARFCIPID	ARFCIPID	CHAR	8	0	Host ID (IP ID
20	ARFCPID	☐	ARFCPID	ARFCPID	CHAR	4	0	Process ID
21	ARFCTIME	☐	ARFCTIME	ARFCTIME	CHAR	8	0	Time Stamp
22	ARFCTIDCNT	☐	ARFCTIDCNT	ARFCTIDCNT	CHAR	4	0	Transaction ID (LUW -> COMMIT WORK)
23	EXSTAT	☐	CO_EXSTAT	CO_CRSTAT	CHAR	5	0	Execution status of a control recipe	*
24	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
25	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
26	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
27	DECNTRL_PRC	☐	DECNTRL_PRC	CHAR1	CHAR	1	0	Indicator for Decentralized Control Recipe Execution
28	XS_ID	☐	CMX_CR_XS_GUID	SYSUUID_22	CHAR	22	0	XSteps: Unique ID of a Node
29	HASTAT	☐	CO_PISTAT	CO_PISTAT	CHAR	5	0	Status of the PI sheet
30	STATTXT	☐			STRG	0	0
31	IDIFS	☐			INT4	10	0
32	FNOTSENT	☐	ICONNAME	ICONNAME	CHAR	30	0	Name of an Icon
33	ICOMS	☐			INT4	10	0
34	MSG_ICON	☐			CHAR	50	0
35	DIF_ICON	☐			CHAR	50	0
36	COMM_ICON	☐			CHAR	50	0
37	CHECK	☐			CHAR	1	0
38	COLOR_INFO	☐			CHAR	3	0
39	.INCLUDE	☐				0	0	Order Data for PI Sheets and Work Instructions
40	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
41	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMX_POC_S_INSTRUCTION_SHEET	MANDT	T000	MANDT	KEY	1	CN
2	CMX_POC_S_INSTRUCTION_SHEET	MATNR	MARA	MATNR	REF	1	CN
3	CMX_POC_S_INSTRUCTION_SHEET	PHSEQ	TC52	PHSEQ	KEY	1	CN
4	CMX_POC_S_INSTRUCTION_SHEET	PRUEFLOS	QALS	PRUEFLOS	REF	1	CN
5	CMX_POC_S_INSTRUCTION_SHEET	WERK	T001W	WERKS	KEY	1	CN

History

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