SAP ABAP View V_TXW_AFRU (Join COEP/COBK/AFRU)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

View Type	D	Database View
Database View	V_TXW_AFRU
Short Description	Join COEP/COBK/AFRU
Root table	COEP	CO Object: Line Items (by Period)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	COEP	COEP
2	COBK
3	AFRU

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	COBK	MANDT	JL	EQ				0	0
2	COEP	MANDT	JR	EQ			AND	0	0
3	COBK	KOKRS	JL	EQ				0	0
4	COEP	KOKRS	JR	EQ			AND	0	0
5	COBK	BELNR	JL	EQ				0	0
6	COEP	BELNR	JR	EQ			AND	0	0
7	AFRU	RUECK	JL	EQ				0	0
8	COBK	REFBN	JR	EQ			AND	0	0
9	AFRU	RMZHL	JL	EQ				0	0
10	COBK	AWORG	JR	EQ			AND	0	0
11	AFRU	MANDT	JL	EQ				0	0
12	COBK	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	AFRU	*		☐		☐
2	MANDT	AFRU	MANDT		☐	MANDT	☐	Client
3	RUECK	AFRU	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
4	RMZHL	AFRU	RMZHL		☐	CO_RMZHL	☐	Confirmation counter
5	ERSDA	AFRU	ERSDA		☐	RU_ERSDA	☐	Confirmation entry date
6	ERNAM	AFRU	ERNAM		☐	RU_ERNAM	☐	Name of the person who entered the confirmation
7	LAEDA	AFRU	LAEDA		☐	LAEDA	☐	Date of Last Change
8	AENAM	AFRU	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
9	BUDAT	AFRU	BUDAT		☐	BUCHDATUM	☐	Posting date
10	ARBID	AFRU	ARBID		☐	OBJEKTID	☐	Object ID
11	WERKS	AFRU	WERKS		☐	WERKS_D	☐	Plant
12	LTXA1	AFRU	LTXA1		☐	CO_RTEXT	☐	Confirmation text
13	TXTSP	AFRU	TXTSP		☐	SPRAS	☐	Language Key
14	ISERH	AFRU	ISERH		☐	ISERH	☐	Confirmed break time
15	ZEIER	AFRU	ZEIER		☐	DZEIER	☐	Unit for the break time
16	ILE01	AFRU	ILE01		☐	CO_ISMNGEH	☐	Unit of measure for the activity to be confirmed
17	ISM01	AFRU	ISM01		☐	RU_ISMNG	☐	Activity currently to be confirmed
18	ILE02	AFRU	ILE02		☐	CO_ISMNGEH	☐	Unit of measure for the activity to be confirmed
19	ISM02	AFRU	ISM02		☐	RU_ISMNG	☐	Activity currently to be confirmed
20	ILE03	AFRU	ILE03		☐	CO_ISMNGEH	☐	Unit of measure for the activity to be confirmed
21	ISM03	AFRU	ISM03		☐	RU_ISMNG	☐	Activity currently to be confirmed
22	ILE04	AFRU	ILE04		☐	CO_ISMNGEH	☐	Unit of measure for the activity to be confirmed
23	ISM04	AFRU	ISM04		☐	RU_ISMNG	☐	Activity currently to be confirmed
24	ILE05	AFRU	ILE05		☐	CO_ISMNGEH	☐	Unit of measure for the activity to be confirmed
25	ISM05	AFRU	ISM05		☐	RU_ISMNG	☐	Activity currently to be confirmed
26	ILE06	AFRU	ILE06		☐	CO_ISMNGEH	☐	Unit of measure for the activity to be confirmed
27	ISM06	AFRU	ISM06		☐	RU_ISMNG	☐	Activity currently to be confirmed
28	ABARB	AFRU	ABARB		☐	CO_ABARB	☐	Confirmation: Degree of processing
29	ISMNW	AFRU	ISMNW		☐	ISMNW	☐	Actual work
30	ISMNE	AFRU	ISMNE		☐	ARBEITE	☐	Unit for work
31	LEARR	AFRU	LEARR		☐	LEARR	☐	Activity type for confirmation
32	IDAUR	AFRU	IDAUR		☐	IDAUR	☐	Actual duration for confirmation
33	IDAUE	AFRU	IDAUE		☐	IDAURE	☐	Unit for actual duration
34	ZCODE	AFRU	ZCODE		☐	DZCODE	☐	Reference number for standard value code
35	LOART	AFRU	LOART		☐	LOHNART	☐	Wage type
36	QUALF	AFRU	QUALF		☐	QUALF	☐	Suitability
37	ANZMA	AFRU	ANZMA		☐	ANZMS	☐	Number of employees
38	LOGRP	AFRU	LOGRP		☐	LOHNGRP	☐	Wage group
39	GMNGA	AFRU	GMNGA		☐	RU_GMNGA	☐	Previously confirmed yield in order unit of measure
40	LMNGA	AFRU	LMNGA		☐	RU_LMNGA	☐	Yield currently to be confirmed
41	XMNGA	AFRU	XMNGA		☐	RU_XMNGA	☐	Scrap currently to be confirmed
42	GMEIN	AFRU	GMEIN		☐	MEINS	☐	Base Unit of Measure
43	MEINH	AFRU	MEINH		☐	RU_VORME	☐	Confirmation unit of measure
44	GRUND	AFRU	GRUND		☐	CO_AGRND	☐	Reason for Variance
45	PERNR	AFRU	PERNR		☐	CO_PERNR	☐	Personnel number
46	ISDD	AFRU	ISDD		☐	RU_ISDD	☐	Confirmed date for start of execution
47	ISDZ	AFRU	ISDZ		☐	RU_ISDZ	☐	Confirmed time for 'Execution start'
48	IERD	AFRU	IERD		☐	RU_IERD	☐	Confirmed date for 'Setup finish'
49	IERZ	AFRU	IERZ		☐	RU_IERZ	☐	Confirmed time for 'Setup finish'
50	ISBD	AFRU	ISBD		☐	RU_ISBD	☐	Confirmed date for 'Processing start'
51	ISBZ	AFRU	ISBZ		☐	RU_ISBZ	☐	Confirmed time for 'Processing start'
52	IEBD	AFRU	IEBD		☐	RU_IEBD	☐	Confirmed date for 'processing finish'
53	IEBZ	AFRU	IEBZ		☐	RU_IEBZ	☐	Confirmed time for 'processing finish'
54	ISAD	AFRU	ISAD		☐	RU_ISAD	☐	Confirmed date for 'teardown start'
55	ISAZ	AFRU	ISAZ		☐	RU_ISAZ	☐	Confirmed time for 'teardown start'
56	IEDD	AFRU	IEDD		☐	RU_IEDD	☐	Confirmed date for execution finish
57	IEDZ	AFRU	IEDZ		☐	RU_IEDZ	☐	Confirmed time for 'Execution finish'
58	PEDD	AFRU	PEDD		☐	CO_PEDD	☐	Forecast finish date of operation from confirmation
59	PEDZ	AFRU	PEDZ		☐	CO_PEDZ	☐	Forecast finish time of operation from confirmation
60	WABLNR	AFRU	WABLNR		☐	MBLNR	☐	Number of Material Document
61	WEBLNR	AFRU	WEBLNR		☐	WEBLNR	☐	Number of a document from a goods movement with errors
62	AUERU	AFRU	AUERU		☐	AUERU_VS	☐	Partial/Final Confirmation
63	AUSOR	AFRU	AUSOR		☐	AUSBU	☐	Clear Open Reservations
64	STNDR	AFRU	STNDR		☐	STNDR	☐	Indicator: Standard confirmation
65	MANUR	AFRU	MANUR		☐	MANUR	☐	Indicator for type of confirmation
66	MEILR	AFRU	MEILR		☐	MEILR	☐	Indicator: Milestone confirmation carried out
67	AUFPL	AFRU	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
68	APLZL	AFRU	APLZL		☐	CO_APLZL	☐	General counter for order
69	AUFNR	AFRU	AUFNR		☐	AUFNR	☐	Order Number
70	APLFL	AFRU	APLFL		☐	PLNFOLGE	☐	Sequence
71	VORNR	AFRU	VORNR		☐	VORNR	☐	Operation/Activity Number
72	SUMNR	AFRU	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
73	OFM01	AFRU	OFM01		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
74	OFE01	AFRU	OFE01		☐	RU_PROGVGE	☐	Unit of measurement for the forecast standard value
75	LEK01	AFRU	LEK01		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
76	OFM02	AFRU	OFM02		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
77	OFE02	AFRU	OFE02		☐	RU_PROGVGE	☐	Unit of measurement for the forecast standard value
78	LEK02	AFRU	LEK02		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
79	OFM03	AFRU	OFM03		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
80	OFE03	AFRU	OFE03		☐	RU_PROGVGE	☐	Unit of measurement for the forecast standard value
81	LEK03	AFRU	LEK03		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
82	OFM04	AFRU	OFM04		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
83	OFE04	AFRU	OFE04		☐	RU_PROGVGE	☐	Unit of measurement for the forecast standard value
84	LEK04	AFRU	LEK04		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
85	OFM05	AFRU	OFM05		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
86	OFE05	AFRU	OFE05		☐	RU_PROGVGE	☐	Unit of measurement for the forecast standard value
87	LEK05	AFRU	LEK05		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
88	OFM06	AFRU	OFM06		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
89	OFE06	AFRU	OFE06		☐	RU_PROGVGE	☐	Unit of measurement for the forecast standard value
90	LEK06	AFRU	LEK06		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
91	OFMNW	AFRU	OFMNW		☐	REMNW	☐	Remaining work
92	OFMNE	AFRU	OFMNE		☐	OFMNE	☐	Unit of measure for remaining work
93	LEKNW	AFRU	LEKNW		☐	LEKNW	☐	Indicator: No Remaining Work Expected
94	ODAUR	AFRU	ODAUR		☐	ODAUR	☐	Remaining duration of activity
95	ODAUE	AFRU	ODAUE		☐	ODAUE	☐	Unit for remaining duration
96	STOKZ	AFRU	STOKZ		☐	CO_STOKZ	☐	Indicator: Document Has Been Reversed
97	STZHL	AFRU	STZHL		☐	CO_STZHL	☐	Confirmation counter of cancelled confirmation
98	SMENG	AFRU	SMENG		☐	MGVRG	☐	Operation Quantity
99	RUECK_MST	AFRU	RUECK_MST		☐	CO_RUECK	☐	Completion confirmation number for the operation
100	RMZHL_MST	AFRU	RMZHL_MST		☐	CO_RMZHL	☐	Confirmation counter
101	PDSNR	AFRU	PDSNR		☐	PDSNR_D	☐	Sequential number for PDC messages
102	KAPID	AFRU	KAPID		☐	KAPID	☐	Capacity ID
103	SPLIT	AFRU	SPLIT		☐	CY_SPLIT	☐	Split number
104	ZAUSW	AFRU	ZAUSW		☐	DZAUSW	☐	Time Recording ID Number
105	ORIND	AFRU	ORIND		☐	ORIND	☐	Origin Indicator of PDC Message (Application)
106	ORIGF	AFRU	ORIGF		☐	ORIGF	☐	Origin Indicator of PDC Message
107	CANUM	AFRU	CANUM		☐	CY_COUNT	☐	Counters for cap. rqmts. records (various caps. + indiv.caps
108	BELNR_IST	AFRU	BELNR_IST		☐	CO_BELNR	☐	Document Number
109	BELNR_UMB	AFRU	BELNR_UMB		☐	CO_BELNR	☐	Document Number
110	RMNGA	AFRU	RMNGA		☐	RU_RMNGA	☐	Current rework quantity to be confirmed
111	CATSBELNR	AFRU	CATSBELNR		☐	CATSBELNR	☐	Document number
112	SATZA	AFRU	SATZA		☐	CO_SATZA	☐	Record type for confirmation
113	ERZET	AFRU	ERZET		☐	RU_ERZET	☐	Confirmation entry time
114	CATSPRICE	AFRU	CATSPRICE		☐	CATSPRICE	☐	Price in Transaction Currency
115	CATSTCURR	AFRU	CATSTCURR		☐	TWAER	☐	Transaction Currency
116	CATSPEINH	AFRU	CATSPEINH		☐	PEINH	☐	Price unit
117	BEMOT	AFRU	BEMOT		☐	BEMOT	☐	Accounting Indicator
118	IPRZ1	AFRU	IPRZ1		☐	RU_IPRZS	☐	Current quantity to be confirmed for the business process
119	IPRE1	AFRU	IPRE1		☐	RU_IPRZE	☐	Unit of measurement for conf. quantity for business process
120	IPRK1	AFRU	IPRK1		☐	RU_IPRZK	☐	No remaining quantity expected for business process
121	EXNAM	AFRU	EXNAM		☐	RU_EXNAM	☐	External creator of confirmation
122	EXERD	AFRU	EXERD		☐	RU_EXERD	☐	External date of entry for confirmation
123	EXERZ	AFRU	EXERZ		☐	RU_EXERZ	☐	External time of entry for confirmation
124	PRZ01	AFRU	PRZ01		☐	CO_PRZNR	☐	Business Process
125	OPRZ1	AFRU	OPRZ1		☐	OPRZ1	☐	Remaining quantity for business process
126	OPRE1	AFRU	OPRE1		☐	OPRE1	☐	Unit for remaining quantity of business process
127	SKOKRS	AFRU	SKOKRS		☐	KOKRS	☐	Controlling Area
128	SKOSTL	AFRU	SKOSTL		☐	SKOSTL	☐	Sender Cost Center
129	NODAT	AFRU	NODAT		☐	NODAT	☐	Do not update actual date in the operation
130	ISMNU	AFRU	ISMNU		☐	ARBEITE	☐	Unit for work
131	OFMNU	AFRU	OFMNU		☐	ARBEITE	☐	Unit for work
132	PACKNO	AFRU	PACKNO		☐	PACKNO	☐	Package number
133	EXTID	AFRU	EXTID		☐	RU_EXTID	☐	External Key for Confirmation (for example, from PDC System)
134	SCHGRUP	AFRU	SCHGRUP		☐	SCHGRUP	☐	Grouping for Shift Definitions and Shift Sequences
135	KAPTPROG	AFRU	KAPTPROG		☐	KAPTPROG	☐	Shift definition
136	OBMAT	AFRU	OBMAT		☐	UCMAT	☐	Material from Original Batch
137	OBCHA	AFRU	OBCHA		☐	UCCHA	☐	Original Batch
138	LICHA	AFRU	LICHA		☐	LICHN	☐	Vendor Batch Number
139	MYEAR	AFRU	MYEAR		☐	MJAHR	☐	Year of material document
140	ME_SFCID	AFRU	ME_SFCID		☐	CO_MES_INT_SFCID	☐	SFC Number from the ME System
141	ME_2ND_CONF_QTY	AFRU	ME_2ND_CONF_QTY		☐	CO_MES_SECOND_CONF_QTY	☐	Rework Quantity Confirmed from SAP ME
142	ROLE_ID	AFRU	ROLE_ID		☐	RMAN_PRSP_ROLEID	☐	Role ID for Confirmation in Portal
143	OBJNR	COEP	OBJNR		☐	J_OBJNR	☐	Object number
144	KOKRS	COBK	KOKRS		☐	KOKRS	☐	Controlling Area
145	PERIO	COEP	PERIO		☐	CO_PERIO	☐	Period
146	GJAHR	COEP	GJAHR		☐	GJAHR	☐	Fiscal Year
147	BELNR	COBK	BELNR		☐	CO_BELNR	☐	Document Number
148	BUZEI	COEP	BUZEI		☐	CO_BUZEI	☐	Posting row
149	AWTYP	COBK	AWTYP		☐	AWTYP	☐	Reference procedure
150	KSTAR	COEP	KSTAR		☐	KSTAR	☐	Cost Element
151	LEDNR	COEP	LEDNR		☐	LEDNR	☐	Ledger for Controlling objects
152	TWAER	COEP	TWAER		☐	TWAER	☐	Transaction Currency
153	CO_MEINB	COEP	MEINB		☐	MEINB	☐	Posted Unit of Measure

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	20131127
SAP Release Created in	470