SAP ABAP Table JGVDB_ZG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JGVDB_ZG	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	XGPLOE	☐	JXLV_GP	XFELD	CHAR	1	0	IS-M: Deletion Flag for General Business Partner
4	XGPLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
5	XGPSPE	☐	XGPSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for General Business Partner
6	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
7	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
8	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
9	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
10	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
11	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
12	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
13	JBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
14	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
15	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
16	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
17	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
18	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
19	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
20	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
21	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
22	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
23	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
24	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
25	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
26	XVSRVGES	☐	XVSRVGES	XFELD	CHAR	1	0	IS-M: Service Company Indicator
27	XVSGLOEV	☐	JXLV_ZG	XFELD	CHAR	1	0	IS-M: Deletion Flag for Service Company
28	XVSGLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
29	XVSGSPE	☐	XZGSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Service Company
30	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
31	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
32	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
33	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
34	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
35	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
36	XZUGLOE	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
37	ANZZUST	☐	ANZZUST	JANZMANUM	DEC	5	0	IS-M: Number of Carriers
38	ANZAUSD	☐	ANZAUSD	JANZMANUM	DEC	5	0	IS-M: Number of Employees in External Sales Force
39	WEGSTRECKE	☐	WEGSTRECKE	ISPMNG13	QUAN	13	3	IS-M: Estimated Path Length
40	LEINS	☐	LEINS	MEINS	UNIT	3	0	IS-M: Metric Unit of Measurement (Length)	T006
41	BUKRS	☐	JBUKRS	BUKRS	CHAR	4	0	IS-M: Company Code for Service Company	T001
42	XSERVZUST	☐	XSERVZUST	XFELD	CHAR	1	0	IS-M: Service Company in Home Delivery Role
43	XSERVRECH	☐	XSERVRECH	XFELD	CHAR	1	0	IS-M: Service Company in Research Role
44	XSERVVERM	☐	XSERVVERM	XFELD	CHAR	1	0	IS-M: Service Company in Sales Agent Role
45	XSERVINK	☐	XSERVINK	XFELD	CHAR	1	0	IS-M: Service Company in Collection Role
46	JZUGEHOER	☐	JZUGEHOER	JZUGSTAT	CHAR	1	0	IS-M: Membership Status Own/Co-Administered/Third Party
47	JFEIERTKAL	☐	JFEIKAL	HIDENT	CHAR	2	0	IS-M: Public Holiday Calendar	THOCI
48	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
49	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
50	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
51	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
52	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
53	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
54	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
55	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
56	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange
57	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
58	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
59	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	T077K
60	KUNNR_LFA1	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
61	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
62	LNRZA	☐	LNRZA	LIFNR	CHAR	10	0	Account Number of the Alternative Payee	LFA1
63	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
64	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
65	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
66	SPERM	☐	SPERM_X	XFELD	CHAR	1	0	Centrally imposed purchasing block
67	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
68	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
69	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
70	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
71	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
72	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
73	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
74	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
75	FISKN	☐	FISKN_K	LIFNR	CHAR	10	0	Account number of the master record with fiscal address	LFA1
76	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
77	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
78	SPERQ	☐	QSPERRFKT	QSPERRFKT	CHAR	2	0	Function That Will Be Blocked	TQ04A

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGVDB_ZG	BERUFSL	TJG05	BERUFSL	REF	C	CN
2	JGVDB_ZG	BRSCH	T016	BRSCH	REF	C	CN
3	JGVDB_ZG	BUKRS	T001	BUKRS	REF	C	CN
4	JGVDB_ZG	FISKN	LFA1	LIFNR	REF	C	CN
5	JGVDB_ZG	GPHERK	TJG41	GPHERK	REF	C	CN
6	JGVDB_ZG	JBRSCH	T016	BRSCH	REF	C	CN
7	JGVDB_ZG	JFAMST	TJG45	JFAMST	REF	C	CN
8	JGVDB_ZG	JFEIERTKAL	THOCI	IDENT	KEY	1	CN
9	JGVDB_ZG	JKTOKD	TJG37	JKTOKD	KEY	1	CN
10	JGVDB_ZG	KTOKK	T077K	KTOKK	REF	1	CN
11	JGVDB_ZG	KUNNR	KNA1	KUNNR	REF	C	1
12	JGVDB_ZG	KUNNR_LFA1	KNA1	KUNNR	REF	C	CN
13	JGVDB_ZG	LAND1	T005	LAND1	REF	C	CN
14	JGVDB_ZG	LEINS	T006	MSEHI	REF	C	CN
15	JGVDB_ZG	LIFNR	LFA1	LIFNR	REF	C	1
16	JGVDB_ZG	LNRZA	LFA1	LIFNR	REF	C	CN
17	JGVDB_ZG	MANDT	T000	MANDT	KEY	1	CN
18	JGVDB_ZG	SPERQ	TQ04A	SPERRFKT	REF	1	CN
19	JGVDB_ZG	SPRAS	T002	SPRAS	REF	1	CN
20	JGVDB_ZG	VBUND	T880	RCOMP	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in