SAP ABAP Table JJVDB_MVK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVDB_MVK	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	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
7	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
8	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
9	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
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	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
14	JBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
15	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
16	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
17	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
18	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
19	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
20	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
21	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
22	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
23	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
24	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
25	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
26	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
27	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
28	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
29	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
30	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
31	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
32	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
33	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
34	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
35	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
36	XMVERM	☐	XMVERMITTL	XFELD	CHAR	1	0	IS-M: Media Sales Agent Indicator
37	XMVERMLV	☐	XMVLV	XFELD	CHAR	1	0	IS-M: Deletion Flag for Media Sales Agent
38	XMVERMLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
39	XMVERMSP	☐	XMVSPE	XFELD	CHAR	1	0	IS-M: Lock Indicator for Media Sales Agent
40	BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
41	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
42	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
43	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
44	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
45	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
46	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
47	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
48	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
49	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
50	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
51	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
52	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange
53	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
54	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
55	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	T077K
56	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
57	LNRZA	☐	LNRZA	LIFNR	CHAR	10	0	Account Number of the Alternative Payee	LFA1
58	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
59	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
60	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
61	SPERM	☐	SPERM_X	XFELD	CHAR	1	0	Centrally imposed purchasing block
62	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
63	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
64	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
65	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
66	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
67	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
68	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
69	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
70	FISKN	☐	FISKN_K	LIFNR	CHAR	10	0	Account number of the master record with fiscal address	LFA1
71	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
72	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
73	SPERQ	☐	QSPERRFKT	QSPERRFKT	CHAR	2	0	Function That Will Be Blocked	TQ04A
74	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_MVK	BERUFSL	TJG05	BERUFSL	REF	C	CN
2	JJVDB_MVK	BON	TJGJ2	BONITAET	KEY	1	CN
3	JJVDB_MVK	BRAN1	TBRC	BRACO	REF	C	CN
4	JJVDB_MVK	BRAN2	TBRC	BRACO	REF	C	CN
5	JJVDB_MVK	BRAN3	TBRC	BRACO	REF	C	CN
6	JJVDB_MVK	BRAN4	TBRC	BRACO	REF	C	CN
7	JJVDB_MVK	BRAN5	TBRC	BRACO	REF	C	CN
8	JJVDB_MVK	BRSCH	T016	BRSCH	REF	C	CN
9	JJVDB_MVK	FISKN	LFA1	LIFNR	REF	C	CN
10	JJVDB_MVK	GFORM	TVGF	GFORM	REF	C	CN
11	JJVDB_MVK	GPHERK	TJG41	GPHERK	REF	C	CN
12	JJVDB_MVK	GP_DUB	TJGJ0	DUBIOS	KEY	1	CN
13	JJVDB_MVK	JBRSCH	T016	BRSCH	REF	C	CN
14	JJVDB_MVK	JFAMST	TJG45	JFAMST	REF	C	CN
15	JJVDB_MVK	JKTOKD	TJG37	JKTOKD	KEY	1	CN
16	JJVDB_MVK	KTOKK	T077K	KTOKK	REF	1	CN
17	JJVDB_MVK	KUNNR	KNA1	KUNNR	REF	C	1
18	JJVDB_MVK	LAND1	T005	LAND1	REF	C	CN
19	JJVDB_MVK	LIFNR	LFA1	LIFNR	REF	C	1
20	JJVDB_MVK	LNRZA	LFA1	LIFNR	REF	C	CN
21	JJVDB_MVK	MANDT	T000	MANDT	KEY	1	CN
22	JJVDB_MVK	SPERQ	TQ04A	SPERRFKT	REF	1	CN
23	JJVDB_MVK	SPRAS	T002	SPRAS	REF	1	CN
24	JJVDB_MVK	VBUND	T880	RCOMP	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in