HBSACTVEXP SAP (Extend BAPI_NETWORK_ACTIVITY_EXP to include work info) Structure details
Description: Extend BAPI_NETWORK_ACTIVITY_EXP to include work info
Structure field list including key, data, relationships and ABAP select examples
HBSACTVEXP 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 "Extend BAPI_NETWORK_ACTIVITY_EXP to include work info" 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_HBSACTVEXP TYPE HBSACTVEXP.
The HBSACTVEXP table consists of various fields, each holding specific information or linking keys about Extend BAPI_NETWORK_ACTIVITY_EXP to include work info data available in SAP. These include NETWORK (Network number), ACTIVITY (Activity number in network and standard network), CONTROL_KEY (Control key), WORK_CNTR (Work 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 HBSACTVEXP 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 |
NETWORK | Network number | NW_AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
ACTIVITY | Activity number in network and standard network | CN_VORNR | CHAR | 4 | NUMCV | VORNR | |||
CONTROL_KEY | Control key | STEUS | CHAR | 4 | T430 | STEUS | |||
WORK_CNTR | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
PLANT | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
DESCRIPTION | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
VENDOR_NO | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
PRICE | Price | PREIS | CURR | 11(2) | WERT11 | ||||
PRICE_UNIT | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
COST_ELEM | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
CURRENCY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
CURRENCY_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
INFO_REC | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
PURCH_ORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
PUR_GROUP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
MATL_GROUP | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
FLEXIBLE_DURATION | Indicator: flexible duration | DAUDEHN | CHAR | 1 | X | ||||
NUMBER_OF_CAPACITIES | Number of capacities required | ANZKAP | INT1 | 3 | INT1 | ||||
PERCENT_OF_WORK | Work percentage | APROZENT | INT1 | 3 | INT1 | ||||
MILESTONE | Usage | MILESTONE | CHAR | 5 | T433 | MILESTONE | |||
ACTTYPE | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
ACTIVITY_COSTS | Costs in the activity | PRKST | CURR | 11(2) | PRKST | ||||
PROJECT_DEFINITION | Project Definition | PS_PSPID | CHAR | 24 | ABPSN | PS_PSPID | PSP | PD_DUMMY | |
WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
FACTORY_CALENDAR | Factory Calendar | WFCID | CHAR | 2 | TFACD | WFCID | FCI | ||
DISTRIBUTING_KEY | Distr.cap.reqmts (plant maint.,process order, network) | CR_VERTN | CHAR | 8 | TC29 | CR_VERTL | |||
PRIORITY | Priority | NW_PRIO | CHAR | 1 | TCN07 | NW_PRIO | |||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
OBJECTCLASS | Object class (language-independent) | SCOPE | CHAR | 2 | SCOPE | ||||
PROFIT_CTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
NOT_MRP_APPLICABLE | Ind: Reserv. not applicable to MRP;Purc. req. not created | NODISP | CHAR | 1 | XFELD | ||||
PROJECT_SUMMARIZATION | Ind.: Take Activity Into Account for Project Summarization | CLASF | CHAR | 1 | XFELD | ||||
OPERATION_MEASURE_UNIT | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | T006 | CUNIT | MEINS | ||
OPERATION_MEASURE_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | T006I | ISOCD_UNIT | |||
PLND_DELRY | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
DURATION_NORMAL | Normal duration of the activity | DAUNOR | QUAN | 5(1) | DAUER_4_1 | ||||
DURATION_NORMAL_UNIT | Normal duration/unit | DAUNORE | UNIT | 3 | T006 | CUNIT | MEINS | ||
DURATION_NORMAL_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | T006I | ISOCD_UNIT | |||
DURATION_MINIMUM | Minimum activity duration | DAUMIN | QUAN | 5(1) | DAUER_4_1 | ||||
DURATION_MINIMUM_UNIT | Unit for the minimum duration | DAUMINE | UNIT | 3 | T006 | CUNIT | MEINS | ||
DURATION_MINIMUM_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | T006I | ISOCD_UNIT | |||
CONSTRAINT_TYPE_START | Constraint on the basic start date for the activity | EINSCHRA | CHAR | 1 | RESTRIKSTR | ||||
CONSTRAINT_TYPE_FINISH | Constraint on the finish date of the activity | EINSCHRE | CHAR | 1 | RESTRIKEND | ||||
WORK_ACTIVITY | Work involved in the activity | ARBEIT | QUAN | 7(1) | ARBEIT | ||||
UN_WORK | Unit for work | ARBEITE | UNIT | 3 | T006 | CUNIT | MEINS | ||
UN_WORK_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | T006I | ISOCD_UNIT | |||
EARLY_START_DATE | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
EARLY_START_TIME | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 6 | ATIME | ||||
EARLY_FINISH_DATE | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
EARLY_FINISH_TIME | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 6 | ATIME | ||||
LATEST_START_DATE | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
LATEST_START_TIME | Latest scheduled start: Execution (time) | SSAVZ | TIMS | 6 | ATIME | ||||
LATEST_FINISH_DATE | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
LATEST_FINISH_TIME | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
FLOAT_FREE | Free float | PUFFR_FREI | DEC | 3 | PUFFER | ||||
FLOAT_TOTAL | Total float | PUFFR_GESM | DEC | 3 | PUFFER | ||||
CONSTRAINT_START_DATE | Constraint for activity start (Basic) | VORGABESTD | DATS | 8 | VORGABESTR | ||||
CONSTRAINT_START_TIME | Constraint for activity start time (Basic) | VORGABESTZ | TIMS | 6 | ATIME | ||||
CONSTRAINT_FINISH_DATE | Constraint for finish of activity (Basic) | VORGABEEND | DATS | 8 | VORGABEEND | ||||
CONSTRAINT_FINISH_TIME | Basic finish time of the activity | VORGABEENZ | TIMS | 6 | ATIME | ||||
USER_FIELD_KEY | Key word ID for user-defined fields | SLWID | CHAR | 7 | TCN00 | SLWID | |||
USER_FIELD_CHAR20_1 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USER_FIELD_CHAR20_2 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USER_FIELD_CHAR10_1 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USER_FIELD_CHAR10_2 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USER_FIELD_QUAN1 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USER_FIELD_UNIT1 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USER_FIELD_UNIT1_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
USER_FIELD_QUAN2 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USER_FIELD_UNIT2 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USER_FIELD_UNIT2_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | T006I | ISOCD_UNIT | |||
USER_FIELD_CURR1 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USER_FIELD_CUKY1 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USER_FIELD_CUKY1_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
USER_FIELD_CURR2 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USER_FIELD_CUKY2 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USER_FIELD_CUKY2_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
USER_FIELD_DATE1 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USER_FIELD_DATE2 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USER_FIELD_FLAG1 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
USER_FIELD_FLAG2 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
DURATION_NORMAL_FC | Normal duration (from forecast) of activity | EWDAN | QUAN | 5(1) | DAUER_4_1 | ||||
DURATION_NORMAL_FC_UNIT | Unit for forecast normal duration | EWDNE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DURATION_NORMAL_FC_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
DURATION_MINIMUM_FC | Minimum duration (from forecast) for activity | EWDAM | QUAN | 5(1) | DAUER_4_1 | ||||
DURATION_MINIMUM_FC_UNIT | Unit for forecast minimum duration | EWDME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DURATION_MINIMUM_FC_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
CONSTRAINT_TYPE_FINISH_FC | Forecast date constraint on activity finish | PS_RESTE | CHAR | 1 | RESTRIKEND | ||||
CONSTRAINT_TYPE_START_FC | Forecast date constraint on activity start | PS_RESTA | CHAR | 1 | RESTRIKSTR | ||||
CONSTRAINT_START_DATE_FC | Forecasted start date for the activity | EWSTARTD | DATS | 8 | DATUM | ||||
CONSTRAINT_START_TIME_FC | Forecast start time of the activity | EWSTARTZ | TIMS | 6 | ATIME | ||||
CONSTRAINT_FINISH_DATE_FC | Forecast finish date | EWENDED | DATS | 8 | DATUM | ||||
CONSTRAINT_FINISH_TIME_FC | Forecast finish time for the activity | EWENDEZ | TIMS | 6 | ATIME | ||||
EARLY_START_DATE_FC | Earliest scheduled start date (forecast) | FPAVD | DATS | 8 | DATUM | ||||
EARLY_START_TIME_FC | Earliest scheduled start time (forecast) | FPAVZ | TIMS | 6 | ATIME | ||||
EARLY_FINISH_DATE_FC | Earliest scheduled finish date (forecast) | FPEDD | DATS | 8 | DATUM | ||||
EARLY_FINISH_TIME_FC | Earliest scheduled finish time (forecast) | FPEDZ | TIMS | 6 | ATIME | ||||
LATEST_START_DATE_FC | Latest scheduled start date (forecast) | SPAVD | DATS | 8 | DATUM | ||||
LATEST_START_TIME_FC | Latest scheduled start time (forecast) | SPAVZ | TIMS | 6 | ATIME | ||||
LATEST_FINISH_DATE_FC | Latest scheduled finish date (forecast) | SPEDD | DATS | 8 | DATUM | ||||
LATEST_FINISH_TIME_FC | Latest scheduled finish time (forecast) | SPEDZ | TIMS | 6 | ATIME | ||||
FLOAT_FREE_FC | Free float (from forecast) | PPUFF_FREI | DEC | 3 | PUFFER | ||||
FLOAT_TOTAL_FC | Total float (from forecast) | PPUFF_GESM | DEC | 3 | PUFFER | ||||
OBJECTCLASS_EXT | Object class, language-dependent | SCOPE_LD | CHAR | 5 | CHAR5 | ||||
FUNC_AREA | Functional Area | FKBER_SHORT | CHAR | 4 | FKBER_SHORT | FBE | |||
FUNC_AREA_LONG | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
REFERENCE_POINT | Reference point for BOM transfer | RFPNT | CHAR | 20 | RFPNT | ||||
WORK_ACTUAL | Actual work | CO_ISMNW | QUAN | 13(3) | MENG13 | ||||
WORK_FORECAST | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT |
Key field | Non-key field |
How do I retrieve data from SAP structure HBSACTVEXP using ABAP code?
As HBSACTVEXP 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 HBSACTVEXP as there is no data to select.How to access SAP table HBSACTVEXP
Within an ECC or HANA version of SAP you can also view further information about HBSACTVEXP 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