SAP ABAP Table JGVDB_KUB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JGVDB_KUB	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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	XGPLOE	☐	JXLV_GP	XFELD	CHAR	1	0	IS-M: Deletion Flag for General Business Partner
5	XGPLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
6	XGPSPE	☐	XGPSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for General Business Partner
7	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
8	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
9	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
10	JBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
11	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
12	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
13	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
14	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
15	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
16	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
17	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
18	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
19	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
20	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
21	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
22	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
23	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
24	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
25	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
26	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
27	XVERTKUN	☐	XVERTKUN	XFELD	CHAR	1	0	IS-M: Sales Customer Indicator
28	XVKUNLOEV	☐	JXLV_KU	XFELD	CHAR	1	0	IS-M: Deletion Flag for Sales Customer
29	XVKUNLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
30	XVKUNSPE	☐	XKUSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Sales Customer
31	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
32	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
33	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
34	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code
35	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code
36	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
37	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
38	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
39	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
40	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
41	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
42	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
43	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
44	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
45	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
46	SPERR_B	☐	SPERB_B	XFELD	CHAR	1	0	Posting block for company code
47	LOEVM_B	☐	LOEVM_B	XFELD	CHAR	1	0	Deletion Flag for Master Record (Company Code Level)
48	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
49	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
50	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKB1
51	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
52	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
53	ZSABE	☐	DZSABE_D	TEXT15	CHAR	15	0	User at customer
54	KVERM	☐	KVERM	TEXT30	CHAR	30	0	Memo
55	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
56	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
57	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
58	KNRZE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
59	KNRZB	☐	KNRZB	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
60	ZAMIM	☐	DZAMIM	XFELD	CHAR	1	0	Indicator: Payment notice to customer (with cleared items)?
61	ZAMIV	☐	DZAMIV	XFELD	CHAR	1	0	Indicator: payment notice to sales department?
62	ZAMIR	☐	DZAMIR	XFELD	CHAR	1	0	Indicator: payment notice to legal department?
63	ZAMIB	☐	DZAMIB	XFELD	CHAR	1	0	Indicator: Payment notice to the accounting department ?
64	ZAMIO	☐	DZAMIO	XFELD	CHAR	1	0	Indicator: payment notice to customer (w/o cleared items)?
65	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
66	XVERR	☐	XVERR_KNB1	XFELD	CHAR	1	0	Indicator: Clearing between customer and vendor ?
67	WAKON	☐	WAKON	ZTERM	CHAR	4	0	Terms of payment key for bill of exchange charges
68	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
69	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
70	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
71	EIKTO	☐	EIKTO_D	CHAR12	CHAR	12	0	Our account number at customer
72	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
73	VRBKZ	☐	VRBKZ	VRBKZ	CHAR	2	0	Export credit insurance institution number
74	VLIBB	☐	VLIBB	WERT7	CURR	13	2	Amount Insured
75	VRSZL	☐	VRSZL	PACK2	DEC	3	0	Insurance lead months
76	VRSPR	☐	VRSPR	PACK2	DEC	3	0	Deductible percentage rate
77	VRSNR	☐	VRSNR	CHAR10	CHAR	10	0	Insurance number
78	VERDT	☐	VERDT	DATUM	DATS	8	0	Insurance validity date
79	PERKZ	☐	PERKZ_KNB1	PERKZ_KNB1	CHAR	1	0	Collective invoice variant
80	XDEZV	☐	XDEZV	XFELD	CHAR	1	0	Indicator: Local processing?
81	XAUSZ	☐	XAUSZ	AUSZG	CHAR	1	0	Indicator for periodic account statements	T048K
82	WEBTR	☐	WEBTR	WERT7	CURR	13	2	Bill of exchange limit (in local currency)
83	REMIT	☐	REMIT	KUNNR	CHAR	10	0	Next payee	KNA1
84	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
85	XZVER	☐	XZVER	XFELD	CHAR	1	0	Indicator: Record Payment History ?
86	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
87	KULTG	☐	KULTG	PACK2	DEC	3	0	Probable time until check is paid
88	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
89	XPORE	☐	XPORE	XFELD	CHAR	1	0	Indicator: Pay all items separately ?
90	BLNKZ	☐	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates
91	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
92	ZGRUP	☐	DZGRUP	ZGRUP	CHAR	2	0	Key for Payment Grouping	TZGR
93	URLID	☐	URLID	URLID	CHAR	4	0	Short Key for Known/Negotiated Leave	T052A
94	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGVDB_KUB	AKONT	SKB1	SAKNR	REF	1	CN
2	JGVDB_KUB	BERUFSL	TJG05	BERUFSL	REF	C	CN
3	JGVDB_KUB	BUKRS	T001	BUKRS	KEY	1	CN
4	JGVDB_KUB	BUSAB	T001S	BUSAB	REF	C	CN
5	JGVDB_KUB	FDGRV	T035	GRUPP	REF	C	CN
6	JGVDB_KUB	GFORM	TVGF	GFORM	KEY	1	CN
7	JGVDB_KUB	GPHERK	TJG41	GPHERK	REF	C	CN
8	JGVDB_KUB	HBKID	T012	HBKID	REF	C	CN
9	JGVDB_KUB	JBRSCH	T016	BRSCH	REF	C	CN
10	JGVDB_KUB	JFAMST	TJG45	JFAMST	REF	C	CN
11	JGVDB_KUB	JKTOKD	TJG37	JKTOKD	KEY	1	CN
12	JGVDB_KUB	KNRZB	KNA1	KUNNR	REF	C	CN
13	JGVDB_KUB	KNRZE	KNA1	KUNNR	REF	C	CN
14	JGVDB_KUB	KTOKD	T077D	KTOKD	REF	1	CN
15	JGVDB_KUB	KUNNR	KNA1	KUNNR	REF	C	1
16	JGVDB_KUB	LIFNR	LFA1	LIFNR	REF	C	1
17	JGVDB_KUB	MANDT	T000	MANDT	KEY	1	CN
18	JGVDB_KUB	MGRUP	T047R	MGRUP	REF	C	CN
19	JGVDB_KUB	REMIT	KNA1	KUNNR	REF	C	CN
20	JGVDB_KUB	SPRAS	T002	SPRAS	REF	1	CN
21	JGVDB_KUB	TOGRU	T043G	TOGRU	REF	C	CN
22	JGVDB_KUB	URLID	T052A	URLID	REF	C	CN
23	JGVDB_KUB	VZSKZ	T056	VZSKZ	REF	C	CN
24	JGVDB_KUB	XAUSZ	T048K	XAUSZ	REF	C	CN
25	JGVDB_KUB	ZAHLS	T008	ZAHLS	REF	C	CN
26	JGVDB_KUB	ZGRUP	TZGR	ZGRUP	REF	C	CN
27	JGVDB_KUB	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in