SAP ABAP Table BAPI2075_MASTERDATA_ALE (Create Order Master Data for BAPIs in ALE Scenario)

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	BAPI2075_MASTERDATA_ALE	Table Relationship Diagram
Short Description	Create Order Master Data for BAPIs in ALE Scenario

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	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
2	ORDER_TYPE	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
3	ORDER_CATG	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
4	EXT_ORD_NO	☐	AUFEX	AUFEX	CHAR	20	0	External order number
5	SHORT_TEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
6	ENTERED_BY	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
7	ENTER_DATE	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
8	ENTER_TIME	☐	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
9	CHANGED_BY	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
10	CHANGE_DATE	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
11	CHANGE_TIME	☐	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
12	REFERENCE_ORDER	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	*
13	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
14	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
16	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
18	RESPCCTR	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
19	LOCATION	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
20	LOCATION_PLANT	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
21	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
22	REQUEST_CCTR	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
23	REQUEST_COMP_CODE	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
24	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
25	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
26	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
27	PLANINTEGRATED	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
28	STATISTICAL	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
29	CCTR_POSTED	☐	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
30	REVENUES	☐	ERLOESE	ERLOESE	CHAR	1	0	Identifier "Revenue posting allowed"
31	PLAN_WITH_LINE_ITEMS	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
32	CURRENCY	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
33	ISO_CODE	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
34	RES_ANAL_KEY	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
35	CSTG_SHEET	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
36	OVERHEAD_KEY	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
37	INTEREST_PROF	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
38	APPLICANT	☐	AUFUSER0	AUFUSER0	CHAR	20	0	Applicant
39	APPLICANT_PHONE	☐	AUFUSER1	AUFUSER1	CHAR	20	0	Applicant's telephone number
40	PERSON_RESP	☐	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
41	PERSON_RESP_PHONE	☐	AUFUSER3	AUFUSER3	CHAR	20	0	Telephone number of person in charge
42	ESTIMATED_COSTS	☐	AUFUSER4BAPI	BAPICURR	DEC	23	4	Estimated Overall Costs of the Order for BAPIs
43	APPLICATION_DATE	☐	AUFUSER5	AUFUSER5	DATS	8	0	Application date
44	DEPARTMENT	☐	AUFUSER6	AUFUSER6	CHAR	15	0	Department
45	DATE_WORK_BEGINS	☐	AUFUSER7	AUFUSER7	DATS	8	0	Work Start
46	DATE_WORK_ENDS	☐	AUFUSER8	AUFUSER8	DATS	8	0	End of Work
47	WORK_PERMIT	☐	AUFUSER9	AUFUSER9	CHAR	1	0	Identifier for work permit issued
48	PROCESSING_GROUP	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
49	INVEST_PROFILE	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
50	SCALE	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
51	INV_REASON	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
52	ENVIR_INVEST	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
53	ORDER_STATUS	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	TKO03
54	LAST_STAT_CHANGE	☐	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
55	REACHED_STATUS	☐	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	TKO03
56	PHASE_CREATE	☐	AUFPHAS0	XFELD	CHAR	1	0	Phase "Order created"
57	PHASE_RELEASE	☐	AUFPHAS1	XFELD	CHAR	1	0	Phase "Order released"
58	PHASE_COMPLETION	☐	AUFPHAS2	XFELD	CHAR	1	0	Phase "order completed"
59	PHASE_CLOSE	☐	AUFPHAS3	XFELD	CHAR	1	0	Phase "order closed"
60	PLN_RELEASE	☐	AUFPDAT1	DATUM	DATS	8	0	Planned release date
61	PLN_COMPLETION	☐	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
62	PLN_CLOSE	☐	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
63	DATE_RELEASE	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
64	DATE_COMPLETION	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
65	DATE_CLOSE	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
66	DISALLOWED_T_GRP	☐	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions	TKAVG
67	DELETION_FLAG	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
68	OBJECTCLASS	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
69	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
70	JOINT_VENTURE	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
71	RECOVERY_IND	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
72	EQUITY_TYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JE
73	JV_OBJECT_TYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
74	JV_JIB_CLASS	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
75	JV_JIB_SUB_CLASS_A	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
76	JV_ORIG_COST_OBJ	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
77	REQUEST_ORDER	☐	AUFANFNR	AUFNR	CHAR	12	0	Requesting order	*
78	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
79	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
80	IN_CHARGE_USER	☐	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	*

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in