SAP ABAP Table ORDER_MASTER (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_MASTER	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	Internal Order: Master Data: Additional Global Data Fields
2	ACTION	☐	ACTIV_AUTH	ACTIV_AUTH	CHAR	2	0	Activity	*
3	.INCLUDE	☐				0	0	Create Order Master Data for BAPIs in ALE Scenario
4	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
5	ORDER_TYPE	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
6	ORDER_CATG	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
7	EXT_ORD_NO	☐	AUFEX	AUFEX	CHAR	20	0	External order number
8	SHORT_TEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
9	ENTERED_BY	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
10	ENTER_DATE	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
11	ENTER_TIME	☐	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
12	CHANGED_BY	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
13	CHANGE_DATE	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
14	CHANGE_TIME	☐	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
15	REFERENCE_ORDER	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	*
16	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
17	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
18	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
19	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
20	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
21	RESPCCTR	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
22	LOCATION	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
23	LOCATION_PLANT	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
24	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
25	REQUEST_CCTR	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
26	REQUEST_COMP_CODE	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
27	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
28	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
29	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
30	PLANINTEGRATED	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
31	STATISTICAL	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
32	CCTR_POSTED	☐	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
33	REVENUES	☐	ERLOESE	ERLOESE	CHAR	1	0	Identifier "Revenue posting allowed"
34	PLAN_WITH_LINE_ITEMS	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
35	CURRENCY	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
36	ISO_CODE	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
37	RES_ANAL_KEY	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
38	CSTG_SHEET	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
39	OVERHEAD_KEY	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
40	INTEREST_PROF	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
41	APPLICANT	☐	AUFUSER0	AUFUSER0	CHAR	20	0	Applicant
42	APPLICANT_PHONE	☐	AUFUSER1	AUFUSER1	CHAR	20	0	Applicant's telephone number
43	PERSON_RESP	☐	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
44	PERSON_RESP_PHONE	☐	AUFUSER3	AUFUSER3	CHAR	20	0	Telephone number of person in charge
45	ESTIMATED_COSTS	☐	AUFUSER4BAPI	BAPICURR	DEC	23	4	Estimated Overall Costs of the Order for BAPIs
46	APPLICATION_DATE	☐	AUFUSER5	AUFUSER5	DATS	8	0	Application date
47	DEPARTMENT	☐	AUFUSER6	AUFUSER6	CHAR	15	0	Department
48	DATE_WORK_BEGINS	☐	AUFUSER7	AUFUSER7	DATS	8	0	Work Start
49	DATE_WORK_ENDS	☐	AUFUSER8	AUFUSER8	DATS	8	0	End of Work
50	WORK_PERMIT	☐	AUFUSER9	AUFUSER9	CHAR	1	0	Identifier for work permit issued
51	PROCESSING_GROUP	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
52	INVEST_PROFILE	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
53	SCALE	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
54	INV_REASON	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
55	ENVIR_INVEST	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
56	ORDER_STATUS	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	TKO03
57	LAST_STAT_CHANGE	☐	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
58	REACHED_STATUS	☐	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	TKO03
59	PHASE_CREATE	☐	AUFPHAS0	XFELD	CHAR	1	0	Phase "Order created"
60	PHASE_RELEASE	☐	AUFPHAS1	XFELD	CHAR	1	0	Phase "Order released"
61	PHASE_COMPLETION	☐	AUFPHAS2	XFELD	CHAR	1	0	Phase "order completed"
62	PHASE_CLOSE	☐	AUFPHAS3	XFELD	CHAR	1	0	Phase "order closed"
63	PLN_RELEASE	☐	AUFPDAT1	DATUM	DATS	8	0	Planned release date
64	PLN_COMPLETION	☐	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
65	PLN_CLOSE	☐	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
66	DATE_RELEASE	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
67	DATE_COMPLETION	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
68	DATE_CLOSE	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
69	DISALLOWED_T_GRP	☐	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions	TKAVG
70	DELETION_FLAG	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
71	OBJECTCLASS	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
72	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
73	JOINT_VENTURE	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
74	RECOVERY_IND	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
75	EQUITY_TYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JE
76	JV_OBJECT_TYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
77	JV_JIB_CLASS	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
78	JV_JIB_SUB_CLASS_A	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
79	JV_ORIG_COST_OBJ	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
80	REQUEST_ORDER	☐	AUFANFNR	AUFNR	CHAR	12	0	Requesting order	*
81	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area	*
82	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
83	IN_CHARGE_USER	☐	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	*
84	.INCLUDE	☐				0	0
85	.INCLUDE	☐				0	0	Internal Order: Master Data - More Internal Order Fields
86	FLG_OBLIGO	☐	CO_OBLIGOX	XFELD	CHAR	1	0	Commitments Management Active
87	OBJNBR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
88	SYST_STATUS	☐	TEXT100	TEXT100	CHAR	100	0	Text (100 characters)
89	USER_STATUS	☐	TEXT100	TEXT100	CHAR	100	0	Text (100 characters)
90	STATUS_NBR	☐	J_STONR	J_STONR	NUMC	2	0	Status Order Number
91	VARIANCE_KEY	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	*
92	VARIANCE_KEY_TXT	☐	AWTXT	TEXT40	CHAR	40	0	Name
93	MATERIAL_NO	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	*
94	VALUAT_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
95	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
96	DELIVERY_DATE	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
97	FLG_OLD_STATUS_MGMT	☐	SVALT_D	XFELD	CHAR	1	0	Indicator 'Order status management active'
98	OLD_ORDER_STATUS	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	*
99	OLD_REACHED_STATUS	☐	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	*
100	LOWEST_ORDER_STATUS	☐	AUFNSTNR	AUFSTNR	NUMC	2	0	Lowest order status	*
101	HIGHEST_ORDER_STATUS	☐	AUFHSTNR	AUFSTNR	NUMC	2	0	Highest order status	*
102	LOWEST_ORDER_STATUS_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
103	HIGHEST_ORDER_STATUS_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
104	BALANCE_ORDER_CURR	☐	O_SALDO	WERTV8	CURR	15	2	Order balance in order currency
105	BALANCE_CO_AREA_CURR	☐	K_SALDO	WERTV8	CURR	15	2	Order balance in controlling-area currency
106	ORDER_CURRENCY	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	*
107	CO_AREA_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
108	.INCLUDE	☐				0	0	Internal Order: Master Data - TEXT
109	ORDER_TYPE_TXT	☐	AUARTTEXT	TEXT40	CHAR	40	0	Short Text
110	CO_AREA_TXT	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
111	TAXJURCODE_TXT	☐	TEXT1_TXJT	TEXT50	CHAR	50	0	Description
112	BUS_AREA_TXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
113	COMP_CODE_TXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
114	PLANT_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
115	FUNC_AREA_TXT	☐	FKBTX	TEXT25	CHAR	25	0	Name of the functional area
116	OBJECTCLASS_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
117	PROFIT_CTR_TXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
118	RESPCCTR_TXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
119	REQUEST_CCTR_TXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
120	WBS_ELEMENT_TXT	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
121	REQUEST_COMP_CODE_TXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
122	REQUEST_ORDER_TXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
123	LOCATION_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
124	LOCATION_PLANT_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
125	S_ORD_ITEM_TXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
126	RES_ANAL_KEY_TXT	☐	KKATEXT	KKATEXT	CHAR	40	0	Character Field for Text Table
127	CSTG_SHEET_TXT	☐	VTXTM	TEXT30	CHAR	30	0	Description
128	OVERHEAD_KEY_TXT	☐	BEZEI30	TEXT30	CHAR	30	0	Description
129	INTEREST_PROF_TXT	☐	PS_ZSCHT	TXT50	CHAR	50	0	Name of Interest Calc.Profile
130	ORDER_STATUS_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
131	DISALLOWED_T_GRP_TXT	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
132	CURRENCY_TXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
133	CCTR_POSTED_TXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
134	ORDER_CATG_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
135	LOGSYSTEM_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
136	INVEST_PROFILE_TXT	☐	IM_INVTXT	TEXT50	CHAR	50	0	Name of capital investment profile
137	SCALE_TXT	☐	IMA_SZTXT	TEXT50	CHAR	50	0	Description of scale
138	INV_REASON_TXT	☐	TXT50	TEXT50	CHAR	50	0	Text
139	ENVIR_INVEST_TXT	☐	TXT50	TEXT50	CHAR	50	0	Text
140	PROCESSING_GROUP_TXT	☐	TEXT40T	TEXT40	CHAR	40	0	Text of length 40 with descriptive text
141	REACHED_STATUS_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
142	IN_CHARGE_USER_TXT	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
143	.INCLUDE	☐				0	0	Internal Order: Master Data - Additional Investment Fields
144	INVESTM_PROG	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	*
145	INV_PROG_POS	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
146	APPROVAL_YR	☐	IM_GNJHR	GJAHR	NUMC	4	0	Approval year of the investment program
147	INVESTM_TXT1	☐	IM_POST1	TEXT40	CHAR	40	0	Short description
148	INVESTM_TXT2	☐	IM_POST1	TEXT40	CHAR	40	0	Short description
149	APROP_REQ_NR	☐	IMA_POSNR	IMA_POSNR	CHAR	12	0	Internal number for appropriation request	*
150	APROP_REQ_TXT	☐	IMA_TXT50	TEXT50	CHAR	50	0	Description of appropriation request
151	ASSET_CLASS	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	*
152	CAPITALIZ_DATE	☐	AM_AKTIVP	DATUM	DATS	8	0	Planned capitalization date
153	ASSET_CLASS_TXT	☐	TXT20_ANKT	TEXT20	CHAR	20	0	Short Text for Asset Class Name

Foreign Keys

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

History

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