SAP ABAP Table BIW_COOR (BW Data Collection of Order Master (BW 2.0Aff))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-OM-IS (Application Component) Information System, iViews
     ⤷ KBWOM2 (Package) BW: Delta Method For Data Extraction in CO-OM

Basic Data

Table Category	INTTAB	Structure
Structure	BIW_COOR	Table Relationship Diagram
Short Description	BW Data Collection of Order Master (BW 2.0Aff)

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	*
3	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
4	ERLOESE	☐	ERLOESE	ERLOESE	CHAR	1	0	Identifier "Revenue posting allowed"
5	OBLIGOX	☐	CO_OBLIGOX	XFELD	CHAR	1	0	Commitments Management Active
6	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
9	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
10	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
11	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	*
12	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	*
13	AKSTL	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	*
14	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
15	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	*
16	SIZECL	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	*
17	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
18	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
19	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
20	BWSTSYS0	☐	BWSTSYS0	J_STONR	NUMC	2	0	System Status
21	REFNR	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	*
22	ERNAM	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
23	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
24	AENAM	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
25	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
26	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
27	CCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key
28	STORT	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	*
29	SOWRK	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	*
30	ASTKZ	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
31	ASTNR	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	*
32	STDAT	☐	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
33	ESTNR	☐	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	*
34	PHAS0	☐	AUFPHAS0	XFELD	CHAR	1	0	Phase "Order created"
35	PHAS1	☐	AUFPHAS1	XFELD	CHAR	1	0	Phase "Order released"
36	PHAS2	☐	AUFPHAS2	XFELD	CHAR	1	0	Phase "order completed"
37	PHAS3	☐	AUFPHAS3	XFELD	CHAR	1	0	Phase "order closed"
38	PDAT1	☐	AUFPDAT1	DATUM	DATS	8	0	Planned release date
39	PDAT2	☐	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
40	PDAT3	☐	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
41	IDAT1	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
42	IDAT2	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
43	IDAT3	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
44	OBJID	☐	CCOBJID	CHAR1	CHAR	1	0	Object ID
45	VOGRP	☐	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions	*
46	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
47	PLGKZ	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
48	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	*
49	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
50	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	*
51	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
52	ABKRS	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	*
53	KSTAR	☐	AUFKSTAR	KSTAR	CHAR	10	0	Settlement cost element	*
54	KOSTL	☐	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	*
55	SAKNR	☐	AUFSAKNR	SAKNR	CHAR	10	0	G/L account for basic settlement	*
56	SETNM	☐	AUFSETNM	SETNR	CHAR	12	0	Allocation set
57	CYCLE	☐	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	*
58	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date	*
59	SEQNR	☐	AUFSEQNR	SQNR	NUMC	4	0	Sequence number	*
60	USER0	☐	AUFUSER0	AUFUSER0	CHAR	20	0	Applicant
61	USER1	☐	AUFUSER1	AUFUSER1	CHAR	20	0	Applicant's telephone number
62	USER2	☐	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
63	USER3	☐	AUFUSER3	AUFUSER3	CHAR	20	0	Telephone number of person in charge
64	USER4	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
65	USER5	☐	AUFUSER5	AUFUSER5	DATS	8	0	Application date
66	USER6	☐	AUFUSER6	AUFUSER6	CHAR	15	0	Department
67	USER7	☐	AUFUSER7	AUFUSER7	DATS	8	0	Work Start
68	USER8	☐	AUFUSER8	AUFUSER8	DATS	8	0	End of Work
69	USER9	☐	AUFUSER9	AUFUSER9	CHAR	1	0	Identifier for work permit issued
70	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	*
71	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	*
72	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
73	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
74	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
75	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
76	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
77	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
78	AUFEX	☐	AUFEX	AUFEX	CHAR	20	0	External order number
79	IVPRO	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	*
80	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
81	FLG_MLTPS	☐	CO_MLTPS	KREUZ	CHAR	1	0	Order with multiple items
82	ABUKR	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	*
83	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	*
84	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	*
85	KSTEMPF	☐	CO_KSTEMPF	CO_KSTEMPF	CHAR	1	0	Indicator: Direct cost collector
86	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	*
87	PKOSA	☐	PKOSA_D	AUFNR	CHAR	12	0	Cost collector for production process PROCNR	*
88	ANFAUFNR	☐	AUFANFNR	AUFNR	CHAR	12	0	Requesting order	*
89	PROCNR	☐	CKML_F_PROCNR	CK_KALNR	NUMC	12	0	Production Process	*
90	PROTY	☐	CKML_PROZESS_TYP	CKML_PROZESS_TYP	CHAR	4	0	Process Category (Procurement/Consumption)	*
91	RSORD	☐	RSORD	XFELD	CHAR	1	0	Refurbishment order indicator (PM)
92	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
93	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
94	ERFZEIT	☐	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
95	AEZEIT	☐	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
96	CSTG_VRNT	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	*
97	COSTESTNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
98	VERAA_USER	☐	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	*
99	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20110901
SAP Release Created in