SAP ABAP View LSTV_PRP_PRODUCT (View for PPR via a Product)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MD-PPR (Application Component) Partner/Product Range
     LST_PRP_MAINTENANCE (Package) Maintenance of the PPR part of Listings
Basic Data
View Type D Database View 
Database View LSTV_PRP_PRODUCT  
Short Description View for PPR via a Product    
Root table CRMM_PRPADM_H   Partner/Product Range 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRMM_PRPADM_H CRMM_PRPADM_H
2 CRMM_PRPADM_I  
3 CRMM_PRP_PROD_I  
4 COMM_PRODUCT  
5 CRMC_PRP_TYPES  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CRMM_PRPADM_H GUID JL EQ 0 0
2 CRMM_PRPADM_I PARENT_GUID JR EQ AND 0 0
3 CRMM_PRPADM_H CLIENT JL EQ 0 0
4 CRMM_PRPADM_I CLIENT JR EQ AND 0 0
5 CRMM_PRP_PROD_I PARENT_GUID JL EQ 0 0
6 CRMM_PRPADM_I GUID JR EQ AND 0 0
7 CRMM_PRP_PROD_I CLIENT JL EQ 0 0
8 CRMM_PRPADM_I CLIENT JR EQ AND 0 0
9 COMM_PRODUCT PRODUCT_GUID JL EQ 0 0
10 CRMM_PRP_PROD_I PRODUCT_REF_GUID JR EQ AND 0 0
11 COMM_PRODUCT CLIENT JL EQ 0 0
12 CRMM_PRP_PROD_I CLIENT JR EQ AND 0 0
13 CRMC_PRP_TYPES CLIENT JL EQ 0 0
14 CRMM_PRPADM_H CLIENT JR EQ AND 0 0
15 CRMC_PRP_TYPES PRP_TYPE JL EQ 0 0
16 CRMM_PRPADM_H PRP_TYPE JR EQ AND 0 0
17 CRMM_PRP_PROD_I TYPE EQ '1' AND 0 0
18 CRMC_PRP_TYPES PRP_LST EQ 'X' AND 0 0
19 CRMM_PRPADM_H PRP_STATUS EQ '1' OR 0 0
20 CRMM_PRPADM_H PRP_STATUS EQ '2' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CRMM_PRPADM_H CLIENT   MANDT Client
2 GUID CRMM_PRPADM_H GUID   CRMT_PRP_GUID Internal, Unique Identifier for PPR Objects
3 PRODUCT_GUID COMM_PRODUCT PRODUCT_GUID   COMT_PRODUCT_GUID Internal Unique ID of Product
4 PRODUCT_ID COMM_PRODUCT PRODUCT_ID   COMT_PRODUCT_ID Product ID
5 PRP_ID CRMM_PRPADM_H PRP_ID   LSTT_PRP_ID Identifier for a Listing Object
6 PRP_TYPE CRMM_PRPADM_H PRP_TYPE   LSTT_PRP_TYPE Type of a Partner/Product Range (PPR) Used for Listing
7 PRP_LST CRMC_PRP_TYPES PRP_LST   CRMT_PRP_LST Flag new listing object
                 
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  20100421 
SAP Release Created in 401