RECONST_ACT SAP (Order Activity Structure for Project Reporting) Structure details
Description: Order Activity Structure for Project Reporting
Structure field list including key, data, relationships and ABAP select examples
RECONST_ACT 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 "Order Activity Structure for Project Reporting" 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_RECONST_ACT TYPE RECONST_ACT.
The RECONST_ACT table consists of various fields, each holding specific information or linking keys about Order Activity Structure for Project Reporting data available in SAP. These include KDPOS (Sales Document Item), AUFNR (Order/Network number), VORNR (Activity number in network and standard network), UVORN (Activity element number (work/external/general costs)).. 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 RECONST_ACT 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 |
KDAUF | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
AUFNR | Order/Network number | AUF_NETNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
VORNR | Activity number in network and standard network | CN_VORNR | CHAR | 4 | NUMCV | VORNR | |||
UVORN | Activity element number (work/external/general costs) | CN_ELEMENT | CHAR | 4 | NUMCV | VORNR | |||
AUTYPTXT | Display field for order category description | AUTYPTEXT | CHAR | 40 | TEXT40 | ||||
STEUS | Control key | STEUS | CHAR | 4 | T430 | STEUS | |||
STEUTXT | Control key description | STEUTXT | CHAR | 40 | TEXT40 | ||||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
ARBTXT | Short text for the CIM operating resource | PS_ARBTEXT | CHAR | 40 | TEXT40 | ||||
KTSCH | Standard text key | KTSCH | CHAR | 7 | T435 | KTSCH | |||
LTXA1 | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
SORTL | Sort Term for Non-Stock Info Records | SORTI | CHAR | 10 | CHAR10 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
PREIS | Price | PREIS | CURR | 11(2) | WERT11 | ||||
SAKTO | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
ESOKZ | Purchasing info record category | ESOKZ | CHAR | 1 | ESOKZ | ESO | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
EKGRP | Purchasing group for external processing | VG_EKGRP | CHAR | 3 | T024 | EKGRP | |||
KZLGF | Indicator: fixed lot external processing | KZLGF | CHAR | 1 | XFELD | ||||
KZWRTF | Indicator: Fixed price for external processing | KZWRTF | CHAR | 1 | XFELD | ||||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
DDEHN | Indicator: flexible duration | DAUDEHN | CHAR | 1 | X | ||||
ANZZL | Number of capacities required | ANZKAP | INT1 | 3 | INT1 | ||||
PRZNT | Work percentage | APROZENT | INT1 | 3 | INT1 | ||||
MLSTN | Usage | MILESTONE | CHAR | 5 | T433 | MILESTONE | |||
MLSTXT | Milestone description | PS_MLSTTXT | CHAR | 40 | TEXT40 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
ANFKO | Requesting cost center | ANFKO | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
ANFKOKRS | Controlling area of the requesting cost center | ANFKOKRS | CHAR | 4 | TKA01 | CACCD | |||
INDET | Key for calculation | INDET | CHAR | 1 | INDET | ||||
LARNT | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
PRKST | Costs in the activity | PRKST | CURR | 11(2) | PRKST | ||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
RMZHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
BANFN | Purchase requisition number | CO_BANFN | CHAR | 10 | ALPHA | BANFN | |||
BNFPO | Item number of the purchase requisition in the order | CO_BNFPO | NUMC | 5 | EBAN | BNFPO | |||
VERTL | Distr.cap.reqmts (plant maint.,process order, network) | CR_VERTN | CHAR | 8 | TC29 | CR_VERTL | |||
LEKNW | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
NPRIO | Priority | NW_PRIO | CHAR | 1 | TCN07 | NW_PRIO | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
AUDISP | Ind: Reservation applicable to MRP;Purc. req. is created | AUDISP | CHAR | 1 | XFELD | ||||
OWAER | Object currency for network activity | OWAERS | CUKY | 5 | TCURC | WAERS | |||
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
KZFIX | Indicator: Purchasing info record data are fixed | CN_KZFIX | CHAR | 1 | XFELD | ||||
PERNR | Personnel number | CO_PERNR | NUMC | 8 | PERNR | PER | |||
WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | Assigned to domain | FPLNR | |||
KLVAR | Costing Variant | CK_KLVAR | CHAR | 4 | Assigned to domain | KLVAR | KRT | ||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
PRZ01 | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | T006 | CUNIT | MEINS | ||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
DAUNO | Normal duration of the activity | DAUNOR | QUAN | 5(1) | DAUER_4_1 | ||||
DAUNE | Normal duration/unit | DAUNORE | UNIT | 3 | T006 | CUNIT | MEINS | ||
DAUMI | Minimum activity duration | DAUMIN | QUAN | 5(1) | DAUER_4_1 | ||||
DAUME | Unit for the minimum duration | DAUMINE | UNIT | 3 | T006 | CUNIT | MEINS | ||
EINSA | Constraint on the basic start date for the activity | EINSCHRA | CHAR | 1 | RESTRIKSTR | ||||
EINSE | Constraint on the finish date of the activity | EINSCHRE | CHAR | 1 | RESTRIKEND | ||||
ARBEI | Work involved in the activity | ARBEIT | QUAN | 7(1) | ARBEIT | ||||
ARBEH | Unit for work | ARBEITE | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGVRG | Operation Quantity | MGVRG | QUAN | 13(3) | MENG13 | ||||
ASVRG | Operation scrap | ASVRG | QUAN | 13(3) | MENG13 | ||||
ISMNW | Actual work | ISMNW | QUAN | 7(1) | ARBEIT | ||||
FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
FSAVZ | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 6 | ATIME | ||||
FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
FSEDZ | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 6 | ATIME | ||||
SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
SSAVZ | Latest scheduled start: Execution (time) | SSAVZ | TIMS | 6 | ATIME | ||||
SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
ISDD | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
ISDZ | Actual start: Execution/setup (time) | ISDZ | TIMS | 6 | ATIME | ||||
IEDD | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
IEDZ | Actual finish: Execution (time) | IEDZ | TIMS | 6 | ATIME | EZR | |||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
PEDZ | Forecast finish time of operation from confirmation | CO_PEDZ | TIMS | 6 | ATIME | ||||
PUFFR | Free float | PUFFR_FREI | DEC | 3 | PUFFER | ||||
PUFGS | Total float | PUFFR_GESM | DEC | 3 | PUFFER | ||||
NTANF | Constraint for activity start (Basic) | VORGABESTD | DATS | 8 | VORGABESTR | ||||
NTANZ | Constraint for activity start time (Basic) | VORGABESTZ | TIMS | 6 | ATIME | ||||
NTEND | Constraint for finish of activity (Basic) | VORGABEEND | DATS | 8 | VORGABEEND | ||||
NTENZ | Basic finish time of the activity | VORGABEENZ | TIMS | 6 | ATIME | ||||
EWSTD | Forecasted start date for the activity | EWSTARTD | DATS | 8 | DATUM | ||||
EWSTZ | Forecast start time of the activity | EWSTARTZ | TIMS | 6 | ATIME | ||||
EWEND | Forecast finish date | EWENDED | DATS | 8 | DATUM | ||||
EWENZ | Forecast finish time for the activity | EWENDEZ | TIMS | 6 | ATIME | ||||
EWDAN | Normal duration (from forecast) of activity | EWDAN | QUAN | 5(1) | DAUER_4_1 | ||||
EWDNE | Unit for forecast normal duration | EWDNE | UNIT | 3 | T006 | CUNIT | MEINS | ||
EWDAM | Minimum duration (from forecast) for activity | EWDAM | QUAN | 5(1) | DAUER_4_1 | ||||
EWDME | Unit for forecast minimum duration | EWDME | UNIT | 3 | T006 | CUNIT | MEINS | ||
EWSTE | Forecast date constraint on activity finish | PS_RESTE | CHAR | 1 | RESTRIKEND | ||||
EWSTA | Forecast date constraint on activity start | PS_RESTA | CHAR | 1 | RESTRIKSTR | ||||
DABEA | Processing time | CO_DAUBEA | QUAN | 7(1) | DAUER_6_1 | ||||
BEAZE | Unit of measure for processing time | BEAZE | UNIT | 3 | CUNIT | EINHEIT | |||
OFMNW | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT | ||||
OFFSTB | Offset to sub-operation start | CP_OOFFSTB | QUAN | 5 | VNZTV | ||||
EHOFFB | Unit for offset to start | CP_OEHOFFB | UNIT | 3 | T006 | CUNIT | MEINS | ||
OFFSTE | Offset to sub-operation finish | CP_OOFFSTE | QUAN | 5 | VNZTV | ||||
EHOFFE | Unit for offset to finish | CP_OEHOFFE | UNIT | 3 | T006 | CUNIT | MEINS | ||
FPAVD | Earliest scheduled start date (forecast) | FPAVD | DATS | 8 | DATUM | ||||
FPAVZ | Earliest scheduled start time (forecast) | FPAVZ | TIMS | 6 | ATIME | ||||
FPEDD | Earliest scheduled finish date (forecast) | FPEDD | DATS | 8 | DATUM | ||||
FPEDZ | Earliest scheduled finish time (forecast) | FPEDZ | TIMS | 6 | ATIME | ||||
SPAVD | Latest scheduled start date (forecast) | SPAVD | DATS | 8 | DATUM | ||||
SPAVZ | Latest scheduled start time (forecast) | SPAVZ | TIMS | 6 | ATIME | ||||
SPEDD | Latest scheduled finish date (forecast) | SPEDD | DATS | 8 | DATUM | ||||
SPEDZ | Latest scheduled finish time (forecast) | SPEDZ | TIMS | 6 | ATIME | ||||
BEAZP | Unit of processing time (Forecast) | BEAZEP | UNIT | 3 | CUNIT | EINHEIT | |||
PUFGP | Total float (from forecast) | PPUFF_GESM | DEC | 3 | PUFFER | ||||
PUFFP | Free float (from forecast) | PPUFF_FREI | DEC | 3 | PUFFER | ||||
DAPBE | Duration of processing time (forecast) | CO_DAUBEAP | QUAN | 7(1) | DAUER_6_1 | ||||
EPANF | Dispatched start date for operation | EPANF | DATS | 8 | DATUM | ||||
EPANZ | Dispatched start time for operation | EPANZ | TIMS | 6 | ATIME | ||||
EPEND | Dispatched finish date | EPEND | DATS | 8 | DATUM | ||||
EPENZ | Dispatched finish time | EPENZ | TIMS | 6 | ATIME | ||||
PDAU | Forecasted duration of activity from confirmation | PDAU | QUAN | 5(1) | DAUER_4_1 | ||||
PDAE | Unit of the forecasted duration from the confirmation | PDAE | UNIT | 3 | T006 | CUNIT | MEINS | ||
WEMNG_OPR | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
WEMEH_OPR | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
FLG_PURS | Indicator: Purchase order exists | FLG_PURS | CHAR | 1 | KREUZ | ||||
IDAUE | Unit for actual duration | IDAURE | UNIT | 3 | T006 | CUNIT | MEINS | ||
ODAUR | Remaining duration of activity | ODAUR | QUAN | 5(1) | DAUER_4_1 | ||||
ODAUE | Unit for remaining duration | ODAUE | UNIT | 3 | T006 | CUNIT | MEINS | ||
ABARBD | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | CO_ABARB | ||||
REMNW | Remaining work | REMNW | QUAN | 7(1) | ARBEIT | ||||
REMNE | Unit for work | ARBEITE | UNIT | 3 | T006 | CUNIT | MEINS | ||
ABARBA | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | CO_ABARB | ||||
VGTYP | Activity or element category | VGTYP | CHAR | 3 | VORG_TYP | ||||
FLG_RCKMLD | Indicator: Can be confirmed | PS_RCKMLDB | CHAR | 1 | XFELD | ||||
DUMMY_CI_AFVU | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
/MRSS/ID_PROFILE | Requirements Profile Was Changed Manually | /MRSS/T_REQU_UPD | CHAR | 1 | /MRSS/_HCM_BOOLEAN | ||||
/MRSS/PROF_KEY | Profile Key | /MRSS/T_RSG_REQUID | CHAR | 10 | ALPHA | /MRSS/RSG_REQUID | |||
/MRSS/PROF_GUID | Character field, length 32 | CHAR32 | CHAR | 32 | CHAR32 | ||||
/MRSS/ACT_TYPE | Process variant | /MRSS/T_ACTIVITY_TYPE | CHAR | 1 | /MRSS/_ACTIVITY_TYPE | ||||
/MRSS/ORDER_PROB | Order probability in percent | /MRSS/T_ORDER_PROB | CHAR | 3 | OPROB | /MRSS/_ORDER_PROB | |||
/MRSS/INIT_DONE | Internal initialization carried out once | /MRSS/T_INIT_DONE | CHAR | 1 | FLAG | ||||
/MRSS/DATACHANGE | Data was changed in the controls on the user screen | /MRSS/T_USCREENCTL_DATACHANGED | CHAR | 1 | FLAG | ||||
/MRSS/DEM_COUNT | Counter for Demands in Operation | /MRSS/T_DEM_COUNT | NUMC | 4 | NUMC4 | ||||
/MRSS/SUPERV_CNT | Number of Site Supervisors | /MRSS/T_RAP_SUPERVISOR_COUNT | CHAR | 2 | ALPHA | /MRSS/_RAP_SUPERVISOR_COUNT | |||
/MRSS/RULE_ID | Time Rule Id | /MRSS/T_RSG_TIME_RULE_ID | CHAR | 25 | TEXT25 | ||||
/MRSS/SALES_ORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
/MRSS/REFF_RCNT | Determination of Remaining Demand: No. of Resources | /MRSS/T_REM_EFFORT_RES_COUNT | NUMC | 3 | NUMC3 | ||||
/MRSS/REFF_E_BEG | Time stamp: start | /MRSS/T_TIMESTAMP_BEGIN | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/REFF_E_END | Time stamp: end | /MRSS/T_TIMESTAMP_END | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/REFF_L_BEG | Time stamp: start | /MRSS/T_TIMESTAMP_BEGIN | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/REFF_L_END | Time stamp: end | /MRSS/T_TIMESTAMP_END | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/RELEVANT | Operation Set as MRS-Relevant | /MRSS/T_RELEVANT_FOR_MRS | CHAR | 1 | FLAG | ||||
/MRSS/TEAM_PLAN | Team Planning flag for Demand | /MRSS/T_RSG_TEAM_PLANNING | CHAR | 1 | /MRSS/_RSG_TEAM_PLANNING | ||||
/MRSS/SINGL_RES | Indicator for Forcing a Single Resource | /MRSS/T_RSG_FORCE_SINGLE_RES | CHAR | 1 | /MRSS/_BOOLEAN | ||||
/MRSS/TO_BEGDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/TO_BEGTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/TO_ENDDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/TO_ENDTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/TO_DURAT | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
/MRSS/TO_DUNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
/MRSS/TO_DISTAN | 19 Characters | CHAR19 | CHAR | 19 | CHAR19 | ||||
/MRSS/TO_MANUAL | Boolean Variable | /MRSS/T_RSG_BOOLEAN | CHAR | 1 | /MRSS/_RSG_BOOLEAN | ||||
/MRSS/FR_BEGDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/FR_BEGTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/FR_ENDDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/FR_ENDTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/FR_DURAT | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
/MRSS/FR_DUNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
/MRSS/FR_DISTAN | 19 Characters | CHAR19 | CHAR | 19 | CHAR19 | ||||
/MRSS/FR_MANUAL | Boolean Variable | /MRSS/T_RSG_BOOLEAN | CHAR | 1 | /MRSS/_RSG_BOOLEAN |
Key field | Non-key field |
How do I retrieve data from SAP structure RECONST_ACT using ABAP code?
As RECONST_ACT 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 RECONST_ACT as there is no data to select.How to access SAP table RECONST_ACT
Within an ECC or HANA version of SAP you can also view further information about RECONST_ACT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects