SAP ABAP Table V_OIGSDOCS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OIGSDOCS	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	VBELN	☑	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
3	POSNR	☑	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
4	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
8	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
11	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
12	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
13	WADAT	☐	WADAK	DATUM	DATS	8	0	Planned goods movement date
14	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
15	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
16	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
17	KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
18	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
19	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
20	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
21	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
22	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
23	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
24	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
25	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
26	KNFAK	☐	KNFAK	WFCID	CHAR	2	0	Customer factory calendar	TFACD
27	TPQUA	☐	TPQUA	TPQUA	CHAR	1	0	not currently in use
28	TPGRP	☐	TPGRP	TPGRP	CHAR	2	0	not currently in use
29	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
30	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
31	KUNNR	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
32	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
33	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
34	STZKL	☐	STZKL	STZKL	DEC	3	2	Not Currently in Use
35	STZZU	☐	STZZU	STZZU	DEC	3	0	not currently in use
36	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
37	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
38	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
39	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
40	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
41	ANZPK	☐	ANZPK	ANZPK	NUMC	5	0	Total number of packages in delivery
42	BEROT	☐	BEROT	BEROT	CHAR	20	0	Picked items location
43	LFUHR	☐	LFUHR	LFUHR	TIMS	6	0	Time of delivery
44	GRULG	☐	GRULG	GRULG	CHAR	4	0	Weight group for delivery (To group)	TVLG
45	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
46	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
47	FKARV	☐	FKARV	FKART	CHAR	4	0	Proposed billing type for a delivery-related billing doc.	TVFK
48	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
49	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
50	ROUTA	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
51	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
52	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
53	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
54	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
55	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
56	VBEAK	☐	VBEAK	DEC4_2	DEC	6	2	Shipping processing time for the entire document
57	ZUKRL	☐	DZUKRL	CHAR40	CHAR	40	0	Combination criteria for delivery
58	VERUR	☐	VERUR_VL	CHAR35	CHAR	35	0	Distribution delivery
59	COMMN	☐	COMMN	COMMN	CHAR	5	0	Communication number for Q-API interface	TQCOM
60	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
61	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
62	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
63	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
64	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
65	VKOIV	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
66	VTWIV	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
67	SPAIV	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing	TSPA
68	FKAIV	☐	FKAIV	FKART	CHAR	4	0	Billing type for intercompany billing	TVFK
69	PIOIV	☐	PIOIV	WFCID	CHAR	2	0	Date for intercompany billing	TFACD
70	FKDIV	☐	FKDIV	DATUM	DATS	8	0	Billing date for intercompany billing
71	KUNIV	☐	KUNIV	KUNNR	CHAR	10	0	Customer number for intercompany billing	KNA1
72	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
73	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
74	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group
75	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
76	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
77	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
78	AMTBL	☐	AMTBL_CM	WERTV8	CURR	15	2	Released credit value of the document
79	BOLNR	☐	BOLNR	CHAR35	CHAR	35	0	Bill of lading
80	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number
81	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	TVTY
82	TRAID	☐	TRAID	TRAID	CHAR	20	0	Means-of-transport ID
83	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
84	CMNGV	☐	CMNGV	DATUM	DATS	8	0	Next date
85	XABLN	☐	XABLN	BELNR	CHAR	10	0	Goods receipt/issue slip number
86	WADAT_IST	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
87	TRSPG	☐	TRSPG	TRSPG	CHAR	2	0	Shipment Blocking Reason	TTSG
88	TPSID	☐	TPSID	COMMN	CHAR	5	0	ID for external transport system	TQCOM
89	LIFEX	☐	LIFEX	TEXT35	CHAR	35	0	External Identification of Delivery Note
90	TERNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
91	KALSM_CH	☐	KALSMA_CH	KALSM	CHAR	6	0	Search procedure for batch determination	T683
92	KLIEF	☐	KLIEF	XFELD	CHAR	1	0	Correction delivery
93	KALSP	☐	KALSP	KALSM	CHAR	6	0	Shipping: Pricing procedure	T683
94	KNUMP	☐	KNUMP	KNUMV	CHAR	10	0	Number of document condition - pricing
95	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	VALW
96	WERKS	☐	EMPFW	WERKS	CHAR	4	0	Receiving plant for deliveries	T001W
97	KOQUK	☐	KOQUK	STATV	CHAR	1	0	Status of pick confirmation
98	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
99	PKSTK	☐	PKSTK	STATV_PKST	CHAR	1	0	Overall packing status of all items
100	TRSTA	☐	TRSTA	TRSTA	CHAR	1	0	Transportation planning status
101	IMEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
102	ICHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
103	IMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
104	IVBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
105	IBWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
106	IWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
107	ILGMNG	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
108	ILFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
109	IVRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
110	ILGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
111	IBRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
112	INTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
113	ILADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	TLGR
114	ITRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
115	IGEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
116	IVOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
117	IVOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
118	IVGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
119	IVGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
120	IVGTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_OIGSDOCS	AULWE	VALW	AULWE	REF	1	CN
2	V_OIGSDOCS	BZIRK	T171	BZIRK	REF	C	CN
3	V_OIGSDOCS	CMWAE	TCURC	WAERS	REF	C	CN
4	V_OIGSDOCS	COMMN	TQCOM	COMMN	REF	C	CN
5	V_OIGSDOCS	CTLPC	T691A	CTLPC	REF	C	CN
6	V_OIGSDOCS	EXNUM	EIKP	EXNUM	REF	C	CN
7	V_OIGSDOCS	FAKSK	TVFS	FAKSP	REF	C	CN
8	V_OIGSDOCS	FKAIV	TVFK	FKART	REF	C	CN
9	V_OIGSDOCS	FKARV	TVFK	FKART	REF	C	CN
10	V_OIGSDOCS	GEWEI	T006	MSEHI	REF	C	CN
11	V_OIGSDOCS	GRULG	TVLG	GRULG	REF	C	CN
12	V_OIGSDOCS	IBWTAR	T149D	BWTAR	REF	C	CN
13	V_OIGSDOCS	ICHARG	MCHA	CHARG	REF	C	CN
14	V_OIGSDOCS	IGEWEI	T006	MSEHI	REF	C	CN
15	V_OIGSDOCS	ILADGR	TLGR	LADGR	REF	C	CN
16	V_OIGSDOCS	ILGORT	T001L	LGORT	REF	C	CN
17	V_OIGSDOCS	IMATNR	MARA	MATNR	REF	C	CN
18	V_OIGSDOCS	IMEINS	T006	MSEHI	REF	C	CN
19	V_OIGSDOCS	INCO1	TINC	INCO1	REF	C	CN
20	V_OIGSDOCS	ITRAGR	TTGR	TRAGR	REF	C	CN
21	V_OIGSDOCS	IVBELV	VBUK	VBELN	REF	C	CN
22	V_OIGSDOCS	IVGBEL	VBUK	VBELN	REF	C	CN
23	V_OIGSDOCS	IVGPOS	VBUP	POSNR	REF	C	CN
24	V_OIGSDOCS	IVOLEH	T006	MSEHI	REF	C	CN
25	V_OIGSDOCS	IVRKME	T006	MSEHI	REF	C	CN
26	V_OIGSDOCS	IWERKS	T001W	WERKS	REF	C	CN
27	V_OIGSDOCS	KALSM	T683	KALSM	REF	C	CN
28	V_OIGSDOCS	KALSM_CH	T683	KALSM	REF	C	CN
29	V_OIGSDOCS	KALSP	T683	KALSM	REF	C	CN
30	V_OIGSDOCS	KDGRP	T151	KDGRP	REF	C	CN
31	V_OIGSDOCS	KKBER	T014	KKBER	REF	C	CN
32	V_OIGSDOCS	KNFAK	TFACD	IDENT	REF	C	CN
33	V_OIGSDOCS	KNKLI	KNA1	KUNNR	REF	C	CN
34	V_OIGSDOCS	KUNAG	KNA1	KUNNR	REF	C	CN
35	V_OIGSDOCS	KUNIV	KNA1	KUNNR	REF	C	CN
36	V_OIGSDOCS	KUNNR	KNA1	KUNNR	REF	1	CN
37	V_OIGSDOCS	LFART	TVLK	LFART	REF	C	CN
38	V_OIGSDOCS	LGNUM	T300	LGNUM	REF	C	CN
39	V_OIGSDOCS	LIFSK	TVLS	LIFSP	REF	C	CN
40	V_OIGSDOCS	LPRIO	TPRIO	LPRIO	REF	C	CN
41	V_OIGSDOCS	LSTEL	TVLA	LSTEL	REF	C	CN
42	V_OIGSDOCS	MANDT	T000	MANDT	KEY	1	CN
43	V_OIGSDOCS	PERFK	TFACD	IDENT	REF	C	CN
44	V_OIGSDOCS	PIOIV	TFACD	IDENT	REF	C	CN
45	V_OIGSDOCS	POSNR	VBUP	POSNR	KEY	1	C
46	V_OIGSDOCS	ROUTA	TVRO	ROUTE	REF	C	CN
47	V_OIGSDOCS	ROUTE	TVRO	ROUTE	REF	C	CN
48	V_OIGSDOCS	SBGRP	T024B	SBGRP	REF	C	CN
49	V_OIGSDOCS	SPAIV	TSPA	SPART	REF	C	CN
50	V_OIGSDOCS	STWAE	TCURC	WAERS	REF	C	CN
51	V_OIGSDOCS	TERNR	AUFK	AUFNR	REF	C	C
52	V_OIGSDOCS	TPSID	TQCOM	COMMN	REF	C	CN
53	V_OIGSDOCS	TRAGR	TTGR	TRAGR	REF	C	CN
54	V_OIGSDOCS	TRATY	TVTY	TRATY	REF	C	CN
55	V_OIGSDOCS	TRSPG	TTSG	TRSPG	REF	C	CN
56	V_OIGSDOCS	VBELN	VBUK	VBELN	KEY	1	C
57	V_OIGSDOCS	VKBUR	TVBUR	VKBUR	REF	C	CN
58	V_OIGSDOCS	VKOIV	TVKO	VKORG	REF	C	CN
59	V_OIGSDOCS	VKORG	TVKO	VKORG	REF	C	CN
60	V_OIGSDOCS	VOLEH	T006	MSEHI	REF	C	CN
61	V_OIGSDOCS	VSBED	TVSB	VSBED	REF	C	CN
62	V_OIGSDOCS	VSTEL	TVST	VSTEL	REF	1	CN
63	V_OIGSDOCS	VTWIV	TVTW	VTWEG	REF	C	CN
64	V_OIGSDOCS	WAERK	TCURC	WAERS	REF	C	CN
65	V_OIGSDOCS	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in