SAP ABAP Table RJHFPVB2 (IS-M: Dyn.part JHTFP, Billing interface for order 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	INTTAB	Structure
Structure	RJHFPVB2	Table Relationship Diagram
Short Description	IS-M: Dyn.part JHTFP, Billing interface for order data

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	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
2	AEPROV	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
3	JAEPRBASIS	☐	JAEPRBASIS	WERTV7	CURR	13	2	IS-M: Agency commission basis
4	ANZSCHALT	☐	ANZ_ANFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUs
5	ANZWDHLG	☐	ANZ_WNFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Days
6	TBEL	☐	TEILBEL	TEILBEL	CHAR	2	0	IS-M: Selective Booking (Advertisement Item Type)	*
7	PRGRP_FARB	☐	PRGRP_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Price Group	*
8	AZAPLZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
9	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
10	PLZANW	☐	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	*
11	IHKTYP	☐	IKOTYP_PR	INHKOM_TYP	CHAR	2	0	IS-M: Price Content Component Type	*
12	IKOTYP_KFM	☐	IKOTYP_KFM	INHKOM_TYP	CHAR	2	0	IS-M: Business Content Component Type	*
13	INHK_TECH1	☐	INHK_PLAZ	INHALTSKOM	CHAR	8	0	IS-M: Positioning content component	*
14	IKOTYP_PLZ	☐	IKOTYP_PLZ	INHKOM_TYP	CHAR	2	0	IS-M: Positioning Content Component Type	*
15	INHK_KLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
16	IKOTYPLEV1	☐	IKOTYPLEV1	INHKOM_TYP	CHAR	2	0	IS-M: Content Component Type from First Hierarchy Level	*
17	AZART_VORL	☐	AZART_VORL	AZART_VORL	CHAR	4	0	IS-M: Template Ad Type	*
18	TMOT_KENNZ	☐	TMOT_KENNZ	TMOTIV_KE	CHAR	6	0	IS-M/AM: Sub ad spec/linked ad specs indicator	*
19	XUEBERBUND	☐	XUEBERBUND	XFELD	CHAR	1	0	IS-M: Indicates That The Ad Spec Overlaps Gutter Margin
20	XANSCHNITT	☐	XANSCHNITT	XFELD	CHAR	1	0	IS-M: Bled Ad Spec Indicator
21	XCOUPON	☐	XCOUPON	XFELD	CHAR	1	0	IS-M: Ad Spec is a Coupon Advertisement Indicator
22	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
23	DSPMGE_PAM	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
24	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
25	XFREMDBEIL	☐	XFREMDBEIL	XFELD	CHAR	1	0	IS-M: Indicator - subject to postal charges (ad insert)
26	PSTMGE_PAM	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
27	FARBANZ	☐	FARBANZ_S	FARBANZ	CHAR	2	0	IS-M: Planned Number of Colors
28	KARR_KUNDE	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	*
29	SINSBEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	*
30	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
31	SI_GEWKL	☐	ISM_SI_GEWKL	SI_GEWKL	CHAR	4	0	IS-M: Ad inserts weight price group	*
32	SI_SEKL	☐	ISM_SI_SEKL	SI_SEKL	CHAR	4	0	IS-M: Price Group for Ad Insert Pages	*
33	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
34	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
35	SI_SEITEN	☐	JANZSEITEN	NUM8	NUMC	8	0	IS-M: Number of pages of an ad insert
36	XTBEL_SI	☐	XTBEL_SI	XFELD	CHAR	1	0	IS-M: Selective Booking of an AI BU
37	XTRANZ	☐	XTRANZEIGE	XFELD	CHAR	1	0	IS-M: Carrier Ad Required Indicator
38	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
39	XTBEL_VT	☐	XTBEL_VT	XFELD	CHAR	1	0	IS-M: Selective Booking For Distribution BU Indicator
40	JVTBEPMART	☐	JVTBEPMART	JVTBEPMART	CHAR	4	0	IS-M/AM: Distribution Planned Quantity Types	*
41	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
42	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
43	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
44	WS_ART	☐	WSPOT_ART	WSPOT_ART	CHAR	4	0	IS-M: Commercial Type	*
45	WS_SENDFRM	☐	WS_SENDFRM	WS_SENDFRM	CHAR	2	0	IS-M: Commercial Design Type	*
46	WS_TARIFGR	☐	WS_TARIFGR	WS_TARIFGR	CHAR	2	0	IS-M: Commercial Rate Group	*
47	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
48	BOOK_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	*
49	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
50	XGESTREUT	☐	XGESTREUT	XFELD	CHAR	1	0	IS-M: Ad Spec Should Be Scattered Indicator
51	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
52	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
53	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
54	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
55	BEILAGHW	☐	XBLGHINW	XFELD	CHAR	1	0	IS-M: Insert Note Required Indicator
56	INS_PROZ	☐	PAM_PROZ	JHPROZ33	DEC	6	3	IS-M: Percentage Figure for Cost Distribution
57	AZGR_INS	☐	AZGR_INS	NUMC4	NUMC	4	0	Column MM of the Ad Which the Advertiser is Involved In
58	ACT_ABSCHL	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	*
59	BE_GRP_BAS	☐	BEGRP_PR	BEGRP_PR	CHAR	2	0	IS-M: BU Grouping for Pricing	*
60	BE_GRP_UR	☐	BEGRP_PR	BEGRP_PR	CHAR	2	0	IS-M: BU Grouping for Pricing	*
61	SD_VBELN_VA	☐	JHVBELN_VA	VBELN	CHAR	10	0	IS-M: Referenced SD Order Number	*
62	.INCLUDE	☐				0	0	IS-M: Contract Conditions (Except ABSRB, ABSBO, ABSFMPR)
63	FMP_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
64	FMP_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
65	FMP_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
66	FMP_ABRMM	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
67	BRABS	☐	JH_BRABS	JH_BRABS	CHAR	1	0	IS-M: Time Discount/Bonus was Granted
68	ABSRB2	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
69	ABSBO2	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
70	ABSFMPR2	☐	AB_KPREIS	WERTV8	CURR	15	2	IS-M: Price from Scale
71	FMP_WAERS2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
72	FMP_KPEIN2	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
73	FMP_KMEIN2	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
74	FMP_ABRMM2	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
75	BRABS2	☐	JH_BRABS	JH_BRABS	CHAR	1	0	IS-M: Time Discount/Bonus was Granted
76	ABSRB3	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
77	ABSBO3	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
78	ABSFMPR3	☐	AB_KPREIS	WERTV8	CURR	15	2	IS-M: Price from Scale
79	FMP_WAERS3	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
80	FMP_KPEIN3	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
81	FMP_KMEIN3	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
82	FMP_ABRMM3	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
83	BRABS3	☐	JH_BRABS	JH_BRABS	CHAR	1	0	IS-M: Time Discount/Bonus was Granted
84	KAUSSCHL	☐	JH_KAUSSCHL	JH_KAUSSCHL	CHAR	1	0	IS-M: Condition Exclusion Rule for Media-Mix Contract	TJJV5
85	.INCLUDE	☐				0	0	IS-M/AM: Multiple Placements JHAGA2
86	INS_SERIES_RULE	☐	ISM_INSERTION_SERIES_RULE	ISM_INSERTION_SERIES_RULE	CHAR	4	0	IS-M/AM: Series Rule	TJHINSSER
87	INS_SERIES	☐	ISM_INSERTION_SERIES	CHAR4	CHAR	4	0	IS-M/AM: Unique Identification of a Series Found
88	INS_SERIES_NO	☐	ISM_INSERTION_SERIES_NO	NUM4	NUMC	4	0	IS-M/AM: Unique Billing Dataset Number Within a Series
89	INS_SERIES_CNT	☐	ISM_INS_SERIES_CNT	NUMC4	NUMC	4	0	IS-M: Series Creation: Number of Elements in a Series
90	INS_SERIES_BLGMENGE	☐	BLGMENGE	STMENGE	DEC	9	0	IS-M: Order Quantity for Insertion
91	INS_SERIES_DISPMENGE	☐	DISPMENGE	STMENGE	DEC	9	0	IS-M: Planning Quantity of Carrying Issue
92	INS_SERIES_BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
93	INS_SERIES_POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
94	INS_SERIES_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
95	INS_SERIES_LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHFPVB2	FMP_KMEIN	T006	MSEHI	REF	C	CN
2	RJHFPVB2	FMP_KMEIN2	T006	MSEHI	REF	C	CN
3	RJHFPVB2	FMP_KMEIN3	T006	MSEHI	REF	C	CN
4	RJHFPVB2	FMP_WAERS	TCURC	WAERS	REF	C	CN
5	RJHFPVB2	FMP_WAERS2	TCURC	WAERS	REF	C	CN
6	RJHFPVB2	FMP_WAERS3	TCURC	WAERS	REF	C	CN
7	RJHFPVB2	INS_SERIES_RULE	TJHINSSER	INS_SERIES_RULE
8	RJHFPVB2	KAUSSCHL	TJJV5	KAUSSCHL	REF	C	CN

History

Last changed by/on	SAP	20070917
SAP Release Created in