SAP ABAP View JBWVABRUF (IS-M/AM BW: View to Select Assignments 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	JBWVABRUF
Short Description	IS-M/AM BW: View to Select Assignments to be Uploaded
Root table	JHTVKO	IS-M/AM: Contract

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHTVKO	JHTVKO
2	JHTVABRUF

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				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	*	JHTVABRUF	*		☐		☐
8	-	JHTVABRUF	MANDT		☐	MANDT	☐	Client
9	-	JHTVABRUF	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
10	POSNR	JHTVABRUF	POSNR		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
11	AVM_NR	JHTVABRUF	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
12	POS_NR	JHTVABRUF	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
13	GRUPPABRNR	JHTVABRUF	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
14	RABATT_NR	JHTVABRUF	RABATT_NR		☐	RABATT_NR	☐	IS-M: Class of Discount in a Billing Dataset
15	INSERENT	JHTVABRUF	INSERENT		☐	INSERENT	☐	IS-M: Advertiser
16	AGENTUR	JHTVABRUF	AGENTUR		☐	AGENTUR	☐	IS-M: Agency
17	PRODH	JHTVABRUF	PRODH		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
18	ABR_DAT	JHTVABRUF	ABR_DAT		☐	ABRUF_DAT	☐	IS-M: Allocation Date of Contract Assignment
19	XFAKTURA	JHTVABRUF	XFAKTURA		☐	XFAK_ZUO	☐	IS-M: Billed Assignment Indicator
20	RABATT	JHTVABRUF	RABATT		☐	AB_RABATT	☐	IS-M: Current Valid Contract Discount Rate
21	BONUS	JHTVABRUF	BONUS		☐	AKTBONUS	☐	IS-M/AM: Current Valid Contract Bonus
22	AB_PREIS	JHTVABRUF	AB_PREIS		☐	AB_PREIS	☐	IS-M: Current Valid Price from Contract
23	FMP_WAERS	JHTVABRUF	FMP_WAERS		☐	WAERS	☐	Currency Key
24	FMP_KPEIN	JHTVABRUF	FMP_KPEIN		☐	KPEIN	☐	Condition pricing unit
25	FMP_KMEIN	JHTVABRUF	FMP_KMEIN		☐	KMEIN	☐	Condition Unit
26	KAUSSCHL	JHTVABRUF	KAUSSCHL		☐	JH_KAUSSCHL	☐	IS-M: Condition Exclusion Rule for Media-Mix Contract
27	XRABATT	JHTVABRUF	XRABATT		☐	XRABATT	☐	IS-M: Assignment Qualifies for Discount
28	XMITZRAB	JHTVABRUF	XMITZRAB		☐	XMITZRAB	☐	IS-M: Assignment Counts Towards Discount Fulfillment
29	XBONUS	JHTVABRUF	XBONUS		☐	XBONUS	☐	IS-M: Assignment Qualifies for Bonus
30	XMITZBON	JHTVABRUF	XMITZBON		☐	XMITZBON	☐	IS-M: Assignment Counts Towards Bonus Fulfillment
31	XMANZUO	JHTVABRUF	XMANZUO		☐	XMANZUO	☐	IS-M: Level of Manual Influence for a Contract Assignment
32	XFRZUO	JHTVABRUF	XFRZUO		☐	XFRZUO	☐	IS-M/AM: Indirect COA Assignment Via Hierarchy
33	XAZORIG	JHTVABRUF	XAZORIG		☐	XAZORIG	☐	IS-M: Indicator for Original Contract Assignment
34	XVBZUO	JHTVABRUF	XVBZUO		☐	XVBZUO	☐	IS-M/AM: COA Assignment From Other Sales Area
35	XPAR_ABS	JHTVABRUF	XPAR_ABS		☐	XPAR_ABS	☐	IS-M: Work With Parallel Contracts Indicator
36	ABR_ZSTAT	JHTVABRUF	ABR_ZSTAT		☐	ABR_ZSTAT	☐	IS-M: Settlement Status of the Assignment
37	XSTORNIERT	JHTVABRUF	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
38	XLOEVM	JHTVABRUF	XLOEVM		☐	LOEVM_ISP	☐	Deletion Flag for Master Data in Media Sales & Distribution
39	VBSTAT	JHTVABRUF	VBSTAT		☐	ABS_VBSTAT	☐	IS-M: Assignment Not Updated in Contract Standing
40	AB_BRUTTO	JHTVABRUF	AB_BRUTTO		☐	AB_BRUTTO	☐	IS-M: Contract Gross
41	ABRMM	JHTVABRUF	ABRMM		☐	ABRMM	☐	IS-M: Quantity (mm, Pages, Seconds)
42	ABRME	JHTVABRUF	ABRME		☐	ABRME	☐	IS-M: Number
43	ORIG_VTNR	JHTVABRUF	ORIG_VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
44	XFR_AVM	JHTVABRUF	XFR_AVM		☐	XFR_AVM	☐	IS-M: Assignment from data transfer legacy system indicator
45	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	20110901
SAP Release Created in	462