CNMASS_ACTIVITY_ELEMENT SAP (Mass change activity element) Structure details
Description: Mass change activity element
Related tables to CNMASS_ACTIVITY_ELEMENT
Access table CNMASS_ACTIVITY_ELEMENT
Structure field list including key, data, relationships and ABAP select examples
CNMASS_ACTIVITY_ELEMENT 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 "Mass change activity element" 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_CNMASS_ACTIVITY_ELEMENT TYPE CNMASS_ACTIVITY_ELEMENT.
The CNMASS_ACTIVITY_ELEMENT table consists of various fields, each holding specific information or linking keys about Mass change activity element data available in SAP. These include ACTIVITY (Activity number in network and standard network), ELEMENT (Activity element number (work/external/general costs)), 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 CNMASS_ACTIVITY_ELEMENT 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 | |||
ELEMENT | Activity element number (work/external/general costs) | CN_ELEMENT | 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 | |
NUMBER_OF_CAPACITIES | Number of capacities required | ANZKAP | INT1 | 3 | INT1 | ||||
PERCENT_OF_WORK | Work percentage | APROZENT | INT1 | 3 | INT1 | ||||
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 | ||
DISTRIBUTING_KEY | Distr.cap.reqmts (plant maint.,process order, network) | CR_VERTN | CHAR | 8 | TC29 | CR_VERTL | |||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
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 | ||||
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 | ||||
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 | T006I | 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 | ||||
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 | ||||
OBJECTCLASS_EXT | Object class, language-dependent | SCOPE_LD | CHAR | 5 | CHAR5 | ||||
OFFSET_START | Offset to start of production resource/tool usage | OFFSTB | QUAN | 5 | VNZTV | ||||
OFFSET_START_UNIT | Unit for offset to start | CP_OEHOFFB | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFFSET_START_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
OFFSET_END | Offset to sub-operation finish | CP_OOFFSTE | QUAN | 5 | VNZTV | ||||
OFFSET_END_UNIT | Unit for offset to finish | CP_OEHOFFE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFFSET_END_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
FUNC_AREA | Functional Area | FKBER_SHORT | CHAR | 4 | FKBER_SHORT | FBE | |||
FUNC_AREA_LONG | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
PERS_NO | Personnel number | CO_PERNR | NUMC | 8 | PERNR | PER | |||
RELEASE | Indicator: Object is being or has been released | PS_RELEASE | CHAR | 1 | XFELD | ||||
TECH_COMPLETE | Indicator: Object is being or has been technically completed | PS_TECH_COMPLETE | CHAR | 1 | XFELD | ||||
DELETE | Indicator: Deletion flag has been set | PS_DELETE | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure CNMASS_ACTIVITY_ELEMENT using ABAP code?
As CNMASS_ACTIVITY_ELEMENT 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 CNMASS_ACTIVITY_ELEMENT as there is no data to select.How to access SAP table CNMASS_ACTIVITY_ELEMENT
Within an ECC or HANA version of SAP you can also view further information about CNMASS_ACTIVITY_ELEMENT 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