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

Table

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

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	JHTVPO	MANDT	JR	EQ			AND	0	0
3	JHTVKO	VTNR	JL	EQ				0	0
4	JHTVPO	VTNR	JR	EQ			AND	0	0
5	JHTVPO	POSNR		EQ	'0001'			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	VKBUR	JHTVKO	VKBUR		☐	VKBUR	☐	Sales office
7	VKGRP	JHTVKO	VKGRP		☐	VKGRP	☐	Sales group
8	XORG_ERG	JHTVKO	XORG_ERG		☐	XORG_ERG	☐	IS-M: Contract has Explicitly Assigned Sales Areas
9	ABINHNR	JHTVKO	ABINHNR		☐	ABINHNR	☐	IS-M/AM: Number of Contract Holder
10	KDMI	JHTVKO	KDMI		☐	ISM_CP_CNTRCT_HLDR	☐	IS-M: Contact Person for Contract Holder
11	XQUASI	JHTVKO	XQUASI		☐	XQUASI	☐	IS-M: System Contracts Yes/No Indicator
12	XBESTK	JHTVKO	XBESTK		☐	XBESTK	☐	IS-M: Contract Status (Created/Confirmed)
13	XNEUSTAT	JHTVKO	XNEUSTAT		☐	XNEUSTAT	☐	IS-M: Renewal status (renewed y/n)
14	XABRSPERR	JHTVKO	XABRSPERR		☐	XABRSPERR	☐	IS-M: Settlement Block
15	ABRECHK	JHTVKO	ABRECHK		☐	ABRECHK	☐	IS-M: Settlement Type
16	XABR	JHTVKO	XABR		☐	XABR	☐	IS-M: Perform Settlement Yes/No Indicator
17	XLOEVM	JHTVKO	XLOEVM		☐	LOEVM_ISP	☐	Deletion Flag for Master Data in Media Sales & Distribution
18	LFZBEG	JHTVKO	LFZBEG		☐	LFZBEG	☐	IS-M: Start of Validity Period
19	LFZEND	JHTVKO	LFZEND		☐	LFZEND	☐	IS-M: End of Validity Period
20	ERFDATE	JHTVKO	ERFDATE		☐	ERFDATE	☐	Created On
21	AENDATE	JHTVKO	AENDATE		☐	AENDATE	☐	Date of Last Change
22	MENGE1	JHTVKO	MENGE1		☐	ABS_MENGE1	☐	IS-M/AM: Agreed Quantity to be Sold
23	EINH1	JHTVKO	EINH1		☐	AB_MEINH	☐	IS-M: Contract Units of Measurement
24	AB_ZIEL1	JHTVKO	AB_ZIEL1		☐	AB_ZIEL1	☐	IS-M/AM: Target Quantity for Monetary Contract
25	AB_WEINH	JHTVKO	AB_WEINH		☐	AB_WEINH	☐	IS-M: Currency Key for Contract
26	MENGE2	JHTVKO	MENGE2		☐	ABS_MENGE2	☐	IS-M/AM: Agreed Quantity to be Sold
27	EINH2	JHTVKO	EINH2		☐	AB_MEINH	☐	IS-M: Contract Units of Measurement
28	ABS_TYP1	JHTVKO	ABS_TYP1		☐	ABS_TYP	☐	IS-M/AM: Contract Category
29	XBEST_PR	JHTVKO	XBEST_PR		☐	XBEST_PR	☐	IS-M: Apply Best Conditions to Number / Quantity
30	LEVEL_BP	JHTVKO	LEVEL_BP		☐	JH_BWCOALEVEL_BP	☐	IS-M/AM: Contract BW Classification for Contract Holder
31	LEVEL_BU	JHTVKO	LEVEL_BU		☐	JH_BWCOALEVEL_BU	☐	IS-M/AM: Contract BW Classification for Booking Unit
32	E_BEDNR	JHTVPO	E_BEDNR		☐	E_BEDNR	☐	IS-M/AM: Inclusive Contract Requirement

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