SAP ABAP Table JJIVM (IS-PAM: Media sales area customer (data part))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	JJIVM	Table Relationship Diagram
Short Description	IS-PAM: Media sales area customer (data part)

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	MK_LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
2	MK_LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
3	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
4	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
5	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
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	XNK	☐	XNEUKUNDE	XFELD	CHAR	1	0	IS-M: New customer indicator
11	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
12	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
13	MK_XAGEN	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
14	MK_XSTR	☐	XAGEN_STR	XFELD	CHAR	1	0	IS-M: Distribution Agency Indicator
15	MK_XPLAN	☐	XAGEN_PLAN	XFELD	CHAR	1	0	IS-M: Planning Agency Indicator
16	MK_XART	☐	XAGEN_KREA	XFELD	CHAR	1	0	IS-M: Creative Boutique Indicator
17	MK_ABRKAG	☐	JABRKALAG	WFCID	CHAR	2	0	IS-M: Agency Billing Schedule (Calendar Identification)	TJG61
18	MKAGEN_GRU	☐	AGEN_GRUP	AGEN_GRUP	CHAR	1	0	IS-M: Agency Type	TJGJ4
19	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
20	MK_DUB	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0
21	MK_BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
22	XMAN	☐	XMANUSKRIP	XFELD	CHAR	1	0	IS-M: Processing of Ad Booking Details Requested Indicator
23	ZTEGR	☐	GR_ZTERM	GR_ZTERM	CHAR	2	0	IS-M: Terms of Payment Group	TJJB7
24	TOL	☐	SIZE_TOL	CHAR03	CHAR	3	0	IS-M: Deviation tolerance as a percentage value
25	RE_STELL	☐	RE_STELL	RE_STELL	CHAR	1	0	IS-M: Billing split	TJJB3
26	DRSTS	☐	JHDRSTS	JHDRSTS	CHAR	2	0	IS-M: Print Control Procedure	TJJB5
27	XORTSPR	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
28	VKBOF	☐	JVKBUR_OFF	VKBUR	CHAR	4	0	IS-M: Alternative sales office for collecting responses	TVKBZ
29	BLART	☐	PAM_BELART	PAM_BELART	CHAR	4	0	IS-M: Voucher Type (Proof)	TJJB1
30	BLANZ	☐	PAM_BELANZ	NUMC5	NUMC	5	0	IS-M: Number of Voucher Copies
31	ZLSCHB	☐	JHZLSCHB	ZLSCH	CHAR	1	0	IS-M/AM: Payment Method for Customer Bonus Settlement	T042Z
32	K_ANZ	☐	KARENZANZ	JKARENZ	NUMC	4	0	IS-M/AM: Grace Period for Changes to Ad Prices
33	K_ANZ_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
34	K_DL	☐	KARENZDL	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Service Prices
35	K_DL_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
36	K_SI	☐	KARENZSI	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Prices of Ad Inserts
37	K_SI_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
38	K_VER	☐	KARENZVER	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Distribution Prices
39	K_VER_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
40	K_WSP	☐	KARENZWSP	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Commercial Prices
41	K_WSP_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
42	K_OL	☐	KARENZOL	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes in Online Advertising
43	K_OL_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
44	.INCLUDE	☐				0	0	IS-PAM: Media sales area customer - COA data
45	XABSCHL	☐	XABSCHLUSS	XFELD	CHAR	1	0	IS-M: Contract Customer Indicator
46	ABE	☐	ABSCH_ERN	JNFELD	CHAR	1	0	IS-M: Indicator: Automatic Contract Renewal
47	MAX_UNT	☐	MAX_UNT	NUMC2	NUMC	2	0	IS-M: Maximum Interruption in Validity Period (in Months)
48	MAX_RDAT	☐	MAX_RDAT	SYNUM02	NUMC	2	0	IS-M: Maximum Backdating Start of Validity Period (Months)
49	MENGA	☐	ANPASS	JNFELD	CHAR	1	0	Quantity Adjustment for Contract Validity Period Change
50	ARAB	☐	ARABATT	JNFELD	CHAR	1	0	IS-M: Qualifies for Contract Indicator
51	RABA	☐	RABATTANP	JH_XRABANP	CHAR	1	0	IS-M: Disc./Price Adjustment During Contract Validity Period
52	RABSPERR	☐	RABSPERR	JNFELD	CHAR	1	0	IS-M: Block higher-level discounts indicator
53	RANPASS	☐	RANPASS	JNFELD	CHAR	1	0	IS-M: Increase Discount in the Case of Over-Fulfillment Ind.
54	RANPASSL	☐	RANPASSL	JNFELD	CHAR	1	0	IS-M: Reduce Discount in the Case of Non-Fulfillment Ind.
55	QABR	☐	QABR	QABR	CHAR	1	0	IS-M: Define Settlement for System Contracts
56	B_AUSR	☐	ABSCHL_BEG	ABSCHL_BEG	CHAR	1	0	IS-M: Rule for Contract Start	TJJV14
57	E_AUSR	☐	ABSCHL_END	ABSCHL_END	CHAR	1	0	IS-M: Rule for Contract End	TJJV15
58	REG_DAU	☐	ABSCHLZEIT	SYNUM02	NUMC	2	0	IS-M: Standard Validity Period for Contracts (in Months)
59	AB_TOL	☐	ABSCHL_TOL	NUMC03	NUMC	3	0	IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)
60	ZLSCHA	☐	JHZLSCHA	ZLSCH	CHAR	1	0	IS-M: Payment Method for Contract Settlement	T042Z
61	FAKSA	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
62	EABR_NACHL	☐	EABR_NACHL	SYNUM02	NUMC	2	0	IS-M: Time of Final Settlement After Runtime (in Months)
63	BEST_PR	☐	BEST_PR	JNFELD	CHAR	1	0	IS-M: Apply Best Conditions to Number / Quantity
64	PAR_ABS	☐	PAR_ABS	JNFELD	CHAR	1	0	IS-M: Work with Parallel Contracts Indicator
65	AB_VOR	☐	AB_VOR	JNFELD	CHAR	1	0	IS-M: Advance Bonus Indicator
66	TO_WARN	☐	TO_WARN	JNFELD	CHAR	1	0	IS-M: Generate Advance Warning Automatically
67	MIN_GUT	☐	MIN_GUTSCH	ISPBETR07	CURR	7	2	IS-M: De Minimis Limitation for Contract Credit Memo
68	MIN_LAST	☐	MIN_LAST	ISPBETR07	CURR	7	2	IS-M/AM: De Minimis Limitation for Contract Debit Memo

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJIVM	BLART	TJJB1	BLART	REF	1	CN
2	JJIVM	B_AUSR	TJJV14	B_AUSR	REF	C	CN
3	JJIVM	DRSTS	TJJB5	DRSTS	REF	1	CN
4	JJIVM	E_AUSR	TJJV15	E_AUSR	REF	C	CN
5	JJIVM	FAKSA	TVFS	FAKSP	REF	1	CN
6	JJIVM	KONKAUS	TJH89	KONKAUS	REF	C	CN
7	JJIVM	KUKARR	TJJ95	KUKARR	REF	C	CN
8	JJIVM	K_ANZ_ME	T006	MSEHI	REF	C	CN
9	JJIVM	K_DL_ME	T006	MSEHI	REF	C	CN
10	JJIVM	K_OL_ME	T006	MSEHI	REF	C	CN
11	JJIVM	K_SI_ME	T006	MSEHI	REF	C	CN
12	JJIVM	K_VER_ME	T006	MSEHI	REF	C	CN
13	JJIVM	K_WSP_ME	T006	MSEHI	REF	C	CN
14	JJIVM	MKAGEN_GRU	TJGJ4	AGEN_GRU	REF	1	N
15	JJIVM	MK_ABRKAG	TJG61	IDENT	REF	1	CN
16	JJIVM	MK_BON	TJGJ2	BONITAET	KEY	1	CN
17	JJIVM	MK_DUB	TJGJ0	DUBIOS	KEY	1	CN
18	JJIVM	RE_STELL	TJJB3	RE_STELL	REF	1	CN
19	JJIVM	VKBOF	TVKBZ	VKBUR	REF	1	CN
20	JJIVM	ZLSCHA	T042Z	ZLSCH	KEY	1	CN
21	JJIVM	ZLSCHB	T042Z	ZLSCH	REF	1	CN
22	JJIVM	ZTEGR	TJJB7	ZTEGR	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in