SAP ABAP Table JGVDB_KU (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JGVDB_KU	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	GPNR	☑	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key
3	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
6	XGPLOE	☐	JXLV_GP	XFELD	CHAR	1	0	IS-M: Deletion Flag for General Business Partner
7	XGPLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
8	XGPSPE	☐	XGPSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for General Business Partner
9	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
10	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
11	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
12	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
13	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
14	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
15	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
16	JBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
17	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
18	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
19	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
20	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
21	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
22	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
23	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
24	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
25	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
26	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
27	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
28	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
29	XVERTKUN	☐	XVERTKUN	XFELD	CHAR	1	0	IS-M: Sales Customer Indicator
30	XVKUNLOEV	☐	JXLV_KU	XFELD	CHAR	1	0	IS-M: Deletion Flag for Sales Customer
31	XVKUNLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
32	XVKUNSPE	☐	XKUSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Sales Customer
33	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
34	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
35	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
36	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
37	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
38	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
39	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
40	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
41	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
42	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
43	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
44	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
45	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	KNA1
46	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
47	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
48	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
49	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
50	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
51	LIFNR_KNA1	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
52	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
53	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
54	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
55	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
56	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
57	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
58	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
59	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
60	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
61	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
62	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
63	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
64	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
65	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
66	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
67	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
68	XZEMP	☐	XREGU	XFELD	CHAR	1	0	Indicator: Is an alternative payer allowed in document?
69	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
70	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
71	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
72	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
73	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
74	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
75	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
76	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
77	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
78	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
79	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
80	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
81	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
82	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	VBUK
83	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
84	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
85	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC
86	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
87	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
88	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
89	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
90	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
91	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
92	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
93	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
94	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
95	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
96	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
97	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
98	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
99	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales
100	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
101	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
102	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
103	BEGRU_KNVV	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
104	LOEVM_KNVV	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
105	VERSG	☐	STGKU	STGKU	CHAR	1	0	Customer Statistics Group	TVSD
106	AUFSD_KNVV	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)	TVAST
107	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
108	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
109	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
110	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
111	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
112	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
113	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
114	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
115	LIFSD_KNVV	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	TVLS
116	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
117	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
118	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
119	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
120	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
121	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
122	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
123	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
124	FAKSD_KNVV	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)	TVFS
125	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
126	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
127	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
128	KVAKZ	☐	KVAKZ	XFELD	CHAR	1	0	Cost estimate indicator (inactive)
129	KVAWT	☐	KVAWT	WERT7	CURR	13	2	Value limit for cost estimate (inactive)
130	WAERS	☐	WAERS_V02D	WAERS	CUKY	5	0	Currency	TCURC
131	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
132	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
133	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
134	VWERK	☐	DWERK_EXT	WERKS	CHAR	4	0	Delivering Plant (Own or External)	TVKWZ
135	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
136	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
137	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal	VBUK
138	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
139	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
140	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
141	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
142	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
143	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
144	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
145	RECHZENTNR	☐	JWBZRZNR	JWBZRZNR	CHAR	2	0	IS-M: WBZ, Computer Center Number	TJKW0
146	JWBZKOMART	☐	JWBZKOMART	JWBZKOMART	CHAR	1	0	IS-M: Communication Type in WBZ Processing
147	XWBZFIRMA	☐	XWBZFIRMA	XFELD	CHAR	1	0	IS-M: Business Partner Is WBZ Company
148	WBZZLSCH	☐	WBZZLSCH	ZLSCH	CHAR	1	0	Payment Method for Billing Documents to WBZ Company	TJK42
149	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGVDB_KU	AUFSD	TVAST	AUFSP	REF	C	CN
2	JGVDB_KU	AUFSD_KNVV	TVAST	AUFSP	REF	C	CN
3	JGVDB_KU	BERUFSL	TJG05	BERUFSL	REF	C	CN
4	JGVDB_KU	BRAN1	TBRC	BRACO	KEY	1	CN
5	JGVDB_KU	BRAN2	TBRC	BRACO	KEY	1	CN
6	JGVDB_KU	BRAN3	TBRC	BRACO	KEY	1	CN
7	JGVDB_KU	BRAN4	TBRC	BRACO	KEY	1	CN
8	JGVDB_KU	BRAN5	TBRC	BRACO	KEY	1	CN
9	JGVDB_KU	BRSCH	T016	BRSCH	REF	C	CN
10	JGVDB_KU	BZIRK	T171	BZIRK	REF	C	CN
11	JGVDB_KU	CITYC	T005G	CITYC	REF	C	CN
12	JGVDB_KU	COUNC	T005E	COUNC	REF	C	CN
13	JGVDB_KU	EKONT	VBUK	VBELN	REF	1	C
14	JGVDB_KU	FAKSD	TVFS	FAKSP	REF	C	CN
15	JGVDB_KU	FAKSD_KNVV	TVFS	FAKSP	REF	C	CN
16	JGVDB_KU	FISKN	KNA1	KUNNR	REF	C	CN
17	JGVDB_KU	GFORM	TVGF	GFORM	KEY	1	CN
18	JGVDB_KU	GPHERK	TJG41	GPHERK	REF	C	CN
19	JGVDB_KU	INCO1	TINC	INCO1	REF	C	CN
20	JGVDB_KU	JBRSCH	T016	BRSCH	REF	C	CN
21	JGVDB_KU	JFAMST	TJG45	JFAMST	REF	C	CN
22	JGVDB_KU	JKTOKD	TJG37	JKTOKD	KEY	1	CN
23	JGVDB_KU	KALKS	TVKD	KALKS	REF	C	CN
24	JGVDB_KU	KATR1	TVK1	KATR1	KEY	1	CN
25	JGVDB_KU	KATR10	TVK0	KATR10	KEY	1	CN
26	JGVDB_KU	KATR2	TVK2	KATR2	KEY	1	CN
27	JGVDB_KU	KATR3	TVK3	KATR3	KEY	1	CN
28	JGVDB_KU	KATR4	TVK4	KATR4	KEY	1	CN
29	JGVDB_KU	KATR5	TVK5	KATR5	KEY	1	CN
30	JGVDB_KU	KATR6	TVK6	KATR6	KEY	1	CN
31	JGVDB_KU	KATR7	TVK7	KATR7	KEY	1	CN
32	JGVDB_KU	KATR8	TVK8	KATR8	KEY	1	CN
33	JGVDB_KU	KATR9	TVK9	KATR9	KEY	1	CN
34	JGVDB_KU	KDGRP	T151	KDGRP	REF	C	CN
35	JGVDB_KU	KNAZK	TFACD	IDENT	REF	C	CN
36	JGVDB_KU	KNRZA	KNA1	KUNNR	REF	C	CN
37	JGVDB_KU	KONDA	T188	KONDA	REF	C	CN
38	JGVDB_KU	KTGRD	TVKT	KTGRD	REF	C	CN
39	JGVDB_KU	KTOKD	T077D	KTOKD	REF	1	CN
40	JGVDB_KU	KUKLA	TKUKL	KUKLA	REF	C	CN
41	JGVDB_KU	KUNNR	KNA1	KUNNR	REF	C	1
42	JGVDB_KU	KURST	TCURV	KURST	REF	C	CN
43	JGVDB_KU	KVGR1	TVV1	KVGR1	REF	C	CN
44	JGVDB_KU	KVGR2	TVV2	KVGR2	REF	C	CN
45	JGVDB_KU	KVGR3	TVV3	KVGR3	REF	C	CN
46	JGVDB_KU	KVGR4	TVV4	KVGR4	REF	C	CN
47	JGVDB_KU	KVGR5	TVV5	KVGR5	REF	C	CN
48	JGVDB_KU	LAND1	T005	LAND1	REF	C	CN
49	JGVDB_KU	LIFNR	LFA1	LIFNR	REF	C	1
50	JGVDB_KU	LIFNR_KNA1	LFA1	LIFNR	REF	C	CN
51	JGVDB_KU	LIFSD	TVLS	LIFSP	REF	C	CN
52	JGVDB_KU	LIFSD_KNVV	TVLS	LIFSP	REF	C	CN
53	JGVDB_KU	LPRIO	TPRIO	LPRIO	REF	C	CN
54	JGVDB_KU	LZONE	TZONE	ZONE1	REF	C	CN
55	JGVDB_KU	MANDT	T000	MANDT	KEY	1	CN
56	JGVDB_KU	NIELS	TNLS	NIELS	REF	C	CN
57	JGVDB_KU	PERFK	TFACD	IDENT	REF	C	CN
58	JGVDB_KU	PERRL	TFACD	IDENT	REF	C	CN
59	JGVDB_KU	PLTYP	T189	PLTYP	REF	C	CN
60	JGVDB_KU	RECHZENTNR	TJKW0	RECHZENTNR	KEY	1	CN
61	JGVDB_KU	REGIO	T005S	BLAND	REF	C	CN
62	JGVDB_KU	SPART	TSPA	SPART	KEY	1	CN
63	JGVDB_KU	SPRAS	T002	SPRAS	REF	1	CN
64	JGVDB_KU	TXJCD	TTXJ	TXJCD	REF	C	CN
65	JGVDB_KU	UWAER	TCURC	WAERS	REF	1	C
66	JGVDB_KU	VBUND	T880	RCOMP	REF	C	CN
67	JGVDB_KU	VERSG	TVSD	STGKU	REF	C	CN
68	JGVDB_KU	VKBUR	TVBUR	VKBUR	REF	C	CN
69	JGVDB_KU	VKGRP	TVBVK	VKGRP	REF	C	CN
70	JGVDB_KU	VKORG	TVKO	VKORG	KEY	1	CN
71	JGVDB_KU	VSBED	TVSB	VSBED	REF	C	CN
72	JGVDB_KU	VSORT	VBUK	VBELN	REF	C	CN
73	JGVDB_KU	VTWEG	TVTW	VTWEG	KEY	1	CN
74	JGVDB_KU	VWERK	TVKWZ	WERKS	REF	C	CN
75	JGVDB_KU	WAERS	TCURC	WAERS	REF	C	CN
76	JGVDB_KU	WBZZLSCH	TJK42	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in