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