SAP ABAP View JJVDB_MV (IS-M/AM: Media Agent)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JJVDB_MV
Short Description	IS-M/AM: Media Agent
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JGTGPNR	JGTGPNR
2	LFA1
3	LFB1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LFA1	MANDT	JL	EQ				0	0
2	JGTGPNR	MANDT	JR	EQ			AND	0	0
3	LFA1	LIFNR	JL	EQ				0	0
4	JGTGPNR	LIFNR	JR	EQ			AND	0	0
5	LFA1	MANDT	JL	EQ				0	0
6	LFB1	MANDT	JR	EQ			AND	0	0
7	LFA1	LIFNR	JL	EQ				0	0
8	LFB1	LIFNR	JR	EQ			AND	0	0
9	JGTGPNR	XMVERM		NE	' '			0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in