SAP ABAP Table TJHVA (IS-M/AM: General Contract Attributes for 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

Table Category	TRANSP	Transparent table
Transparent table	TJHVA	Table Relationship Diagram
Short Description	IS-M/AM: General Contract Attributes for Sales Area

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	.INCLUDE	☑				0	0	IS-M: Sales Area
3	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVTA
4	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTA
5	SPART	☑	SPART	SPART	CHAR	2	0	Division	TVTA
6	ABS_TYP1	☐	ABS_TYP	ABS_TYP	CHAR	1	0	IS-M/AM: Contract Category	TJH11
7	XBEST_PR	☐	XBEST_PR	XFELD	CHAR	1	0	IS-M: Apply Best Conditions to Number / Quantity
8	EINH1	☐	AB_MEINH1	MEINS	UNIT	3	0	IS-M: Contract Units of Measurement	T006
9	EINH2	☐	AB_MEINH2	MEINS	UNIT	3	0	IS-M/AM: Contract Units of Measurement	T006
10	HITYP	☐	DHITYP	HIERATYP	CHAR	1	0	IS-M: Hierarchy Type of BP Hierarchy	TJJ69
11	XINI_KONZ	☐	XINI_KONZ	XINI_KONZ	CHAR	1	0	IS-M: Control Default Setting for Group Indicator
12	XVBONUS	☐	XVBONUS	XFELD	CHAR	1	0	IS-M: Advance Bonus Indicator
13	PROZ_BEZ	☐	ABS_PROZ	PROZBEZ	DEC	5	2	IS-M: Limit in Percent of Contract-Relevant Involvement
14	XPAR_ABS	☐	XPAR_ABS	XFELD	CHAR	1	0	IS-M: Work With Parallel Contracts Indicator
15	XQUASI	☐	ISM_QUASI	ISM_QUASI	CHAR	1	0	IS-M: Define System Contracts
16	XST_GEGES	☐	XST_GEGES	XFELD	CHAR	1	0	IS-M: Work with Barter Deal Yes/No Indicator
17	GTORE_COMP	☐	FIELDNAME	FDNAME	CHAR	30	0	Field Name	MJJVA5
18	XST_GTORE	☐	XST_GTORE	JH_GTORE	CHAR	1	0	IS-M: Largest Subsidiary Rule - Sort Criterion
19	XST_KFIND	☐	SYBATCH	SYCHAR01	CHAR	1	0	Background Processing Active
20	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
21	KALSM_KUBO	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
22	N_KALSM	☐	KALSMB_ABS	KALSM	CHAR	6	0	IS-M: Contract Output Determination Procedure	T683
23	N_KALSM_AB	☐	KALSMB_AAB	KALSM	CHAR	6	0	IS-M: Contract Settlement for Output Determination Procedure	T683
24	ABS_KOLI	☐	ABS_KOLI	PROGRAM_ID	CHAR	40	0	IS-M: Contract Condition List
25	NUMKR_A	☐	JHNUMKR_A	NUMKR	CHAR	2	0	IS-M: Number Rge for Plan.Doc.Conds in Contract Settlement
26	NUMKR_F	☐	JHNUMKR_F	NUMKR	CHAR	2	0	IS-M: Number Rge for Diff.Doc.Conds in Contract Settlement
27	QABR	☐	QABR	QABR	CHAR	1	0	IS-M: Define Settlement for System Contracts
28	XAABRREG	☐	JH_AABRREG	XFELD	CHAR	1	0	IS-M: Contract Settlement in Payer Currency Indicator
29	XABETRNET	☐	JH_ABETRNET	XFELD	CHAR	1	0	IS-M: Indicator: Settlement Amount Without Tax
30	B_AUSR	☐	ABSCHL_BEG	ABSCHL_BEG	CHAR	1	0	IS-M: Rule for Contract Start	TJJV14
31	E_AUSR	☐	ABSCHL_END	ABSCHL_END	CHAR	1	0	IS-M: Rule for Contract End	TJJV15
32	REG_DAU	☐	ABSCHLZEIT	SYNUM02	NUMC	2	0	IS-M: Standard Validity Period for Contracts (in Months)
33	EABR_NACHL	☐	EABR_NACHL	SYNUM02	NUMC	2	0	IS-M: Time of Final Settlement After Runtime (in Months)
34	XTOL_FERN	☐	XTOL_FERN	XFELD	CHAR	1	0	IS-M: Control Tolerance Levels
35	AB_TOL	☐	ABSCHL_TOL	NUMC03	NUMC	3	0	IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)
36	MIN_GUT	☐	MIN_GUTSCH	ISPBETR07	CURR	7	2	IS-M: De Minimis Limitation for Contract Credit Memo
37	MIN_LAST	☐	MIN_LAST	ISPBETR07	CURR	7	2	IS-M/AM: De Minimis Limitation for Contract Debit Memo
38	BAG_WAERS	☐	JWAERS	WAERS	CUKY	5	0	IS-M: Currency Key	TCURC
39	XST_BAG	☐	XST_BAG	XFELD	CHAR	1	0	IS-M: Control De Mnimis Limitation For Contract Settlement
40	XMENGA	☐	XANPASS	XFELD	CHAR	1	0	Quantity Adjustment for Change to Contract Validity Period
41	LFZ_VORL	☐	LFZ_VORL	NUMC02	NUMC	2	0	Lead Time for Pending Validity Period End Date (Contract)
42	XABE	☐	XABSCH_ERN	XFELD	CHAR	1	0	IS-M: Automatic Contract Renewal?
43	ERN_VORL	☐	ERN_VORL	NUMC02	NUMC	2	0	IS-M: Lead Time for Contract Renewal
44	MAX_UNT	☐	MAX_UNT	NUMC2	NUMC	2	0	IS-M: Maximum Interruption in Validity Period (in Months)
45	MAX_RDAT	☐	MAX_RDAT	SYNUM02	NUMC	2	0	IS-M: Maximum Backdating Start of Validity Period (Months)
46	XERN_AGENT	☐	XERN_AGENT	XFELD	CHAR	1	0	IS-M: Do not Renew Contract for Agency Orders
47	XERN_HINW	☐	XERN_HINW	XFELD	CHAR	1	0	IS-M: Renewal Notification Immediately/ With First Placement
48	XRABA	☐	RABATTANP	JH_XRABANP	CHAR	1	0	IS-M: Disc./Price Adjustment During Contract Validity Period
49	XRABA_ALL	☐	XRABA_ALL	XFELD	CHAR	1	0	IS-M: Discount/Price Change Affects All Billing Datasets
50	XST_RFIND	☐	XST_RFIND	XST_RFIND	NUMC	1	0	IS-M: Control discount adjustment - accepted/billed
51	XST_RKUMU	☐	XST_RKUMU	XST_RKUMU	NUMC	1	0	IS-M: Type of cumulation for rolling discount
52	XZIELANP	☐	XZIELANP	XFELD	CHAR	1	0	IS-M: Change Target Quantities For Rolling Discount
53	XRANPASS	☐	XRANPASS	XFELD	CHAR	1	0	IS-M: Increase discount in the case of over-fulfillment ind.
54	XRANPASSL	☐	XRANPASSL	XFELD	CHAR	1	0	IS-M: Reduce discount in the case of non-fulfillment ind.
55	STAND_TYP	☐	STAND_TYP	STAND_TYP	CHAR	1	0	IS-M/AM: Type for Contract Standing Screen
56	XSTAN_SUM	☐	XSTAN_SUM	XFELD	CHAR	1	0	IS-M/AM: Determine Total Types In The Contract Standing
57	XSUMRAB	☐	XSUMRAB	XFELD	CHAR	1	0	IS-M: Indicator Only original orders qual.for discount
58	XSUMFR	☐	XSUMFR	XFELD	CHAR	1	0	IS-M/AM: Indicator Only totals from other BUs which count
59	XAUTO_BEST	☐	XAUTO_BEST	XFELD	CHAR	1	0	Contract is Confirmed on Creation Indicator Yes/No Ind.
60	XNB_ZUORD	☐	XNB_ZUORD	XFELD	CHAR	1	0	IS-M: Assignment to Unconfirmed Contracts Possible? Y/N
61	XTO_BEST	☐	XTO_BEST	XFELD	CHAR	1	0	IS-M: "Confirnation Required" Indicator
62	XTO_WARN	☐	XTO_WARN	XFELD	CHAR	1	0	IS-M: Advance Warning Indicator
63	XTO_HINW	☐	XTO_HINW	XFELD	CHAR	1	0	IS-M: Generate end note indicator
64	XRABSPERR	☐	XRABSPERR	XFELD	CHAR	1	0	IS-M: Block higher-level discounts indicator
65	XBEST_FIND	☐	XBEST_FIND	XFELD	CHAR	1	0	IS-M: Indicator: Do Not Determine BU Distance
66	XFIND_HINW	☐	XFIND_HINW	XFELD	CHAR	1	0	IS-M: Output Note with Contract Determination
67	XF_HINW_GE	☐	XF_HINW_GE	XFELD	CHAR	1	0	IS-M: Control Barter Deal not Found Note
68	KONFL_STEU	☐	KONFL_STEU	XFELD	CHAR	1	0	IS-M: Display Original Assignments in Order
69	ZLSCHA	☐	JHZLSCHA	ZLSCH	CHAR	1	0	IS-M: Payment Method for Contract Settlement	T042Z
70	ZLSCHB	☐	JHZLSCHB	ZLSCH	CHAR	1	0	IS-M/AM: Payment Method for Customer Bonus Settlement	T042Z
71	PARGR	☐	JHPARGR	JHPARGR	CHAR	4	0	IS-M: Partner Determination Procedure	JHVTJJ25_FKEY
72	FKART	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	JHV05
73	FAKSA	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
74	FAKSP_B	☐	FAKSP_B	FAKSP	CHAR	2	0	IS-M: Billing Block Indicator for Trivial Amounts	TVFS
75	FAKSP_G	☐	FAKSP_G	FAKSP	CHAR	2	0	IS-M: Billing Block for Credit Memos	TVFS
76	FAKSP_L	☐	FAKSP_L	FAKSP	CHAR	2	0	IS-M: Billing Block for Debit Memos	TVFS
77	TAGE_SP	☐	TAGE_SP	NUMC03	NUMC	3	0	Blocking Period between Contract Settlement and Billing
78	BEZKD_DTI	☐	BEZDK_DTI	JBEZKOND	CHAR	2	0	Contract Evaluation Details for Cond.Reference: Advertiser	TJJ83
79	XST_AVMACT	☐	XST_AVMACT	XST_AVMACT	NUMC	1	0	IS-M: Control Order Update from Contract
80	XNOVABR	☐	JHXNOVABR	XFELD	CHAR	1	0	IS-M: Contract Settlement Billing not Rel.to Commission Ind.
81	XERRABSUBL	☐	JHERRABSUL	JHERRABSUL	CHAR	2	0	IS-M: Error Handling for Contract Overlap
82	QUASI_VERH	☐	JHQU_VERH	JHQU_VERH	NUMC	1	0	IS-M: Prevent Conflicts for System Contracts
83	KOQSI_VERH	☐	JHKQ_VERH	JHKQ_VERH	NUMC	1	0	IS-M: Control Prevention of Group Contract Creation
84	ABS_TYP_SI	☐	ABS_TYP	ABS_TYP	CHAR	1	0	IS-M/AM: Contract Category	TJH11
85	EINH1_SI	☐	AB_MEINH1	MEINS	UNIT	3	0	IS-M: Contract Units of Measurement	T006
86	EINH2_SI	☐	AB_MEINH2	MEINS	UNIT	3	0	IS-M/AM: Contract Units of Measurement	T006
87	XERN_BEST	☐	JHERN_BEST	XFELD	CHAR	1	0	IS-M: Indicator Automatic Confirmation of Renewed Contracts
88	XERN_LEER	☐	JHERN_LEER	XFELD	CHAR	1	0	IS-M: Indicator Contract without Assignments to be Renewed
89	XARCH_OEABR	☐	ISM_XARCH_OEABR	XFELD	CHAR	1	0	IS-M: Ind: Contracts W/O Final Settlement Are Archivable
90	XWOENQ	☐	ISM_COAWOENQ	XFELD	CHAR	1	0	IS-M: Indicator for Contract Determination Without Block
91	KOZGF	☐	JHZUO_KOZGF	JHZUO_KOZGF	CHAR	4	0	Access Sequence for Partner Selection in Contract Determ.	TJJV3
92	KONFL	☐	JH_KONFL	JH_KONFL	CHAR	4	0	IS-M: Conflict Control	TJJV7
93	XNO_CHDK	☐	XNO_CHDK	XFELD	CHAR	1	0	IS-M: Do Not Generate Change Documents
94	XFAKTPRZUO	☐	ISM_XFAKT_PRZUO	XFELD	CHAR	1	0	IS-M: Assign Billed Orders to Price Contracts
95	XSBC_OVL_CHK	☐	ISM_SBC_OVL_CHK	XFELD	CHAR	1	0	Perform Overlap Check for Scale Basis Contracts

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TJHVA	ABS_TYP1	TJH11	ABS_TYP	KEY	1	CN
2	TJHVA	ABS_TYP_SI	TJH11	ABS_TYP	REF	1	CN
3	TJHVA	BAG_WAERS	TCURC	WAERS	KEY	1	CN
4	TJHVA	BEZKD_DTI	TJJ83	BEZKOND	REF	1	CN
5	TJHVA	B_AUSR	TJJV14	B_AUSR	REF	C	CN
6	TJHVA	EINH1	T006	MSEHI	REF	1	CN
7	TJHVA	EINH1_SI	T006	MSEHI	REF	C	CN
8	TJHVA	EINH2	T006	MSEHI	REF	1	CN
9	TJHVA	EINH2_SI	T006	MSEHI	REF	C	CN
10	TJHVA	E_AUSR	TJJV15	E_AUSR	REF	C	CN
11	TJHVA	FAKSA	TVFS	FAKSP	REF	1	CN
12	TJHVA	FAKSP_B	TVFS	FAKSP	REF	1	CN
13	TJHVA	FAKSP_G	TVFS	FAKSP	REF	1	CN
14	TJHVA	FAKSP_L	TVFS	FAKSP	REF	1	CN
15	TJHVA	FKART	JHV05	FKART	REF	C	CN
16	TJHVA	GTORE_COMP	MJJVA5	FIELDNAME	REF	C	CN
17	TJHVA	HITYP	TJJ69	HITYP	REF	1	CN
18	TJHVA	KALSM	T683	KALSM	REF	1	CN
19	TJHVA	KALSM_KUBO	T683	KALSM	REF	C	CN
20	TJHVA	KONFL	TJJV7	KONFL	REF	1	CN
21	TJHVA	KOZGF	TJJV3	KOZGF	REF	C	CN
22	TJHVA	MANDT	T000	MANDT	KEY	1	CN
23	TJHVA	N_KALSM	T683	KALSM	REF	1	CN
24	TJHVA	N_KALSM_AB	T683	KALSM	REF	1	CN
25	TJHVA	PARGR	JHVTJJ25_FKEY	PARGR	REF	C	CN
26	TJHVA	SPART	TVTA	SPART	KEY	1	C
27	TJHVA	VKORG	TVTA	VKORG	KEY	1	C
28	TJHVA	VTWEG	TVTA	VTWEG	KEY	1	C
29	TJHVA	ZLSCHA	T042Z	ZLSCH	REF	C	CN
30	TJHVA	ZLSCHB	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in