SAP ABAP Table AFRU_COL (Internal structure for collective confirmation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CORU (Package) R/3 Application development: PP Confirmations

Basic Data

Table Category	INTTAB	Structure
Structure	AFRU_COL	Table Relationship Diagram
Short Description	Internal structure for collective confirmation

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	Dialog table for completion confirmations
2	.INCLUDE	☐				0	0	Order Confirmations
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
5	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
6	ERSDA	☐	RU_ERSDA	DATUM	DATS	8	0	Confirmation entry date
7	ERNAM	☐	RU_ERNAM	USNAM	CHAR	12	0	Name of the person who entered the confirmation
8	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
9	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	BUDAT	☐	BUCHDATUM	DATUM	DATS	8	0	Posting date
11	ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
12	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	LTXA1	☐	CO_RTEXT	TEXT40	CHAR	40	0	Confirmation text
14	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
15	ISERH	☐	ISERH	VGWRT	QUAN	9	3	Confirmed break time
16	ZEIER	☐	DZEIER	MEINS	UNIT	3	0	Unit for the break time	T006
17	ILE01	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
18	ISM01	☐	RU_ISMNG	MENGV13	QUAN	13	3	Activity currently to be confirmed
19	ILE02	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
20	ISM02	☐	RU_ISMNG	MENGV13	QUAN	13	3	Activity currently to be confirmed
21	ILE03	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
22	ISM03	☐	RU_ISMNG	MENGV13	QUAN	13	3	Activity currently to be confirmed
23	ILE04	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
24	ISM04	☐	RU_ISMNG	MENGV13	QUAN	13	3	Activity currently to be confirmed
25	ILE05	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
26	ISM05	☐	RU_ISMNG	MENGV13	QUAN	13	3	Activity currently to be confirmed
27	ILE06	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
28	ISM06	☐	RU_ISMNG	MENGV13	QUAN	13	3	Activity currently to be confirmed
29	ABARB	☐	CO_ABARB	CO_ABARB	NUMC	3	0	Confirmation: Degree of processing
30	ISMNW	☐	ISMNW	ARBEIT	QUAN	7	1	Actual work
31	ISMNE	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
32	LEARR	☐	LEARR	LSTAR	CHAR	6	0	Activity type for confirmation	CSLA
33	IDAUR	☐	IDAUR	DAUER_4_1	QUAN	5	1	Actual duration for confirmation
34	IDAUE	☐	IDAURE	MEINS	UNIT	3	0	Unit for actual duration	T006
35	ZCODE	☐	DZCODE	ZCODE	CHAR	6	0	Reference number for standard value code
36	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type	*
37	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
38	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
39	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
40	GMNGA	☐	RU_GMNGA	MENG13	QUAN	13	3	Previously confirmed yield in order unit of measure
41	LMNGA	☐	RU_LMNGA	MENGV13	QUAN	13	3	Yield currently to be confirmed
42	XMNGA	☐	RU_XMNGA	MENGV13	QUAN	13	3	Scrap currently to be confirmed
43	GMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
44	MEINH	☐	RU_VORME	MEINS	UNIT	3	0	Confirmation unit of measure	T006
45	GRUND	☐	CO_AGRND	CO_AGRND	CHAR	4	0	Reason for Variance	TRUG
46	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
47	ISDD	☐	RU_ISDD	DATUM	DATS	8	0	Confirmed date for start of execution
48	ISDZ	☐	RU_ISDZ	ATIME	TIMS	6	0	Confirmed time for 'Execution start'
49	IERD	☐	RU_IERD	DATUM	DATS	8	0	Confirmed date for 'Setup finish'
50	IERZ	☐	RU_IERZ	ATIME	TIMS	6	0	Confirmed time for 'Setup finish'
51	ISBD	☐	RU_ISBD	DATUM	DATS	8	0	Confirmed date for 'Processing start'
52	ISBZ	☐	RU_ISBZ	ATIME	TIMS	6	0	Confirmed time for 'Processing start'
53	IEBD	☐	RU_IEBD	DATUM	DATS	8	0	Confirmed date for 'processing finish'
54	IEBZ	☐	RU_IEBZ	ATIME	TIMS	6	0	Confirmed time for 'processing finish'
55	ISAD	☐	RU_ISAD	DATUM	DATS	8	0	Confirmed date for 'teardown start'
56	ISAZ	☐	RU_ISAZ	ATIME	TIMS	6	0	Confirmed time for 'teardown start'
57	IEDD	☐	RU_IEDD	DATUM	DATS	8	0	Confirmed date for execution finish
58	IEDZ	☐	RU_IEDZ	ATIME	TIMS	6	0	Confirmed time for 'Execution finish'
59	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
60	PEDZ	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
61	WABLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
62	WEBLNR	☐	WEBLNR	BELNR	CHAR	10	0	Number of a document from a goods movement with errors
63	AUERU	☐	AUERU_VS	AUERU_VS	CHAR	1	0	Partial/Final Confirmation
64	AUSOR	☐	AUSBU	XFELD	CHAR	1	0	Clear Open Reservations
65	STNDR	☐	STNDR	XFELD	CHAR	1	0	Indicator: Standard confirmation
66	MANUR	☐	MANUR	MANUR	CHAR	1	0	Indicator for type of confirmation
67	MEILR	☐	MEILR	MEILR	CHAR	1	0	Indicator: Milestone confirmation carried out
68	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
69	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	AFVC
70	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
71	APLFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
72	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
73	SUMNR	☐	SUMKNTNR	KNTNR	NUMC	8	0	Node number of the superior operation
74	OFM01	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
75	OFE01	☐	RU_PROGVGE	MEINS	UNIT	3	0	Unit of measurement for the forecast standard value	T006
76	LEK01	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
77	OFM02	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
78	OFE02	☐	RU_PROGVGE	MEINS	UNIT	3	0	Unit of measurement for the forecast standard value	T006
79	LEK02	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
80	OFM03	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
81	OFE03	☐	RU_PROGVGE	MEINS	UNIT	3	0	Unit of measurement for the forecast standard value	T006
82	LEK03	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
83	OFM04	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
84	OFE04	☐	RU_PROGVGE	MEINS	UNIT	3	0	Unit of measurement for the forecast standard value	T006
85	LEK04	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
86	OFM05	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
87	OFE05	☐	RU_PROGVGE	MEINS	UNIT	3	0	Unit of measurement for the forecast standard value	T006
88	LEK05	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
89	OFM06	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
90	OFE06	☐	RU_PROGVGE	MEINS	UNIT	3	0	Unit of measurement for the forecast standard value	T006
91	LEK06	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
92	OFMNW	☐	REMNW	ARBEIT	QUAN	7	1	Remaining work
93	OFMNE	☐	OFMNE	MEINS	UNIT	3	0	Unit of measure for remaining work	T006
94	LEKNW	☐	LEKNW	XFELD	CHAR	1	0	Indicator: No Remaining Work Expected
95	ODAUR	☐	ODAUR	DAUER_4_1	QUAN	5	1	Remaining duration of activity
96	ODAUE	☐	ODAUE	MEINS	UNIT	3	0	Unit for remaining duration	T006
97	STOKZ	☐	CO_STOKZ	FLAG	CHAR	1	0	Indicator: Document Has Been Reversed
98	STZHL	☐	CO_STZHL	CIM_COUNT	NUMC	8	0	Confirmation counter of cancelled confirmation
99	SMENG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
100	RUECK_MST	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
101	RMZHL_MST	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
102	PDSNR	☐	PDSNR_D	PDSNR	NUMC	12	0	Sequential number for PDC messages	*
103	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	KAKO
104	SPLIT	☐	CY_SPLIT	INT1	INT1	3	0	Split number
105	ZAUSW	☐	DZAUSW	ZAUSW	NUMC	8	0	Time Recording ID Number
106	ORIND	☐	ORIND	ORIND	CHAR	1	0	Origin Indicator of PDC Message (Application)
107	ORIGF	☐	ORIGF	ORIGF	CHAR	1	0	Origin Indicator of PDC Message
108	CANUM	☐	CY_COUNT	CY_COUNT	NUMC	4	0	Counters for cap. rqmts. records (various caps. + indiv.caps	KBED
109	BELNR_IST	☐	CO_BELNR	CO_BELNR	CHAR	10	0	Document Number	*
110	BELNR_UMB	☐	CO_BELNR	CO_BELNR	CHAR	10	0	Document Number	*
111	RMNGA	☐	RU_RMNGA	MENGV13	QUAN	13	3	Current rework quantity to be confirmed
112	CATSBELNR	☐	CATSBELNR	BELNR	CHAR	10	0	Document number
113	SATZA	☐	CO_SATZA	CO_SATZA	CHAR	3	0	Record type for confirmation
114	ERZET	☐	RU_ERZET	UZEIT	TIMS	6	0	Confirmation entry time
115	CATSPRICE	☐	CATSPRICE	WERTV6	CURR	11	2	Price in Transaction Currency
116	CATSTCURR	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	*
117	CATSPEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
118	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
119	IPRZ1	☐	RU_IPRZS	MENGV13	QUAN	13	3	Current quantity to be confirmed for the business process
120	IPRE1	☐	RU_IPRZE	MEINS	UNIT	3	0	Unit of measurement for conf. quantity for business process	T006
121	IPRK1	☐	RU_IPRZK	XFELD	CHAR	1	0	No remaining quantity expected for business process
122	EXNAM	☐	RU_EXNAM	USNAM	CHAR	12	0	External creator of confirmation
123	EXERD	☐	RU_EXERD	DATUM	DATS	8	0	External date of entry for confirmation
124	EXERZ	☐	RU_EXERZ	UZEIT	TIMS	6	0	External time of entry for confirmation
125	PRZ01	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
126	OPRZ1	☐	OPRZ1	MENGV13	QUAN	13	3	Remaining quantity for business process
127	OPRE1	☐	OPRE1	MEINS	UNIT	3	0	Unit for remaining quantity of business process	T006
128	SKOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
129	SKOSTL	☐	SKOSTL	KOSTL	CHAR	10	0	Sender Cost Center	*
130	NODAT	☐	NODAT	XFELD	CHAR	1	0	Do not update actual date in the operation
131	ISMNU	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
132	OFMNU	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
133	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
134	EXTID	☐	RU_EXTID	SYSUUID	RAW	16	0	External Key for Confirmation (for example, from PDC System)
135	SCHGRUP	☐	SCHGRUP	SCHGRUP	CHAR	2	0	Grouping for Shift Definitions and Shift Sequences	*
136	KAPTPROG	☐	KAPTPROG	KAPTPROG	CHAR	4	0	Shift definition	*
137	.INCLUDE	☐				0	0
138	OBMAT	☐	UCMAT	MATNR	CHAR	18	0	Material from Original Batch	*
139	OBCHA	☐	UCCHA	CHARG	CHAR	10	0	Original Batch	*
140	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
141	MYEAR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
142	ME_SFCID	☐	CO_MES_INT_SFCID	CHAR60	CHAR	60	0	SFC Number from the ME System
143	ME_2ND_CONF_QTY	☐	CO_MES_SECOND_CONF_QTY	MENGV13	QUAN	13	3	Rework Quantity Confirmed from SAP ME
144	.INCLU--AP	☐				0	0	Additional Fields for Confirmation
145	ROLE_ID	☐	RMAN_PRSP_ROLEID	RMAN_PRSP_ROLEID	CHAR	1	0	Role ID for Confirmation in Portal
146	.INCLUDE	☐				0	0	Confirmation: Additional dialog fields for table AFRU
147	ARBPL	☐	RU_ARBPLI	ARBPL	CHAR	8	0	Work Center
148	NAME	☐	RU_NAME	TEXT40	CHAR	40	0	Name of employee
149	PERSA	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
150	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
151	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
152	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
153	INDBT	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
154	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	TC26
155	ABARBMAX	☐	DELTAARB	NUM3	NUMC	3	0	Deviation (in %) permitted for work in confirmation
156	ABARBIST	☐	DELTAARB	NUM3	NUMC	3	0	Deviation (in %) permitted for work in confirmation
157	ABDAUMAX	☐	DELTADAU	NUM3	NUMC	3	0	Permitted deviation (in %) for duration in confirmation
158	ABDAUIST	☐	DELTADAU	NUM3	NUMC	3	0	Permitted deviation (in %) for duration in confirmation
159	DEFSET	☐	DEFSET	XFELD	CHAR	1	0	Default values set in collective confirmation
160	VSDAT	☐	VSDAT	XFELD	CHAR	1	0	Indicator: Actual data already proposed
161	VSWBN	☐	VSWBN	XFELD	CHAR	1	0	Indicator: Goods movements are already determined
162	LDATE	☐	LDATE	DATUM	DATS	8	0	Logical Date
163	LTIME	☐	LTIME	UZEIT	TIMS	6	0	Logical time
164	GRDTX	☐	CO_GRDTX	TEXT30	CHAR	30	0	Text describing the reason for a variance in a confirmation
165	ISMNW_2	☐	ISMNW_2	ARBEIT_2	QUAN	8	2	Actual Work
166	OFMNW_2	☐	REMNW_2	ARBEIT_2	QUAN	8	2	Remaining Work
167	.INCLUDE	☐				0	0	Actual Activites for Confirmation of Operation
168	SLK01	☐	RU_TARGET_ACTIVITY	XFELD	CHAR	1	0	Indicator: Determine target activity
169	SLK02	☐	RU_TARGET_ACTIVITY	XFELD	CHAR	1	0	Indicator: Determine target activity
170	SLK03	☐	RU_TARGET_ACTIVITY	XFELD	CHAR	1	0	Indicator: Determine target activity
171	SLK04	☐	RU_TARGET_ACTIVITY	XFELD	CHAR	1	0	Indicator: Determine target activity
172	SLK05	☐	RU_TARGET_ACTIVITY	XFELD	CHAR	1	0	Indicator: Determine target activity
173	SLK06	☐	RU_TARGET_ACTIVITY	XFELD	CHAR	1	0	Indicator: Determine target activity
174	SPRK1	☐	RU_TARGET_BUS_PROC	XFELD	CHAR	1	0	Indicator: Determine target qty for business transaction
175	.INCLUDE	☐				0	0	Additonal EAML Dialog fields for Confirmation
176	EAML_TABIX	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
177	REQKZ	☐	FLG_SEL	XFELD	CHAR	1	0	Selection indicator
178	SELKZ	☐	FLG_SEL	XFELD	CHAR	1	0	Selection indicator
179	VBKZ	☐	VBKZ	VERBUCHER	CHAR	1	0	Update indicator
180	VTEXT	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
181	VFSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
182	VFSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
183	VSSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
184	VSSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
185	VISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
186	VIEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
187	VARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
188	VOFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
189	VISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
190	VARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	*
191	SORT_TABIX	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFRU_COL	APLZL	AFVC	APLZL
2	AFRU_COL	AUFNR	AUFK	AUFNR
3	AFRU_COL	BEMOT	TBMOT	BEMOT
4	AFRU_COL	CANUM	KBED	CANUM
5	AFRU_COL	GMEIN	T006	MSEHI
6	AFRU_COL	GRUND	TRUG	GRUND
7	AFRU_COL	IDAUE	T006	MSEHI
8	AFRU_COL	ILE01	T006	MSEHI
9	AFRU_COL	ILE02	T006	MSEHI
10	AFRU_COL	ILE03	T006	MSEHI
11	AFRU_COL	ILE04	T006	MSEHI
12	AFRU_COL	ILE05	T006	MSEHI
13	AFRU_COL	ILE06	T006	MSEHI
14	AFRU_COL	IPRE1	T006	MSEHI
15	AFRU_COL	ISMNE	T006	MSEHI
16	AFRU_COL	ISMNU	T006	MSEHI
17	AFRU_COL	KAPAR	TC26	KAPAR
18	AFRU_COL	KAPID	KAKO	KAPID
19	AFRU_COL	LEARR	CSLA	LSTAR
20	AFRU_COL	LOGRP	T421	LOGRP
21	AFRU_COL	MANDT	T000	MANDT
22	AFRU_COL	MEINH	T006	MSEHI
23	AFRU_COL	ODAUE	T006	MSEHI
24	AFRU_COL	OFE01	T006	MSEHI
25	AFRU_COL	OFE02	T006	MSEHI
26	AFRU_COL	OFE03	T006	MSEHI
27	AFRU_COL	OFE04	T006	MSEHI
28	AFRU_COL	OFE05	T006	MSEHI
29	AFRU_COL	OFE06	T006	MSEHI
30	AFRU_COL	OFMNE	T006	MSEHI
31	AFRU_COL	OFMNU	T006	MSEHI
32	AFRU_COL	OPRE1	T006	MSEHI
33	AFRU_COL	QUALF	T423	QUALF
34	AFRU_COL	TXTSP	T002	SPRAS
35	AFRU_COL	WERKS	T001W	WERKS
36	AFRU_COL	ZEIER	T006	MSEHI

History

Last changed by/on	SAP	20131127
SAP Release Created in