SAP ABAP Table JJVDB_IS (Generated Table for View JJVDB_IS)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVDB_IS	Table Relationship Diagram
Short Description	Generated Table for View JJVDB_IS

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	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
7	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
8	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
9	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
10	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
11	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
12	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
13	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
14	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
15	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
16	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
17	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
18	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
19	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
20	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
21	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
22	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
23	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
24	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
25	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
26	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
27	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
28	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
29	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
30	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
31	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
32	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
33	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
34	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
35	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
36	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
37	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
38	GPKLA1	☐	GPKLA	GPKLA	CHAR	4	0	IS-M: BP Class (Not in Use Yet)	TJG51
39	GPKLA2	☐	GPKLA2	GPKLA2	CHAR	4	0	IS-M: BP Class 2	TJG53
40	GPKLA3	☐	GPKLA3	GPKLA3	CHAR	4	0	IS-M: BP Class 3	TJG55
41	GPKLA4	☐	GPKLA4	GPKLA4	CHAR	4	0	IS-M: BP Class 4	TJG57
42	GPKLA5	☐	GPKLA5	GPKLA5	CHAR	4	0	IS-M: BP Class 5	TJG59
43	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
44	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
45	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
46	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
47	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
48	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
49	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
50	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
51	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
52	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
53	XINSER	☐	XINSERENT	XINSERENT	CHAR	1	0	IS-M: Selection Indicator for Advertiser
54	XINSERLV	☐	XISLV	XFELD	CHAR	1	0	IS-M: Advertiser Deletion Flag
55	XINSERLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
56	XINSERSP	☐	XISSPE	XFELD	CHAR	1	0	IS-M: Advertiser Lock Indicator
57	BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
58	KLIM_EINZ	☐	JKLIMEINZ	WERT8	CURR	15	2	IS-M: Individual Credit Limit
59	KLIM_GES	☐	JKLIMGES	WERT8	CURR	15	2	IS-M: Total Credit Limit
60	KLIM_WAERS	☐	JWAERS	WAERS	CUKY	5	0	IS-M: Currency Key	TCURC
61	ISPCVERL	☐	ISPVERL	TEXT11	CHAR	11	0	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
62	GP_DUB	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJVDB_IS	BERUFSL	TJG05	BERUFSL	REF	C	CN
2	JJVDB_IS	BON	TJGJ2	BONITAET	KEY	1	CN
3	JJVDB_IS	BRAN1	TBRC	BRACO	REF	C	CN
4	JJVDB_IS	BRAN2	TBRC	BRACO	REF	C	CN
5	JJVDB_IS	BRAN3	TBRC	BRACO	REF	C	CN
6	JJVDB_IS	BRAN4	TBRC	BRACO	REF	C	CN
7	JJVDB_IS	BRAN5	TBRC	BRACO	REF	C	CN
8	JJVDB_IS	BRSCH	T016	BRSCH	REF	C	CN
9	JJVDB_IS	GFORM	TVGF	GFORM	REF	C	CN
10	JJVDB_IS	GPHERK	TJG41	GPHERK	REF	C	CN
11	JJVDB_IS	GPKLA1	TJG51	GPKLA	REF	C	CN
12	JJVDB_IS	GPKLA2	TJG53	GPKLA2	REF	C	CN
13	JJVDB_IS	GPKLA3	TJG55	GPKLA3	REF	C	CN
14	JJVDB_IS	GPKLA4	TJG57	GPKLA4	REF	C	CN
15	JJVDB_IS	GPKLA5	TJG59	GPKLA5	REF	C	CN
16	JJVDB_IS	GP_DUB	TJGJ0	DUBIOS	KEY	1	CN
17	JJVDB_IS	JFAMST	TJG45	JFAMST	REF	C	CN
18	JJVDB_IS	JKTOKD	TJG37	JKTOKD	KEY	1	CN
19	JJVDB_IS	KATR1	TVK1	KATR1	REF	C	CN
20	JJVDB_IS	KATR10	TVK0	KATR10	REF	C	CN
21	JJVDB_IS	KATR2	TVK2	KATR2	REF	C	CN
22	JJVDB_IS	KATR3	TVK3	KATR3	REF	C	CN
23	JJVDB_IS	KATR4	TVK4	KATR4	REF	C	CN
24	JJVDB_IS	KATR5	TVK5	KATR5	REF	C	CN
25	JJVDB_IS	KATR6	TVK6	KATR6	REF	C	CN
26	JJVDB_IS	KATR7	TVK7	KATR7	REF	C	CN
27	JJVDB_IS	KATR8	TVK8	KATR8	REF	C	CN
28	JJVDB_IS	KATR9	TVK9	KATR9	REF	C	CN
29	JJVDB_IS	KLIM_WAERS	TCURC	WAERS	REF	C	CN
30	JJVDB_IS	KUNNR	KNA1	KUNNR	REF	C	1
31	JJVDB_IS	LIFNR	LFA1	LIFNR	REF	C	1
32	JJVDB_IS	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in