MAM_30_ORDER_OPERATION SAP (Order Operation) Structure details
Description: Order Operation
Related tables to MAM_30_ORDER_OPERATION
Access table MAM_30_ORDER_OPERATION
Structure field list including key, data, relationships and ABAP select examples
MAM_30_ORDER_OPERATION 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 Operation" 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_MAM_30_ORDER_OPERATION TYPE MAM_30_ORDER_OPERATION.
The MAM_30_ORDER_OPERATION table consists of various fields, each holding specific information or linking keys about Order Operation data available in SAP. These include SUB_ACTIVITY (Suboperation), CONTROL_KEY (Control key), WORK_CNTR (Work center), PLANT (Plant).. 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: Cannot Be Enhanced
SAP MAM_30_ORDER_OPERATION 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 |
ACTIVITY | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
SUB_ACTIVITY | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
CONTROL_KEY | Control key | STEUS | CHAR | 4 | Assigned to domain | STEUS | |||
WORK_CNTR | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
STANDARD_TEXT_KEY | Standard text key | KTSCH | CHAR | 7 | Assigned to domain | KTSCH | |||
DESCRIPTION | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
LANGU | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | LAISO | ||||
NO_OF_TIME_TICKETS | Number of Time Tickets | LOHNANZ | DEC | 3 | LOHNANZ | ||||
WAGETYPE | Wage Type | LOHNART | CHAR | 4 | LOART | ||||
SUITABILITY | Suitability | QUALF | CHAR | 2 | Assigned to domain | QUALF | |||
WAGEGROUP | Wage group | LOHNGRP | CHAR | 3 | Assigned to domain | LOHNGRP | |||
SORT_FLD | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
VENDOR_NO | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
QUANTITY | Operation quantity in order unit of measure | CX_LOSVG | QUAN | 13(3) | MENG13 | ||||
BASE_UOM | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BASE_UOM_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
PRICE | Price | PREIS | CURR | 11(2) | WERT11 | ||||
PRICE_UNIT | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
COST_ELEMENT | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CURRENCY_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
INFO_REC | Number of Purchasing Info Record | INFNR | CHAR | 10 | Assigned to domain | ALPHA | INFNR | INF | MEIN_C |
PURCH_ORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
PUR_GROUP | Purchasing group for external processing | VG_EKGRP | CHAR | 3 | Assigned to domain | EKGRP | |||
MATL_GROUP | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
AGREEMENT | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
AGMT_ITEM | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
PREQ_NAME | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
TRACKINGNO | Requirement Tracking Number | BEDNR | CHAR | 10 | CHAR10 | ||||
NUMBER_OF_CAPACITIES | Number of capacities required | ANZKAP | INT1 | 3 | INT1 | ||||
PERCENT_OF_WORK | Work percentage | APROZENT | INT1 | 3 | INT1 | ||||
CALC_KEY | Key for calculation | INDET | CHAR | 1 | INDET | ||||
ACTTYPE | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
SYSTCOND | Syst.Condition | ANLZU | CHAR | 1 | Assigned to domain | ANLZU | |||
ASSEMBLY | Assembly | ISTRU | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
INT_DISTR | Distr.cap.reqmts (plant maint.,process order, network) | CR_VERTN | CHAR | 8 | Assigned to domain | CR_VERTL | |||
GR_RCPT | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | WEMPF | ||||
UNLOAD_PT | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
PERS_NO | Personnel number | CO_PERNR | NUMC | 8 | PERNR | PER | |||
FW_ORDER | Framework Order | SFORDN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
ORDER_ITEM | Item of framework order | FORDP | NUMC | 5 | Assigned to domain | EBELP | |||
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 | Assigned to domain | CUNIT | MEINS | ||
DURATION_NORMAL_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | 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 | Assigned to domain | CUNIT | MEINS | ||
UN_WORK_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
START_CONS | Constraint for activity start (Basic) | VORGABESTD | DATS | 8 | VORGABESTR | ||||
STRTTIMCON | Constraint for activity start time (Basic) | VORGABESTZ | TIMS | 6 | ATIME | ||||
FIN_CONSTR | Constraint for finish of activity (Basic) | VORGABEEND | DATS | 8 | VORGABEEND | ||||
FINTIMCONS | Basic finish time of the activity | VORGABEENZ | TIMS | 6 | ATIME | ||||
EXECFACTOR | Execution Factor | AFAKT | DEC | 3 | AFAKT | ||||
MRP_RELEVANT | Reservation Relevance/Generation of Purchase Requisition | AUDISP_PLUS | CHAR | 1 | AUDISP | ||||
FIELD_KEY | Key word ID for user-defined fields | SLWID | CHAR | 7 | Assigned to domain | SLWID | |||
USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE04 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USE04_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE05 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USE05_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
USR06 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE06 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
USE06_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
USR07 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE07 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
USE07_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
USR08 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR09 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
CONF_NO | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
PREQ_NO | Purchase requisition number | CO_BANFN | CHAR | 10 | ALPHA | BANFN | |||
PREQ_ITEM | Item number of the purchase requisition in the order | CO_BNFPO | NUMC | 5 | Assigned to domain | BNFPO | |||
COMPLETE | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1 | XFELD | ||||
WORK_ACTUAL | Actual work | CO_ISMNW | QUAN | 13(3) | MENG13 | ||||
EARL_SCHED_START_DATE | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
EARL_SCHED_START_TIME | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 6 | ATIME | ||||
EARL_SCHED_FIN_DATE | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
EARL_SCHED_FIN_TIME | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 6 | ATIME | ||||
LATE_SCHED_START_DATE | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
LATE_SCHED_START_TIME | Latest scheduled start: Execution (time) | SSAVZ | TIMS | 6 | ATIME | ||||
LATE_SCHED_FIN_DATE | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
LATE_SCHED_FIN_TIME | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
ACT_START_DATE | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
ACT_START_TIME | Actual start: Execution/setup (time) | ISDZ | TIMS | 6 | ATIME | ||||
ACT_END_DATE | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
ACT_END_TIME | Actual finish: Execution (time) | IEDZ | TIMS | 6 | ATIME | EZR | |||
FCST_FIN_DATE | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
FCST_FIN_TIME | Forecast finish time of operation from confirmation | CO_PEDZ | TIMS | 6 | ATIME | ||||
FREE_BUFFER | Free float | PUFFR_FREI | DEC | 3 | PUFFER | ||||
TOTAL_BUFFER | Total float | PUFFR_GESM | DEC | 3 | PUFFER | ||||
WORK_FORECAST | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT | ||||
SYSTEM_STATUS_TEXT | System Status | CO_STTXT | CHAR | 40 | CHAR40 | ||||
CHANGEABLE | General Flag | FLAG | CHAR | 1 | FLAG | ||||
XA_STAT_PROF | Status Profile | J_STSMA | CHAR | 8 | Assigned to domain | J_STSMA | |||
ADD_FLAG | Entry was made | ALM_ME_ADD_FLAG | CHAR | 1 | FLAG | ||||
ENHANCEMENT_FLAG | Enhancement for This Object Active | ALM_ME_ENHANCEMENT_FLAG | CHAR | 1 | CHAR01 |
Key field | Non-key field |
How do I retrieve data from SAP structure MAM_30_ORDER_OPERATION using ABAP code?
As MAM_30_ORDER_OPERATION 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 MAM_30_ORDER_OPERATION as there is no data to select.How to access SAP table MAM_30_ORDER_OPERATION
Within an ECC or HANA version of SAP you can also view further information about MAM_30_ORDER_OPERATION 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