SAP table ORDER_MAD (Internal Order: Master Data)

Field Description Data Type Length Decimals Checktable Data Element
ORDERID Order Number CHAR 12 0 * AUFNR
ORDER_TYPE Order Type CHAR 4 0 T003O AUFART
ORDER_CATG Order category NUMC 2 0 AUFTYP
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
99 Master Planned order
EXT_ORD_NO External order number CHAR 20 0 AUFEX
SHORT_TEXT Description CHAR 40 0 AUFTEXT
ENTERED_BY Entered By CHAR 12 0 AUFERFNAM
ENTER_DATE Created On DATS 8 0 AUFERFDAT
ENTER_TIME Time created TIMS 6 0 CO_INS_TIME
CHANGED_BY Last Changed By CHAR 12 0 AUFAENAM
CHANGE_DATE Change Date for Order Master DATS 8 0 AUFAEDAT
CHANGE_TIME Changed At TIMS 6 0 CO_CHG_TIME
REFERENCE_ORDER Reference Order Number CHAR 12 0 * AUFREFNR
CO_AREA Controlling Area CHAR 4 0 TKA01 KOKRS
COMP_CODE Company Code CHAR 4 0 T001 BUKRS
BUS_AREA Business Area CHAR 4 0 TGSB GSBER
PLANT Plant CHAR 4 0 T001W WERKS_D
PROFIT_CTR Profit Center CHAR 10 0 CEPC PRCTR
RESPCCTR Responsible cost center CHAR 10 0 CSKS AUFKOSTV
LOCATION Location CHAR 10 0 T499S AUFSTORT
LOCATION_PLANT Location Plant CHAR 4 0 T001W AUFSOWRK
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
REQUEST_CCTR Requesting cost center CHAR 10 0 CSKS PS_AKSTL
REQUEST_COMP_CODE Requesting company code CHAR 4 0 T001 IM_ABUKRS
SALES_ORD Sales Order Number CHAR 10 0 * KDAUF
S_ORD_ITEM Item number in Sales Order NUMC 6 0 KDPOS
TAXJURCODE Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
PLANINTEGRATED Indicator for Integrated Planning CHAR 1 0 PLINT
STATISTICAL Identifier for Statistical Order CHAR 1 0 AUFSTKZ
CCTR_POSTED Cost center to which costs are actually posted CHAR 10 0 CSKS ST_KOSTL
REVENUES Identifier "Revenue Posting Allowed" CHAR 1 0 ERLOESE
not allowed
X allowed
PLAN_WITH_LINE_ITEMS Identifier for Planning with Line Items CHAR 1 0 PLGKZ
CURRENCY Order Currency CUKY 5 0 TCURC AUFWAERS
ISO_CODE ISO currency code CHAR 3 0 ISOCD
RES_ANAL_KEY Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL
CSTG_SHEET Costing Sheet CHAR 6 0 T683 AUFKALSM
OVERHEAD_KEY Overhead key CHAR 6 0 AUFZSCHL
INTEREST_PROF Interest Profile for Project/Order Interest Calculation CHAR 7 0 TPI01 PS_ZSCHM
APPLICANT Applicant CHAR 20 0 AUFUSER0
APPLICANT_PHONE Applicant's telephone number CHAR 20 0 AUFUSER1
PERSON_RESP Person Responsible CHAR 20 0 AUFUSER2
PERSON_RESP_PHONE Telephone number of person in charge CHAR 20 0 AUFUSER3
ESTIMATED_COSTS Estimated Overall Costs of the Order for BAPIs DEC 23 4 AUFUSER4BAPI
APPLICATION_DATE Application date DATS 8 0 AUFUSER5
DEPARTMENT Department CHAR 15 0 AUFUSER6
DATE_WORK_BEGINS Work Start DATS 8 0 AUFUSER7
DATE_WORK_ENDS End of Work DATS 8 0 AUFUSER8
WORK_PERMIT Identifier for work permit issued CHAR 1 0 AUFUSER9
X Work permit issued
PROCESSING_GROUP Processing group NUMC 2 0 TKO08 AUFABKRS
INVEST_PROFILE Investment Measure Profile CHAR 6 0 TAPRF IM_PROFIL
SCALE Scale of investment objects CHAR 2 0 TAIF5 IM_SIZECL
INV_REASON Reason for Investment CHAR 2 0 T087I IZWEK
ENVIR_INVEST Reason for Environmental Investment CHAR 5 0 T087K AM_UMWKZ
ORDER_STATUS Order Status NUMC 2 0 TKO03 AUFASTNR
LAST_STAT_CHANGE Date of Last Status Change DATS 8 0 AUFSTDAT
REACHED_STATUS Status Reached so Far NUMC 2 0 TKO03 AUFESTNR
PHASE_CREATE Phase "Order Created" CHAR 1 0 AUFPHAS0
PHASE_RELEASE Phase "Order Released" CHAR 1 0 AUFPHAS1
PHASE_COMPLETION Phase "Order Completed" CHAR 1 0 AUFPHAS2
PHASE_CLOSE Phase "Order Closed" CHAR 1 0 AUFPHAS3
PLN_RELEASE Planned release date DATS 8 0 AUFPDAT1
PLN_COMPLETION Planned completion date DATS 8 0 AUFPDAT2
PLN_CLOSE Planned closing date DATS 8 0 AUFPDAT3
DATE_RELEASE Release Date DATS 8 0 AUFIDAT1
DATE_COMPLETION Technical Completion Date DATS 8 0 AUFIDAT2
DATE_CLOSE Close Date DATS 8 0 AUFIDAT3
DISALLOWED_T_GRP Group of Disallowed Transactions CHAR 4 0 TKAVG AUFSPSET
DELETION_FLAG Deletion Flag CHAR 1 0 AUFLOEKZ
OBJECTCLASS Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
JOINT_VENTURE Joint venture CHAR 6 0 T8JV JV_NAME
RECOVERY_IND Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
EQUITY_TYPE Equity type CHAR 3 0 T8JE JV_ETYPE
JV_OBJECT_TYPE Joint Venture Object Type CHAR 4 0 JV_OTYPE
JV_JIB_CLASS JIB/JIBE Class CHAR 3 0 T8J6A JV_JIBCL
JV_JIB_SUB_CLASS_A JIB/JIBE Subclass A CHAR 5 0 T8J6C JV_JIBSA
JV_ORIG_COST_OBJ JV original cost object CHAR 1 0 JV_OR_CO
REQUEST_ORDER Requesting order CHAR 12 0 * AUFANFNR
FUNC_AREA Functional Area CHAR 4 0 FKBER_SHORT
FUNC_AREA_LONG Functional Area CHAR 16 0 * FKBER
IN_CHARGE_USER Person Responsible for CO Internal Order CHAR 12 0 * VERAA_USER
TAXJURCODE_TXT Description CHAR 50 0 TEXT1_TXJT
BUS_AREA_TXT Business area description CHAR 30 0 GTEXT
COMP_CODE_TXT Name of Company Code or Company CHAR 25 0 BUTXT
PLANT_TXT Name CHAR 30 0 NAME1
FUNC_AREA_TXT Name of the functional area CHAR 25 0 FKBTX
OBJECTCLASS_TXT Short Text for Fixed Values CHAR 60 0 VAL_TEXT
PROFIT_CTR_TXT General Name CHAR 20 0 KTEXT
RESPCCTR_TXT Description CHAR 40 0 KLTXT
REQUEST_CCTR_TXT Description CHAR 40 0 KLTXT
WBS_ELEMENT_TXT PS: Short description (1st text line) CHAR 40 0 PS_POST1
REQUEST_COMP_CODE_TXT Name of Company Code or Company CHAR 25 0 BUTXT
REQUEST_ORDER_TXT Description CHAR 40 0 AUFTEXT
LOCATION_TXT Text, 40 Characters Long CHAR 40 0 TEXT40
LOCATION_PLANT_TXT Name CHAR 30 0 NAME1
S_ORD_ITEM_TXT Short text for sales order item CHAR 40 0 ARKTX
RES_ANAL_KEY_TXT Character Field for Text Table CHAR 40 0 KKATEXT
CSTG_SHEET_TXT Description CHAR 30 0 VTXTM
OVERHEAD_KEY_TXT Description CHAR 30 0 BEZEI30
INTEREST_PROF_TXT Name of Interest Calc.Profile CHAR 50 0 PS_ZSCHT
ORDER_STATUS_TXT Text, 40 Characters Long CHAR 40 0 TEXT40
DISALLOWED_T_GRP_TXT Text, Length 40 CHAR 40 0 TXT40
CURRENCY_TXT Long Text CHAR 40 0 LTEXT
CCTR_POSTED_TXT General Name CHAR 20 0 KTEXT
ORDER_CATG_TXT Text, 40 Characters Long CHAR 40 0 TEXT40
LOGSYSTEM_TXT Text, 40 Characters Long CHAR 40 0 TEXT40
INVEST_PROFILE_TXT Name of capital investment profile CHAR 50 0 IM_INVTXT
SCALE_TXT Description of scale CHAR 50 0 IMA_SZTXT
INV_REASON_TXT Name CHAR 50 0 TXT50
ENVIR_INVEST_TXT Name CHAR 50 0 TXT50
PROCESSING_GROUP_TXT Text of Length 40 with Descriptive Text CHAR 40 0 TEXT40T

ORDER_MAD foreign key relationships

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