SAP ABAP Table JJTVM (IS-M/AM: Media Sales Area Customer)

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	TRANSP	Transparent table
Transparent table	JJTVM	Table Relationship Diagram
Short Description	IS-M/AM: Media Sales Area Customer

Delivery and Maintenance

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

History

Last changed by/on	SAP	20110901
SAP Release Created in