SAP ABAP Table JJVDB_MKK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVDB_MKK	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	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	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
31	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
32	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
33	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
34	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
35	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
36	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
37	GPKLA1	☐	GPKLA	GPKLA	CHAR	4	0	IS-M: BP Class (Not in Use Yet)	TJG51
38	GPKLA2	☐	GPKLA2	GPKLA2	CHAR	4	0	IS-M: BP Class 2	TJG53
39	GPKLA3	☐	GPKLA3	GPKLA3	CHAR	4	0	IS-M: BP Class 3	TJG55
40	GPKLA4	☐	GPKLA4	GPKLA4	CHAR	4	0	IS-M: BP Class 4	TJG57
41	GPKLA5	☐	GPKLA5	GPKLA5	CHAR	4	0	IS-M: BP Class 5	TJG59
42	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
43	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
44	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
45	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
46	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
47	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
48	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
49	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
50	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
51	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
52	XINTERN	☐	XINTERN	XFELD	CHAR	1	0	IS-M: Internal Business Partner Indicator
53	XINTLOEV	☐	XLOESCH	XFELD	CHAR	1	0	IS-M: Deletion Flag (Role-Specific)
54	AUFORG	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
55	XINTSPE	☐	XSPERR	XFELD	CHAR	1	0	IS-M: Lock Indicator (Role-Specific)
56	VERLVKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
57	ISPCVERL	☐	ISPVERL	TEXT11	CHAR	11	0	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
58	XMEDIAK	☐	XMEDIAK	XFELD	CHAR	1	0	IS-M: Media customer
59	XMEDIAKLV	☐	XMKLV	XFELD	CHAR	1	0	IS-M: Deletion Flag for Media Customer
60	XMEDIAKLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
61	XMEDIAKSP	☐	XMKSPE	XFELD	CHAR	1	0	IS-M: Lock Indicator for Media Customer
62	XINSER	☐	XINSERENT	XINSERENT	CHAR	1	0	IS-M: Selection Indicator for Advertiser
63	XINSERLV	☐	XISLV	XFELD	CHAR	1	0	IS-M: Advertiser Deletion Flag
64	XINSERLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
65	XINSERSP	☐	XISSPE	XFELD	CHAR	1	0	IS-M: Advertiser Lock Indicator
66	XAGEN	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
67	XAGENLV	☐	XARLV	XFELD	CHAR	1	0	IS-M: Agency Deletion Flag
68	XAGENLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
69	XAGENLSP	☐	XARSPE	XFELD	CHAR	1	0	IS-M: Agency Lock Indicator
70	AGEN_ART	☐	XAGEN_KREA	XFELD	CHAR	1	0	IS-M: Creative Boutique Indicator
71	AGEN_GRU	☐	AGEN_GRUP	AGEN_GRUP	CHAR	1	0	IS-M: Agency Type	TJGJ4
72	BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
73	XVERLAG	☐	XVERLAG	XFELD	CHAR	1	0	IS-M: Publisher Indicator
74	XVERLLOEV	☐	XLOESCH	XFELD	CHAR	1	0	IS-M: Deletion Flag (Role-Specific)
75	XVERLSPE	☐	XSPERR	XFELD	CHAR	1	0	IS-M: Lock Indicator (Role-Specific)
76	XVERLEIG	☐	XVERLEIG	XFELD	CHAR	1	0	IS-M: Indicator: Owned By Publisher
77	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
78	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
79	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
80	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
81	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
82	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
83	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
84	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
85	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
86	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
87	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
88	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
89	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	KNA1
90	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
91	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
92	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
93	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
94	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
95	LIFNR_KNA1	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
96	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
97	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
98	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
99	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
100	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
101	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
102	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
103	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
104	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
105	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
106	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
107	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
108	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
109	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
110	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
111	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
112	XZEMP	☐	XREGU	XFELD	CHAR	1	0	Indicator: Is an alternative payer allowed in document?
113	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
114	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
115	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
116	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
117	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
118	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
119	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
120	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	VBUK
121	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
122	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
123	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC
124	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
125	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
126	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
127	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales
128	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
129	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
130	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
131	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
132	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
133	AGEN_STR	☐	XAGEN_STR	XFELD	CHAR	1	0	IS-M: Distribution Agency Indicator
134	AGEN_PLAN	☐	XAGEN_PLAN	XFELD	CHAR	1	0	IS-M: Planning Agency Indicator
135	KUNNR_SD	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
136	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_MKK	AGEN_GRU	TJGJ4	AGEN_GRU	KEY	1	CN
2	JJVDB_MKK	AUFORG	TVBUR	VKBUR	KEY	1	CN
3	JJVDB_MKK	AUFSD	TVAST	AUFSP	REF	C	CN
4	JJVDB_MKK	BERUFSL	TJG05	BERUFSL	REF	C	CN
5	JJVDB_MKK	BON	TJGJ2	BONITAET	KEY	1	CN
6	JJVDB_MKK	BRAN1	TBRC	BRACO	REF	C	CN
7	JJVDB_MKK	BRAN2	TBRC	BRACO	REF	C	CN
8	JJVDB_MKK	BRAN3	TBRC	BRACO	REF	C	CN
9	JJVDB_MKK	BRAN4	TBRC	BRACO	REF	C	CN
10	JJVDB_MKK	BRAN5	TBRC	BRACO	REF	C	CN
11	JJVDB_MKK	BRSCH	T016	BRSCH	REF	C	CN
12	JJVDB_MKK	CITYC	T005G	CITYC	REF	C	CN
13	JJVDB_MKK	COUNC	T005E	COUNC	REF	C	CN
14	JJVDB_MKK	EKONT	VBUK	VBELN	REF	1	C
15	JJVDB_MKK	FAKSD	TVFS	FAKSP	REF	C	CN
16	JJVDB_MKK	FISKN	KNA1	KUNNR	REF	C	CN
17	JJVDB_MKK	GFORM	TVGF	GFORM	REF	C	CN
18	JJVDB_MKK	GPHERK	TJG41	GPHERK	REF	C	CN
19	JJVDB_MKK	GPKLA1	TJG51	GPKLA	REF	C	CN
20	JJVDB_MKK	GPKLA2	TJG53	GPKLA2	REF	C	CN
21	JJVDB_MKK	GPKLA3	TJG55	GPKLA3	REF	C	CN
22	JJVDB_MKK	GPKLA4	TJG57	GPKLA4	REF	C	CN
23	JJVDB_MKK	GPKLA5	TJG59	GPKLA5	REF	C	CN
24	JJVDB_MKK	GP_DUB	TJGJ0	DUBIOS	KEY	1	CN
25	JJVDB_MKK	JFAMST	TJG45	JFAMST	REF	C	CN
26	JJVDB_MKK	JKTOKD	TJG37	JKTOKD	KEY	1	CN
27	JJVDB_MKK	KATR1	TVK1	KATR1	REF	C	CN
28	JJVDB_MKK	KATR10	TVK0	KATR10	REF	C	CN
29	JJVDB_MKK	KATR2	TVK2	KATR2	REF	C	CN
30	JJVDB_MKK	KATR3	TVK3	KATR3	REF	C	CN
31	JJVDB_MKK	KATR4	TVK4	KATR4	REF	C	CN
32	JJVDB_MKK	KATR5	TVK5	KATR5	REF	C	CN
33	JJVDB_MKK	KATR6	TVK6	KATR6	REF	C	CN
34	JJVDB_MKK	KATR7	TVK7	KATR7	REF	C	CN
35	JJVDB_MKK	KATR8	TVK8	KATR8	REF	C	CN
36	JJVDB_MKK	KATR9	TVK9	KATR9	REF	C	CN
37	JJVDB_MKK	KNAZK	TFACD	IDENT	REF	C	CN
38	JJVDB_MKK	KNRZA	KNA1	KUNNR	REF	C	CN
39	JJVDB_MKK	KTOKD	T077D	KTOKD	REF	1	CN
40	JJVDB_MKK	KUNNR_SD	KNA1	KUNNR	REF	C	1
41	JJVDB_MKK	LAND1	T005	LAND1	REF	C	CN
42	JJVDB_MKK	LIFNR	LFA1	LIFNR	REF	C	1
43	JJVDB_MKK	LIFNR_KNA1	LFA1	LIFNR	REF	C	CN
44	JJVDB_MKK	LIFSD	TVLS	LIFSP	REF	C	CN
45	JJVDB_MKK	LZONE	TZONE	ZONE1	REF	C	CN
46	JJVDB_MKK	MANDT	T000	MANDT	KEY	1	CN
47	JJVDB_MKK	NIELS	TNLS	NIELS	REF	C	CN
48	JJVDB_MKK	REGIO	T005S	BLAND	REF	C	CN
49	JJVDB_MKK	SPRAS	T002	SPRAS	REF	1	CN
50	JJVDB_MKK	TXJCD	TTXJ	TXJCD	REF	C	CN
51	JJVDB_MKK	UWAER	TCURC	WAERS	REF	1	C
52	JJVDB_MKK	VBUND	T880	RCOMP	REF	C	CN
53	JJVDB_MKK	VERLVKORG	TVKO	VKORG	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in