SAP ABAP Table JJVDB_MV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVDB_MV	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	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	XGPLOE	☐	JXLV_GP	XFELD	CHAR	1	0	IS-M: Deletion Flag for General Business Partner
6	XGPLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
7	XGPSPE	☐	XGPSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for General Business Partner
8	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
9	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
10	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
11	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
12	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
13	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
14	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
15	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
16	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
17	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
18	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
19	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
20	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
21	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
22	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
23	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
24	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
25	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
26	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
27	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
28	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
29	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
30	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
31	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
32	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
33	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
34	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
35	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
36	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
37	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
38	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
39	XMVERM	☐	XMVERMITTL	XFELD	CHAR	1	0	IS-M: Media Sales Agent Indicator
40	XMVERMLV	☐	XMVLV	XFELD	CHAR	1	0	IS-M: Deletion Flag for Media Sales Agent
41	XMVERMLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
42	XMVERMSP	☐	XMVSPE	XFELD	CHAR	1	0	IS-M: Lock Indicator for Media Sales Agent
43	GP_DUB	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0
44	BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
45	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
46	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	T077K
47	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
48	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
49	SPERM	☐	SPERM_X	XFELD	CHAR	1	0	Centrally imposed purchasing block
50	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
51	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
52	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
53	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
54	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
55	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
56	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
57	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
58	SEXKZ	☐	SEXKZ	SEXKZ	CHAR	1	0	Key for the Sex of the Person Subject to Withholding Tax
59	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
60	KTOCK	☐	KTOCK	KTOKK	CHAR	4	0	Reference Account Group for One-Time Account (Vendor)	T077K
61	PLKAL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
62	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
63	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
64	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKB1
65	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
66	XVERR	☐	XVERR_LFB1	XFELD	CHAR	1	0	Indicator: Clearing between customer and vendor?
67	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
68	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
69	EIKTO	☐	EIKTO_K	CHAR12	CHAR	12	0	Our account number with the vendor
70	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
71	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
72	XPORE	☐	XPORE	XFELD	CHAR	1	0	Indicator: Pay all items separately ?
73	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
74	QSZDT	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
75	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code
76	ZGRUP	☐	DZGRUP	ZGRUP	CHAR	2	0	Key for Payment Grouping	TZGR
77	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
78	TOGRR	☐	TOGRR	TOGRR	CHAR	4	0	Tolerance group; Invoice Verification	T169L

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJVDB_MV	AKONT	SKB1	SAKNR	REF	1	CN
2	JJVDB_MV	BEGRU	TBRG	BRGRU
3	JJVDB_MV	BERUFSL	TJG05	BERUFSL	REF	C	CN
4	JJVDB_MV	BON	TJGJ2	BONITAET	KEY	1	CN
5	JJVDB_MV	BRAN1	TBRC	BRACO	REF	C	CN
6	JJVDB_MV	BRAN2	TBRC	BRACO	REF	C	CN
7	JJVDB_MV	BRAN3	TBRC	BRACO	REF	C	CN
8	JJVDB_MV	BRAN4	TBRC	BRACO	REF	C	CN
9	JJVDB_MV	BRAN5	TBRC	BRACO	REF	C	CN
10	JJVDB_MV	BRSCH	T016	BRSCH	REF	C	CN
11	JJVDB_MV	BUKRS	T001	BUKRS	KEY	1	CN
12	JJVDB_MV	FDGRV	T035	GRUPP	REF	C	CN
13	JJVDB_MV	GFORM	TVGF	GFORM	REF	C	CN
14	JJVDB_MV	GPHERK	TJG41	GPHERK	REF	C	CN
15	JJVDB_MV	GP_DUB	TJGJ0	DUBIOS	KEY	1	CN
16	JJVDB_MV	JFAMST	TJG45	JFAMST	REF	C	CN
17	JJVDB_MV	JKTOKD	TJG37	JKTOKD	KEY	1	CN
18	JJVDB_MV	KTOCK	T077K	KTOKK	REF	C	CN
19	JJVDB_MV	KTOKK	T077K	KTOKK	REF	1	CN
20	JJVDB_MV	KUNNR	KNA1	KUNNR	REF	C	1
21	JJVDB_MV	LAND1	T005	LAND1	REF	C	CN
22	JJVDB_MV	MANDT	T000	MANDT	KEY	1	CN
23	JJVDB_MV	MGRUP	T047R	MGRUP	REF	C	CN
24	JJVDB_MV	PLKAL	TFACD	IDENT	REF	C	CN
25	JJVDB_MV	SPRAS	T002	SPRAS	REF	1	CN
26	JJVDB_MV	TOGRR	T169L	TOGRR	REF	1	CN
27	JJVDB_MV	TOGRU	T043G	TOGRU	REF	C	CN
28	JJVDB_MV	TXJCD	TTXJ	TXJCD	REF	C	CN
29	JJVDB_MV	ZAHLS	T008	ZAHLS	REF	C	CN
30	JJVDB_MV	ZGRUP	TZGR	ZGRUP	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in