SAP ABAP Table BAPIBUSISM007_MC_SALES (IS-M: Business Partner Media Sales Customer (JJTVM))

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIBUSISM007_MC_SALES	Table Relationship Diagram
Short Description	IS-M: Business Partner Media Sales Customer (JJTVM)

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	SALESORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
2	DISTR_CHAN	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
3	DIVISION	☑	SPART	SPART	CHAR	2	0	Division	TSPA
4	NEW_CUSTOMER	☐	XNEUKUNDE	XFELD	CHAR	1	0	IS-M: New customer indicator
5	CUSTOMER_PROFILE	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
6	COMPETITOR_EXCLUSION	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
7	AGENCY	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
8	CREATIVE_AGENCY	☐	XAGEN_KREA	XFELD	CHAR	1	0	IS-M: Creative Boutique Indicator
9	DISTRIBUTION_AGENCY	☐	XAGEN_STR	XFELD	CHAR	1	0	IS-M: Distribution Agency Indicator
10	PLANNING_AGENCY	☐	XAGEN_PLAN	XFELD	CHAR	1	0	IS-M: Planning Agency Indicator
11	AGENCY_TYPE	☐	AGEN_GRUP	AGEN_GRUP	CHAR	1	0	IS-M: Agency Type	TJGJ4
12	AGENCY_BILLING_SCHEDULE	☐	JABRKALAG	WFCID	CHAR	2	0	IS-M: Agency Billing Schedule (Calendar Identification)	*
13	AGENCY_COMMISSION	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
14	CREDIT_STANDING_QUERY	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0
15	CREDITWORTHINESS	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
16	PROC_AD_BOOKING_DETAILS_REQ	☐	XMANUSKRIP	XFELD	CHAR	1	0	IS-M: Processing of Ad Booking Details Requested Indicator
17	TERMS_OF_PAYMENT_GROUP	☐	GR_ZTERM	GR_ZTERM	CHAR	2	0	IS-M: Terms of Payment Group	TJJB7
18	DEVIATION_TOLERANCE	☐	SIZE_TOL	CHAR03	CHAR	3	0	IS-M: Deviation tolerance as a percentage value
19	BILLING_SPLIT	☐	RE_STELL	RE_STELL	CHAR	1	0	IS-M: Billing split	TJJB3
20	PRINT_CONTROL_SCHEMA	☐	JHDRSTS	JHDRSTS	CHAR	2	0	IS-M: Print Control Procedure	TJJB5
21	LOCAL_CUSTOMER	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
22	COLLECTING_RESPONSE_SALE_OFF	☐	JVKBUR_OFF	VKBUR	CHAR	4	0	IS-M: Alternative sales office for collecting responses	*
23	VOUCHER_COPY_TYPE	☐	PAM_BELART	PAM_BELART	CHAR	4	0	IS-M: Voucher Type (Proof)	TJJB1
24	VOUCHER_COPIES_NO	☐	PAM_BELANZ	NUMC5	NUMC	5	0	IS-M: Number of Voucher Copies
25	PYMT_METH_BONUS_SETTLEMENT	☐	JHZLSCHB	ZLSCH	CHAR	1	0	IS-M/AM: Payment Method for Customer Bonus Settlement	T042Z
26	GRACE_PRD_CHANGE_PRICE_AD	☐	KARENZANZ	JKARENZ	NUMC	4	0	IS-M/AM: Grace Period for Changes to Ad Prices
27	GRACE_PRD_TIME_UNIT_AD	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	*
28	GRACE_PRD_TIME_UNIT_ISO_AD	☐	JJMEINS_ISO	ISOCD	CHAR	3	0	IS-M: ISO Code for Basic Unit of Measure for Time
29	GRACE_PRD_CHANGE_PRICE_SV	☐	KARENZDL	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Service Prices
30	GRACE_PRD_TIME_UNIT_SV	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	*
31	GRACE_PRD_TIME_UNIT_ISO_SV	☐	JJMEINS_ISO	ISOCD	CHAR	3	0	IS-M: ISO Code for Basic Unit of Measure for Time
32	GRACE_PRD_CHANGE_PRICE_AI	☐	KARENZSI	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Prices of Ad Inserts
33	GRACE_PRD_TIME_UNIT_AI	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
34	GRACE_PRD_TIME_UNIT_ISO_AI	☐	JJMEINS_ISO	ISOCD	CHAR	3	0	IS-M: ISO Code for Basic Unit of Measure for Time
35	GRACE_PRD_CHANGE_PRICE_DT	☐	KARENZVER	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Distribution Prices
36	GRACE_PRD_TIME_UNIT_DT	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
37	GRACE_PRD_TIME_UNIT_ISO_DT	☐	JJMEINS_ISO	ISOCD	CHAR	3	0	IS-M: ISO Code for Basic Unit of Measure for Time
38	GRACE_PRD_CHANGE_PRICE_CM	☐	KARENZWSP	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Commercial Prices
39	GRACE_PRD_TIME_UNIT_CM	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
40	GRACE_PRD_TIME_UNIT_ISO_CM	☐	JJMEINS_ISO	ISOCD	CHAR	3	0	IS-M: ISO Code for Basic Unit of Measure for Time
41	GRACE_PRD_CHANGE_PRICE_OL	☐	KARENZOL	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes in Online Advertising
42	GRACE_PRD_TIME_UNIT_OL	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	*
43	GRACE_PRD_TIME_UNIT_ISO_OL	☐	JJMEINS_ISO	ISOCD	CHAR	3	0	IS-M: ISO Code for Basic Unit of Measure for Time
44	CONTRACT_CUSTOMER	☐	XABSCHLUSS	XFELD	CHAR	1	0	IS-M: Contract Customer Indicator
45	CONTRACT_RENEWAL_AUTOMATIC	☐	ABSCH_ERN	JNFELD	CHAR	1	0	IS-M: Indicator: Automatic Contract Renewal
46	CONTRACT_MAX_INTERRUPTION	☐	MAX_UNT	NUMC2	NUMC	2	0	IS-M: Maximum Interruption in Validity Period (in Months)
47	CONTRACT_MAX_BACKDATING	☐	MAX_RDAT	SYNUM02	NUMC	2	0	IS-M: Maximum Backdating Start of Validity Period (Months)
48	CONTRACT_TARGET_ADJ_TO_PERIOD	☐	ANPASS	JNFELD	CHAR	1	0	Quantity Adjustment for Contract Validity Period Change
49	CONTRACT_DISCOUNT_CUSTOMER	☐	ARABATT	JNFELD	CHAR	1	0	IS-M: Qualifies for Contract Indicator
50	CONTRACT_DISCOUNT_ADJUSTMENT	☐	RABATTANP	JH_XRABANP	CHAR	1	0	IS-M: Disc./Price Adjustment During Contract Validity Period
51	CONTRACT_DISCOUNT_BLOCK	☐	RABSPERR	JNFELD	CHAR	1	0	IS-M: Block higher-level discounts indicator
52	CONTRACT_OVERFULFILL_INCREASE	☐	RANPASS	JNFELD	CHAR	1	0	IS-M: Increase Discount in the Case of Over-Fulfillment Ind.
53	CONTRACT_UNDERFULFILL_DECREASE	☐	RANPASSL	JNFELD	CHAR	1	0	IS-M: Reduce Discount in the Case of Non-Fulfillment Ind.
54	SYSTEM_CONTRACTS_SETTLEMENT	☐	QABR	QABR	CHAR	1	0	IS-M: Define Settlement for System Contracts
55	CONTRACT_START_RULE	☐	ABSCHL_BEG	ABSCHL_BEG	CHAR	1	0	IS-M: Rule for Contract Start	TJJV14
56	CONTRACT_END_RULE	☐	ABSCHL_END	ABSCHL_END	CHAR	1	0	IS-M: Rule for Contract End	TJJV15
57	CONTRACT_VALIDITY_PERIOD	☐	ABSCHLZEIT	SYNUM02	NUMC	2	0	IS-M: Standard Validity Period for Contracts (in Months)
58	CONTRACT_TOLERANCE_PERCENTAGE	☐	ABSCHL_TOL	NUMC03	NUMC	3	0	IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)
59	PYMT_METH_CONTRACT	☐	JHZLSCHA	ZLSCH	CHAR	1	0	IS-M: Payment Method for Contract Settlement	T042Z
60	BILL_BLOCK	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
61	CONTRACT_STL_WAITING_PERIOD	☐	EABR_NACHL	SYNUM02	NUMC	2	0	IS-M: Time of Final Settlement After Runtime (in Months)
62	CONTRACT_BEST_CONDITIONS	☐	BEST_PR	JNFELD	CHAR	1	0	IS-M: Apply Best Conditions to Number / Quantity
63	PARALLEL_ASSIGNMENT	☐	PAR_ABS	JNFELD	CHAR	1	0	IS-M: Work with Parallel Contracts Indicator
64	CONTRACT_ADVANCE_BONUS	☐	AB_VOR	JNFELD	CHAR	1	0	IS-M: Advance Bonus Indicator
65	CONTRACT_WARNING_AUTOMATIC	☐	TO_WARN	JNFELD	CHAR	1	0	IS-M: Generate Advance Warning Automatically
66	CONTRACT_CREDIT_DEMINLIM	☐	MIN_GUTSCH	ISPBETR07	CURR	7	2	IS-M: De Minimis Limitation for Contract Credit Memo
67	CONTRACT_DEBIT_DEMINLIM	☐	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	BAPIBUSISM007_MC_SALES	AGENCY_TYPE	TJGJ4	AGEN_GRU	REF	1	N
2	BAPIBUSISM007_MC_SALES	BILLING_SPLIT	TJJB3	RE_STELL	REF	1	CN
3	BAPIBUSISM007_MC_SALES	BILL_BLOCK	TVFS	FAKSP	REF	1	CN
4	BAPIBUSISM007_MC_SALES	COMPETITOR_EXCLUSION	TJH89	KONKAUS	REF	C	CN
5	BAPIBUSISM007_MC_SALES	CONTRACT_END_RULE	TJJV15	E_AUSR	REF	C	CN
6	BAPIBUSISM007_MC_SALES	CONTRACT_START_RULE	TJJV14	B_AUSR	REF	C	CN
7	BAPIBUSISM007_MC_SALES	CREDITWORTHINESS	TJGJ2	BONITAET	KEY	1	CN
8	BAPIBUSISM007_MC_SALES	CREDIT_STANDING_QUERY	TJGJ0	DUBIOS	KEY	1	CN
9	BAPIBUSISM007_MC_SALES	CUSTOMER_PROFILE	TJJ95	KUKARR	REF	C	CN
10	BAPIBUSISM007_MC_SALES	DISTR_CHAN	TVTW	VTWEG	KEY	1	CN
11	BAPIBUSISM007_MC_SALES	DIVISION	TSPA	SPART	KEY	1	CN
12	BAPIBUSISM007_MC_SALES	GRACE_PRD_TIME_UNIT_AI	T006	MSEHI	REF	C	CN
13	BAPIBUSISM007_MC_SALES	GRACE_PRD_TIME_UNIT_CM	T006	MSEHI	REF	C	CN
14	BAPIBUSISM007_MC_SALES	GRACE_PRD_TIME_UNIT_DT	T006	MSEHI	REF	C	CN
15	BAPIBUSISM007_MC_SALES	PRINT_CONTROL_SCHEMA	TJJB5	DRSTS	REF	1	CN
16	BAPIBUSISM007_MC_SALES	PYMT_METH_BONUS_SETTLEMENT	T042Z	ZLSCH	REF	1	CN
17	BAPIBUSISM007_MC_SALES	PYMT_METH_CONTRACT	T042Z	ZLSCH	KEY	1	CN
18	BAPIBUSISM007_MC_SALES	SALESORG	TVKO	VKORG	KEY	1	CN
19	BAPIBUSISM007_MC_SALES	TERMS_OF_PAYMENT_GROUP	TJJB7	ZTEGR	REF	1	CN
20	BAPIBUSISM007_MC_SALES	VOUCHER_COPY_TYPE	TJJB1	BLART	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	464