SAP ABAP View JBWVABRFP (IS-M/AM BW: View to Select Billing Items to be Uploaded)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-IS (Application Component) Information System
     ⤷ JSBW (Package) IS-M: Link to Business Information Warehouse

Basic Data

View Type	D	Database View
Database View	JBWVABRFP
Short Description	IS-M/AM BW: View to Select Billing Items to be Uploaded
Root table	JHTVKO	IS-M/AM: Contract

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHTVKO	JHTVKO
2	JHTVABRUF
3	JHTFP
4	JHTFK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHTVKO	MANDT	JL	EQ				0	0
2	JHTVABRUF	MANDT	JR	EQ			AND	0	0
3	JHTVKO	VTNR	JL	EQ				0	0
4	JHTVABRUF	VTNR	JR	EQ			AND	0	0
5	JHTVABRUF	MANDT	JL	EQ				0	0
6	JHTFP	MANDT	JR	EQ			AND	0	0
7	JHTVABRUF	AVM_NR	JL	EQ				0	0
8	JHTFP	AUBEL	JR	EQ			AND	0	0
9	JHTVABRUF	POS_NR	JL	EQ				0	0
10	JHTFP	AUPOS	JR	EQ			AND	0	0
11	JHTVABRUF	GRUPPABRNR	JL	EQ				0	0
12	JHTFP	AUGRP	JR	EQ			AND	0	0
13	JHTFK	MANDT	JL	EQ				0	0
14	JHTFP	MANDT	JR	EQ			AND	0	0
15	JHTFK	VBELN	JL	EQ				0	0
16	JHTFP	VBELN	JR	EQ			AND	0	0
17	JHTFK	FKTYP		EQ	'A'		OR	0	0
18	JHTFK	FKTYP		EQ	'B'		OR	0	0
19	JHTFK	FKTYP		EQ	'F'		OR	0	0
20	JHTFK	FKTYP		EQ	'P'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHTVKO	MANDT		☐	MANDT	☐	Client
2	VTNR	JHTVKO	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
3	VKORG	JHTVKO	VKORG		☐	VKORG	☐	Sales Organization
4	VTWEG	JHTVKO	VTWEG		☐	VTWEG	☐	Distribution Channel
5	SPART	JHTVKO	SPART		☐	SPART	☐	Division
6	LFZEND	JHTVKO	LFZEND		☐	LFZEND	☐	IS-M: End of Validity Period
7	VPOSNR	JHTFP	POSNR		☐	JJPOSNR	☐	IS-M/AM: Item (number) in settlement document
8	KZWI1	JHTFP	KZWI1		☐	KZWI1	☐	Subtotal 1 from pricing procedure for condition
9	KZWI2	JHTFP	KZWI2		☐	KZWI2	☐	Subtotal 2 from pricing procedure for condition
10	KZWI3	JHTFP	KZWI3		☐	KZWI3	☐	Subtotal 3 from pricing procedure for condition
11	KZWI4	JHTFP	KZWI4		☐	KZWI4	☐	Subtotal 4 from pricing procedure for condition
12	KZWI5	JHTFP	KZWI5		☐	KZWI5	☐	Subtotal 5 from pricing procedure for condition
13	KZWI6	JHTFP	KZWI6		☐	KZWI6	☐	Subtotal 6 from pricing procedure for condition
14	BRTWP	JHTFP	BRTWP		☐	JHBRTWRP	☐	IS-M: Gross Value in Document Currency (Item)
15	NETWP	JHTFP	NETWP		☐	NETWR_FP	☐	Net value of the billing item in document currency
16	MWSBP	JHTFP	MWSBP		☐	MWSBP	☐	Tax amount in document currency
17	VBELN	JHTFK	VBELN		☐	JJBELNR	☐	IS-M/AM: Billing Document
18	FKART	JHTFK	FKART		☐	FKART_PAM	☐	IS-M/AM: Billing/Settlement Document Type
19	FKTYP	JHTFK	FKTYP		☐	JHFKTYP	☐	IS-M/AM: Billing Category
20	VBTYP	JHTFK	VBTYP		☐	ISPVBTYP	☐	IS-M/AM: Sales Document Category
21	WAERK	JHTFK	WAERK		☐	WAERK	☐	SD document currency
22	*	JHTVABRUF	*		☐		☐
23	-	JHTVABRUF	MANDT		☐	MANDT	☐	Client
24	-	JHTVABRUF	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
25	POSNR	JHTVABRUF	POSNR		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
26	AVM_NR	JHTVABRUF	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
27	POS_NR	JHTVABRUF	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
28	GRUPPABRNR	JHTVABRUF	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
29	RABATT_NR	JHTVABRUF	RABATT_NR		☐	RABATT_NR	☐	IS-M: Class of Discount in a Billing Dataset
30	INSERENT	JHTVABRUF	INSERENT		☐	INSERENT	☐	IS-M: Advertiser
31	AGENTUR	JHTVABRUF	AGENTUR		☐	AGENTUR	☐	IS-M: Agency
32	PRODH	JHTVABRUF	PRODH		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
33	ABR_DAT	JHTVABRUF	ABR_DAT		☐	ABRUF_DAT	☐	IS-M: Allocation Date of Contract Assignment
34	XFAKTURA	JHTVABRUF	XFAKTURA		☐	XFAK_ZUO	☐	IS-M: Billed Assignment Indicator
35	RABATT	JHTVABRUF	RABATT		☐	AB_RABATT	☐	IS-M: Current Valid Contract Discount Rate
36	BONUS	JHTVABRUF	BONUS		☐	AKTBONUS	☐	IS-M/AM: Current Valid Contract Bonus
37	AB_PREIS	JHTVABRUF	AB_PREIS		☐	AB_PREIS	☐	IS-M: Current Valid Price from Contract
38	FMP_WAERS	JHTVABRUF	FMP_WAERS		☐	WAERS	☐	Currency Key
39	FMP_KPEIN	JHTVABRUF	FMP_KPEIN		☐	KPEIN	☐	Condition pricing unit
40	FMP_KMEIN	JHTVABRUF	FMP_KMEIN		☐	KMEIN	☐	Condition Unit
41	KAUSSCHL	JHTVABRUF	KAUSSCHL		☐	JH_KAUSSCHL	☐	IS-M: Condition Exclusion Rule for Media-Mix Contract
42	XRABATT	JHTVABRUF	XRABATT		☐	XRABATT	☐	IS-M: Assignment Qualifies for Discount
43	XMITZRAB	JHTVABRUF	XMITZRAB		☐	XMITZRAB	☐	IS-M: Assignment Counts Towards Discount Fulfillment
44	XBONUS	JHTVABRUF	XBONUS		☐	XBONUS	☐	IS-M: Assignment Qualifies for Bonus
45	XMITZBON	JHTVABRUF	XMITZBON		☐	XMITZBON	☐	IS-M: Assignment Counts Towards Bonus Fulfillment
46	XMANZUO	JHTVABRUF	XMANZUO		☐	XMANZUO	☐	IS-M: Level of Manual Influence for a Contract Assignment
47	XFRZUO	JHTVABRUF	XFRZUO		☐	XFRZUO	☐	IS-M/AM: Indirect COA Assignment Via Hierarchy
48	XAZORIG	JHTVABRUF	XAZORIG		☐	XAZORIG	☐	IS-M: Indicator for Original Contract Assignment
49	XVBZUO	JHTVABRUF	XVBZUO		☐	XVBZUO	☐	IS-M/AM: COA Assignment From Other Sales Area
50	XPAR_ABS	JHTVABRUF	XPAR_ABS		☐	XPAR_ABS	☐	IS-M: Work With Parallel Contracts Indicator
51	ABR_ZSTAT	JHTVABRUF	ABR_ZSTAT		☐	ABR_ZSTAT	☐	IS-M: Settlement Status of the Assignment
52	XSTORNIERT	JHTVABRUF	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
53	XLOEVM	JHTVABRUF	XLOEVM		☐	LOEVM_ISP	☐	Deletion Flag for Master Data in Media Sales & Distribution
54	VBSTAT	JHTVABRUF	VBSTAT		☐	ABS_VBSTAT	☐	IS-M: Assignment Not Updated in Contract Standing
55	AB_BRUTTO	JHTVABRUF	AB_BRUTTO		☐	AB_BRUTTO	☐	IS-M: Contract Gross
56	ABRMM	JHTVABRUF	ABRMM		☐	ABRMM	☐	IS-M: Quantity (mm, Pages, Seconds)
57	ABRME	JHTVABRUF	ABRME		☐	ABRME	☐	IS-M: Number
58	ORIG_VTNR	JHTVABRUF	ORIG_VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
59	XFR_AVM	JHTVABRUF	XFR_AVM		☐	XFR_AVM	☐	IS-M: Assignment from data transfer legacy system indicator
60	PSTYV	JHTVABRUF	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	462