OLR3_ACTI SAP (PSIS - Individual Overviews: Activities) Structure details

Dictionary Type: Structure
Description: PSIS - Individual Overviews: Activities




ABAP Code to SELECT data from OLR3_ACTI
Related tables to OLR3_ACTI
Access table OLR3_ACTI




Structure field list including key, data, relationships and ABAP select examples

OLR3_ACTI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "PSIS - Individual Overviews: Activities" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_OLR3_ACTI TYPE OLR3_ACTI.

The OLR3_ACTI table consists of various fields, each holding specific information or linking keys about PSIS - Individual Overviews: Activities data available in SAP. These include ARNUMMER (Archiving Session Number), VSGRUPPE (Group for a project version), VSNUMMER (Number or description of a version), PRCTR (Profit Center).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OLR3_ACTI structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
ARNUMMERArchiving Session Number ADMI_RUN_DCHAR6ADMI_RUN
VSGRUPPEGroup for a project version VSGRUPPECHAR20TEXT20
VSNUMMERNumber or description of a version VSNMRCHAR12VSNMRVS2
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PRNAMInvestment program name IM_PRNAMCHAR8IMTPIM_PRNAMIMT
PRPOSIdentification for an investment program position IM_POSIDCHAR24POSIDIM_POSIDIMP
PSPIDProject Definition PS_PSPIDCHAR24ABPSNPS_PSPIDPSPPD_DUMMY
POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
KDAUFSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
KDPOSSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
AUFNROrder/Network number AUF_NETNRCHAR12AUFKALPHAAUFNRANR
VORNRActivity number in network and standard network CN_VORNRCHAR4NUMCVVORNR
UVORNActivity element number (work/external/general costs) CN_ELEMENTCHAR4NUMCVVORNR
AUTYPTXTDisplay field for order category description AUTYPTEXTCHAR40TEXT40
STEUSControl key STEUSCHAR4T430STEUS
STEUTXTControl key description STEUTXTCHAR40TEXT40
ARBPLWork center ARBPLCHAR8ARBPLAGR
ARBTXTShort text for the CIM operating resource PS_ARBTEXTCHAR40TEXT40
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
KTSCHStandard text key KTSCHCHAR7T435KTSCH
LTXA1Operation short text LTXA1CHAR40TEXT40
TXTSPLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
RSTRAReduction strategy per operation/activity RSTRACHAR2T499QRSTRA
SORTLSort Term for Non-Stock Info Records SORTICHAR10CHAR10
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
PREISPrice PREISCURR11(2) WERT11
PEINHPrice Unit PEINHDEC5PACK3
SAKTOCost Element KSTARCHAR10CSKAALPHAKSTARKAT
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
INFNRNumber of Purchasing Info Record INFNRCHAR10EINAALPHAINFNRINFMEIN_C
ESOKZPurchasing info record category ESOKZCHAR1ESOKZESO
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
EKGRPPurchasing group for external processing VG_EKGRPCHAR3T024EKGRP
KZLGFIndicator: fixed lot external processing KZLGFCHAR1XFELD
KZWRTFIndicator: Fixed price for external processing KZWRTFCHAR1XFELD
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
DDEHNIndicator: flexible duration DAUDEHNCHAR1X
ANZZLNumber of capacities required ANZKAPINT13INT1
PRZNTWork percentage APROZENTINT13INT1
MLSTNUsage MILESTONECHAR5T433MILESTONE
MLSTXTMilestone description PS_MLSTTXTCHAR40TEXT40
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
ANFKORequesting cost center ANFKOCHAR10CSKSALPHAKOSTL
ANFKOKRSControlling area of the requesting cost center ANFKOKRSCHAR4TKA01CACCD
INDETKey for calculation INDETCHAR1INDET
LARNTActivity Type LSTARCHAR6CSLALSTARLARLART_EMPTY
PRKSTCosts in the activity PRKSTCURR11(2) PRKST
RUECKCompletion confirmation number for the operation CO_RUECKNUMC10CO_RUECKRCK
RMZHLInternal counter CIM_COUNTNUMC8CIM_COUNT
BANFNPurchase requisition number CO_BANFNCHAR10ALPHABANFN
BNFPOItem number of the purchase requisition in the order CO_BNFPONUMC5EBANBNFPO
KALIDFactory Calendar WFCIDCHAR2TFACDWFCIDFCI
VERTLDistr.cap.reqmts (plant maint.,process order, network) CR_VERTNCHAR8TC29CR_VERTL
LEKNWIndicator: No remaining activity expected CO_LEIKZCHAR1XFELD
NPRIOPriority NW_PRIOCHAR1TCN07NW_PRIO
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
SCOPEObject Class SCOPE_CVCHAR2SCOPESCOPE_CVPCO
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
AUDISPInd: Reservation applicable to MRP;Purc. req. is created AUDISPCHAR1XFELD
AENNRChange Number AENNRCHAR12AENRAENNRAENNRAEN
EVGEWAggregation weight for POC (PS progress) EV_WEIGHTDDEC8DEC8
CLASFInd.: Take Activity Into Account for Project Summarization CLASFCHAR1XFELD
OWAERObject currency for network activity OWAERSCUKY5TCURCWAERS
AFNAMName of Requisitioner/Requester AFNAMCHAR12AFNAM
KZFIXIndicator: Purchasing info record data are fixed CN_KZFIXCHAR1XFELD
PERNRPersonnel number CO_PERNRNUMC8PERNRPER
WKURSExchange Rate WKURSDEC9(5) EXCRTKURSP
FPLNRBilling plan number / invoicing plan number FPLNRCHAR10Assigned to domainFPLNR
KLVARCosting Variant CK_KLVARCHAR4Assigned to domainKLVARKRT
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
PRZ01Business Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
MEINHUnit of Measure for Activity/Operation VORMEUNIT3T006CUNITMEINS
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
DAUNONormal duration of the activity DAUNORQUAN5(1) DAUER_4_1
DAUNENormal duration/unit DAUNOREUNIT3T006CUNITMEINS
DAUMIMinimum activity duration DAUMINQUAN5(1) DAUER_4_1
DAUMEUnit for the minimum duration DAUMINEUNIT3T006CUNITMEINS
EINSAConstraint on the basic start date for the activity EINSCHRACHAR1RESTRIKSTR
EINSEConstraint on the finish date of the activity EINSCHRECHAR1RESTRIKEND
ARBEIWork involved in the activity ARBEITQUAN7(1) ARBEIT
ARBEHUnit for work ARBEITEUNIT3T006CUNITMEINS
MGVRGOperation Quantity MGVRGQUAN13(3) MENG13
ASVRGOperation scrap ASVRGQUAN13(3) MENG13
ISMNWActual work CO_ISMNWQUAN13(3) MENG13
FSAVDEarliest scheduled start: Execution (date) FSAVDDATS8DATUM
FSAVZEarliest scheduled start: Execution (time) FSAVZTIMS6ATIME
FSEDDEarliest scheduled finish: Execution (date) FSEDDDATS8DATUM
FSEDZEarliest scheduled finish: Execution (time) FSEDZTIMS6ATIME
SSAVDLatest scheduled start: Execution (date) SSAVDDATS8DATUM
SSAVZLatest scheduled start: Execution (time) SSAVZTIMS6ATIME
SSEDDLatest scheduled finish: Execution (date) SSEDDDATS8DATUM
SSEDZLatest scheduled finish: Execution (time) SSEDZTIMS6ATIME
ISDDActual start: Execution (date) ISDDDATS8DATUM
ISDZActual start: Execution/setup (time) ISDZTIMS6ATIME
IEDDActual finish: Execution (date) IEDDDATS8DATUMEDR
IEDZActual finish: Execution (time) IEDZTIMS6ATIMEEZR
PEDDForecast finish date of operation from confirmation CO_PEDDDATS8DATUM
PEDZForecast finish time of operation from confirmation CO_PEDZTIMS6ATIME
PUFFRFree float PUFFR_FREIDEC3PUFFER
PUFGSTotal float PUFFR_GESMDEC3PUFFER
NTANFConstraint for activity start (Basic) VORGABESTDDATS8VORGABESTR
NTANZConstraint for activity start time (Basic) VORGABESTZTIMS6ATIME
NTENDConstraint for finish of activity (Basic) VORGABEENDDATS8VORGABEEND
NTENZBasic finish time of the activity VORGABEENZTIMS6ATIME
EWSTDForecasted start date for the activity EWSTARTDDATS8DATUM
EWSTZForecast start time of the activity EWSTARTZTIMS6ATIME
EWENDForecast finish date EWENDEDDATS8DATUM
EWENZForecast finish time for the activity EWENDEZTIMS6ATIME
EWDANNormal duration (from forecast) of activity EWDANQUAN5(1) DAUER_4_1
EWDNEUnit for forecast normal duration EWDNEUNIT3T006CUNITMEINS
EWDAMMinimum duration (from forecast) for activity EWDAMQUAN5(1) DAUER_4_1
EWDMEUnit for forecast minimum duration EWDMEUNIT3T006CUNITMEINS
EWSTEForecast date constraint on activity finish PS_RESTECHAR1RESTRIKEND
EWSTAForecast date constraint on activity start PS_RESTACHAR1RESTRIKSTR
DABEAProcessing time CO_DAUBEAQUAN7(1) DAUER_6_1
BEAZEUnit of measure for processing time BEAZEUNIT3CUNITEINHEIT
OFMNWForecasted work (actual + remaining) OFMNWQUAN7(1) ARBEIT
OFFSTBOffset to sub-operation start CP_OOFFSTBQUAN5VNZTV
EHOFFBUnit for offset to start CP_OEHOFFBUNIT3T006CUNITMEINS
OFFSTEOffset to sub-operation finish CP_OOFFSTEQUAN5VNZTV
EHOFFEUnit for offset to finish CP_OEHOFFEUNIT3T006CUNITMEINS
FPAVDEarliest scheduled start date (forecast) FPAVDDATS8DATUM
FPAVZEarliest scheduled start time (forecast) FPAVZTIMS6ATIME
FPEDDEarliest scheduled finish date (forecast) FPEDDDATS8DATUM
FPEDZEarliest scheduled finish time (forecast) FPEDZTIMS6ATIME
SPAVDLatest scheduled start date (forecast) SPAVDDATS8DATUM
SPAVZLatest scheduled start time (forecast) SPAVZTIMS6ATIME
SPEDDLatest scheduled finish date (forecast) SPEDDDATS8DATUM
SPEDZLatest scheduled finish time (forecast) SPEDZTIMS6ATIME
BEAZPUnit of processing time (Forecast) BEAZEPUNIT3CUNITEINHEIT
PUFGPTotal float (from forecast) PPUFF_GESMDEC3PUFFER
PUFFPFree float (from forecast) PPUFF_FREIDEC3PUFFER
DAPBEDuration of processing time (forecast) CO_DAUBEAPQUAN7(1) DAUER_6_1
EPANFDispatched start date for operation EPANFDATS8DATUM
EPANZDispatched start time for operation EPANZTIMS6ATIME
EPENDDispatched finish date EPENDDATS8DATUM
EPENZDispatched finish time EPENZTIMS6ATIME
PDAUForecasted duration of activity from confirmation PDAUQUAN5(1) DAUER_4_1
PDAEUnit of the forecasted duration from the confirmation PDAEUNIT3T006CUNITMEINS
SLWIDKey word ID for user-defined fields SLWIDCHAR7TCN00SLWID
USR00User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR01User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR02User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR03User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR04User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE04User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USR05User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE05User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USR06User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE06User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USR07User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE07User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USR08User field for date USRDATEDATS8USRDATE
USR09User field for date USRDATEDATS8USRDATE
USR10User-defined field: Indicator for reports USRFLAGCHAR1FLAG
USR11User-defined field: Indicator for reports USRFLAGCHAR1FLAG
WEMNG_OPRQuantity of Goods Received WEMNGQUAN13(3) MENG13
WEMEH_OPRPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
FLG_PURSIndicator: Purchase order exists FLG_PURSCHAR1KREUZ
IDAURActual Duration for Confirmation IDAURQUAN5(1) DAUER_4_1
IDAUEUnit for actual duration IDAUREUNIT3T006CUNITMEINS
ODAURRemaining duration of activity ODAURQUAN5(1) DAUER_4_1
ODAUEUnit for remaining duration ODAUEUNIT3T006CUNITMEINS
ABARBDConfirmation: Degree of processing CO_ABARBNUMC3CO_ABARB
REMNWRemaining Work REMNW_2QUAN8(2) ARBEIT_2
REMNEUnit for work ARBEITEUNIT3T006CUNITMEINS
ABARBAConfirmation: Degree of processing CO_ABARBNUMC3CO_ABARB
STATXTEdited status text STATUSTEXT_2CHAR80CHAR80
FRUEHERActual start is before earliest scheduled start FRUEHER_2QUAN10(1) DAUER_9_1
SPAETERActual Finish/Planned Finish After Latest Scheduled Finish SPAETER_2QUAN10(1) DAUER_9_1
VERZUGDuration After Latest Scheduled Finish VERZUG_2QUAN10(1) DAUER_9_1
VORBEIDuration After Earliest Scheduled Start VORBEI_2QUAN10(1) DAUER_9_1
VEINHUnit for Duration of the Delay VERZ_EINHTUNIT3T006CUNITMEINS
VGTYPActivity or element category VGTYPCHAR3VORG_TYP
FLG_RCKMLDIndicator: Can be confirmed PS_RCKMLDBCHAR1XFELD
FUNC_AREAFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
DUMMY_CI_AFVUSingle-Character Indicator CHAR1CHAR1CHAR1
.INCLU--AP 0
/MRSS/ID_PROFILERequirements Profile Was Changed Manually /MRSS/T_REQU_UPDCHAR1/MRSS/_HCM_BOOLEAN
/MRSS/PROF_KEYProfile Key /MRSS/T_RSG_REQUIDCHAR10ALPHA/MRSS/RSG_REQUID
/MRSS/PROF_GUIDCharacter field, length 32 CHAR32CHAR32CHAR32
/MRSS/ACT_TYPEProcess variant /MRSS/T_ACTIVITY_TYPECHAR1/MRSS/_ACTIVITY_TYPE
/MRSS/ORDER_PROBOrder probability in percent /MRSS/T_ORDER_PROBCHAR3OPROB/MRSS/_ORDER_PROB
/MRSS/INIT_DONEInternal initialization carried out once /MRSS/T_INIT_DONECHAR1FLAG
/MRSS/DATACHANGEData was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGEDCHAR1FLAG
/MRSS/DEM_COUNTCounter for Demands in Operation /MRSS/T_DEM_COUNTNUMC4NUMC4
/MRSS/SUPERV_CNTNumber of Site Supervisors /MRSS/T_RAP_SUPERVISOR_COUNTCHAR2ALPHA/MRSS/_RAP_SUPERVISOR_COUNT
/MRSS/RULE_IDTime Rule Id /MRSS/T_RSG_TIME_RULE_IDCHAR25TEXT25
/MRSS/SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
/MRSS/REFF_RCNTDetermination of Remaining Demand: No. of Resources /MRSS/T_REM_EFFORT_RES_COUNTNUMC3NUMC3
/MRSS/REFF_E_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_E_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/RELEVANTOperation Set as MRS-Relevant /MRSS/T_RELEVANT_FOR_MRSCHAR1FLAG
/MRSS/TEAM_PLANTeam Planning flag for Demand /MRSS/T_RSG_TEAM_PLANNINGCHAR1/MRSS/_RSG_TEAM_PLANNING
/MRSS/SINGL_RESIndicator for Forcing a Single Resource /MRSS/T_RSG_FORCE_SINGLE_RESCHAR1/MRSS/_BOOLEAN
/MRSS/TO_BEGDATField of type DATS DATSDATS8DATS
/MRSS/TO_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_ENDDATField of type DATS DATSDATS8DATS
/MRSS/TO_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/TO_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/TO_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/TO_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN
/MRSS/FR_BEGDATField of type DATS DATSDATS8DATS
/MRSS/FR_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_ENDDATField of type DATS DATSDATS8DATS
/MRSS/FR_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/FR_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/FR_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/FR_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN
INT_IDID/Object key OBJEKT_IDCHAR30CHAR30
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
AUTYPOrder category AUFTYPNUMC2AUFTYP
ARBIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
KAPIDCapacity ID KAPIDNUMC8Assigned to domainKAPID
KAPARCapacity category KAPARTCHAR3Assigned to domainKAPARTCAA
LOEKZDeletion Indicator LOEVMCHAR1XFELD
ELTYPActivity or element category VGTYPCHAR3VORG_TYP
LIGHTALV control: Exception as LED LVC_EXLEDCHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP structure OLR3_ACTI using ABAP code?

As OLR3_ACTI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on OLR3_ACTI as there is no data to select.

How to access SAP table OLR3_ACTI

Within an ECC or HANA version of SAP you can also view further information about OLR3_ACTI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!