ORDER_MAD SAP (Internal Order: Master Data) Structure details
Description: Internal Order: Master Data
Structure field list including key, data, relationships and ABAP select examples
ORDER_MAD 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_MAD TYPE ORDER_MAD.
The ORDER_MAD table consists of various fields, each holding specific information or linking keys about Internal Order: Master Data data available in SAP. These include ORDERID (Order Number), ORDER_TYPE (Order Type), ORDER_CATG (Order category), EXT_ORD_NO (External order number).. 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_MAD 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 |
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 | 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 | ||||
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 | ||||
.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_MAD using ABAP code?
As ORDER_MAD 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_MAD as there is no data to select.How to access SAP table ORDER_MAD
Within an ECC or HANA version of SAP you can also view further information about ORDER_MAD 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