SAP ABAP Table RJHFPALV (IS-M: Billing Item - Field List for ABAP List Viewer)

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	RJHFPALV	Table Relationship Diagram
Short Description	IS-M: Billing Item - Field List for ABAP List Viewer

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: Update Reference Structure For XJHTFP/YJHTFP
2	.INCLUDE	☐				0	0	IS-M/AM: Billing/Settlement Documents - Item
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
5	POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	*
6	.INCLUDE	☐				0	0	IS-PAM: Settlement Documents - Item - Data Part
7	.INCLUDE	☐				0	0	IS-M/AM: Settlement Documents - Item - Gen.Customer Fields
8	.INCLUDE	☐				0	0	IS-PAM: Settlement Documents - Cust.Item Fields - Interface
9	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
10	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
11	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
12	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
13	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
14	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
15	ARKTX	☐	ISM_ARKTX	TEXT40	CHAR	40	0	IS-M: Short Text for Document Item (Billing Doc.,Settlement)
16	AUBEL	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
17	AUPOS	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
18	AUGRP	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
19	AUETE	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAE
20	AVMAUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
21	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
22	BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
23	BEINH_BAS	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
24	DRERZ	☐	JHDRERZ	DRERZ	CHAR	8	0	IS-M: Publication	JDTDRER
25	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
26	IHKOMP	☐	IKO_PREIS	INHALTSKOM	CHAR	8	0	IS-M: Content component for pricing call	JJTIKO
27	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
28	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
29	AZAFOV	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
30	AZAFO	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
31	AZAFA	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
32	AZAGST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
33	TERMINSPEZ	☐	TERMINSPEZ	TERMINSPEZ	CHAR	6	0	IS-M/AM: Specify Dates for Date Combinations	*
34	VAVTYP	☐	VAVARTYP	VAVARTYP	CHAR	2	0	Issue Variant Type	TJD05
35	CHIFFRE	☐	CHIFFRE_KZ	CHIFFRE_KZ	CHAR	1	0	IS-M: Box Number Indicator	TJH59
36	ABSRB	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
37	ABSBO	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
38	ABSFMPR	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
39	GO_PREIS	☐	GO_PREIS	GO_PREIS	CHAR	1	0	IS-M: Basic/Local Price
40	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
41	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
42	DIENSTL	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
43	DITYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
44	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
45	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
46	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
47	FSART	☐	ISP_FSART	ISP_FSART	CHAR	1	0	IS-M/AM: Billing Method
48	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
49	KTGRB	☐	KTGRB	KTGRB	CHAR	2	0	IS-M: Booking Unit Account Assignment Group	TJJ39
50	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
51	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
52	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
53	SHKZG	☐	JHSHKZG	JHSHKZG	CHAR	1	0	IS-M: Debit/Credit indicator
54	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
55	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
56	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
57	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
58	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
59	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
60	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
61	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
62	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document	*
63	VGTYP	☐	ISPVBTYP_V	ISPVBTYP	CHAR	1	0	IS-M: Preceding Sales Document Category
64	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
65	VGFKTYP	☐	JHVGFKTYP	JHFKTYP	CHAR	1	0	IS-M: Billing Category for Preceding Billing Document	TJH19
66	VBELV	☐	ISMVBELV	ISMVBELV	CHAR	10	0	IS-M: Originating sales document
67	POSNV	☐	ISMPOSNV	ISMPOSNR	NUMC	6	0	IS-M: Originating item
68	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
69	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
70	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
71	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
72	POSAR	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
73	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
74	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
75	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
76	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
77	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
78	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
79	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
80	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
81	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
82	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
83	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
84	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
85	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
86	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
87	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
88	RK_AUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
89	RK_POSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
90	KOSTL_R2	☐	KOSTL_R2	KOSTL_R2	CHAR	8	0	Cost center in R/2
91	STGRB	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	TJJ67
92	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
93	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
94	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
95	RRSTA	☐			CHAR	1	0
96	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
97	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
98	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
99	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
100	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
101	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
102	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
103	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
104	KUNAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
105	ELAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
106	POSPA	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment	*
107	PLTYP_AUFT	☐	PLTYP_AUFT	PLTYP	CHAR	2	0	Price list type of sales order	*
108	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
109	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
110	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
111	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
112	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
113	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
114	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
115	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
116	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
117	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
118	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
119	BRTWP	☐	JHBRTWRP	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency (Item)
120	NETWP	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
121	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
122	CMPRE	☐			CURR	11	2
123	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
124	UVPRS	☐	ISM_UVPRS	XFELD	CHAR	1	0	Incomplete with Regard to Pricing
125	UVALL	☐	JHUVALL	XFELD	CHAR	1	0	IS-M: Generally incomplete
126	XERLV	☐	JHXERLV	JHXERLV	CHAR	1	0	IS-M: Revenue Distribution Status
127	XPEAB	☐	JHXPEAB	XFELD	CHAR	1	0	IS-M: Period end accrual performed indicator
128	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
129	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
130	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
131	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
132	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
133	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
134	ZUONR	☐	JHZUONR	ZUONR	CHAR	18	0	IS-M: Assignment number in FI document
135	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
136	XCNCL	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item
137	.INCLUDE	☐				0	0	IS-PAM: Settlement Documents - Item - Commission Fields
138	.INCLUDE	☐				0	0	Settlement documents - item commission data - interface
139	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
140	PROVTYP	☐	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
141	VZUONR	☐	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)	*
142	BERART	☐	JBERART	BERART	CHAR	1	0	IS-M/AM: Calculation Type for Media Sales Agent Commission
143	PBSCHL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
144	SCBAS	☐	JHSCBAS	JHSCBAS	CHAR	1	0	IS-M/AM: Scale Base Value for Commission Key
145	VERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
146	PR_BETRAG	☐	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
147	PBBASIS	☐	JPBBASIS	WERTV7	CURR	13	2	IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)
148	ISPBEDART	☐	VMBEDART	JVMBEDART	CHAR	2	0	IS-M/AM: Requirement Type in Media Sales Agent Contract	*
149	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
150	XSTEIG	☐	XJSTEIG	XFELD	CHAR	1	0	IS-M: Can be Incremented Indicator
151	.INCLUDE	☐				0	0	IS-PAM: Billing item fields for revenue distribution
152	.INCLUDE	☐				0	0	IS-PAM: Billing item fields for revenue distribution
153	VKORG_AUFT	☐	JHVKORGAUF	VKORG	CHAR	4	0	IS-M: Sales Organization for Customer Order	TVKO
154	EPROZ	☐	ISPPROZERL	ISPPROZERL	DEC	8	5	IS-M: Percentage rate from rev.distributed billing item
155	NETWPV	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
156	KTGRP	☐	JPVAKNTGRP	KTGRM	CHAR	2	0	Account assignment grouping for edition	TVKM
157	.INCLUDE	☐				0	0	IS-M: Non database part of update structure for JHTFP
158	.INCLUDE	☐				0	0	IS-M: Dyn.part JHTFP, Billing interface for order data
159	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
160	AEPROV	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
161	JAEPRBASIS	☐	JAEPRBASIS	WERTV7	CURR	13	2	IS-M: Agency commission basis
162	ANZSCHALT	☐	ANZ_ANFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUs
163	ANZWDHLG	☐	ANZ_WNFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Days
164	TBEL	☐	TEILBEL	TEILBEL	CHAR	2	0	IS-M: Selective Booking (Advertisement Item Type)	*
165	PRGRP_FARB	☐	PRGRP_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Price Group	*
166	AZAPLZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
167	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
168	PLZANW	☐	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	*
169	IHKTYP	☐	IKOTYP_PR	INHKOM_TYP	CHAR	2	0	IS-M: Price Content Component Type	*
170	IKOTYP_KFM	☐	IKOTYP_KFM	INHKOM_TYP	CHAR	2	0	IS-M: Business Content Component Type	*
171	INHK_TECH1	☐	INHK_PLAZ	INHALTSKOM	CHAR	8	0	IS-M: Positioning content component	*
172	IKOTYP_PLZ	☐	IKOTYP_PLZ	INHKOM_TYP	CHAR	2	0	IS-M: Positioning Content Component Type	*
173	INHK_KLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
174	IKOTYPLEV1	☐	IKOTYPLEV1	INHKOM_TYP	CHAR	2	0	IS-M: Content Component Type from First Hierarchy Level	*
175	AZART_VORL	☐	AZART_VORL	AZART_VORL	CHAR	4	0	IS-M: Template Ad Type	*
176	TMOT_KENNZ	☐	TMOT_KENNZ	TMOTIV_KE	CHAR	6	0	IS-M/AM: Sub ad spec/linked ad specs indicator	*
177	XUEBERBUND	☐	XUEBERBUND	XFELD	CHAR	1	0	IS-M: Indicates That The Ad Spec Overlaps Gutter Margin
178	XANSCHNITT	☐	XANSCHNITT	XFELD	CHAR	1	0	IS-M: Bled Ad Spec Indicator
179	XCOUPON	☐	XCOUPON	XFELD	CHAR	1	0	IS-M: Ad Spec is a Coupon Advertisement Indicator
180	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
181	DSPMGE_PAM	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
182	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
183	XFREMDBEIL	☐	XFREMDBEIL	XFELD	CHAR	1	0	IS-M: Indicator - subject to postal charges (ad insert)
184	PSTMGE_PAM	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
185	FARBANZ	☐	FARBANZ_S	FARBANZ	CHAR	2	0	IS-M: Planned Number of Colors
186	KARR_KUNDE	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	*
187	SINSBEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	*
188	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
189	SI_GEWKL	☐	ISM_SI_GEWKL	SI_GEWKL	CHAR	4	0	IS-M: Ad inserts weight price group	*
190	SI_SEKL	☐	ISM_SI_SEKL	SI_SEKL	CHAR	4	0	IS-M: Price Group for Ad Insert Pages	*
191	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
192	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
193	SI_SEITEN	☐	JANZSEITEN	NUM8	NUMC	8	0	IS-M: Number of pages of an ad insert
194	XTBEL_SI	☐	XTBEL_SI	XFELD	CHAR	1	0	IS-M: Selective Booking of an AI BU
195	XTRANZ	☐	XTRANZEIGE	XFELD	CHAR	1	0	IS-M: Carrier Ad Required Indicator
196	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
197	XTBEL_VT	☐	XTBEL_VT	XFELD	CHAR	1	0	IS-M: Selective Booking For Distribution BU Indicator
198	JVTBEPMART	☐	JVTBEPMART	JVTBEPMART	CHAR	4	0	IS-M/AM: Distribution Planned Quantity Types	*
199	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
200	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
201	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
202	WS_ART	☐	WSPOT_ART	WSPOT_ART	CHAR	4	0	IS-M: Commercial Type	*
203	WS_SENDFRM	☐	WS_SENDFRM	WS_SENDFRM	CHAR	2	0	IS-M: Commercial Design Type	*
204	WS_TARIFGR	☐	WS_TARIFGR	WS_TARIFGR	CHAR	2	0	IS-M: Commercial Rate Group	*
205	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
206	BOOK_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	*
207	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
208	XGESTREUT	☐	XGESTREUT	XFELD	CHAR	1	0	IS-M: Ad Spec Should Be Scattered Indicator
209	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
210	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
211	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
212	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
213	BEILAGHW	☐	XBLGHINW	XFELD	CHAR	1	0	IS-M: Insert Note Required Indicator
214	INS_PROZ	☐	PAM_PROZ	JHPROZ33	DEC	6	3	IS-M: Percentage Figure for Cost Distribution
215	AZGR_INS	☐	AZGR_INS	NUMC4	NUMC	4	0	Column MM of the Ad Which the Advertiser is Involved In
216	ACT_ABSCHL	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	*
217	BE_GRP_BAS	☐	BEGRP_PR	BEGRP_PR	CHAR	2	0	IS-M: BU Grouping for Pricing	*
218	BE_GRP_UR	☐	BEGRP_PR	BEGRP_PR	CHAR	2	0	IS-M: BU Grouping for Pricing	*
219	SD_VBELN_VA	☐	JHVBELN_VA	VBELN	CHAR	10	0	IS-M: Referenced SD Order Number	*
220	.INCLUDE	☐				0	0	IS-M: Contract Conditions (Except ABSRB, ABSBO, ABSFMPR)
221	FMP_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
222	FMP_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
223	FMP_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
224	FMP_ABRMM	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
225	BRABS	☐	JH_BRABS	JH_BRABS	CHAR	1	0	IS-M: Time Discount/Bonus was Granted
226	ABSRB2	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
227	ABSBO2	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
228	ABSFMPR2	☐	AB_KPREIS	WERTV8	CURR	15	2	IS-M: Price from Scale
229	FMP_WAERS2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
230	FMP_KPEIN2	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
231	FMP_KMEIN2	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
232	FMP_ABRMM2	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
233	BRABS2	☐	JH_BRABS	JH_BRABS	CHAR	1	0	IS-M: Time Discount/Bonus was Granted
234	ABSRB3	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
235	ABSBO3	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
236	ABSFMPR3	☐	AB_KPREIS	WERTV8	CURR	15	2	IS-M: Price from Scale
237	FMP_WAERS3	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
238	FMP_KPEIN3	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
239	FMP_KMEIN3	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
240	FMP_ABRMM3	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
241	BRABS3	☐	JH_BRABS	JH_BRABS	CHAR	1	0	IS-M: Time Discount/Bonus was Granted
242	KAUSSCHL	☐	JH_KAUSSCHL	JH_KAUSSCHL	CHAR	1	0	IS-M: Condition Exclusion Rule for Media-Mix Contract	TJJV5
243	.INCLUDE	☐				0	0	IS-M/AM: Multiple Placements JHAGA2
244	INS_SERIES_RULE	☐	ISM_INSERTION_SERIES_RULE	ISM_INSERTION_SERIES_RULE	CHAR	4	0	IS-M/AM: Series Rule	TJHINSSER
245	INS_SERIES	☐	ISM_INSERTION_SERIES	CHAR4	CHAR	4	0	IS-M/AM: Unique Identification of a Series Found
246	INS_SERIES_NO	☐	ISM_INSERTION_SERIES_NO	NUM4	NUMC	4	0	IS-M/AM: Unique Billing Dataset Number Within a Series
247	INS_SERIES_CNT	☐	ISM_INS_SERIES_CNT	NUMC4	NUMC	4	0	IS-M: Series Creation: Number of Elements in a Series
248	INS_SERIES_BLGMENGE	☐	BLGMENGE	STMENGE	DEC	9	0	IS-M: Order Quantity for Insertion
249	INS_SERIES_DISPMENGE	☐	DISPMENGE	STMENGE	DEC	9	0	IS-M: Planning Quantity of Carrying Issue
250	INS_SERIES_BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
251	INS_SERIES_POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
252	INS_SERIES_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
253	INS_SERIES_LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
254	.INCLUDE	☐				0	0	IS-M/AM: Dyn.part JHTFP; Revenue distrib.interface
255	KAPPLV	☐	ISPKAPPLV	KAPPL	CHAR	2	0	IS-M: Previous Application	*
256	KALSMV	☐	ISPKALSMV	KALSM	CHAR	6	0	IS-M: Preceding determination procedure	*
257	KNUMVV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
258	KPOSNV	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
259	TMP_KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
260	TMP_KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
261	TMP_KUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
262	TMP_KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
263	TMP_KREAN	☐	KREAN	LIFNR	CHAR	10	0	IS-M: Contractor	*
264	TMP_KRERS	☐	KRERS	LIFNR	CHAR	10	0	IS-M: Invoicing party	*
265	TMP_KREZE	☐	KREZE	LIFNR	CHAR	10	0	IS-M: Payee	*
266	ANZOB	☐	SYTFILL	SYST_LONG	INT4	10	0	Number of Rows in Internal Tables
267	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
268	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
269	XKOMV_UPD	☐	JHKONDUPD	XFELD	CHAR	1	0	IS-M: Conditions were changed
270	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHFPALV	ALAND	T005	LAND1	REF	1	CN
2	RJHFPALV	AUBEL	JHAK	AVM_NR	REF	1	CN
3	RJHFPALV	AUETE	JHAE	EIN_NR		1	CN
4	RJHFPALV	AUFNR	AUFK	AUFNR	KEY	1	CN
5	RJHFPALV	AUGRP	JHAGA	GRUPPABRNR	REF	1	CN
6	RJHFPALV	AUPOS	JHAP	POS_NR	REF	1	CN
7	RJHFPALV	AVMAUART	TJHAK	AUART	REF	1	CN
8	RJHFPALV	AZAFA	TJJ11	AZART_FARB	REF	1	CN
9	RJHFPALV	AZAFO	TJJ17	AZART_FORM	REF	1	CN
10	RJHFPALV	AZAFOV	TJJ13	AZART_AREA	REF	1	CN
11	RJHFPALV	AZAGST	TJJ19	AZART_GEST	REF	1	CN
12	RJHFPALV	BEDNR	JJTVB	BEDNR	REF	1	CN
13	RJHFPALV	BEINH	JJTBE	BELEINH	REF	1	CN
14	RJHFPALV	BEINH_BAS	JJTBE	BELEINH	REF	1	CN
15	RJHFPALV	CHIFFRE	TJH59	CHIFFRE_KZ	REF	1	CN
16	RJHFPALV	DIENSTL	JJTDIEN	MATNR	REF	1	CN
17	RJHFPALV	DITYP	TJH71	DIENTYP	REF	1	CN
18	RJHFPALV	DRERZ	JDTDRER	DRERZ	REF	1	CN
19	RJHFPALV	ELAND	T005	LAND1	REF	1	CN
20	RJHFPALV	FMP_KMEIN	T006	MSEHI	REF	C	CN
21	RJHFPALV	FMP_KMEIN2	T006	MSEHI	REF	C	CN
22	RJHFPALV	FMP_KMEIN3	T006	MSEHI	REF	C	CN
23	RJHFPALV	FMP_WAERS	TCURC	WAERS	REF	C	CN
24	RJHFPALV	FMP_WAERS2	TCURC	WAERS	REF	C	CN
25	RJHFPALV	FMP_WAERS3	TCURC	WAERS	REF	C	CN
26	RJHFPALV	GEWEI	T006	MSEHI	REF	1	CN
27	RJHFPALV	GSBER	TGSB	GSBER	REF	1	CN
28	RJHFPALV	IHKOMP	JJTIKO	INHALTSKOM	REF	1	CN
29	RJHFPALV	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
30	RJHFPALV	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
31	RJHFPALV	INSERENT	JJVDB_MK_FK	GPNR	REF	1	CN
32	RJHFPALV	INS_SERIES_RULE	TJHINSSER	INS_SERIES_RULE
33	RJHFPALV	KALSM	T683	KALSM	REF	1	CN
34	RJHFPALV	KAPPL	T681A	KAPPL	REF	1	CN
35	RJHFPALV	KAUSSCHL	TJJV5	KAUSSCHL	REF	C	CN
36	RJHFPALV	KDGRP	T151	KDGRP	REF	1	CN
37	RJHFPALV	KOKRS	TKA01	KOKRS	REF	1	CN
38	RJHFPALV	KONDA	T188	KONDA	REF	1	CN
39	RJHFPALV	KOSTL	CSKS	KOSTL	REF	1	CN
40	RJHFPALV	KTGRB	TJJ39	KTGRB	REF	1	CN
41	RJHFPALV	KTGRM	TVKM	KTGRM	REF	1	CN
42	RJHFPALV	KTGRP	TVKM	KTGRM	REF	1	CN
43	RJHFPALV	KUNAG	JGTGPNR	GPNR	REF	1	CN
44	RJHFPALV	MANDT	T000	MANDT	KEY	1	CN
45	RJHFPALV	MATNR	MARA	MATNR	REF	1	CN
46	RJHFPALV	MEINS	T006	MSEHI	REF	1	CN
47	RJHFPALV	PBSCHL	TJH23	PRSCHL	REF	C	CN
48	RJHFPALV	POSAR	TJH17	AVMPOS_ART	REF	1	CN
49	RJHFPALV	PRCTR	CEPC	PRCTR	REF	1	CN
50	RJHFPALV	PRODH	JJT179	PRODH	REF	1	CN
51	RJHFPALV	PSTYV	TJHAP	PSTYV	REF	1	CN
52	RJHFPALV	PVA	JDTPVA	PVA	REF	1	CN
53	RJHFPALV	SPART	TSPA	SPART	REF	1	CN
54	RJHFPALV	STAFO	TMCB	STAFO	REF	1	CN
55	RJHFPALV	STGRB	TJJ67	BEGRP_STAT	REF	1	CN
56	RJHFPALV	VAVTYP	TJD05	VAVARTYP	REF	1	CN
57	RJHFPALV	VBELN	JHTFK	VBELN	KEY	1	CN
58	RJHFPALV	VERMART	TJJ09	JVERMART	REF	C	CN
59	RJHFPALV	VGFKTYP	TJH19	FKTYP
60	RJHFPALV	VGOBJ	TJH97	OBJKT	REF
61	RJHFPALV	VKBUR	TVBUR	VKBUR	REF	1	CN
62	RJHFPALV	VKGRP	TVKGR	VKGRP	REF	1	CN
63	RJHFPALV	VKORG_AUFT	TVKO	VKORG	REF	1	CN
64	RJHFPALV	VRKME	T006	MSEHI	REF	1	CN
65	RJHFPALV	VTWEG	TVTW	VTWEG	REF	1	CN
66	RJHFPALV	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in