SAP ABAP Table RJHFPVB1 (IS-M: Non database part of update structure for JHTFP)

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	RJHFPVB1	Table Relationship Diagram
Short Description	IS-M: Non database part of update structure for JHTFP

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in