1. Home
  2. Resources
  3. SAP Tables
  4. ORDER_MAD - Internal Order: Master Data

SAP Table ORDER_MAD

Internal Order: Master Data

ORDER_MAD (Internal Order: Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ORDER_MAD to other SAP tables.

ORDER_MAD table fields

Field Data element Checktable Datatype Length Decimals
ORDERID Order Number AUFNR CHAR 12 0
ORDER_TYPE Order Type AUFART T003O CHAR 4 0
ORDER_CATG Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
EXT_ORD_NO External order number AUFEX CHAR 20 0
SHORT_TEXT Description AUFTEXT CHAR 40 0
ENTERED_BY Entered by AUFERFNAM CHAR 12 0
ENTER_DATE Created on AUFERFDAT DATS 8 0
ENTER_TIME Time created CO_INS_TIME TIMS 6 0
CHANGED_BY Last changed by AUFAENAM CHAR 12 0
CHANGE_DATE Change date for Order Master AUFAEDAT DATS 8 0
CHANGE_TIME Changed at CO_CHG_TIME TIMS 6 0
REFERENCE_ORDER Reference order number AUFREFNR CHAR 12 0
CO_AREA Controlling Area KOKRS TKA01 CHAR 4 0
COMP_CODE Company Code BUKRS T001 CHAR 4 0
BUS_AREA Business Area GSBER TGSB CHAR 4 0
PLANT Plant WERKS_D T001W CHAR 4 0
PROFIT_CTR Profit Center PRCTR CEPC CHAR 10 0
RESPCCTR Responsible cost center AUFKOSTV CSKS CHAR 10 0
LOCATION Location AUFSTORT T499S CHAR 10 0
LOCATION_PLANT Location plant AUFSOWRK T001W CHAR 4 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
REQUEST_CCTR Requesting cost center PS_AKSTL CSKS CHAR 10 0
REQUEST_COMP_CODE Requesting company code IM_ABUKRS T001 CHAR 4 0
SALES_ORD Sales Order Number KDAUF VBUK CHAR 10 0
S_ORD_ITEM Item Number in Sales Order KDPOS NUMC 6 0
TAXJURCODE Tax Jurisdiction TXJCD TTXJ CHAR 15 0
PLANINTEGRATED Indicator for Integrated Planning PLINT CHAR 1 0
X Yes
NULL No
STATISTICAL Identifier for statistical order AUFSTKZ CHAR 1 0
X Yes
NULL No
CCTR_POSTED Cost center to which costs are actually posted ST_KOSTL CSKS CHAR 10 0
REVENUES Identifier "Revenue posting allowed" ERLOESE CHAR 1 0
NULL not allowed
X allowed
PLAN_WITH_LINE_ITEMS Identifier for planning with line items PLGKZ CHAR 1 0
X Yes
NULL No
CURRENCY Order Currency AUFWAERS TCURC CUKY 5 0
ISO_CODE ISO currency code ISOCD CHAR 3 0
RES_ANAL_KEY Results Analysis Key ABGR_SCHL TKKAA CHAR 6 0
CSTG_SHEET Costing Sheet AUFKALSM T683 CHAR 6 0
OVERHEAD_KEY Overhead key AUFZSCHL CHAR 6 0
INTEREST_PROF Interest Profile for Project/Order Interest Calculation PS_ZSCHM TPI01 CHAR 7 0
APPLICANT Applicant AUFUSER0 CHAR 20 0
APPLICANT_PHONE Applicant's telephone number AUFUSER1 CHAR 20 0
PERSON_RESP Person responsible AUFUSER2 CHAR 20 0
PERSON_RESP_PHONE Telephone number of person in charge AUFUSER3 CHAR 20 0
ESTIMATED_COSTS Estimated Overall Costs of the Order for BAPIs AUFUSER4BAPI DEC 23 4
APPLICATION_DATE Application Date AUFUSER5 DATS 8 0
DEPARTMENT Department AUFUSER6 CHAR 15 0
DATE_WORK_BEGINS Work Start AUFUSER7 DATS 8 0
DATE_WORK_ENDS End of Work AUFUSER8 DATS 8 0
WORK_PERMIT Identifier for work permit issued AUFUSER9 CHAR 1 0
X Work permit issued
NULL
PROCESSING_GROUP Processing group AUFABKRS TKO08 NUMC 2 0
INVEST_PROFILE Investment measure profile IM_PROFIL TAPRF CHAR 6 0
SCALE Scale of investment objects IM_SIZECL TAIF5 CHAR 2 0
INV_REASON Reason for investment IZWEK T087I CHAR 2 0
ENVIR_INVEST Reason for environmental investment AM_UMWKZ T087K CHAR 5 0
ORDER_STATUS Order status AUFASTNR TKO03 NUMC 2 0
LAST_STAT_CHANGE Date of last status change AUFSTDAT DATS 8 0
REACHED_STATUS Status reached so far AUFESTNR TKO03 NUMC 2 0
PHASE_CREATE Phase "Order created" AUFPHAS0 CHAR 1 0
X Yes
NULL No
PHASE_RELEASE Phase "Order released" AUFPHAS1 CHAR 1 0
X Yes
NULL No
PHASE_COMPLETION Phase "order completed" AUFPHAS2 CHAR 1 0
X Yes
NULL No
PHASE_CLOSE Phase "order closed" AUFPHAS3 CHAR 1 0
X Yes
NULL No
PLN_RELEASE Planned release date AUFPDAT1 DATS 8 0
PLN_COMPLETION Planned completion date AUFPDAT2 DATS 8 0
PLN_CLOSE Planned closing date AUFPDAT3 DATS 8 0
DATE_RELEASE Release date AUFIDAT1 DATS 8 0
DATE_COMPLETION Technical completion date AUFIDAT2 DATS 8 0
DATE_CLOSE Close date AUFIDAT3 DATS 8 0
DISALLOWED_T_GRP Group of disallowed transactions AUFSPSET TKAVG CHAR 4 0
DELETION_FLAG Deletion flag AUFLOEKZ CHAR 1 0
X Yes
NULL No
OBJECTCLASS Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
LOGSYSTEM Logical System LOGSYSTEM TBDLS CHAR 10 0
JOINT_VENTURE Joint Venture JV_NAME T8JV CHAR 6 0
RECOVERY_IND Recovery Indicator JV_RECIND T8JJ CHAR 2 0
EQUITY_TYPE Equity type JV_ETYPE T8JE CHAR 3 0
JV_OBJECT_TYPE Joint Venture Object Type JV_OTYPE CHAR 4 0
JV_JIB_CLASS JIB/JIBE Class JV_JIBCL T8J6A CHAR 3 0
JV_JIB_SUB_CLASS_A JIB/JIBE Subclass A JV_JIBSA T8J6C CHAR 5 0
JV_ORIG_COST_OBJ JV original cost object JV_OR_CO CHAR 1 0
P object type for projects
O object type for orders
C object type for costcenters
NULL object type for current object
REQUEST_ORDER Requesting order AUFANFNR CHAR 12 0
FUNC_AREA Functional Area FKBER_SHORT CHAR 4 0
FUNC_AREA_LONG Functional Area FKBER CHAR 16 0
IN_CHARGE_USER Person Responsible for CO Internal Order VERAA_USER CHAR 12 0
DUMMY_CI_AUFK Single-Character Indicator CHAR1 CHAR 1 0
TAXJURCODE_TXT Description TEXT1_TXJT CHAR 50 0
BUS_AREA_TXT Business area description GTEXT CHAR 30 0
COMP_CODE_TXT Name of Company Code or Company BUTXT CHAR 25 0
PLANT_TXT Name NAME1 CHAR 30 0
FUNC_AREA_TXT Name of the functional area FKBTX CHAR 25 0
OBJECTCLASS_TXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
PROFIT_CTR_TXT General Name KTEXT CHAR 20 0
RESPCCTR_TXT Description KLTXT CHAR 40 0
REQUEST_CCTR_TXT Description KLTXT CHAR 40 0
WBS_ELEMENT_TXT PS: Short description (1st text line) PS_POST1 CHAR 40 0
REQUEST_COMP_CODE_TXT Name of Company Code or Company BUTXT CHAR 25 0
REQUEST_ORDER_TXT Description AUFTEXT CHAR 40 0
LOCATION_TXT Text, 40 Characters Long TEXT40 CHAR 40 0
LOCATION_PLANT_TXT Name NAME1 CHAR 30 0
S_ORD_ITEM_TXT Short text for sales order item ARKTX CHAR 40 0
RES_ANAL_KEY_TXT Character Field for Text Table KKATEXT CHAR 40 0
CSTG_SHEET_TXT Description VTXTM CHAR 30 0
OVERHEAD_KEY_TXT Description BEZEI30 CHAR 30 0
INTEREST_PROF_TXT Name of Interest Calc.Profile PS_ZSCHT CHAR 50 0
ORDER_STATUS_TXT Text, 40 Characters Long TEXT40 CHAR 40 0
DISALLOWED_T_GRP_TXT Text, length 40 TXT40 CHAR 40 0
CURRENCY_TXT Long Text LTEXT CHAR 40 0
CCTR_POSTED_TXT General Name KTEXT CHAR 20 0
ORDER_CATG_TXT Text, 40 Characters Long TEXT40 CHAR 40 0
LOGSYSTEM_TXT Text, 40 Characters Long TEXT40 CHAR 40 0
INVEST_PROFILE_TXT Name of capital investment profile IM_INVTXT CHAR 50 0
SCALE_TXT Description of scale IMA_SZTXT CHAR 50 0
INV_REASON_TXT Text TXT50 CHAR 50 0
ENVIR_INVEST_TXT Text TXT50 CHAR 50 0
PROCESSING_GROUP_TXT Text of length 40 with descriptive text TEXT40T CHAR 40 0
/MRSS/PL_STRU_ID Resource planning nodes /MRSS/T_PLAN_STRUCT_ID NUMC 8 0
/MRSS/PL_MAN_TYP Assignment to resource planner or contact person /MRSS/T_MANAGER_TYPE CHAR 1 0
C Contact Person
R Resource Manager
/MRSS/ORDER_PROB Order probability in percent /MRSS/T_ORDER_PROB CHAR 3 0
/MRSS/ACT_TYPE Process variant /MRSS/T_ACTIVITY_TYPE CHAR 1 0
NULL Not Relevant to Resource Planning
1 Contact person process
2 Resource planner process
3 Background Resource Planning Process
/MRSS/INIT_DONE Internal initialization carried out once /MRSS/T_INIT_DONE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/DATACHANGE Data was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/SALES_ORG Sales Organization VKORG CHAR 4 0
/MRSS/NW_BOOKED Network Set to "Booked" /MRSS/T_NW_BOOKED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set

ORDER_MAD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ORDER_MAD BUS_AREA SY MANDT TGSB Business Areas MANDT
ORDER_MAD BUS_AREA ORDER_MAD BUS_AREA TGSB Business Areas GSBER
ORDER_MAD CCTR_POSTED SY MANDT CSKS Cost Center Master Data MANDT
ORDER_MAD CCTR_POSTED ORDER_MAD CO_AREA CSKS Cost Center Master Data KOKRS
ORDER_MAD CCTR_POSTED ORDER_MAD CCTR_POSTED CSKS Cost Center Master Data KOSTL
ORDER_MAD CCTR_POSTED * CSKS Cost Center Master Data DATBI
ORDER_MAD COMP_CODE SY MANDT T001 Company Codes MANDT
ORDER_MAD COMP_CODE ORDER_MAD COMP_CODE T001 Company Codes BUKRS
ORDER_MAD CO_AREA SY MANDT TKA01 Controlling Areas MANDT
ORDER_MAD CO_AREA ORDER_MAD CO_AREA TKA01 Controlling Areas KOKRS
ORDER_MAD CSTG_SHEET 'KA' T683 Pricing procedures KAPPL
ORDER_MAD CSTG_SHEET ORDER_MAD CSTG_SHEET T683 Pricing procedures KALSM
ORDER_MAD CSTG_SHEET SY MANDT T683 Pricing procedures MANDT
ORDER_MAD CSTG_SHEET 'A' T683 Pricing procedures KVEWE
ORDER_MAD CURRENCY SY MANDT TCURC Currency Codes MANDT
ORDER_MAD CURRENCY ORDER_MAD CURRENCY TCURC Currency Codes WAERS
ORDER_MAD DISALLOWED_T_GRP * TKAVG Transaction groups ACTIVITY
ORDER_MAD DISALLOWED_T_GRP SY MANDT TKAVG Transaction groups MANDT
ORDER_MAD DISALLOWED_T_GRP * TKAVG Transaction groups OBJID
ORDER_MAD DISALLOWED_T_GRP ORDER_MAD DISALLOWED_T_GRP TKAVG Transaction groups GRUPPE
ORDER_MAD ENVIR_INVEST SY MANDT T087K Reason for investment protecting the environment MANDT
ORDER_MAD ENVIR_INVEST ORDER_MAD ENVIR_INVEST T087K Reason for investment protecting the environment UMWKZ
ORDER_MAD EQUITY_TYPE ORDER_MAD EQUITY_TYPE T8JE Investment Type ETYPE
ORDER_MAD EQUITY_TYPE SY MANDT T8JE Investment Type MANDT
ORDER_MAD EQUITY_TYPE ORDER_MAD COMP_CODE T8JE Investment Type BUKRS
ORDER_MAD INTEREST_PROF SY MANDT TPI01 Interest Profile MANDT
ORDER_MAD INTEREST_PROF ORDER_MAD INTEREST_PROF TPI01 Interest Profile ZSCHM
ORDER_MAD INVEST_PROFILE ORDER_MAD INVEST_PROFILE TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
ORDER_MAD INVEST_PROFILE SY MANDT TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
ORDER_MAD INV_REASON SY MANDT T087I Reason for investment MANDT
ORDER_MAD INV_REASON ORDER_MAD INV_REASON T087I Reason for investment IZWEK
ORDER_MAD JOINT_VENTURE ORDER_MAD COMP_CODE T8JV Joint Venture BUKRS
ORDER_MAD JOINT_VENTURE ORDER_MAD JOINT_VENTURE T8JV Joint Venture VNAME
ORDER_MAD JOINT_VENTURE SY MANDT T8JV Joint Venture MANDT
ORDER_MAD JV_JIB_CLASS SY MANDT T8J6A JIB/JIBE Class MANDT
ORDER_MAD JV_JIB_CLASS ORDER_MAD COMP_CODE T8J6A JIB/JIBE Class BUKRS
ORDER_MAD JV_JIB_CLASS ORDER_MAD JV_JIB_CLASS T8J6A JIB/JIBE Class CLASS
ORDER_MAD JV_JIB_SUB_CLASS_A SY MANDT T8J6C JIB/JIBE Subclass MANDT
ORDER_MAD JV_JIB_SUB_CLASS_A ORDER_MAD COMP_CODE T8J6C JIB/JIBE Subclass BUKRS
ORDER_MAD JV_JIB_SUB_CLASS_A ORDER_MAD JV_JIB_CLASS T8J6C JIB/JIBE Subclass CLASS
ORDER_MAD JV_JIB_SUB_CLASS_A ORDER_MAD JV_JIB_SUB_CLASS_A T8J6C JIB/JIBE Subclass SUBCLASS
ORDER_MAD LOCATION SY MANDT T499S Location MANDT
ORDER_MAD LOCATION ORDER_MAD PLANT T499S Location WERKS
ORDER_MAD LOCATION ORDER_MAD LOCATION T499S Location STAND
ORDER_MAD LOCATION_PLANT SY MANDT T001W Plants/Branches MANDT
ORDER_MAD LOCATION_PLANT ORDER_MAD LOCATION_PLANT T001W Plants/Branches WERKS
ORDER_MAD LOGSYSTEM ORDER_MAD LOGSYSTEM TBDLS Logical system LOGSYS
ORDER_MAD ORDER_STATUS ORDER_MAD ORDER_STATUS TKO03 Order status ASTNR
ORDER_MAD ORDER_STATUS SY MANDT TKO03 Order status CLIENT
ORDER_MAD ORDER_STATUS ORDER_MAD ORDER_TYPE TKO03 Order status ART
ORDER_MAD ORDER_TYPE SY MANDT T003O Order Types CLIENT
ORDER_MAD ORDER_TYPE ORDER_MAD ORDER_TYPE T003O Order Types AUART
ORDER_MAD PLANT SY MANDT T001W Plants/Branches MANDT
ORDER_MAD PLANT ORDER_MAD PLANT T001W Plants/Branches WERKS
ORDER_MAD PROCESSING_GROUP ORDER_MAD PROCESSING_GROUP TKO08 Processing groups for orders ABKRS
ORDER_MAD PROCESSING_GROUP SY MANDT TKO08 Processing groups for orders CLIENT
ORDER_MAD PROCESSING_GROUP ORDER_MAD CO_AREA TKO08 Processing groups for orders KOKRS
ORDER_MAD PROFIT_CTR ORDER_MAD CO_AREA CEPC Profit Center Master Data Table KOKRS
ORDER_MAD PROFIT_CTR SY MANDT CEPC Profit Center Master Data Table MANDT
ORDER_MAD PROFIT_CTR ORDER_MAD PROFIT_CTR CEPC Profit Center Master Data Table PRCTR
ORDER_MAD PROFIT_CTR * CEPC Profit Center Master Data Table DATBI
ORDER_MAD REACHED_STATUS SY MANDT TKO03 Order status CLIENT
ORDER_MAD REACHED_STATUS ORDER_MAD ORDER_TYPE TKO03 Order status ART
ORDER_MAD REACHED_STATUS ORDER_MAD REACHED_STATUS TKO03 Order status ASTNR
ORDER_MAD RECOVERY_IND SY MANDT T8JJ Recovery Indicator MANDT
ORDER_MAD RECOVERY_IND ORDER_MAD COMP_CODE T8JJ Recovery Indicator BUKRS
ORDER_MAD RECOVERY_IND ORDER_MAD RECOVERY_IND T8JJ Recovery Indicator RECID
ORDER_MAD REQUEST_CCTR SY MANDT CSKS Cost Center Master Data MANDT
ORDER_MAD REQUEST_CCTR ORDER_MAD CO_AREA CSKS Cost Center Master Data KOKRS
ORDER_MAD REQUEST_CCTR ORDER_MAD REQUEST_CCTR CSKS Cost Center Master Data KOSTL
ORDER_MAD REQUEST_CCTR * CSKS Cost Center Master Data DATBI
ORDER_MAD REQUEST_COMP_CODE ORDER_MAD REQUEST_COMP_CODE T001 Company Codes BUKRS
ORDER_MAD REQUEST_COMP_CODE SY MANDT T001 Company Codes MANDT
ORDER_MAD RESPCCTR ORDER_MAD RESPCCTR CSKS Cost Center Master Data KOSTL
ORDER_MAD RESPCCTR * CSKS Cost Center Master Data DATBI
ORDER_MAD RESPCCTR SY MANDT CSKS Cost Center Master Data MANDT
ORDER_MAD RESPCCTR ORDER_MAD CO_AREA CSKS Cost Center Master Data KOKRS
ORDER_MAD RES_ANAL_KEY SY MANDT TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
ORDER_MAD RES_ANAL_KEY ORDER_MAD RES_ANAL_KEY TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
ORDER_MAD SALES_ORD SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
ORDER_MAD SALES_ORD ORDER_MAD SALES_ORD VBUK Sales Document: Header Status and Administrative Data VBELN
ORDER_MAD SCALE SY MANDT TAIF5 Scale of investment objects MANDT
ORDER_MAD SCALE ORDER_MAD SCALE TAIF5 Scale of investment objects SIZECL
ORDER_MAD TAXJURCODE ORDER_MAD TAXJURCODE TTXJ Check Table for Tax Jurisdiction TXJCD
ORDER_MAD TAXJURCODE SY MANDT TTXJ Check Table for Tax Jurisdiction MANDT
ORDER_MAD TAXJURCODE * TTXJ Check Table for Tax Jurisdiction KALSM