SAP ABAP View JJPRDHV_PROFGP (IS-M/AM: Product Hierarchy: View for Sorting Link Table)

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_PROFGP
Short Description	IS-M/AM: Product Hierarchy: View for Sorting Link Table
Root table	JJTPRDH_PROD	IS-M/AM: Products (S&P Product Hierarchy)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTPRDH_PROD	JJTPRDH_PROD
2	JJTPRDH_PRFGP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTPRDH_PROD	MANDT	JL	EQ				0	0
2	JJTPRDH_PRFGP	MANDT	JR	EQ			AND	0	0
3	JJTPRDH_PROD	HERKUNFT	JL	EQ				0	0
4	JJTPRDH_PRFGP	HERKUNFT	JR	EQ			AND	0	0
5	JJTPRDH_PROD	PRODUKT	JL	EQ				0	0
6	JJTPRDH_PRFGP	PRODUKT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTPRDH_PROD	MANDT		☐	MANDT	☐	Client
2	HERKUNFT	JJTPRDH_PROD	HERKUNFT		☐	ISM_PRDH_HERKUNFT	☐	IS-M/AM: Origin Key
3	PRODUKT	JJTPRDH_PROD	PRODUKT		☐	ISM_PRDH_PROD	☐	IS-M/AM: Product
4	LAND	JJTPRDH_PROD	LAND		☐	ISM_PRDH_LAND	☐	IS-M/AM: Country Code
5	DATAB	JJTPRDH_PROD	DATAB		☐	BEGDA	☐	Start Date
6	DATBIS	JJTPRDH_PROD	DATBIS		☐	ENDDA	☐	End Date
7	PRODBEZ	JJTPRDH_PROD	PRODBEZ		☐	ISM_PRDH_BEZEICHNUNG	☐	IS-M/AM: Product Hierarchy: Description
8	FGPBEZ	JJTPRDH_PRFGP	FGPBEZ		☐	ISM_PRDH_FGPBEZ	☐	IS-M/AM: External BP Description
9	FGPPLZ	JJTPRDH_PRFGP	FGPPLZ		☐	ISM_PRDH_FGP_PLZ	☐	IS-M/AM: Postal Code for External Business Partner

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	471