ORDER_MASTER SAP (Internal Order: Master Data) Structure details
Description: Internal Order: Master Data
Structure field list including key, data, relationships and ABAP select examples
ORDER_MASTER 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 "Internal Order: Master Data" 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_ORDER_MASTER TYPE ORDER_MASTER.
The ORDER_MASTER table consists of various fields, each holding specific information or linking keys about Internal Order: Master Data data available in SAP. These include ACTION (Activity), ORDERID (Order Number), ORDER_TYPE (Order Type), ORDER_CATG (Order category).. 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 ORDER_MASTER 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 |
ACTION | Activity | ACTIV_AUTH | CHAR | 2 | Assigned to domain | ACTIV_AUTH | |||
ORDERID | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
ORDER_TYPE | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
ORDER_CATG | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
EXT_ORD_NO | External order number | AUFEX | CHAR | 20 | ALPHA | AUFEX | |||
SHORT_TEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
ENTERED_BY | Entered by | AUFERFNAM | CHAR | 12 | USNAM | ||||
ENTER_DATE | Created on | AUFERFDAT | DATS | 8 | DATUM | ||||
ENTER_TIME | Time created | CO_INS_TIME | TIMS | 6 | UZEIT | ||||
CHANGED_BY | Last changed by | AUFAENAM | CHAR | 12 | USNAM | ||||
CHANGE_DATE | Change date for Order Master | AUFAEDAT | DATS | 8 | DATUM | ||||
CHANGE_TIME | Changed at | CO_CHG_TIME | TIMS | 6 | UZEIT | ||||
REFERENCE_ORDER | Reference order number | AUFREFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANV | |
CO_AREA | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
COMP_CODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUS_AREA | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PLANT | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PROFIT_CTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
RESPCCTR | Responsible cost center | AUFKOSTV | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
LOCATION | Location | AUFSTORT | CHAR | 10 | T499S | AP_STAND | |||
LOCATION_PLANT | Location plant | AUFSOWRK | CHAR | 4 | T001W | WERKS | |||
WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
REQUEST_CCTR | Requesting cost center | PS_AKSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
REQUEST_COMP_CODE | Requesting company code | IM_ABUKRS | CHAR | 4 | T001 | BUKRS | BUK | ||
SALES_ORD | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
S_ORD_ITEM | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
PLANINTEGRATED | Indicator for Integrated Planning | PLINT | CHAR | 1 | XFELD | ||||
STATISTICAL | Identifier for statistical order | AUFSTKZ | CHAR | 1 | XFELD | ||||
CCTR_POSTED | Cost center to which costs are actually posted | ST_KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
REVENUES | Identifier 'Revenue posting allowed' | ERLOESE | CHAR | 1 | ERLOESE | ||||
PLAN_WITH_LINE_ITEMS | Identifier for planning with line items | PLGKZ | CHAR | 1 | XFELD | ||||
CURRENCY | Order Currency | AUFWAERS | CUKY | 5 | TCURC | WAERS | |||
ISO_CODE | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
RES_ANAL_KEY | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | ABGR_SCHL | ACS | ||
CSTG_SHEET | Costing Sheet | AUFKALSM | CHAR | 6 | T683 | KALSM | |||
OVERHEAD_KEY | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
INTEREST_PROF | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | CHAR | 7 | TPI01 | PS_ZSCHM | |||
APPLICANT | Applicant | AUFUSER0 | CHAR | 20 | AUFUSER0 | ||||
APPLICANT_PHONE | Applicant's telephone number | AUFUSER1 | CHAR | 20 | AUFUSER1 | ||||
PERSON_RESP | Person responsible | AUFUSER2 | CHAR | 20 | AUFUSER2 | ||||
PERSON_RESP_PHONE | Telephone number of person in charge | AUFUSER3 | CHAR | 20 | AUFUSER3 | ||||
ESTIMATED_COSTS | Estimated Overall Costs of the Order for BAPIs | AUFUSER4BAPI | DEC | 23(4) | BAPICURR | ||||
APPLICATION_DATE | Application Date | AUFUSER5 | DATS | 8 | AUFUSER5 | ||||
DEPARTMENT | Department | AUFUSER6 | CHAR | 15 | AUFUSER6 | ||||
DATE_WORK_BEGINS | Work Start | AUFUSER7 | DATS | 8 | AUFUSER7 | ||||
DATE_WORK_ENDS | End of Work | AUFUSER8 | DATS | 8 | AUFUSER8 | ||||
WORK_PERMIT | Identifier for work permit issued | AUFUSER9 | CHAR | 1 | AUFUSER9 | ||||
PROCESSING_GROUP | Processing group | AUFABKRS | NUMC | 2 | TKO08 | AKREIS | AKR | ||
INVEST_PROFILE | Investment measure profile | IM_PROFIL | CHAR | 6 | TAPRF | IM_PROFIL | |||
SCALE | Scale of investment objects | IM_SIZECL | CHAR | 2 | TAIF5 | ALPHA | SIZECL | ||
INV_REASON | Reason for investment | IZWEK | CHAR | 2 | T087I | IZWEK | |||
ENVIR_INVEST | Reason for environmental investment | AM_UMWKZ | CHAR | 5 | T087K | AM_UMWKZ | |||
ORDER_STATUS | Order status | AUFASTNR | NUMC | 2 | TKO03 | AUFSTNR | |||
LAST_STAT_CHANGE | Date of last status change | AUFSTDAT | DATS | 8 | DATUM | ||||
REACHED_STATUS | Status reached so far | AUFESTNR | NUMC | 2 | TKO03 | AUFSTNR | |||
PHASE_CREATE | Phase 'Order created' | AUFPHAS0 | CHAR | 1 | XFELD | ||||
PHASE_RELEASE | Phase 'Order released' | AUFPHAS1 | CHAR | 1 | XFELD | ||||
PHASE_COMPLETION | Phase 'order completed' | AUFPHAS2 | CHAR | 1 | XFELD | ||||
PHASE_CLOSE | Phase 'order closed' | AUFPHAS3 | CHAR | 1 | XFELD | ||||
PLN_RELEASE | Planned release date | AUFPDAT1 | DATS | 8 | DATUM | ||||
PLN_COMPLETION | Planned completion date | AUFPDAT2 | DATS | 8 | DATUM | ||||
PLN_CLOSE | Planned closing date | AUFPDAT3 | DATS | 8 | DATUM | ||||
DATE_RELEASE | Release date | AUFIDAT1 | DATS | 8 | DATUM | ||||
DATE_COMPLETION | Technical completion date | AUFIDAT2 | DATS | 8 | DATUM | ||||
DATE_CLOSE | Close date | AUFIDAT3 | DATS | 8 | DATUM | ||||
DISALLOWED_T_GRP | Group of disallowed transactions | AUFSPSET | CHAR | 4 | TKAVG | VOGRP | |||
DELETION_FLAG | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
OBJECTCLASS | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
JOINT_VENTURE | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
RECOVERY_IND | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
EQUITY_TYPE | Equity type | JV_ETYPE | CHAR | 3 | T8JE | ALPHA | JV_ETYPE | ||
JV_OBJECT_TYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | ALPHA | JV_OTYPE | |||
JV_JIB_CLASS | JIB/JIBE Class | JV_JIBCL | CHAR | 3 | T8J6A | JV_JIBCL | JIB | ||
JV_JIB_SUB_CLASS_A | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 5 | T8J6C | JV_JIBSA | JBS | ||
JV_ORIG_COST_OBJ | JV original cost object | JV_OR_CO | CHAR | 1 | JV_OR_COB | ||||
REQUEST_ORDER | Requesting order | AUFANFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
FUNC_AREA | Functional Area | FKBER_SHORT | CHAR | 4 | Assigned to domain | FKBER_SHORT | FBE | ||
FUNC_AREA_LONG | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
IN_CHARGE_USER | Person Responsible for CO Internal Order | VERAA_USER | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
DUMMY_CI_AUFK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
FLG_OBLIGO | Commitments Management Active | CO_OBLIGOX | CHAR | 1 | XFELD | ||||
OBJNBR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
SYST_STATUS | Text (100 characters) | TEXT100 | CHAR | 100 | TEXT100 | ||||
USER_STATUS | Text (100 characters) | TEXT100 | CHAR | 100 | TEXT100 | ||||
STATUS_NBR | Status Order Number | J_STONR | NUMC | 2 | J_STONR | ||||
VARIANCE_KEY | Variance Key | AWSLS | CHAR | 6 | Assigned to domain | AWSLS | |||
VARIANCE_KEY_TXT | Name | AWTXT | CHAR | 40 | TEXT40 | ||||
MATERIAL_NO | Material Number for Order | CO_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
VALUAT_TYPE | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
BATCH | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
DELIVERY_DATE | Actual delivery/finish date | CO_LTRMI | DATS | 8 | DATUM | ||||
FLG_OLD_STATUS_MGMT | Indicator 'Order status management active' | SVALT_D | CHAR | 1 | XFELD | ||||
OLD_ORDER_STATUS | Order status | AUFASTNR | NUMC | 2 | Assigned to domain | AUFSTNR | |||
OLD_REACHED_STATUS | Status reached so far | AUFESTNR | NUMC | 2 | Assigned to domain | AUFSTNR | |||
LOWEST_ORDER_STATUS | Lowest order status | AUFNSTNR | NUMC | 2 | Assigned to domain | AUFSTNR | |||
HIGHEST_ORDER_STATUS | Highest order status | AUFHSTNR | NUMC | 2 | Assigned to domain | AUFSTNR | |||
LOWEST_ORDER_STATUS_TXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
HIGHEST_ORDER_STATUS_TXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
BALANCE_ORDER_CURR | Order balance in order currency | O_SALDO | CURR | 15(2) | WERTV8 | ||||
BALANCE_CO_AREA_CURR | Order balance in controlling-area currency | K_SALDO | CURR | 15(2) | WERTV8 | ||||
ORDER_CURRENCY | Order Currency | AUFWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
CO_AREA_CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
ORDER_TYPE_TXT | Short Text | AUARTTEXT | CHAR | 40 | TEXT40 | ||||
CO_AREA_TXT | Name of the controlling area | BEZEI | CHAR | 25 | TEXT25 | ||||
TAXJURCODE_TXT | Description | TEXT1_TXJT | CHAR | 50 | TEXT50 | ||||
BUS_AREA_TXT | Business area description | GTEXT | CHAR | 30 | TEXT30 | ||||
COMP_CODE_TXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
PLANT_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
FUNC_AREA_TXT | Name of the functional area | FKBTX | CHAR | 25 | TEXT25 | ||||
OBJECTCLASS_TXT | Short Text for Fixed Values | VAL_TEXT | CHAR | 60 | DDTEXT | ||||
PROFIT_CTR_TXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
RESPCCTR_TXT | Description | KLTXT | CHAR | 40 | TEXT40 | ||||
REQUEST_CCTR_TXT | Description | KLTXT | CHAR | 40 | TEXT40 | ||||
WBS_ELEMENT_TXT | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | TEXT40 | ||||
REQUEST_COMP_CODE_TXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
REQUEST_ORDER_TXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
LOCATION_TXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
LOCATION_PLANT_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
S_ORD_ITEM_TXT | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
RES_ANAL_KEY_TXT | Character Field for Text Table | KKATEXT | CHAR | 40 | KKATEXT | ||||
CSTG_SHEET_TXT | Description | VTXTM | CHAR | 30 | TEXT30 | ||||
OVERHEAD_KEY_TXT | Description | BEZEI30 | CHAR | 30 | TEXT30 | ||||
INTEREST_PROF_TXT | Name of Interest Calc.Profile | PS_ZSCHT | CHAR | 50 | TXT50 | ||||
ORDER_STATUS_TXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
DISALLOWED_T_GRP_TXT | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
CURRENCY_TXT | Long Text | LTEXT | CHAR | 40 | TEXT40 | ||||
CCTR_POSTED_TXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
ORDER_CATG_TXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
LOGSYSTEM_TXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
INVEST_PROFILE_TXT | Name of capital investment profile | IM_INVTXT | CHAR | 50 | TEXT50 | ||||
SCALE_TXT | Description of scale | IMA_SZTXT | CHAR | 50 | TEXT50 | ||||
INV_REASON_TXT | Text | TXT50 | CHAR | 50 | TEXT50 | ||||
ENVIR_INVEST_TXT | Text | TXT50 | CHAR | 50 | TEXT50 | ||||
PROCESSING_GROUP_TXT | Text of length 40 with descriptive text | TEXT40T | CHAR | 40 | TEXT40 | ||||
REACHED_STATUS_TXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
IN_CHARGE_USER_TXT | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
INVESTM_PROG | Investment program name | IM_PRNAM | CHAR | 8 | Assigned to domain | IM_PRNAM | IMT | ||
INV_PROG_POS | Identification for an investment program position | IM_POSID | CHAR | 24 | POSID | IM_POSID | IMP | ||
APPROVAL_YR | Approval year of the investment program | IM_GNJHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
INVESTM_TXT1 | Short description | IM_POST1 | CHAR | 40 | TEXT40 | ||||
INVESTM_TXT2 | Short description | IM_POST1 | CHAR | 40 | TEXT40 | ||||
APROP_REQ_NR | Internal number for appropriation request | IMA_POSNR | CHAR | 12 | Assigned to domain | REQNR | IMA_POSNR | IAF | IIMA |
APROP_REQ_TXT | Description of appropriation request | IMA_TXT50 | CHAR | 50 | TEXT50 | ||||
ASSET_CLASS | Asset Class | ANLKL | CHAR | 8 | Assigned to domain | ALPHA | ANLKL | ANK | SH_ANLKA |
CAPITALIZ_DATE | Planned capitalization date | AM_AKTIVP | DATS | 8 | DATUM | ||||
ASSET_CLASS_TXT | Short Text for Asset Class Name | TXT20_ANKT | CHAR | 20 | TEXT20 | ||||
.INCLU--AP | 0 | ||||||||
/MRSS/PL_STRU_ID | Resource planning nodes | /MRSS/T_PLAN_STRUCT_ID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
/MRSS/PL_MAN_TYP | Assignment to resource planner or contact person | /MRSS/T_MANAGER_TYPE | CHAR | 1 | /MRSS/_MANAGER_TYPE | ||||
/MRSS/ORDER_PROB | Order probability in percent | /MRSS/T_ORDER_PROB | CHAR | 3 | OPROB | /MRSS/_ORDER_PROB | |||
/MRSS/ACT_TYPE | Process variant | /MRSS/T_ACTIVITY_TYPE | CHAR | 1 | /MRSS/_ACTIVITY_TYPE | ||||
/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/SALES_ORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
/MRSS/NW_BOOKED | Network Set to 'Booked' | /MRSS/T_NW_BOOKED | CHAR | 1 | FLAG |
Key field | Non-key field |
How do I retrieve data from SAP structure ORDER_MASTER using ABAP code?
As ORDER_MASTER 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 ORDER_MASTER as there is no data to select.How to access SAP table ORDER_MASTER
Within an ECC or HANA version of SAP you can also view further information about ORDER_MASTER 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