SAP ABAP Table BW_0CS_ORDER (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BW_0CS_ORDER	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
2	AUFNR	☑	BWCSAUFNR	AUFNR	CHAR	12	0	Service Order	AUFK
3	AUART	☑	AUFART	AUFART	CHAR	4	0	Order Type	T003O
4	EQUNR	☑	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
5	BAUTL	☑	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
6	IWERK	☑	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
7	INGRP	☑	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
8	ARBPL	☑	ARBPL	ARBPL	CHAR	8	0	Work center
9	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	KUNUM	☑	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
11	REVNR	☑	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	T352R
12	ILART	☑	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
13	TPLNR	☑	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
14	ABCKZ	☑	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
15	SWERK	☑	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
16	STORT	☑	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
17	MSGRP	☑	RAUMNR	CHAR8	CHAR	8	0	Room
18	BEBER	☑	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
19	GSBER	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	KOKRS	☑	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
21	KOSTL	☑	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	CSKS
22	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
23	ANLNR	☑	ANLN1	ANLN1	CHAR	12	0	Main Asset Number
24	ANLUN	☑	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber
25	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
26	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
27	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
28	VKGRP	☑	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
29	VKBUR	☑	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
30	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
31	ERDAT	☑	AUFERFDAT	DATUM	DATS	8	0	Created on
32	AEDAT	☑	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
33	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BW_0CS_ORDER	ABCKZ	T370C	ABCKZ	REF	C	CN
2	BW_0CS_ORDER	AUART	T003O	AUART	REF	1	CN
3	BW_0CS_ORDER	AUFNR	AUFK	AUFNR	KEY	1	CN
4	BW_0CS_ORDER	BAUTL	MARA	MATNR	REF	C	CN
5	BW_0CS_ORDER	BEBER	T357	BEBER	REF	C	CN
6	BW_0CS_ORDER	BUKRS	T001	BUKRS	REF	1	CN
7	BW_0CS_ORDER	EQUNR	EQUI	EQUNR	REF	C	CN
8	BW_0CS_ORDER	GSBER	TGSB	GSBER	REF	1	CN
9	BW_0CS_ORDER	ILART	T353I	ILART	REF	C	CN
10	BW_0CS_ORDER	INGRP	T024I	INGRP	REF	C	CN
11	BW_0CS_ORDER	IWERK	T399I	IWERK	REF	C	CN
12	BW_0CS_ORDER	KOKRS	TKA01	KOKRS	REF	1	CN
13	BW_0CS_ORDER	KOSTL	CSKS	KOSTL		1	CN
14	BW_0CS_ORDER	KUNUM	KNA1	KUNNR	REF	C	CN
15	BW_0CS_ORDER	MANDT	T000	MANDT	KEY	1	CN
16	BW_0CS_ORDER	OBJNR	ONR00	OBJNR	REF	1	1
17	BW_0CS_ORDER	QMNUM	QMEL	QMNUM	REF	C	CN
18	BW_0CS_ORDER	REVNR	T352R	REVNR	REF	C	CN
19	BW_0CS_ORDER	SPART	TSPA	SPART
20	BW_0CS_ORDER	STORT	T499S	STAND	REF	C	CN
21	BW_0CS_ORDER	SWERK	T001W	WERKS	REF	1	CN
22	BW_0CS_ORDER	TPLNR	IFLOT	TPLNR	REF	C	CN
23	BW_0CS_ORDER	VKBUR	TVKBZ	VKBUR	REF	C	CN
24	BW_0CS_ORDER	VKGRP	TVBVK	VKGRP	REF	C	CN
25	BW_0CS_ORDER	VKORG	TVKO	VKORG
26	BW_0CS_ORDER	VTWEG	TVTW	VTWEG
27	BW_0CS_ORDER	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in