SAP ABAP View JHVGVZ03 (IS-M/AM: Selection View for Service RJHALI02)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JHVGVZ03
Short Description	IS-M/AM: Selection View for Service RJHALI02
Root table	JHAGPZ	IS-M/AM: Assign Business Partner to Order and Item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAGPZ	JHAGPZ
2	JHAK
3	JHAP
4	JHAPD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAK	MANDT	JL	EQ				0	0
2	JHAGPZ	MANDT	JR	EQ			AND	0	0
3	JHAK	AVM_NR	JL	EQ				0	0
4	JHAGPZ	AVM_NR	JR	EQ			AND	0	0
5	JHAP	MANDT	JL	EQ				0	0
6	JHAGPZ	MANDT	JR	EQ			AND	0	0
7	JHAP	AVM_NR	JL	EQ				0	0
8	JHAGPZ	AVM_NR	JR	EQ			AND	0	0
9	JHAP	POS_NR	JL	EQ				0	0
10	JHAGPZ	POS_NR	JR	EQ			AND	0	0
11	JHAK	MANDT	JL	EQ				0	0
12	JHAP	MANDT	JR	EQ			AND	0	0
13	JHAK	AVM_NR	JL	EQ				0	0
14	JHAP	AVM_NR	JR	EQ			AND	0	0
15	JHAK	AVM_NR	JL	EQ				0	0
16	JHAP	AVM_NR	JR	EQ			AND	0	0
17	JHAP	MANDT	JL	EQ				0	0
18	JHAPD	MANDT	JR	EQ			AND	0	0
19	JHAP	AVM_NR	JL	EQ				0	0
20	JHAPD	AVM_NR	JR	EQ			AND	0	0
21	JHAP	POS_NR	JL	EQ				0	0
22	JHAPD	POS_NR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAGPZ	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAGPZ	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAGPZ	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GPROLLE	JHAGPZ	GPROLLE		☐	JPARVW	☐	IS-M: Business Partner Role
5	GPNR	JHAGPZ	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
6	PARZA	JHAGPZ	PARZA		☐	JPARZA	☐	IS-M: Partner Role Counter
7	GRUPPABRNR	JHAGPZ	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
8	UPOS_NR	JHAGPZ	UPOS_NR		☐	UPOS_NR	☐	IS-M: Order Sub-Item Number
9	EIN_NR	JHAGPZ	EIN_NR		☐	EIN_NR	☐	IS-M: Schedule Line
10	MOTIV	JHAGPZ	MOTIV		☐	MOTIV_NR	☐	IS-M: Ad Spec Number (Ad)
11	ADRNR	JHAGPZ	ADRNR		☐	JADRNR	☐	IS-M: Address Number
12	LOGADR	JHAGPZ	LOGADR		☐	JLOGADR	☐	IS-M: Logical Address Number
13	BELEG_ART	JHAGPZ	BELEG_ART		☐	PAM_BELART	☐	IS-M: Voucher Type (Proof)
14	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
15	ANGDT	JHAK	ANGDT		☐	ANGDT_V	☐	Quotation/Inquiry is valid from
16	BNDDT	JHAK	BNDDT		☐	BNDDT	☐	Date until which bid/quotation is binding (valid-to date)
17	AUDAT	JHAK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
18	VBTYP	JHAK	VBTYP		☐	VBTYP	☐	SD document category
19	TRVOG	JHAK	TRVOG		☐	TRVOG_PAM	☐	IS-M: Transaction Process Group - Order Processing
20	AUART	JHAK	AUART		☐	AUART_PAM	☐	IS-M: Sales Document Type
21	AUGRU	JHAK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
22	WAEHRG	JHAK	WAEHRG		☐	WAERK	☐	SD document currency
23	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
24	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
25	SPART	JHAK	SPART		☐	SPART	☐	Division
26	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
27	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
28	GSBER	JHAK	GSBER		☐	GSBER	☐	Business Area
29	GSKST	JHAK	GSKST		☐	GSKST	☐	Business area from cost center
30	KNUMV	JHAK	KNUMV		☐	KNUMV	☐	Number of the document condition
31	KALSM	JHAK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
32	FKARA	JHAK	FKARA		☐	FKARA	☐	Proposed billing type for an order-related billing document
33	BSTNK	JHAK	BSTNK		☐	BSTNK	☐	Customer purchase order number
34	BSARK	JHAK	BSARK		☐	BSARK	☐	Customer Order Type
35	BSTDK	JHAK	BSTDK		☐	BSTDK	☐	Customer purchase order date
36	BSTZD	JHAK	BSTZD		☐	BSTZD	☐	Customer purchase order number supplement
37	IHREZ	JHAK	IHREZ		☐	IHREZ	☐	Your Reference
38	BNAME	JHAK	BNAME		☐	BNAME_V	☐	Name of orderer
39	TELF1	JHAK	TELF1		☐	TELF1_VP	☐	Telephone Number
40	STAFO	JHAK	STAFO		☐	JHSTAFO	☐	IS-M: Update group for statistics update
41	STWAE	JHAK	STWAE		☐	STWAE	☐	Statistics currency
42	KKBER	JHAK	KKBER		☐	KKBER	☐	Credit control area
43	KNKLI	JHAK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
44	GRUPP	JHAK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
45	SBGRP	JHAK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
46	CTLPC	JHAK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
47	CMWAE	JHAK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
48	CMFRE	JHAK	CMFRE		☐	CMFRE	☐	Release date of the document determined by credit management
49	MANUSERF	JHAK	MANUSERF		☐	MANUSERF	☐	IS-M: Order data entered by (entry on paper)
50	MAN_VKBUR	JHAK	MAN_VKBUR		☐	MAN_VKBUR	☐	IS-M/AM: Sales Office of Person who Entered Booking Details
51	REF_AVM_NR	JHAK	REF_AVM_NR		☐	REF_AVM_NR	☐	IS-M: Reference Order Number of Preceding Order
52	FRD_AVM_NR	JHAK	FRD_AVM_NR		☐	FRD_AVM_NR	☐	IS-M: Externally Assigned Order Number
53	STATUSK	JHAK	STATUSK		☐	STATUSK	☐	IS-M: Status
54	NOTIZKNZ	JHAK	NOTIZKNZ		☐	NOTIZKNZ	☐	IS-M: Indicates Whether Notes are Available for an OPM Objct
55	VERMITTLER	JHAK	VERMITTLER		☐	VERMK	☐	IS-M: Sales Agent with ID Code for Screen
56	ERFUSER	JHAK	ERFUSER		☐	ERFUSER	☐	Created By
57	ERFDATE	JHAK	ERFDATE		☐	ERFDATE	☐	Created On
58	ERFTIME	JHAK	ERFTIME		☐	ERFTIME	☐	Time Created
59	AENUSER	JHAK	AENUSER		☐	AENUSER	☐	Last Changed By
60	AENDATE	JHAK	AENDATE		☐	AENDATE	☐	Date of Last Change
61	AENTIME	JHAK	AENTIME		☐	AENTIME	☐	Time of Last Change
62	RAB1_BETR	JHAK	RAB1_BETR		☐	JRABPROZ	☐	IS-M/AM: Percentage discount
63	RAB1_GRUND	JHAK	RAB1_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
64	RAB1_BKTYP	JHAK	RAB1_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
65	RAB2_BETR	JHAK	RAB2_BETR		☐	JRABPROZ	☐	IS-M/AM: Percentage discount
66	RAB2_GRUND	JHAK	RAB2_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
67	RAB2_BKTYP	JHAK	RAB2_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
68	RAB3_BETR	JHAK	RAB3_BETR		☐	JRABPROZ	☐	IS-M/AM: Percentage discount
69	RAB3_GRUND	JHAK	RAB3_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
70	RAB3_BKTYP	JHAK	RAB3_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
71	RAB4_BETR	JHAK	RAB4_BETR		☐	JRABMEIN	☐	IS-M/AM: Quantity-dependent discount
72	RAB4_PEIN	JHAK	RAB4_PEIN		☐	PAMPEIN	☐	IS-M: Price Unit (Surcharge Discount, Basic Price)
73	RAB4_MEIN	JHAK	RAB4_MEIN		☐	PAMMEIN	☐	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)
74	RAB4_GRUND	JHAK	RAB4_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
75	RAB4_BKTYP	JHAK	RAB4_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
76	RAB5_BETR	JHAK	RAB5_BETR		☐	JRABBETR	☐	IS-M/AM: Amount discount
77	RAB5_GRUND	JHAK	RAB5_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
78	RAB5_BKTYP	JHAK	RAB5_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
79	ZUS1_BETR	JHAK	ZUS1_BETR		☐	JZUSPROZ	☐	IS-M/AM: Percentage Surcharge
80	ZUS1_GRUND	JHAK	ZUS1_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
81	ZUS1_BKTYP	JHAK	ZUS1_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
82	ZUS2_BETR	JHAK	ZUS2_BETR		☐	JZUSPROZ	☐	IS-M/AM: Percentage Surcharge
83	ZUS2_GRUND	JHAK	ZUS2_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
84	ZUS2_BKTYP	JHAK	ZUS2_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
85	ZUS3_BETR	JHAK	ZUS3_BETR		☐	JZUSPROZ	☐	IS-M/AM: Percentage Surcharge
86	ZUS3_GRUND	JHAK	ZUS3_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
87	ZUS3_BKTYP	JHAK	ZUS3_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
88	ZUS4_BETR	JHAK	ZUS4_BETR		☐	JZUSMEIN	☐	IS-M/AM: Quantity-dependent surcharge
89	ZUS4_PEIN	JHAK	ZUS4_PEIN		☐	PAMPEIN	☐	IS-M: Price Unit (Surcharge Discount, Basic Price)
90	ZUS4_MEIN	JHAK	ZUS4_MEIN		☐	PAMMEIN	☐	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)
91	ZUS4_GRUND	JHAK	ZUS4_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
92	ZUS4_BKTYP	JHAK	ZUS4_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
93	ZUS5_BETR	JHAK	ZUS5_BETR		☐	JZUSBETR	☐	IS-M/AM: Amount Surcharge
94	ZUS5_GRUND	JHAK	ZUS5_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
95	ZUS5_BKTYP	JHAK	ZUS5_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
96	FPRG_BETR	JHAK	FPRG_BETR		☐	JGPRBETR	☐	IS-M/AM: Basic Price
97	FPRG_PEIN	JHAK	FPRG_PEIN		☐	PAMPEIN	☐	IS-M: Price Unit (Surcharge Discount, Basic Price)
98	FPRG_MEIN	JHAK	FPRG_MEIN		☐	PAMMEIN	☐	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)
99	FPRG_GRUND	JHAK	FPRG_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
100	FPRG_BKTYP	JHAK	FPRG_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
101	FPR1_BETR	JHAK	FPR1_BETR		☐	JVPRBETR	☐	IS-M/AM: Agreed price
102	FPR1_GRUND	JHAK	FPR1_GRUND		☐	JGRKOND	☐	IS-M: Reason for Entering Conditions
103	FPR1_BKTYP	JHAK	FPR1_BKTYP		☐	BKTYP	☐	IS-M: Condition Input Type in the Order
104	XRABZU	JHAK	XRABZU		☐	XRABZU	☐	IS-M: Discount/Surcharge Exists Indicator
105	WAER_IPZA	JHAK	WAER_IPZA		☐	WAERK	☐	SD document currency
106	POS_ART	JHAP	POS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
107	WERBK_TYP	JHAP	WERBK_TYP		☐	WKOMBI_TYP	☐	IS-M: Combination Sale Type
108	XAGENAUFTR	JHAP	XAGENAUFTR		☐	XAGENAUFTR	☐	IS-M: Agency order indicator
109	BRAN_PAM	JHAP	BRAN_PAM		☐	BRAN_POS	☐	IS-M/AM: Current Industry Sector Associated With Order Item
110	KAMPAGNE	JHAP	KAMPAGNE		☐	KAMPAGNE	☐	IS-M: Campaign (customer)
111	STATUS_P	JHAP	STATUSK		☐	STATUSK	☐	IS-M: Status

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