SAP ABAP View JJPRDHV_AVVORPR (IS-M/AM: P.Hierarchy: View for OPM F4 Help Product All)

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	JJPRDHV_AVVORPR
Short Description	IS-M/AM: P.Hierarchy: View for OPM F4 Help Product All
Root table	JJTPRDH_WB	IS-M/AM (S&P Product Hierarchy): Economic Sectors

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTPRDH_WB	JJTPRDH_WB
2	JJTPRDH_PRGR
3	JJTPRDH_PRFAM
4	JJTPRDH_DACHPR
5	JJTPRDH_PROD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTPRDH_WB	MANDT	JL	EQ				0	0
2	JJTPRDH_PRGR	MANDT	JR	EQ			AND	0	0
3	JJTPRDH_WB	MANDT	JL	EQ				0	0
4	JJTPRDH_PRFAM	MANDT	JR	EQ			AND	0	0
5	JJTPRDH_WB	MANDT	JL	EQ				0	0
6	JJTPRDH_DACHPR	MANDT	JR	EQ			AND	0	0
7	JJTPRDH_WB	MANDT	JL	EQ				0	0
8	JJTPRDH_PROD	MANDT	JR	EQ			AND	0	0
9	JJTPRDH_WB	HERKUNFT	JL	EQ				0	0
10	JJTPRDH_PRGR	HERKUNFT	JR	EQ			AND	0	0
11	JJTPRDH_WB	HERKUNFT	JL	EQ				0	0
12	JJTPRDH_PRFAM	HERKUNFT	JR	EQ			AND	0	0
13	JJTPRDH_WB	HERKUNFT	JL	EQ				0	0
14	JJTPRDH_DACHPR	HERKUNFT	JR	EQ			AND	0	0
15	JJTPRDH_WB	HERKUNFT	JL	EQ				0	0
16	JJTPRDH_PROD	HERKUNFT	JR	EQ			AND	0	0
17	JJTPRDH_WB	WB	JL	EQ				0	0
18	JJTPRDH_PRGR	WB	JR	EQ			AND	0	0
19	JJTPRDH_WB	WB	JL	EQ				0	0
20	JJTPRDH_PRFAM	WB	JR	EQ			AND	0	0
21	JJTPRDH_WB	WB	JL	EQ				0	0
22	JJTPRDH_DACHPR	WB	JR	EQ			AND	0	0
23	JJTPRDH_WB	WB	JL	EQ				0	0
24	JJTPRDH_PROD	WB	JR	EQ			AND	0	0
25	JJTPRDH_WB	LAND	JL	EQ				0	0
26	JJTPRDH_PRGR	LAND	JR	EQ			AND	0	0
27	JJTPRDH_WB	LAND	JL	EQ				0	0
28	JJTPRDH_PRFAM	LAND	JR	EQ			AND	0	0
29	JJTPRDH_WB	LAND	JL	EQ				0	0
30	JJTPRDH_DACHPR	LAND	JR	EQ			AND	0	0
31	JJTPRDH_WB	LAND	JL	EQ				0	0
32	JJTPRDH_PROD	LAND	JR	EQ			AND	0	0
33	JJTPRDH_PRGR	MANDT	JL	EQ				0	0
34	JJTPRDH_PRFAM	MANDT	JR	EQ			AND	0	0
35	JJTPRDH_PRGR	MANDT	JL	EQ				0	0
36	JJTPRDH_DACHPR	MANDT	JR	EQ			AND	0	0
37	JJTPRDH_PRGR	MANDT	JL	EQ				0	0
38	JJTPRDH_PROD	MANDT	JR	EQ			AND	0	0
39	JJTPRDH_PRGR	HERKUNFT	JL	EQ				0	0
40	JJTPRDH_PRFAM	HERKUNFT	JR	EQ			AND	0	0
41	JJTPRDH_PRGR	HERKUNFT	JL	EQ				0	0
42	JJTPRDH_DACHPR	HERKUNFT	JR	EQ			AND	0	0
43	JJTPRDH_PRGR	HERKUNFT	JL	EQ				0	0
44	JJTPRDH_PROD	HERKUNFT	JR	EQ			AND	0	0
45	JJTPRDH_PRGR	WB	JL	EQ				0	0
46	JJTPRDH_PRFAM	WB	JR	EQ			AND	0	0
47	JJTPRDH_PRGR	WB	JL	EQ				0	0
48	JJTPRDH_DACHPR	WB	JR	EQ			AND	0	0
49	JJTPRDH_PRGR	WB	JL	EQ				0	0
50	JJTPRDH_PROD	WB	JR	EQ			AND	0	0
51	JJTPRDH_PRGR	PRODGR	JL	EQ				0	0
52	JJTPRDH_PRFAM	PRODGR	JR	EQ			AND	0	0
53	JJTPRDH_PRGR	PRODGR	JL	EQ				0	0
54	JJTPRDH_DACHPR	PRODGR	JR	EQ			AND	0	0
55	JJTPRDH_PRGR	PRODGR	JL	EQ				0	0
56	JJTPRDH_PROD	PRODGR	JR	EQ			AND	0	0
57	JJTPRDH_PRGR	LAND	JL	EQ				0	0
58	JJTPRDH_PRFAM	LAND	JR	EQ			AND	0	0
59	JJTPRDH_PRGR	LAND	JL	EQ				0	0
60	JJTPRDH_DACHPR	LAND	JR	EQ			AND	0	0
61	JJTPRDH_PRGR	LAND	JL	EQ				0	0
62	JJTPRDH_PROD	LAND	JR	EQ			AND	0	0
63	JJTPRDH_PRFAM	MANDT	JL	EQ				0	0
64	JJTPRDH_DACHPR	MANDT	JR	EQ			AND	0	0
65	JJTPRDH_PRFAM	MANDT	JL	EQ				0	0
66	JJTPRDH_PROD	MANDT	JR	EQ			AND	0	0
67	JJTPRDH_PRFAM	HERKUNFT	JL	EQ				0	0
68	JJTPRDH_DACHPR	HERKUNFT	JR	EQ			AND	0	0
69	JJTPRDH_PRFAM	HERKUNFT	JL	EQ				0	0
70	JJTPRDH_PROD	HERKUNFT	JR	EQ			AND	0	0
71	JJTPRDH_PRFAM	WB	JL	EQ				0	0
72	JJTPRDH_DACHPR	WB	JR	EQ			AND	0	0
73	JJTPRDH_PRFAM	WB	JL	EQ				0	0
74	JJTPRDH_PROD	WB	JR	EQ			AND	0	0
75	JJTPRDH_PRFAM	PRODGR	JL	EQ				0	0
76	JJTPRDH_DACHPR	PRODGR	JR	EQ			AND	0	0
77	JJTPRDH_PRFAM	PRODGR	JL	EQ				0	0
78	JJTPRDH_PROD	PRODGR	JR	EQ			AND	0	0
79	JJTPRDH_PRFAM	PRODFAM	JL	EQ				0	0
80	JJTPRDH_DACHPR	PRODFAM	JR	EQ			AND	0	0
81	JJTPRDH_PRFAM	PRODFAM	JL	EQ				0	0
82	JJTPRDH_PROD	PRODFAM	JR	EQ			AND	0	0
83	JJTPRDH_PRFAM	LAND	JL	EQ				0	0
84	JJTPRDH_DACHPR	LAND	JR	EQ			AND	0	0
85	JJTPRDH_PRFAM	LAND	JL	EQ				0	0
86	JJTPRDH_PROD	LAND	JR	EQ			AND	0	0
87	JJTPRDH_DACHPR	MANDT	JL	EQ				0	0
88	JJTPRDH_PROD	MANDT	JR	EQ			AND	0	0
89	JJTPRDH_DACHPR	HERKUNFT	JL	EQ				0	0
90	JJTPRDH_PROD	HERKUNFT	JR	EQ			AND	0	0
91	JJTPRDH_DACHPR	WB	JL	EQ				0	0
92	JJTPRDH_WB	WB	JR	EQ			AND	0	0
93	JJTPRDH_DACHPR	PRODGR	JL	EQ				0	0
94	JJTPRDH_PRGR	PRODGR	JR	EQ			AND	0	0
95	JJTPRDH_DACHPR	PRODFAM	JL	EQ				0	0
96	JJTPRDH_PRFAM	PRODFAM	JR	EQ			AND	0	0
97	JJTPRDH_DACHPR	DACHPROD	JL	EQ				0	0
98	JJTPRDH_PROD	DACHPROD	JR	EQ			AND	0	0
99	JJTPRDH_DACHPR	LAND	JL	EQ				0	0
100	JJTPRDH_WB	LAND	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTPRDH_WB	MANDT		☐	MANDT	☐	Client
2	HERKUNFT	JJTPRDH_WB	HERKUNFT		☐	ISM_PRDH_HERKUNFT	☐	IS-M/AM: Origin Key
3	WB	JJTPRDH_WB	WB		☐	ISM_PRDH_WBEREICH	☐	IS-M/AM: Economic Sector
4	WBBEZ	JJTPRDH_WB	WBBEZ		☐	ISM_PRDH_BEZEICHNUNG	☐	IS-M/AM: Product Hierarchy: Description
5	PRODGR	JJTPRDH_PRGR	PRODGR		☐	ISM_PRDH_PRODGRP	☐	IS-M/AM: Product Group
6	PRODGRBEZ	JJTPRDH_PRGR	PRODGRBEZ		☐	ISM_PRDH_BEZEICHNUNG	☐	IS-M/AM: Product Hierarchy: Description
7	PRODFAM	JJTPRDH_PRFAM	PRODFAM		☐	ISM_PRDH_PRODFAM	☐	IS-M/AM: Product Family
8	PRODFAMBEZ	JJTPRDH_PRFAM	PRODFAMBEZ		☐	ISM_PRDH_BEZEICHNUNG	☐	IS-M/AM: Product Hierarchy: Description
9	DACHPROD	JJTPRDH_DACHPR	DACHPROD		☐	ISM_PRDH_DACHPROD	☐	IS-M/AM: Umbrella Product
10	DACHPRODBEZ	JJTPRDH_DACHPR	DACHPRODBEZ		☐	ISM_PRDH_BEZEICHNUNG	☐	IS-M/AM: Product Hierarchy: Description
11	PRODUKT	JJTPRDH_PROD	PRODUKT		☐	ISM_PRDH_PROD	☐	IS-M/AM: Product
12	PRODBEZ	JJTPRDH_PROD	PRODBEZ		☐	ISM_PRDH_BEZEICHNUNG	☐	IS-M/AM: Product Hierarchy: Description
13	DATAB	JJTPRDH_PROD	DATAB		☐	BEGDA	☐	Start Date
14	DATBIS	JJTPRDH_PROD	DATBIS		☐	ENDDA	☐	End Date
15	LAND	JJTPRDH_PROD	LAND		☐	ISM_PRDH_LAND	☐	IS-M/AM: Country Code

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	20050224
SAP Release Created in	472