SAP ABAP View JJVDB_MKK (IS-M/AM: Media Customer Header (Without 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_MKK
Short Description	IS-M/AM: Media Customer Header (Without Sales Area)
Root table	KNA1	General Data in Customer Master

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNA1	KNA1
2	JGTGPNR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	JGTGPNR	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	JGTGPNR	KUNNR	JR	EQ			AND	0	0
5	JGTGPNR	XMEDIAK		NE	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNA1	MANDT		☐	MANDT	☐	Client
2	GPNR	JGTGPNR	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
3	XGPLOE	JGTGPNR	XGPLOE		☐	JXLV_GP	☐	IS-M: Deletion Flag for General Business Partner
4	XGPLOEKZ	JGTGPNR	XGPLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
5	XGPSPE	JGTGPNR	XGPSPE		☐	XGPSPE	☐	IS-M/SD: Lock Indicator for General Business Partner
6	ERFUSER	JGTGPNR	ERFUSER		☐	ERFUSER	☐	Created By
7	ERFDATE	JGTGPNR	ERFDATE		☐	ERFDATE	☐	Created On
8	ERFTIME	JGTGPNR	ERFTIME		☐	ERFTIME	☐	Time Created
9	AENUSER	JGTGPNR	AENUSER		☐	AENUSER	☐	Last Changed By
10	AENDATE	JGTGPNR	AENDATE		☐	AENDATE	☐	Date of Last Change
11	AENTIME	JGTGPNR	AENTIME		☐	AENTIME	☐	Time of Last Change
12	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
13	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
14	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
15	GFORM	JGTGPNR	GFORM		☐	GFORM	☐	Legal status
16	BRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
17	BRAN1	JGTGPNR	BRAN1		☐	BRAN1_D	☐	Industry code 1
18	BRAN2	JGTGPNR	BRAN2		☐	BRAN2	☐	Industry code 2
19	BRAN3	JGTGPNR	BRAN3		☐	BRAN3	☐	Industry code 3
20	BRAN4	JGTGPNR	BRAN4		☐	BRAN4	☐	Industry code 4
21	BRAN5	JGTGPNR	BRAN5		☐	BRAN5	☐	Industry code 5
22	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
23	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
24	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
25	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
26	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
27	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
28	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
29	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
30	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
31	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
32	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
33	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
34	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
35	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
36	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
37	GPKLA1	JGTGPNR	GPKLA1		☐	GPKLA	☐	IS-M: BP Class (Not in Use Yet)
38	GPKLA2	JGTGPNR	GPKLA2		☐	GPKLA2	☐	IS-M: BP Class 2
39	GPKLA3	JGTGPNR	GPKLA3		☐	GPKLA3	☐	IS-M: BP Class 3
40	GPKLA4	JGTGPNR	GPKLA4		☐	GPKLA4	☐	IS-M: BP Class 4
41	GPKLA5	JGTGPNR	GPKLA5		☐	GPKLA5	☐	IS-M: BP Class 5
42	KATR1	JGTGPNR	KATR1		☐	KATR1	☐	Attribute 1
43	KATR2	JGTGPNR	KATR2		☐	KATR2	☐	Attribute 2
44	KATR3	JGTGPNR	KATR3		☐	KATR3	☐	Attribute 3
45	KATR4	JGTGPNR	KATR4		☐	KATR4	☐	Attribute 4
46	KATR5	JGTGPNR	KATR5		☐	KATR5	☐	Attribute 5
47	KATR6	JGTGPNR	KATR6		☐	KATR6	☐	Attribute 6
48	KATR7	JGTGPNR	KATR7		☐	KATR7	☐	Attribute 7
49	KATR8	JGTGPNR	KATR8		☐	KATR8	☐	Attribute 8
50	KATR9	JGTGPNR	KATR9		☐	KATR9	☐	Attribute 9
51	KATR10	JGTGPNR	KATR10		☐	KATR10	☐	Attribute 10
52	XINTERN	JGTGPNR	XINTERN		☐	XINTERN	☐	IS-M: Internal Business Partner Indicator
53	XINTLOEV	JGTGPNR	XINTLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
54	AUFORG	JGTGPNR	AUFORG		☐	VKBUR	☐	Sales office
55	XINTSPE	JGTGPNR	XINTSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
56	VERLVKORG	JGTGPNR	VERLVKORG		☐	VKORG	☐	Sales Organization
57	ISPCVERL	JGTGPNR	ISPCVERL		☐	ISPVERL	☐	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
58	XMEDIAK	JGTGPNR	XMEDIAK		☐	XMEDIAK	☐	IS-M: Media customer
59	XMEDIAKLV	JGTGPNR	XMEDIAKLV		☐	XMKLV	☐	IS-M: Deletion Flag for Media Customer
60	XMEDIAKLKZ	JGTGPNR	XMEDIAKLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
61	XMEDIAKSP	JGTGPNR	XMEDIAKSP		☐	XMKSPE	☐	IS-M: Lock Indicator for Media Customer
62	XINSER	JGTGPNR	XINSER		☐	XINSERENT	☐	IS-M: Selection Indicator for Advertiser
63	XINSERLV	JGTGPNR	XINSERLV		☐	XISLV	☐	IS-M: Advertiser Deletion Flag
64	XINSERLKZ	JGTGPNR	XINSERLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
65	XINSERSP	JGTGPNR	XINSERSP		☐	XISSPE	☐	IS-M: Advertiser Lock Indicator
66	XAGEN	JGTGPNR	XAGEN		☐	XAGENTUR	☐	IS-M: Agency Indicator
67	XAGENLV	JGTGPNR	XAGENLV		☐	XARLV	☐	IS-M: Agency Deletion Flag
68	XAGENLKZ	JGTGPNR	XAGENLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
69	XAGENLSP	JGTGPNR	XAGENLSP		☐	XARSPE	☐	IS-M: Agency Lock Indicator
70	AGEN_ART	JGTGPNR	AGEN_ART		☐	XAGEN_KREA	☐	IS-M: Creative Boutique Indicator
71	AGEN_GRU	JGTGPNR	AGEN_GRU		☐	AGEN_GRUP	☐	IS-M: Agency Type
72	BON	JGTGPNR	BON		☐	JBONITAET	☐	IS-M: Creditworthiness Indicator
73	XVERLAG	JGTGPNR	XVERLAG		☐	XVERLAG	☐	IS-M: Publisher Indicator
74	XVERLLOEV	JGTGPNR	XVERLLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
75	XVERLSPE	JGTGPNR	XVERLSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
76	XVERLEIG	JGTGPNR	XVERLEIG		☐	XVERLEIG	☐	IS-M: Indicator: Owned By Publisher
77	AUFSD	KNA1	AUFSD		☐	AUFSD_X	☐	Central order block for customer
78	BAHNE	KNA1	BAHNE		☐	BAHNE	☐	Express train station
79	BAHNS	KNA1	BAHNS		☐	BAHNS	☐	Train station
80	BBBNR	KNA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
81	BBSNR	KNA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
82	BEGRU	KNA1	BEGRU		☐	BRGRU	☐	Authorization Group
83	BUBKZ	KNA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
84	DATLT	KNA1	DATLT		☐	DATLT	☐	Data communication line no.
85	ERDAT	KNA1	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
86	ERNAM	KNA1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
87	EXABL	KNA1	EXABL		☐	EXABL	☐	Indicator: Unloading points exist
88	FAKSD	KNA1	FAKSD		☐	FAKSD_X	☐	Central billing block for customer
89	FISKN	KNA1	FISKN		☐	FISKN_D	☐	Account number of the master record with the fiscal address
90	KNAZK	KNA1	KNAZK		☐	KNAZK	☐	Working Time Calendar
91	KNRZA	KNA1	KNRZA		☐	KNRZA	☐	Account number of an alternative payer
92	KONZS	KNA1	KONZS		☐	KONZS	☐	Group key
93	KTOKD	KNA1	KTOKD		☐	KTOKD	☐	Customer Account Group
94	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
95	LIFNR_KNA1	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
96	LIFSD	KNA1	LIFSD		☐	LIFSD_X	☐	Central delivery block for the customer
97	LOCCO	KNA1	LOCCO		☐	LOCCO	☐	City Coordinates
98	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
99	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
100	COUNC	KNA1	COUNC		☐	COUNC	☐	County Code
101	CITYC	KNA1	CITYC		☐	CITYC	☐	City Code
102	RPMKR	KNA1	RPMKR		☐	RPMKR	☐	Regional market
103	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
104	SPERR	KNA1	SPERR		☐	SPERB_X	☐	Central posting block
105	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
106	STCD1	KNA1	STCD1		☐	STCD1	☐	Tax Number 1
107	STCD2	KNA1	STCD2		☐	STCD2	☐	Tax Number 2
108	STKZA	KNA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
109	STKZU	KNA1	STKZU		☐	STKZU	☐	Liable for VAT
110	LZONE	KNA1	LZONE		☐	LZONE	☐	Transportation zone to or from which the goods are delivered
111	XCPDK	KNA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
112	XZEMP	KNA1	XZEMP		☐	XREGU	☐	Indicator: Is an alternative payer allowed in document?
113	VBUND	KNA1	VBUND		☐	RASSC	☐	Company ID of trading partner
114	STCEG	KNA1	STCEG		☐	STCEG	☐	VAT Registration Number
115	DEAR1	KNA1	DEAR1		☐	DEAR1	☐	Indicator: Competitor
116	DEAR2	KNA1	DEAR2		☐	DEAR2	☐	Indicator: Sales partner
117	DEAR3	KNA1	DEAR3		☐	DEAR3	☐	Indicator: Sales prospect
118	DEAR4	KNA1	DEAR4		☐	DEAR4	☐	Indicator for customer type 4
119	DEAR5	KNA1	DEAR5		☐	DEAR5	☐	ID for default sold-to party
120	EKONT	KNA1	EKONT		☐	EKONT	☐	Initial contact
121	UMSAT	KNA1	UMSAT		☐	UMSAT	☐	Annual sales
122	UMJAH	KNA1	UMJAH		☐	UMJAH	☐	Year For Which Sales are Given
123	UWAER	KNA1	UWAER		☐	UWAER	☐	Currency of Sales Volume
124	JMZAH	KNA1	JMZAH		☐	JMZAH	☐	Yearly number of employees
125	JMJAH	KNA1	JMJAH		☐	JMJAH	☐	Year for which the number of employees is given
126	STKZN	KNA1	STKZN		☐	STKZN	☐	Natural Person
127	UMSA1	KNA1	UMSA1		☐	UMSA1	☐	Annual sales
128	TXJCD	KNA1	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
129	MCOD1	KNA1	MCOD1		☐	MCDD1	☐	Search term for matchcode search
130	MCOD2	KNA1	MCOD2		☐	MCDD2	☐	Search Term for Matchcode Search
131	MCOD3	KNA1	MCOD3		☐	MCDD3	☐	Search term for matchcode search
132	NIELS	KNA1	NIELS		☐	NIELS	☐	Nielsen ID
133	AGEN_STR	JGTGPNR	AGEN_STR		☐	XAGEN_STR	☐	IS-M: Distribution Agency Indicator
134	AGEN_PLAN	JGTGPNR	AGEN_PLAN		☐	XAGEN_PLAN	☐	IS-M: Planning Agency Indicator
135	KUNNR_SD	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
136	GP_DUB	JGTGPNR	GP_DUB		☐	JDUBIOS	☐	IS-M: Credit Query Indicator

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