SAP ABAP Table RJHTVAABP (IS-M/AM: JHTVAABP with P/A separation criteria and dyn.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	RJHTVAABP	Table Relationship Diagram
Short Description	IS-M/AM: JHTVAABP with P/A separation criteria and dyn.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	.INCLUDE	☐				0	0	IS-M/AM: Key Fields for P/A Record
2	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
3	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
4	TRENNUNG	☐	JH_TRENNUNG	CHAR10	CHAR	10	0	IS-M/AM: Split Criteria for Payer/Advertiser Records
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	TVKO
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
9	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
10	ZWGRFTYP	☐	JH_ZWGRFTYP	JH_ZWGRFTYP	CHAR	1	0	IS-M/AM: Twinned Billing Dataset Type	TJHVAZW
11	XZWGRF_DONE	☐	SYBATCH	SYCHAR01	CHAR	1	0	Background Processing Active
12	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
13	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
14	ABRGNR	☐	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	JHTVAABK
15	APOSNR	☐	ABRG_POSNR	ABRG_POSNR	NUMC	4	0	IS-M: Contract Settlement - Item Number	JHTVAABP
16	.INCLUDE	☐				0	0	IS-M/AM: Common part of RJHTVAABP and JHTVAABP
17	POSNR	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	*
18	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
19	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
20	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
21	ZW_AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
22	ZW_POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
23	ZW_GRABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
24	AABRAUSW	☐	AABRAUSW	XFELD	CHAR	1	0	IS-M: Contract Settlement Selection Indicator
25	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
26	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
27	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document	*
28	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
29	XVBELEGTYP	☐	XVBELEGTYP	XVBELEGTYP	CHAR	1	0	IS-M: Preceding Document Type of Contract Settlement Item
30	ABR_DAT	☐	ABRUF_DAT	DATUM	DATS	8	0	IS-M: Allocation Date of Contract Assignment
31	FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
32	WAERK_OLD	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
33	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
34	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
35	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
36	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
37	AB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
38	ABRMM	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
39	ABRME	☐	ABRME	SAEME	DEC	5	0	IS-M: Number
40	OLD_KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
41	OLD_KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
42	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
43	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
44	FAKBELNR	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
45	FAKPOSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP
46	NEW_KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
47	NEW_KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
48	DIFF_KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
49	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
50	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
51	ABR_ZSTAT	☐	ABR_ZSTAT	ABR_ZSTAT	CHAR	1	0	IS-M: Settlement Status of the Assignment
52	RAB_IST	☐	RAB_IST	WERTV7	CURR	13	2	IS-M: Contract Discount Granted to Date
53	RAB_SOLL	☐	RAB_SOLL	WERTV7	CURR	13	2	IS-M: Current Contract Discount
54	BON_IST	☐	BON_IST	WERTV7	CURR	13	2	IS-M: Contract Bonus Granted to Date
55	BON_SOLL	☐	BON_SOLL	WERTV7	CURR	13	2	IS-M/AM: Current Contract Bonus
56	ABETR_IST	☐	ABETR_IST	WERTV8	CURR	15	2	IS-M: Contract Settlement Amount Paid to Date
57	ABETR_SOLL	☐	ABETR_SOLL	WERTV8	CURR	15	2	IS-M: Current Contract Settlement Amount
58	GL_BETRAG	☐	GL_BETRAG	WERTV8	CURR	15	2	IS-M: Credit/Debit Memo Amount for Contract Settlement
59	X_AVM_STOR	☐	X_AVM_STOR	XFELD	CHAR	1	0	IS-M: Processing due to Order Reversal
60	XFR_AVM	☐	XFR_AVM	XFELD	CHAR	1	0	IS-M: Assignment from data transfer legacy system indicator
61	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
62	RABATT_NR	☐	RABATT_NR	RABATT_NR	NUMC	1	0	IS-M: Class of Discount in a Billing Dataset
63	KAUSSCHL	☐	JH_KAUSSCHL	JH_KAUSSCHL	CHAR	1	0	IS-M: Condition Exclusion Rule for Media-Mix Contract	TJJV5
64	RABATT	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
65	BONUS	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
66	PREIS	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
67	FMP_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
68	FMP_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
69	KSCHL_RAB	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685
70	KSCHL_BON	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685
71	JAEPRBASIS	☐	JAEPRBASIS	WERTV7	CURR	13	2	IS-M: Agency commission basis

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHTVAABP	ABRGNR	JHTVAABK	ABRGNR	KEY	1	CN
2	RJHTVAABP	APOSNR	JHTVAABP	APOSNR	KEY	1	CN
3	RJHTVAABP	AVM_NR	JHAK	AVM_NR	REF	1	CN
4	RJHTVAABP	FAKBELNR	JHTFK	VBELN		1	CN
5	RJHTVAABP	FAKPOSNR	JHTFP	POSNR		1	CN
6	RJHTVAABP	FMP_KMEIN	T006	MSEHI	REF	C	CN
7	RJHTVAABP	GRUPPABRNR	JHAGA	GRUPPABRNR	REF	1	CN
8	RJHTVAABP	INSERENT	JJVDB_MK_FK	GPNR	REF	1	CN
9	RJHTVAABP	KALSM	T683	KALSM	REF	1	CN
10	RJHTVAABP	KAUSSCHL	TJJV5	KAUSSCHL	REF	C	CN
11	RJHTVAABP	KSCHL_BON	T685	KSCHL	REF	1	CN
12	RJHTVAABP	KSCHL_RAB	T685	KSCHL	REF	1	CN
13	RJHTVAABP	KURST	TCURV	KURST		1	CN
14	RJHTVAABP	MANDT	T000	MANDT	KEY	1	CN
15	RJHTVAABP	POS_NR	JHAP	POS_NR	REF	1	CN
16	RJHTVAABP	PSTYV	TJHAP	PSTYV	REF	C	CN
17	RJHTVAABP	REGULIERER	JGTGPNR	GPNR	REF	1	CN
18	RJHTVAABP	SPART	TSPA	SPART		1	CN
19	RJHTVAABP	VGOBJ	TJH97	OBJKT	REF	1	CN
20	RJHTVAABP	VKORG	TVKO	VKORG		1	CN
21	RJHTVAABP	VTNR	JHTVKO	VTNR	KEY	1	CN
22	RJHTVAABP	VTWEG	TVTW	VTWEG		1	CN
23	RJHTVAABP	WAERK_OLD	TCURC	WAERS		1	CN
24	RJHTVAABP	ZWGRFTYP	TJHVAZW	ZWGRFTYP	REF	C	CN
25	RJHTVAABP	ZW_AVM_NR	JHAK	AVM_NR	REF	C	CN
26	RJHTVAABP	ZW_GRABRNR	JHAGA	GRUPPABRNR	REF	C	CN
27	RJHTVAABP	ZW_POS_NR	JHAP	POS_NR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in