SAP ABAP View JJVDB_MK (IS-M/AM: Media Customer (with Sales Area))

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_MK
Short Description	IS-M/AM: Media Customer (with Sales Area)
Root table	JJTVM	IS-M/AM: Media Sales Area Customer

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTVM	JJTVM
2	KNVV
3	KNA1
4	JGTGPNR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNVV	MANDT	JL	EQ				0	0
2	JJTVM	MANDT	JR	EQ			AND	0	0
3	KNVV	KUNNR	JL	EQ				0	0
4	JJTVM	KUNNR	JR	EQ			AND	0	0
5	KNVV	VKORG	JL	EQ				0	0
6	JJTVM	VKORG	JR	EQ			AND	0	0
7	KNVV	VTWEG	JL	EQ				0	0
8	JJTVM	VTWEG	JR	EQ			AND	0	0
9	KNVV	SPART	JL	EQ				0	0
10	JJTVM	SPART	JR	EQ			AND	0	0
11	KNA1	MANDT	JL	EQ				0	0
12	KNVV	MANDT	JR	EQ			AND	0	0
13	KNA1	KUNNR	JL	EQ				0	0
14	KNVV	KUNNR	JR	EQ			AND	0	0
15	KNA1	MANDT	JL	EQ				0	0
16	JGTGPNR	MANDT	JR	EQ			AND	0	0
17	KNA1	KUNNR	JL	EQ				0	0
18	JGTGPNR	KUNNR	JR	EQ			AND	0	0
19	JGTGPNR	XMEDIAK		NE	' '		AND	0	0
20	JGTGPNR	KUNNR		NE	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTVM	MANDT		☐	MANDT	☐	Client
2	GPNR	JGTGPNR	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
3	VKORG	JJTVM	VKORG		☐	VKORG	☐	Sales Organization
4	VTWEG	JJTVM	VTWEG		☐	VTWEG	☐	Distribution Channel
5	SPART	JJTVM	SPART		☐	SPART	☐	Division
6	XGPLOE	JGTGPNR	XGPLOE		☐	JXLV_GP	☐	IS-M: Deletion Flag for General Business Partner
7	XGPLOEKZ	JGTGPNR	XGPLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
8	XGPSPE	JGTGPNR	XGPSPE		☐	XGPSPE	☐	IS-M/SD: Lock Indicator for General Business Partner
9	ERFUSER	JGTGPNR	ERFUSER		☐	ERFUSER	☐	Created By
10	ERFDATE	JGTGPNR	ERFDATE		☐	ERFDATE	☐	Created On
11	ERFTIME	JGTGPNR	ERFTIME		☐	ERFTIME	☐	Time Created
12	AENUSER	JGTGPNR	AENUSER		☐	AENUSER	☐	Last Changed By
13	AENDATE	JGTGPNR	AENDATE		☐	AENDATE	☐	Date of Last Change
14	AENTIME	JGTGPNR	AENTIME		☐	AENTIME	☐	Time of Last Change
15	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
16	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
17	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
18	GFORM	JGTGPNR	GFORM		☐	GFORM	☐	Legal status
19	JBRSCH	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	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
33	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
34	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
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	KATR1	JGTGPNR	KATR1		☐	KATR1	☐	Attribute 1
40	KATR2	JGTGPNR	KATR2		☐	KATR2	☐	Attribute 2
41	KATR3	JGTGPNR	KATR3		☐	KATR3	☐	Attribute 3
42	KATR4	JGTGPNR	KATR4		☐	KATR4	☐	Attribute 4
43	KATR5	JGTGPNR	KATR5		☐	KATR5	☐	Attribute 5
44	KATR6	JGTGPNR	KATR6		☐	KATR6	☐	Attribute 6
45	KATR7	JGTGPNR	KATR7		☐	KATR7	☐	Attribute 7
46	KATR8	JGTGPNR	KATR8		☐	KATR8	☐	Attribute 8
47	KATR9	JGTGPNR	KATR9		☐	KATR9	☐	Attribute 9
48	KATR10	JGTGPNR	KATR10		☐	KATR10	☐	Attribute 10
49	XMEDIAK	JGTGPNR	XMEDIAK		☐	XMEDIAK	☐	IS-M: Media customer
50	XMEDIAKLV	JGTGPNR	XMEDIAKLV		☐	XMKLV	☐	IS-M: Deletion Flag for Media Customer
51	XMEDIAKLKZ	JGTGPNR	XMEDIAKLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
52	XMEDIAKSP	JGTGPNR	XMEDIAKSP		☐	XMKSPE	☐	IS-M: Lock Indicator for Media Customer
53	BON	JGTGPNR	BON		☐	JBONITAET	☐	IS-M: Creditworthiness Indicator
54	AUFSD	KNA1	AUFSD		☐	AUFSD_X	☐	Central order block for customer
55	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
56	BRSCH	KNA1	BRSCH		☐	BRSCH	☐	Industry key
57	FAKSD	KNA1	FAKSD		☐	FAKSD_X	☐	Central billing block for customer
58	KTOKD	KNA1	KTOKD		☐	KTOKD	☐	Customer Account Group
59	SPERR	KNA1	SPERR		☐	SPERB_X	☐	Central posting block
60	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
61	COUNC	KNA1	COUNC		☐	COUNC	☐	County Code
62	CITYC	KNA1	CITYC		☐	CITYC	☐	City Code
63	TXJCD	KNA1	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
64	AUFSD_KNVV	KNVV	AUFSD		☐	AUFSD_V	☐	Customer order block (sales area)
65	LOEVM_KNVV	KNVV	LOEVM		☐	LOEVM_V	☐	Deletion flag for customer (sales level)
66	VERSG	KNVV	VERSG		☐	STGKU	☐	Customer Statistics Group
67	KALKS	KNVV	KALKS		☐	KALKS	☐	Pricing procedure assigned to this customer
68	KDGRP	KNVV	KDGRP		☐	KDGRP	☐	Customer group
69	KONDA	KNVV	KONDA		☐	KONDA	☐	Price Group (Customer)
70	PLTYP	KNVV	PLTYP		☐	PLTYP	☐	Price list type
71	INCO1	KNVV	INCO1		☐	INCO1	☐	Incoterms (part 1)
72	INCO2	KNVV	INCO2		☐	INCO2	☐	Incoterms (part 2)
73	EIKTO	KNVV	EIKTO		☐	EIKTO	☐	Shipper's (Our) Account Number at the Customer or Vendor
74	MRNKZ	KNVV	MRNKZ		☐	MRNKZ	☐	Manual invoice maintenance
75	PERFK	KNVV	PERFK		☐	PERFK	☐	Invoice dates (calendar identification)
76	WAERS	KNVV	WAERS		☐	WAERS_V02D	☐	Currency
77	KTGRD	KNVV	KTGRD		☐	KTGRD	☐	Account assignment group for this customer
78	ZTERM	KNVV	ZTERM		☐	DZTERM	☐	Terms of payment key
79	VKGRP	KNVV	VKGRP		☐	VKGRP	☐	Sales group
80	VKBUR	KNVV	VKBUR		☐	VKBUR	☐	Sales office
81	KURST	KNVV	KURST		☐	KURST	☐	Exchange Rate Type
82	MK_LOEVM	JJTVM	MK_LOEVM		☐	LOEVM_ISP	☐	Deletion Flag for Master Data in Media Sales & Distribution
83	MK_LOEKZ	JJTVM	MK_LOEKZ		☐	LOEKZ_ISP	☐	Deletion Indicator for Master Data in Media Sales & Dist.
84	MK_ERFUSER	JJTVM	ERFUSER		☐	ERFUSER	☐	Created By
85	MK_ERFDATE	JJTVM	ERFDATE		☐	ERFDATE	☐	Created On
86	MK_ERFTIME	JJTVM	ERFTIME		☐	ERFTIME	☐	Time Created
87	MK_AENUSER	JJTVM	AENUSER		☐	AENUSER	☐	Last Changed By
88	MK_AENDATE	JJTVM	AENDATE		☐	AENDATE	☐	Date of Last Change
89	MK_AENTIME	JJTVM	AENTIME		☐	AENTIME	☐	Time of Last Change
90	XNK	JJTVM	XNK		☐	XNEUKUNDE	☐	IS-M: New customer indicator
91	KONKAUS	JJTVM	KONKAUS		☐	KONKAUS	☐	IS-M: Competitor exclusion
92	XMAN	JJTVM	XMAN		☐	XMANUSKRIP	☐	IS-M: Processing of Ad Booking Details Requested Indicator
93	TOL	JJTVM	TOL		☐	SIZE_TOL	☐	IS-M: Deviation tolerance as a percentage value
94	RE_STELL	JJTVM	RE_STELL		☐	RE_STELL	☐	IS-M: Billing split
95	XORTSPR	JJTVM	XORTSPR		☐	XORTSPREIS	☐	IS-M/AM: Local Customer Indicator
96	BLART	JJTVM	BLART		☐	PAM_BELART	☐	IS-M: Voucher Type (Proof)
97	BLANZ	JJTVM	BLANZ		☐	PAM_BELANZ	☐	IS-M: Number of Voucher Copies
98	XABSCHL	JJTVM	XABSCHL		☐	XABSCHLUSS	☐	IS-M: Contract Customer Indicator
99	MAX_UNT	JJTVM	MAX_UNT		☐	MAX_UNT	☐	IS-M: Maximum Interruption in Validity Period (in Months)
100	B_AUSR	JJTVM	B_AUSR		☐	ABSCHL_BEG	☐	IS-M: Rule for Contract Start
101	E_AUSR	JJTVM	E_AUSR		☐	ABSCHL_END	☐	IS-M: Rule for Contract End
102	REG_DAU	JJTVM	REG_DAU		☐	ABSCHLZEIT	☐	IS-M: Standard Validity Period for Contracts (in Months)
103	AB_TOL	JJTVM	AB_TOL		☐	ABSCHL_TOL	☐	IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)
104	MIN_GUT	JJTVM	MIN_GUT		☐	MIN_GUTSCH	☐	IS-M: De Minimis Limitation for Contract Credit Memo
105	MIN_LAST	JJTVM	MIN_LAST		☐	MIN_LAST	☐	IS-M/AM: De Minimis Limitation for Contract Debit Memo
106	MK_BON	JJTVM	MK_BON		☐	JBONITAET	☐	IS-M: Creditworthiness Indicator
107	MK_XAGEN	JJTVM	MK_XAGEN		☐	XAGENTUR	☐	IS-M: Agency Indicator
108	MK_XART	JJTVM	MK_XART		☐	XAGEN_KREA	☐	IS-M: Creative Boutique Indicator
109	MK_XSTR	JJTVM	MK_XSTR		☐	XAGEN_STR	☐	IS-M: Distribution Agency Indicator
110	MK_XPLAN	JJTVM	MK_XPLAN		☐	XAGEN_PLAN	☐	IS-M: Planning Agency Indicator
111	MK_ABRKAG	JJTVM	MK_ABRKAG		☐	JABRKALAG	☐	IS-M: Agency Billing Schedule (Calendar Identification)
112	MKAGEN_GRU	JJTVM	MKAGEN_GRU		☐	AGEN_GRUP	☐	IS-M: Agency Type
113	KUKARR	JJTVM	KUKARR		☐	JKUKARR	☐	IS-M: Customer Profile
114	MK_DUB	JJTVM	MK_DUB		☐	JDUBIOS	☐	IS-M: Credit Query Indicator
115	K_ANZ	JJTVM	K_ANZ		☐	KARENZANZ	☐	IS-M/AM: Grace Period for Changes to Ad Prices
116	K_ANZ_ME	JJTVM	K_ANZ_ME		☐	JJMEINS	☐	IS-M: Basic Unit of Measure for Time
117	K_DL	JJTVM	K_DL		☐	KARENZDL	☐	IS-M: Grace Period for Changes to Service Prices
118	K_DL_ME	JJTVM	K_DL_ME		☐	JJMEINS	☐	IS-M: Basic Unit of Measure for Time
119	K_SI	JJTVM	K_SI		☐	KARENZSI	☐	IS-M: Grace Period for Changes to Prices of Ad Inserts
120	K_SI_ME	JJTVM	K_SI_ME		☐	JJMEINS	☐	IS-M: Basic Unit of Measure for Time
121	K_VER	JJTVM	K_VER		☐	KARENZVER	☐	IS-M: Grace Period for Changes to Distribution Prices
122	K_VER_ME	JJTVM	K_VER_ME		☐	JJMEINS	☐	IS-M: Basic Unit of Measure for Time
123	K_WSP	JJTVM	K_WSP		☐	KARENZWSP	☐	IS-M: Grace Period for Changes to Commercial Prices
124	K_WSP_ME	JJTVM	K_WSP_ME		☐	JJMEINS	☐	IS-M: Basic Unit of Measure for Time
125	K_OL	JJTVM	K_OL		☐	KARENZOL	☐	IS-M: Grace Period for Price Changes in Online Advertising
126	K_OL_ME	JJTVM	K_OL_ME		☐	JJMEINS	☐	IS-M: Basic Unit of Measure for Time
127	KUNNR_SD	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
128	AUFORG	JGTGPNR	AUFORG		☐	VKBUR	☐	Sales office
129	XVERLAG	JGTGPNR	XVERLAG		☐	XVERLAG	☐	IS-M: Publisher Indicator
130	XVERLLOEV	JGTGPNR	XVERLLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
131	XVERLSPE	JGTGPNR	XVERLSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
132	XVERLEIG	JGTGPNR	XVERLEIG		☐	XVERLEIG	☐	IS-M: Indicator: Owned By Publisher
133	ISPCVERL	JGTGPNR	ISPCVERL		☐	ISPVERL	☐	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
134	REFBELEG	JGTGPNR	REFBELEG		☐	REMELD_ISP	☐	IS-M/SD: Reference Document in Legacy System
135	GP_DUB	JGTGPNR	GP_DUB		☐	JDUBIOS	☐	IS-M: Credit Query Indicator
136	XAGEN	JGTGPNR	XAGEN		☐	XAGENTUR	☐	IS-M: Agency Indicator
137	XAGENLV	JGTGPNR	XAGENLV		☐	XARLV	☐	IS-M: Agency Deletion Flag
138	XAGENLKZ	JGTGPNR	XAGENLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
139	XAGENLSP	JGTGPNR	XAGENLSP		☐	XARSPE	☐	IS-M: Agency Lock Indicator
140	AGEN_ART	JGTGPNR	AGEN_ART		☐	XAGEN_KREA	☐	IS-M: Creative Boutique Indicator
141	AGEN_STR	JGTGPNR	AGEN_STR		☐	XAGEN_STR	☐	IS-M: Distribution Agency Indicator
142	AGEN_PLAN	JGTGPNR	AGEN_PLAN		☐	XAGEN_PLAN	☐	IS-M: Planning Agency Indicator
143	AGEN_GRU	JGTGPNR	AGEN_GRU		☐	AGEN_GRUP	☐	IS-M: Agency Type
144	VERLVKORG	JGTGPNR	VERLVKORG		☐	VKORG	☐	Sales Organization
145	XINSER	JGTGPNR	XINSER		☐	XINSERENT	☐	IS-M: Selection Indicator for Advertiser
146	XINSERLV	JGTGPNR	XINSERLV		☐	XISLV	☐	IS-M: Advertiser Deletion Flag
147	XINSERLKZ	JGTGPNR	XINSERLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
148	XINSERSP	JGTGPNR	XINSERSP		☐	XISSPE	☐	IS-M: Advertiser Lock Indicator
149	STCEG	KNA1	STCEG		☐	STCEG	☐	VAT Registration Number
150	FAKSD_KNVV	KNVV	FAKSD		☐	FAKSD_V	☐	Billing block for customer (sales and distribution)
151	DRSTS	JJTVM	DRSTS		☐	JHDRSTS	☐	IS-M: Print Control Procedure
152	VKBOF	JJTVM	VKBOF		☐	JVKBUR_OFF	☐	IS-M: Alternative sales office for collecting responses
153	ZLSCHB	JJTVM	ZLSCHB		☐	JHZLSCHB	☐	IS-M/AM: Payment Method for Customer Bonus Settlement
154	ABE	JJTVM	ABE		☐	ABSCH_ERN	☐	IS-M: Indicator: Automatic Contract Renewal
155	MAX_RDAT	JJTVM	MAX_RDAT		☐	MAX_RDAT	☐	IS-M: Maximum Backdating Start of Validity Period (Months)
156	MENGA	JJTVM	MENGA		☐	ANPASS	☐	Quantity Adjustment for Contract Validity Period Change
157	RABA	JJTVM	RABA		☐	RABATTANP	☐	IS-M: Disc./Price Adjustment During Contract Validity Period
158	RABSPERR	JJTVM	RABSPERR		☐	RABSPERR	☐	IS-M: Block higher-level discounts indicator
159	RANPASS	JJTVM	RANPASS		☐	RANPASS	☐	IS-M: Increase Discount in the Case of Over-Fulfillment Ind.
160	RANPASSL	JJTVM	RANPASSL		☐	RANPASSL	☐	IS-M: Reduce Discount in the Case of Non-Fulfillment Ind.
161	QABR	JJTVM	QABR		☐	QABR	☐	IS-M: Define Settlement for System Contracts
162	ZLSCHA	JJTVM	ZLSCHA		☐	JHZLSCHA	☐	IS-M: Payment Method for Contract Settlement
163	FAKSA	JJTVM	FAKSA		☐	PAM_FAKSP	☐	IS-M: Billing Block
164	EABR_NACHL	JJTVM	EABR_NACHL		☐	EABR_NACHL	☐	IS-M: Time of Final Settlement After Runtime (in Months)
165	BEST_PR	JJTVM	BEST_PR		☐	BEST_PR	☐	IS-M: Apply Best Conditions to Number / Quantity
166	PAR_ABS	JJTVM	PAR_ABS		☐	PAR_ABS	☐	IS-M: Work with Parallel Contracts Indicator
167	TO_WARN	JJTVM	TO_WARN		☐	TO_WARN	☐	IS-M: Generate Advance Warning Automatically
168	AE	JJTVM	AE		☐	AGEN_AE	☐	IS-M: Agency Commission Entitlement
169	AB_VOR	JJTVM	AB_VOR		☐	AB_VOR	☐	IS-M: Advance Bonus Indicator
170	ZTEGR	JJTVM	ZTEGR		☐	GR_ZTERM	☐	IS-M: Terms of Payment Group
171	ARAB	JJTVM	ARAB		☐	ARABATT	☐	IS-M: Qualifies for Contract Indicator
172	XCPDK	KNA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?

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