SAP ABAP Table ORDER_MAD (Internal Order: Master Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KAUF (Package) Cost Accounting, Orders

Basic Data

Table Category	INTTAB	Structure
Structure	ORDER_MAD	Table Relationship Diagram
Short Description	Internal Order: Master Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Create Order Master Data for BAPIs in ALE Scenario
2	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
3	ORDER_TYPE	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
4	ORDER_CATG	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
5	EXT_ORD_NO	☐	AUFEX	AUFEX	CHAR	20	0	External order number
6	SHORT_TEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
7	ENTERED_BY	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
8	ENTER_DATE	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
9	ENTER_TIME	☐	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
10	CHANGED_BY	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
11	CHANGE_DATE	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
12	CHANGE_TIME	☐	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
13	REFERENCE_ORDER	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	*
14	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
15	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
16	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
17	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
18	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
19	RESPCCTR	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
20	LOCATION	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
21	LOCATION_PLANT	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
22	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
23	REQUEST_CCTR	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
24	REQUEST_COMP_CODE	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
25	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
26	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
27	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
28	PLANINTEGRATED	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
29	STATISTICAL	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
30	CCTR_POSTED	☐	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
31	REVENUES	☐	ERLOESE	ERLOESE	CHAR	1	0	Identifier "Revenue posting allowed"
32	PLAN_WITH_LINE_ITEMS	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
33	CURRENCY	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
34	ISO_CODE	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
35	RES_ANAL_KEY	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
36	CSTG_SHEET	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
37	OVERHEAD_KEY	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
38	INTEREST_PROF	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
39	APPLICANT	☐	AUFUSER0	AUFUSER0	CHAR	20	0	Applicant
40	APPLICANT_PHONE	☐	AUFUSER1	AUFUSER1	CHAR	20	0	Applicant's telephone number
41	PERSON_RESP	☐	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
42	PERSON_RESP_PHONE	☐	AUFUSER3	AUFUSER3	CHAR	20	0	Telephone number of person in charge
43	ESTIMATED_COSTS	☐	AUFUSER4BAPI	BAPICURR	DEC	23	4	Estimated Overall Costs of the Order for BAPIs
44	APPLICATION_DATE	☐	AUFUSER5	AUFUSER5	DATS	8	0	Application date
45	DEPARTMENT	☐	AUFUSER6	AUFUSER6	CHAR	15	0	Department
46	DATE_WORK_BEGINS	☐	AUFUSER7	AUFUSER7	DATS	8	0	Work Start
47	DATE_WORK_ENDS	☐	AUFUSER8	AUFUSER8	DATS	8	0	End of Work
48	WORK_PERMIT	☐	AUFUSER9	AUFUSER9	CHAR	1	0	Identifier for work permit issued
49	PROCESSING_GROUP	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
50	INVEST_PROFILE	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
51	SCALE	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
52	INV_REASON	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
53	ENVIR_INVEST	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
54	ORDER_STATUS	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	TKO03
55	LAST_STAT_CHANGE	☐	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
56	REACHED_STATUS	☐	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	TKO03
57	PHASE_CREATE	☐	AUFPHAS0	XFELD	CHAR	1	0	Phase "Order created"
58	PHASE_RELEASE	☐	AUFPHAS1	XFELD	CHAR	1	0	Phase "Order released"
59	PHASE_COMPLETION	☐	AUFPHAS2	XFELD	CHAR	1	0	Phase "order completed"
60	PHASE_CLOSE	☐	AUFPHAS3	XFELD	CHAR	1	0	Phase "order closed"
61	PLN_RELEASE	☐	AUFPDAT1	DATUM	DATS	8	0	Planned release date
62	PLN_COMPLETION	☐	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
63	PLN_CLOSE	☐	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
64	DATE_RELEASE	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
65	DATE_COMPLETION	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
66	DATE_CLOSE	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
67	DISALLOWED_T_GRP	☐	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions	TKAVG
68	DELETION_FLAG	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
69	OBJECTCLASS	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
70	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
71	JOINT_VENTURE	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
72	RECOVERY_IND	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
73	EQUITY_TYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JE
74	JV_OBJECT_TYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
75	JV_JIB_CLASS	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
76	JV_JIB_SUB_CLASS_A	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
77	JV_ORIG_COST_OBJ	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
78	REQUEST_ORDER	☐	AUFANFNR	AUFNR	CHAR	12	0	Requesting order	*
79	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
80	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
81	IN_CHARGE_USER	☐	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	*
82	.INCLUDE	☐				0	0
83	TAXJURCODE_TXT	☐	TEXT1_TXJT	TEXT50	CHAR	50	0	Description
84	BUS_AREA_TXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
85	COMP_CODE_TXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
86	PLANT_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
87	FUNC_AREA_TXT	☐	FKBTX	TEXT25	CHAR	25	0	Name of the functional area
88	OBJECTCLASS_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
89	PROFIT_CTR_TXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
90	RESPCCTR_TXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
91	REQUEST_CCTR_TXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
92	WBS_ELEMENT_TXT	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
93	REQUEST_COMP_CODE_TXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
94	REQUEST_ORDER_TXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
95	LOCATION_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
96	LOCATION_PLANT_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
97	S_ORD_ITEM_TXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
98	RES_ANAL_KEY_TXT	☐	KKATEXT	KKATEXT	CHAR	40	0	Character Field for Text Table
99	CSTG_SHEET_TXT	☐	VTXTM	TEXT30	CHAR	30	0	Description
100	OVERHEAD_KEY_TXT	☐	BEZEI30	TEXT30	CHAR	30	0	Description
101	INTEREST_PROF_TXT	☐	PS_ZSCHT	TXT50	CHAR	50	0	Name of Interest Calc.Profile
102	ORDER_STATUS_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
103	DISALLOWED_T_GRP_TXT	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
104	CURRENCY_TXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
105	CCTR_POSTED_TXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
106	ORDER_CATG_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
107	LOGSYSTEM_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
108	INVEST_PROFILE_TXT	☐	IM_INVTXT	TEXT50	CHAR	50	0	Name of capital investment profile
109	SCALE_TXT	☐	IMA_SZTXT	TEXT50	CHAR	50	0	Description of scale
110	INV_REASON_TXT	☐	TXT50	TEXT50	CHAR	50	0	Text
111	ENVIR_INVEST_TXT	☐	TXT50	TEXT50	CHAR	50	0	Text
112	PROCESSING_GROUP_TXT	☐	TEXT40T	TEXT40	CHAR	40	0	Text of length 40 with descriptive text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ORDER_MAD	BUS_AREA	TGSB	GSBER	REF	C	CN
2	ORDER_MAD	CCTR_POSTED	CSKS	KOSTL		1	CN
3	ORDER_MAD	COMP_CODE	T001	BUKRS
4	ORDER_MAD	CO_AREA	TKA01	KOKRS
5	ORDER_MAD	CSTG_SHEET	T683	KALSM
6	ORDER_MAD	CURRENCY	TCURC	WAERS	REF	1	CN
7	ORDER_MAD	DISALLOWED_T_GRP	TKAVG	GRUPPE	REF	1	CN
8	ORDER_MAD	ENVIR_INVEST	T087K	UMWKZ		1	CN
9	ORDER_MAD	EQUITY_TYPE	T8JE	ETYPE
10	ORDER_MAD	INTEREST_PROF	TPI01	ZSCHM	REF	C	CN
11	ORDER_MAD	INVEST_PROFILE	TAPRF	IVPRO	REF	C	CN
12	ORDER_MAD	INV_REASON	T087I	IZWEK		1	CN
13	ORDER_MAD	JOINT_VENTURE	T8JV	VNAME
14	ORDER_MAD	JV_JIB_CLASS	T8J6A	CLASS
15	ORDER_MAD	JV_JIB_SUB_CLASS_A	T8J6C	SUBCLASS
16	ORDER_MAD	LOCATION	T499S	STAND		1	CN
17	ORDER_MAD	LOCATION_PLANT	T001W	WERKS		1	CN
18	ORDER_MAD	LOGSYSTEM	TBDLS	LOGSYS	REF	1	CN
19	ORDER_MAD	ORDER_STATUS	TKO03	ASTNR	REF	1	CN
20	ORDER_MAD	ORDER_TYPE	T003O	AUART		1	CN
21	ORDER_MAD	PLANT	T001W	WERKS	REF	C	CN
22	ORDER_MAD	PROCESSING_GROUP	TKO08	ABKRS	REF	1	CN
23	ORDER_MAD	PROFIT_CTR	CEPC	PRCTR		1	CN
24	ORDER_MAD	REACHED_STATUS	TKO03	ASTNR	REF	1	CN
25	ORDER_MAD	RECOVERY_IND	T8JJ	RECID
26	ORDER_MAD	REQUEST_CCTR	CSKS	KOSTL		1	CN
27	ORDER_MAD	REQUEST_COMP_CODE	T001	BUKRS
28	ORDER_MAD	RESPCCTR	CSKS	KOSTL	REF	1	CN
29	ORDER_MAD	RES_ANAL_KEY	TKKAA	ABGSL
30	ORDER_MAD	SALES_ORD	VBUK	VBELN		1	CN
31	ORDER_MAD	SCALE	TAIF5	SIZECL		1	CN
32	ORDER_MAD	TAXJURCODE	TTXJ	TXJCD

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C