SAP ABAP Table OLR3_ACTI (PSIS - Individual Overviews: Activities)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   PS-ST (Application Component) Structures
     R3_OBJECTLINK_R3 (Package) Object Link cProjects and R/3
Basic Data
Table Category INTTAB    Structure 
Structure OLR3_ACTI   Table Relationship Diagram
Short Description PSIS - Individual Overviews: Activities    
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   Order Activity Structure for Project Reporting  
2 ARNUMMER ADMI_RUN_D ADMI_RUN CHAR 6   0   Archiving Session Number  
3 VSGRUPPE VSGRUPPE TEXT20 CHAR 20   0   Group for a project version  
4 VSNUMMER VSNMR VSNMR CHAR 12   0   Number or description of a version  
5 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
6 PRNAM IM_PRNAM IM_PRNAM CHAR 8   0   Investment program name IMTP
7 PRPOS IM_POSID IM_POSID CHAR 24   0   Identification for an investment program position  
8 PSPID PS_PSPID PS_PSPID CHAR 24   0   Project definition  
9 POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
10 KDAUF VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
11 KDPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
12 AUFNR AUF_NETNR AUFNR CHAR 12   0   Order/Network number AUFK
13 VORNR CN_VORNR VORNR CHAR 4   0   Activity number in network and standard network  
14 UVORN CN_ELEMENT VORNR CHAR 4   0   Activity element number (work/external/general costs)  
15 AUTYPTXT AUTYPTEXT TEXT40 CHAR 40   0   Display field for order category description  
16 STEUS STEUS STEUS CHAR 4   0   Control key T430
17 STEUTXT STEUTXT TEXT40 CHAR 40   0   Control key description  
18 ARBPL ARBPL ARBPL CHAR 8   0   Work center  
19 ARBTXT PS_ARBTEXT TEXT40 CHAR 40   0   Short text for the CIM operating resource  
20 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
21 KTSCH KTSCH KTSCH CHAR 7   0   Standard text key T435
22 LTXA1 LTXA1 TEXT40 CHAR 40   0   Operation short text  
23 TXTSP SPRAS SPRAS LANG 1   0   Language Key T002
24 RSTRA RSTRA RSTRA CHAR 2   0   Reduction strategy per operation/activity T499Q
25 SORTL SORTI CHAR10 CHAR 10   0   Sort Term for Non-Stock Info Records  
26 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
27 PREIS PREIS WERT11 CURR 11   2   Price  
28 PEINH PEINH PACK3 DEC 5   0   Price unit  
29 SAKTO KSTAR KSTAR CHAR 10   0   Cost Element CSKA
30 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
31 INFNR INFNR INFNR CHAR 10   0   Number of purchasing info record EINA
32 ESOKZ ESOKZ ESOKZ CHAR 1   0   Purchasing info record category  
33 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
34 EKGRP VG_EKGRP EKGRP CHAR 3   0   Purchasing group for external processing T024
35 KZLGF KZLGF XFELD CHAR 1   0   Indicator: fixed lot external processing  
36 KZWRTF KZWRTF XFELD CHAR 1   0   Indicator: Fixed price for external processing  
37 MATKL MATKL MATKL CHAR 9   0   Material Group T023
38 DDEHN DAUDEHN X CHAR 1   0   Indicator: flexible duration  
39 ANZZL ANZKAP INT1 INT1 3   0   Number of capacities required  
40 PRZNT APROZENT INT1 INT1 3   0   Work percentage  
41 MLSTN MILESTONE MILESTONE CHAR 5   0   Usage T433
42 MLSTXT PS_MLSTTXT TEXT40 CHAR 40   0   Milestone description  
43 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
44 ANFKO ANFKO KOSTL CHAR 10   0   Requesting cost center CSKS
45 ANFKOKRS ANFKOKRS CACCD CHAR 4   0   Controlling area of the requesting cost center TKA01
46 INDET INDET INDET CHAR 1   0   Calculation key  
47 LARNT LSTAR LSTAR CHAR 6   0   Activity Type CSLA
48 PRKST PRKST PRKST CURR 11   2   Costs in the activity  
49 RUECK CO_RUECK CO_RUECK NUMC 10   0   Completion confirmation number for the operation  
50 RMZHL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
51 BANFN CO_BANFN BANFN CHAR 10   0   Purchase requisition number  
52 BNFPO CO_BNFPO BNFPO NUMC 5   0   Item number of the purchase requisition in the order EBAN
53 KALID WFCID WFCID CHAR 2   0   Factory Calendar TFACD
54 VERTL CR_VERTN CR_VERTL CHAR 8   0   Distr.cap.reqmts (plant maint.,process order, network) TC29
55 LEKNW CO_LEIKZ XFELD CHAR 1   0   Indicator: No remaining activity expected  
56 NPRIO NW_PRIO NW_PRIO CHAR 1   0   Priority TCN07
57 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
58 SCOPE SCOPE_CV SCOPE_CV CHAR 2   0   Object Class  
59 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
60 AUDISP AUDISP XFELD CHAR 1   0   Ind: Reservation applicable to MRP;Purc. req. is created  
61 AENNR AENNR AENNR CHAR 12   0   Change Number AENR
62 EVGEW EV_WEIGHTD DEC8 DEC 8   0   Aggregation weight for POC (PS progress)  
63 CLASF CLASF XFELD CHAR 1   0   Ind.: Take Activity Into Account for Project Summarization  
64 OWAER OWAERS WAERS CUKY 5   0   Object currency for network activity TCURC
65 AFNAM AFNAM AFNAM CHAR 12   0   Name of requisitioner/requester  
66 KZFIX CN_KZFIX XFELD CHAR 1   0   Indicator: Purchasing info record data are fixed  
67 PERNR CO_PERNR PERNR NUMC 8   0   Personnel number  
68 WKURS WKURS KURSP DEC 9   5   Exchange Rate  
69 FPLNR FPLNR FPLNR CHAR 10   0   Billing plan number / invoicing plan number *
70 KLVAR CK_KLVAR KLVAR CHAR 4   0   Costing Variant *
71 KALNR CK_KALNR CK_KALNR NUMC 12   0   Cost Estimate Number for Cost Est. w/o Qty Structure *
72 PRZ01 CO_PRZNR CO_PRZNR CHAR 12   0   Business Process *
73 MEINH VORME MEINS UNIT 3   0   Unit of measure for activity T006
74 PLIFZ PLIFZ DEC3 DEC 3   0   Planned delivery time in days  
75 DAUNO DAUNOR DAUER_4_1 QUAN 5   1   Normal duration of the activity  
76 DAUNE DAUNORE MEINS UNIT 3   0   Normal duration/unit T006
77 DAUMI DAUMIN DAUER_4_1 QUAN 5   1   Minimum activity duration  
78 DAUME DAUMINE MEINS UNIT 3   0   Unit for the minimum duration T006
79 EINSA EINSCHRA RESTRIKSTR CHAR 1   0   Constraint on the basic start date for the activity  
80 EINSE EINSCHRE RESTRIKEND CHAR 1   0   Constraint on the finish date of the activity  
81 ARBEI ARBEIT ARBEIT QUAN 7   1   Work involved in the activity  
82 ARBEH ARBEITE MEINS UNIT 3   0   Unit for work T006
83 MGVRG MGVRG MENG13 QUAN 13   3   Operation Quantity  
84 ASVRG ASVRG MENG13 QUAN 13   3   Operation scrap  
85 ISMNW CO_ISMNW MENG13 QUAN 13   3   Actual work  
86 FSAVD FSAVD DATUM DATS 8   0   Earliest scheduled start: Execution (date)  
87 FSAVZ FSAVZ ATIME TIMS 6   0   Earliest scheduled start: Execution (time)  
88 FSEDD FSEDD DATUM DATS 8   0   Earliest scheduled finish: Execution (date)  
89 FSEDZ FSEDZ ATIME TIMS 6   0   Earliest scheduled finish: Execution (time)  
90 SSAVD SSAVD DATUM DATS 8   0   Latest scheduled start: Execution (date)  
91 SSAVZ SSAVZ ATIME TIMS 6   0   Latest scheduled start: Execution (time)  
92 SSEDD SSEDD DATUM DATS 8   0   Latest scheduled finish: Execution (date)  
93 SSEDZ SSEDZ ATIME TIMS 6   0   Latest scheduled finish: Execution (time)  
94 ISDD ISDD DATUM DATS 8   0   Actual start: Execution (date)  
95 ISDZ ISDZ ATIME TIMS 6   0   Actual start: Execution/setup (time)  
96 IEDD IEDD DATUM DATS 8   0   Actual finish: Execution (date)  
97 IEDZ IEDZ ATIME TIMS 6   0   Actual finish: Execution (time)  
98 PEDD CO_PEDD DATUM DATS 8   0   Forecast finish date of operation from confirmation  
99 PEDZ CO_PEDZ ATIME TIMS 6   0   Forecast finish time of operation from confirmation  
100 PUFFR PUFFR_FREI PUFFER DEC 3   0   Free float  
101 PUFGS PUFFR_GESM PUFFER DEC 3   0   Total float  
102 NTANF VORGABESTD VORGABESTR DATS 8   0   Constraint for activity start (Basic)  
103 NTANZ VORGABESTZ ATIME TIMS 6   0   Constraint for activity start time (Basic)  
104 NTEND VORGABEEND VORGABEEND DATS 8   0   Constraint for finish of activity (Basic)  
105 NTENZ VORGABEENZ ATIME TIMS 6   0   Basic finish time of the activity  
106 EWSTD EWSTARTD DATUM DATS 8   0   Forecasted start date for the activity  
107 EWSTZ EWSTARTZ ATIME TIMS 6   0   Forecast start time of the activity  
108 EWEND EWENDED DATUM DATS 8   0   Forecast finish date  
109 EWENZ EWENDEZ ATIME TIMS 6   0   Forecast finish time for the activity  
110 EWDAN EWDAN DAUER_4_1 QUAN 5   1   Normal duration (from forecast) of activity  
111 EWDNE EWDNE MEINS UNIT 3   0   Unit for forecast normal duration T006
112 EWDAM EWDAM DAUER_4_1 QUAN 5   1   Minimum duration (from forecast) for activity  
113 EWDME EWDME MEINS UNIT 3   0   Unit for forecast minimum duration T006
114 EWSTE PS_RESTE RESTRIKEND CHAR 1   0   Forecast date constraint on activity finish  
115 EWSTA PS_RESTA RESTRIKSTR CHAR 1   0   Forecast date constraint on activity start  
116 DABEA CO_DAUBEA DAUER_6_1 QUAN 7   1   Processing time  
117 BEAZE BEAZE EINHEIT UNIT 3   0   Unit of measure for processing time  
118 OFMNW OFMNW ARBEIT QUAN 7   1   Forecasted work (actual + remaining)  
119 OFFSTB CP_OOFFSTB VNZTV QUAN 5   0   Offset to sub-operation start  
120 EHOFFB CP_OEHOFFB MEINS UNIT 3   0   Unit for offset to start T006
121 OFFSTE CP_OOFFSTE VNZTV QUAN 5   0   Offset to sub-operation finish  
122 EHOFFE CP_OEHOFFE MEINS UNIT 3   0   Unit for offset to finish T006
123 FPAVD FPAVD DATUM DATS 8   0   Earliest scheduled start date (forecast)  
124 FPAVZ FPAVZ ATIME TIMS 6   0   Earliest scheduled start time (forecast)  
125 FPEDD FPEDD DATUM DATS 8   0   Earliest scheduled finish date (forecast)  
126 FPEDZ FPEDZ ATIME TIMS 6   0   Earliest scheduled finish time (forecast)  
127 SPAVD SPAVD DATUM DATS 8   0   Latest scheduled start date (forecast)  
128 SPAVZ SPAVZ ATIME TIMS 6   0   Latest scheduled start time (forecast)  
129 SPEDD SPEDD DATUM DATS 8   0   Latest scheduled finish date (forecast)  
130 SPEDZ SPEDZ ATIME TIMS 6   0   Latest scheduled finish time (forecast)  
131 BEAZP BEAZEP EINHEIT UNIT 3   0   Unit of processing time (Forecast)  
132 PUFGP PPUFF_GESM PUFFER DEC 3   0   Total float (from forecast)  
133 PUFFP PPUFF_FREI PUFFER DEC 3   0   Free float (from forecast)  
134 DAPBE CO_DAUBEAP DAUER_6_1 QUAN 7   1   Duration of processing time (forecast)  
135 EPANF EPANF DATUM DATS 8   0   Dispatched start date for operation  
136 EPANZ EPANZ ATIME TIMS 6   0   Dispatched start time for operation  
137 EPEND EPEND DATUM DATS 8   0   Dispatched finish date  
138 EPENZ EPENZ ATIME TIMS 6   0   Dispatched finish time  
139 PDAU PDAU DAUER_4_1 QUAN 5   1   Forecasted duration of activity from confirmation  
140 PDAE PDAE MEINS UNIT 3   0   Unit of the forecasted duration from the confirmation T006
141 SLWID SLWID SLWID CHAR 7   0   Key word ID for user-defined fields TCN00
142 USR00 USRCHAR20 USRCHAR20 CHAR 20   0   User field with 20 characters  
143 USR01 USRCHAR20 USRCHAR20 CHAR 20   0   User field with 20 characters  
144 USR02 USRCHAR10 USRCHAR10 CHAR 10   0   User field with 10 characters  
145 USR03 USRCHAR10 USRCHAR10 CHAR 10   0   User field with 10 characters  
146 USR04 USRQUAN13 USRQUAN13 QUAN 13   3   User field for quantity (length 10.3)  
147 USE04 USRUNIT MEINS UNIT 3   0   User field: Unit for quantity fields T006
148 USR05 USRQUAN13 USRQUAN13 QUAN 13   3   User field for quantity (length 10.3)  
149 USE05 USRUNIT MEINS UNIT 3   0   User field: Unit for quantity fields T006
150 USR06 USRCURR13 USRCURR13 CURR 13   3   User-defined field for values (length 10,3)  
151 USE06 USRCUKY WAERS CUKY 5   0   User field: Unit for value fields TCURC
152 USR07 USRCURR13 USRCURR13 CURR 13   3   User-defined field for values (length 10,3)  
153 USE07 USRCUKY WAERS CUKY 5   0   User field: Unit for value fields TCURC
154 USR08 USRDATE USRDATE DATS 8   0   User field for date  
155 USR09 USRDATE USRDATE DATS 8   0   User field for date  
156 USR10 USRFLAG FLAG CHAR 1   0   User-defined field: Indicator for reports  
157 USR11 USRFLAG FLAG CHAR 1   0   User-defined field: Indicator for reports  
158 WEMNG_OPR WEMNG MENG13 QUAN 13   3   Quantity of goods received  
159 WEMEH_OPR BSTME MEINS UNIT 3   0   Order unit T006
160 FLG_PURS FLG_PURS KREUZ CHAR 1   0   Indicator: Purchase order exists  
161 IDAUR IDAUR DAUER_4_1 QUAN 5   1   Actual duration for confirmation  
162 IDAUE IDAURE MEINS UNIT 3   0   Unit for actual duration T006
163 ODAUR ODAUR DAUER_4_1 QUAN 5   1   Remaining duration of activity  
164 ODAUE ODAUE MEINS UNIT 3   0   Unit for remaining duration T006
165 ABARBD CO_ABARB CO_ABARB NUMC 3   0   Confirmation: Degree of processing  
166 REMNW REMNW_2 ARBEIT_2 QUAN 8   2   Remaining Work  
167 REMNE ARBEITE MEINS UNIT 3   0   Unit for work T006
168 ABARBA CO_ABARB CO_ABARB NUMC 3   0   Confirmation: Degree of processing  
169 STATXT STATUSTEXT_2 CHAR80 CHAR 80   0   Edited status text  
170 FRUEHER FRUEHER_2 DAUER_9_1 QUAN 10   1   Actual start is before earliest scheduled start  
171 SPAETER SPAETER_2 DAUER_9_1 QUAN 10   1   Actual Finish/Planned Finish After Latest Scheduled Finish  
172 VERZUG VERZUG_2 DAUER_9_1 QUAN 10   1   Duration After Latest Scheduled Finish  
173 VORBEI VORBEI_2 DAUER_9_1 QUAN 10   1   Duration After Earliest Scheduled Start  
174 VEINH VERZ_EINHT MEINS UNIT 3   0   Unit for Duration of the Delay T006
175 VGTYP VGTYP VORG_TYP CHAR 3   0   Activity or element category  
176 FLG_RCKMLD PS_RCKMLDB XFELD CHAR 1   0   Indicator: Can be confirmed  
177 FUNC_AREA FKBER FKBER CHAR 16   0   Functional Area *
178 .INCLUDE       0   0    
179 .INCLUDE       0   0    
180 INT_ID OBJEKT_ID CHAR30 CHAR 30   0   ID/Object key  
181 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
182 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
183 AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
184 ARBID CR_OBJID CR_OBJID NUMC 8   0   Object ID of the resource *
185 KAPID KAPID KAPID NUMC 8   0   Capacity ID *
186 KAPAR KAPART KAPART CHAR 3   0   Capacity category *
187 LOEKZ LOEVM XFELD CHAR 1   0   Deletion Indicator  
188 ELTYP VGTYP VORG_TYP CHAR 3   0   Activity or element category  
189 LIGHT LVC_EXLED CHAR1 CHAR 1   0   ALV control: Exception as LED  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OLR3_ACTI AENNR AENR AENNR REF    
2 OLR3_ACTI ANFKO CSKS KOSTL REF C CN
3 OLR3_ACTI ANFKOKRS TKA01 KOKRS REF C CN
4 OLR3_ACTI ARBEH T006 MSEHI REF C CN
5 OLR3_ACTI AUFNR AUFK AUFNR KEY 1 CN
6 OLR3_ACTI BNFPO EBAN BNFPO REF C CN
7 OLR3_ACTI BUKRS T001 BUKRS REF 1 CN
8 OLR3_ACTI DAUME T006 MSEHI REF C CN
9 OLR3_ACTI DAUNE T006 MSEHI REF C CN
10 OLR3_ACTI EHOFFB T006 MSEHI REF C CN
11 OLR3_ACTI EHOFFE T006 MSEHI REF C CN
12 OLR3_ACTI EKGRP T024 EKGRP REF C CN
13 OLR3_ACTI EKORG T024E EKORG REF C CN
14 OLR3_ACTI EWDME T006 MSEHI REF C CN
15 OLR3_ACTI EWDNE T006 MSEHI REF C CN
16 OLR3_ACTI GSBER TGSB GSBER REF C CN
17 OLR3_ACTI IDAUE T006 MSEHI REF C CN
18 OLR3_ACTI INFNR EINA INFNR REF C CN
19 OLR3_ACTI KALID TFACD IDENT REF C CN
20 OLR3_ACTI KDAUF VBUK VBELN REF C CN
21 OLR3_ACTI KDPOS VBUP POSNR REF C CN
22 OLR3_ACTI KTSCH T435 VLSCH REF C CN
23 OLR3_ACTI LARNT CSLA LSTAR REF C CN
24 OLR3_ACTI LIFNR LFA1 LIFNR REF C CN
25 OLR3_ACTI MATKL T023 MATKL REF C CN
26 OLR3_ACTI MEINH T006 MSEHI REF C CN
27 OLR3_ACTI MLSTN T433 MLSTN REF C CN
28 OLR3_ACTI NPRIO TCN07 NPRIO REF C CN
29 OLR3_ACTI ODAUE T006 MSEHI REF C CN
30 OLR3_ACTI OWAER TCURC WAERS    
31 OLR3_ACTI PDAE T006 MSEHI REF C CN
32 OLR3_ACTI PRCTR CEPC PRCTR REF C CN
33 OLR3_ACTI PRNAM IMTP PRNAM   CN
34 OLR3_ACTI REMNE T006 MSEHI REF C CN
35 OLR3_ACTI RSTRA T499Q RSTRA REF C CN
36 OLR3_ACTI SAKTO CSKA KSTAR REF C CN
37 OLR3_ACTI SLWID TCN00 SLWID REF C CN
38 OLR3_ACTI STEUS T430 STEUS REF 1 CN
39 OLR3_ACTI TXJCD TTXJ TXJCD REF C CN
40 OLR3_ACTI TXTSP T002 SPRAS REF C CN
41 OLR3_ACTI USE04 T006 MSEHI REF C CN
42 OLR3_ACTI USE05 T006 MSEHI REF C CN
43 OLR3_ACTI USE06 TCURC WAERS REF C CN
44 OLR3_ACTI USE07 TCURC WAERS REF C CN
45 OLR3_ACTI VEINH T006 MSEHI REF C CN
46 OLR3_ACTI VERTL TC29 VERTL REF C CN
47 OLR3_ACTI WAERS TCURC WAERS REF C CN
48 OLR3_ACTI WEMEH_OPR T006 MSEHI REF C CN
49 OLR3_ACTI WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in