SAP ABAP Table V_AVCHANA_OR_GE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_AVCHANA_OR_GE	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	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUFNR	AUFNR	AUFNR	CHAR	12	0	Order Number
3	AUART	AUFART	AUFART	CHAR	4	0	Order Type	T003O
4	AUTYP	AUFTYP	AUFTYP	NUMC	2	0	Order category
5	REFNR	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	AUFK
6	ERNAM	AUFERFNAM	USNAM	CHAR	12	0	Entered by
7	ERDAT	AUFERFDAT	DATUM	DATS	8	0	Created on
8	AENAM	AUFAENAM	USNAM	CHAR	12	0	Last changed by
9	AEDAT	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
10	KTEXT	AUFTEXT	TEXT40	CHAR	40	0	Description
11	LTEXT	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
12	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
14	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
15	KOKRS	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
16	CCKEY	CCKEY	CCKEY	CHAR	23	0	Cost collector key
17	KOSTV	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
18	STORT	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
19	SOWRK	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
20	ASTKZ	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
21	WAERS	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
22	ASTNR	AUFASTNR	AUFSTNR	NUMC	2	0	Order status
23	STDAT	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
24	ESTNR	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	TKO03
25	PHAS0	AUFPHAS0	XFELD	CHAR	1	0	Phase "Order created"
26	PHAS1	AUFPHAS1	XFELD	CHAR	1	0	Phase "Order released"
27	PHAS2	AUFPHAS2	XFELD	CHAR	1	0	Phase "order completed"
28	PHAS3	AUFPHAS3	XFELD	CHAR	1	0	Phase "order closed"
29	PDAT1	AUFPDAT1	DATUM	DATS	8	0	Planned release date
30	PDAT2	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
31	PDAT3	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
32	IDAT1	AUFIDAT1	DATUM	DATS	8	0	Release date
33	IDAT2	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
34	IDAT3	AUFIDAT3	DATUM	DATS	8	0	Close date
35	OBJID	CCOBJID	CHAR1	CHAR	1	0	Object ID
36	VOGRP	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions	TKAVG
37	LOEKZ	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
38	PLGKZ	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
39	KVEWE	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
40	KAPPL	KAPPL	KAPPL	CHAR	2	0	Application	T681A
41	KALSM	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
42	ZSCHL	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
43	ABKRS	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
44	KSTAR	AUFKSTAR	KSTAR	CHAR	10	0	Settlement cost element	CSKB
45	KOSTL	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	CSKS
46	SAKNR	AUFSAKNR	SAKNR	CHAR	10	0	G/L account for basic settlement	SKB1
47	SETNM	AUFSETNM	SETNR	CHAR	12	0	Allocation set
48	CYCLE	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
49	SDATE	SDATE	SDATE	DATS	8	0	Start Date
50	SEQNR	AUFSEQNR	SQNR	NUMC	4	0	Sequence number
51	USER0	AUFUSER0	AUFUSER0	CHAR	20	0	Applicant
52	USER1	AUFUSER1	AUFUSER1	CHAR	20	0	Applicant's telephone number
53	USER2	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
54	USER3	AUFUSER3	AUFUSER3	CHAR	20	0	Telephone number of person in charge
55	USER4	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
56	USER5	AUFUSER5	AUFUSER5	DATS	8	0	Application date
57	USER6	AUFUSER6	AUFUSER6	CHAR	15	0	Department
58	USER7	AUFUSER7	AUFUSER7	DATS	8	0	Work Start
59	USER8	AUFUSER8	AUFUSER8	DATS	8	0	End of Work
60	USER9	AUFUSER9	AUFUSER9	CHAR	1	0	Identifier for work permit issued
61	OBJNR	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
62	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
63	PSPEL	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
64	AWSLS	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
65	ABGSL	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
66	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
67	FUNC_AREA	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
68	SCOPE	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
69	PLINT	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
70	KDAUF	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
71	KDPOS	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
72	AUFEX	AUFEX	AUFEX	CHAR	20	0	External order number
73	IVPRO	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
74	LOGSYSTEM	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
75	FLG_MLTPS	CO_MLTPS	KREUZ	CHAR	1	0	Order with multiple items
76	ABUKR	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
77	AKSTL	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
78	SIZECL	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
79	IZWEK	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
80	UMWKZ	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
81	KSTEMPF	CO_KSTEMPF	CO_KSTEMPF	CHAR	1	0	Indicator: Direct cost collector
82	ZSCHM	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
83	PKOSA	PKOSA_D	AUFNR	CHAR	12	0	Cost collector for production process PROCNR
84	ANFAUFNR	AUFANFNR	AUFNR	CHAR	12	0	Requesting order	AUFK
85	PROCNR	CKML_F_PROCNR	CK_KALNR	NUMC	12	0	Production Process
86	PROTY	CKML_PROZESS_TYP	CKML_PROZESS_TYP	CHAR	4	0	Process Category (Procurement/Consumption)
87	RSORD	RSORD	XFELD	CHAR	1	0	Refurbishment order indicator (PM)
88	BEMOT	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
89	ADRNRA	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
90	ERFZEIT	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
91	AEZEIT	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
92	CSTG_VRNT	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant
93	COSTESTNR	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
94	VERAA_USER	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	USR02
95	VNAME	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
96	RECID	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
97	ETYPE	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
98	OTYPE	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
99	JV_JIBCL	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
100	JV_JIBSA	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
101	JV_OCO	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
102	LEDNR	BP_LEDNR	LEDNR_BP	CHAR	4	0	Budget/Planning Ledger
103	POSIT	BP_POSIT	BP_POSIT	CHAR	8	0	Internal commitment item (8 chars)
104	TRGKZ	BP_TRGKZ	BP_TRGKZ	CHAR	1	0	Object indicator
105	WRTTP	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
106	GEBER	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
107	VERSN	BP_VERSION	BP_VERSION	CHAR	3	0	Planning/budgeting version
108	VORGA	BP_VORGANG	ACTIVITY	CHAR	4	0	Budget Type Budgeting/Planning	T022
109	TWAER	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
110	SUBVO	BP_SUBVO	BP_SUBVO	CHAR	4	0	Budget Subtype
111	FAREA	FM_FAREA	FKBER	CHAR	16	0	Functional Area
112	WTGES	BP_WGT	WERTV8	CURR	15	2	Overall value in transaction currency
113	WLGES	BP_WGL	WERTV8	CURR	15	2	Total value in ledger currency
114	WTGEV	BP_WGTV	WERTV8	CURR	15	2	Total distributed value in transaction currency
115	WLGEV	BP_WGLV	WERTV8	CURR	15	2	Distributed value total in ledger currency
116	KALNR	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
117	KLVAR	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	TCK03
118	BELTP	BP_INOUT	BP_INOUT	NUMC	1	0	Debit type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_AVCHANA_OR_GE	ABGSL	TKKAA	ABGSL	REF	C	CN
2	V_AVCHANA_OR_GE	ABKRS	TKO08	ABKRS	REF	1	CN
3	V_AVCHANA_OR_GE	ABUKR	T001	BUKRS		1	CN
4	V_AVCHANA_OR_GE	AKSTL	CSKS	KOSTL		1	CN
5	V_AVCHANA_OR_GE	ANFAUFNR	AUFK	AUFNR	REF	1	CN
6	V_AVCHANA_OR_GE	AUART	T003O	AUART	REF	1	CN
7	V_AVCHANA_OR_GE	AWSLS	TKV01	AWSLS	REF	C	CN
8	V_AVCHANA_OR_GE	BEMOT	TBMOT	BEMOT
9	V_AVCHANA_OR_GE	BUKRS	T001	BUKRS	REF	1	CN
10	V_AVCHANA_OR_GE	CYCLE	CSKS	KOSTL		1	CN
11	V_AVCHANA_OR_GE	ESTNR	TKO03	ASTNR	REF	1	CN
12	V_AVCHANA_OR_GE	ETYPE	T8JG	ETYPE	REF	C	CN
13	V_AVCHANA_OR_GE	FUNC_AREA	TFKB	FKBER
14	V_AVCHANA_OR_GE	GEBER	FMFINCODE	FINCODE	KEY	1	CN
15	V_AVCHANA_OR_GE	GSBER	TGSB	GSBER	REF	1	CN
16	V_AVCHANA_OR_GE	IVPRO	TAPRF	IVPRO	REF	C	CN
17	V_AVCHANA_OR_GE	IZWEK	T087I	IZWEK		1	CN
18	V_AVCHANA_OR_GE	JV_JIBCL	T8J6A	CLASS	REF	C	CN
19	V_AVCHANA_OR_GE	JV_JIBSA	T8J6C	SUBCLASS	REF	C	CN
20	V_AVCHANA_OR_GE	KALSM	T683	KALSM	REF	1	CN
21	V_AVCHANA_OR_GE	KAPPL	T681A	KAPPL	REF	1	CN
22	V_AVCHANA_OR_GE	KDAUF	VBUK	VBELN		1	CN
23	V_AVCHANA_OR_GE	KLVAR	TCK03	KLVAR	KEY	1	CN
24	V_AVCHANA_OR_GE	KOKRS	TKA01	KOKRS	REF	1	CN
25	V_AVCHANA_OR_GE	KOSTL	CSKS	KOSTL		1	CN
26	V_AVCHANA_OR_GE	KOSTV	CSKS	KOSTL		1	CN
27	V_AVCHANA_OR_GE	KSTAR	CSKB	KSTAR		1	CN
28	V_AVCHANA_OR_GE	KVEWE	T681V	KVEWE	REF	1	CN
29	V_AVCHANA_OR_GE	LOGSYSTEM	TBDLS	LOGSYS	REF	1	CN
30	V_AVCHANA_OR_GE	MANDT	T000	MANDT	KEY	1	CN
31	V_AVCHANA_OR_GE	OBJNR	ONR00	OBJNR	REF	1	1
32	V_AVCHANA_OR_GE	PRCTR	CEPC	PRCTR		1	CN
33	V_AVCHANA_OR_GE	PSPEL	PRPS	PSPNR	REF	C	CN
34	V_AVCHANA_OR_GE	RECID	T8JJ	RECID	REF	C	CN
35	V_AVCHANA_OR_GE	REFNR	AUFK	AUFNR	REF	1	CN
36	V_AVCHANA_OR_GE	SAKNR	SKB1	SAKNR		1	CN
37	V_AVCHANA_OR_GE	SIZECL	TAIF5	SIZECL		1	CN
38	V_AVCHANA_OR_GE	SOWRK	T001W	WERKS	REF	1	CN
39	V_AVCHANA_OR_GE	STORT	T499S	STAND	REF	1	CN
40	V_AVCHANA_OR_GE	TWAER	TCURC	WAERS	KEY	1	CN
41	V_AVCHANA_OR_GE	TXJCD	TTXJ	TXJCD
42	V_AVCHANA_OR_GE	UMWKZ	T087K	UMWKZ		1	CN
43	V_AVCHANA_OR_GE	VERAA_USER	USR02	BNAME
44	V_AVCHANA_OR_GE	VNAME	T8JV	VNAME	REF	C	CN
45	V_AVCHANA_OR_GE	VOGRP	TKAVG	GRUPPE		1	CN
46	V_AVCHANA_OR_GE	VORGA	T022	ACTIVITY	KEY	1	CN
47	V_AVCHANA_OR_GE	WAERS	TCURC	WAERS	REF	1	CN
48	V_AVCHANA_OR_GE	WERKS	T001W	WERKS	REF	1	CN
49	V_AVCHANA_OR_GE	ZSCHM	TPI01	ZSCHM	REF	C	CN