SAP ABAP Table JHTVAABP (IS-M/AM: Contract Settlement Item Data)

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	JHTVAABP	Table Relationship Diagram
Short Description	IS-M/AM: Contract Settlement Item Data

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	VTNR	☑	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVAARI
3	ABRGNR	☑	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	JHTVAARI
4	APOSNR	☑	ABRG_POSNR	ABRG_POSNR	NUMC	4	0	IS-M: Contract Settlement - Item Number
5	.INCLUDE	☐				0	0	IS-M: Sales area data for COA settlement table
6	.INCLUDE	☐				0	0	IS-M: Sales Area
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	JHTVAARI
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	JHTVAARI
9	SPART	☐	SPART	SPART	CHAR	2	0	Division	JHTVAARI
10	.INCLUDE	☐				0	0	IS-M/AM: Key Fields for P/A Record
11	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JHTVAARI
12	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JHTVAARI
13	TRENNUNG	☐	JH_TRENNUNG	CHAR10	CHAR	10	0	IS-M/AM: Split Criteria for Payer/Advertiser Records	JHTVAARI
14	.INCLUDE	☐				0	0	IS-M/AM: Common part of RJHTVAABP and JHTVAABP
15	POSNR	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVPO
16	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
17	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
18	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
19	ZW_AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
20	ZW_POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
21	ZW_GRABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
22	AABRAUSW	☐	AABRAUSW	XFELD	CHAR	1	0	IS-M: Contract Settlement Selection Indicator
23	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
24	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
25	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document	*
26	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
27	XVBELEGTYP	☐	XVBELEGTYP	XVBELEGTYP	CHAR	1	0	IS-M: Preceding Document Type of Contract Settlement Item
28	ABR_DAT	☐	ABRUF_DAT	DATUM	DATS	8	0	IS-M: Allocation Date of Contract Assignment
29	FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
30	WAERK_OLD	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
31	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
32	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
33	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
34	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
35	AB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
36	ABRMM	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
37	ABRME	☐	ABRME	SAEME	DEC	5	0	IS-M: Number
38	OLD_KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
39	OLD_KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
40	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
41	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
42	FAKBELNR	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
43	FAKPOSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP
44	NEW_KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
45	NEW_KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
46	DIFF_KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
47	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
48	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
49	ABR_ZSTAT	☐	ABR_ZSTAT	ABR_ZSTAT	CHAR	1	0	IS-M: Settlement Status of the Assignment
50	RAB_IST	☐	RAB_IST	WERTV7	CURR	13	2	IS-M: Contract Discount Granted to Date
51	RAB_SOLL	☐	RAB_SOLL	WERTV7	CURR	13	2	IS-M: Current Contract Discount
52	BON_IST	☐	BON_IST	WERTV7	CURR	13	2	IS-M: Contract Bonus Granted to Date
53	BON_SOLL	☐	BON_SOLL	WERTV7	CURR	13	2	IS-M/AM: Current Contract Bonus
54	ABETR_IST	☐	ABETR_IST	WERTV8	CURR	15	2	IS-M: Contract Settlement Amount Paid to Date
55	ABETR_SOLL	☐	ABETR_SOLL	WERTV8	CURR	15	2	IS-M: Current Contract Settlement Amount
56	GL_BETRAG	☐	GL_BETRAG	WERTV8	CURR	15	2	IS-M: Credit/Debit Memo Amount for Contract Settlement
57	X_AVM_STOR	☐	X_AVM_STOR	XFELD	CHAR	1	0	IS-M: Processing due to Order Reversal
58	XFR_AVM	☐	XFR_AVM	XFELD	CHAR	1	0	IS-M: Assignment from data transfer legacy system indicator
59	ZWGRFTYP	☐	JH_ZWGRFTYP	JH_ZWGRFTYP	CHAR	1	0	IS-M/AM: Twinned Billing Dataset Type	TJHVAZW

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHTVAABP	ABRGNR	JHTVAARI	ABRGNR	KEY	1	CN
2	JHTVAABP	AVM_NR	JHAK	AVM_NR		1	CN
3	JHTVAABP	FAKBELNR	JHTFK	VBELN		1	CN
4	JHTVAABP	FAKPOSNR	JHTFP	POSNR		1	CN
5	JHTVAABP	GRUPPABRNR	JHAGA	GRUPPABRNR		1	CN
6	JHTVAABP	INSERENT	JHTVAARI	REGULIERER	REF	1	CN
7	JHTVAABP	KALSM	T683	KALSM	REF	1	CN
8	JHTVAABP	KURST	TCURV	KURST		1	CN
9	JHTVAABP	MANDT	T000	MANDT	KEY	1	CN
10	JHTVAABP	POSNR	JHTVPO	POSNR		1	CN
11	JHTVAABP	POS_NR	JHAP	POS_NR		1	CN
12	JHTVAABP	TRENNUNG	JHTVAARI	INSERENT	REF	1	CN
13	JHTVAABP	VGOBJ	TJH97	OBJKT	REF	1	CN
14	JHTVAABP	VKORG	JHTVAARI	TRENNUNG	REF	1	CN
15	JHTVAABP	VTNR	JHTVAARI	VTNR	KEY	1	CN
16	JHTVAABP	WAERK_OLD	TCURC	WAERS		1	CN
17	JHTVAABP	ZWGRFTYP	TJHVAZW	ZWGRFTYP	REF	C	CN
18	JHTVAABP	ZW_AVM_NR	JHAK	AVM_NR	REF	C	CN
19	JHTVAABP	ZW_GRABRNR	JHAGA	GRUPPABRNR	REF	C	CN
20	JHTVAABP	ZW_POS_NR	JHAP	POS_NR	REF	C	CN

History

Last changed by/on	SAP	20050520
SAP Release Created in