SAP ABAP View COMV_PRODUCT_UPL (Join via Product Master Data and Uploaded Materials)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MD-PRO-IF-PRO (Application Component) Data Exchange Products
     COM_PRODUCT_DATAEXCHANGE (Package) Product Data Exchange
Basic Data
View Type D Database View 
Database View COMV_PRODUCT_UPL  
Short Description Join via Product Master Data and Uploaded Materials    
Root table COMM_PR_MATERIAL   Product - Material - Assignment 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 COMM_PR_MATERIAL COMM_PR_MATERIAL
2 COMM_PRODUCT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 COMM_PRODUCT CLIENT JL EQ 0 0
2 COMM_PR_MATERIAL CLIENT JR EQ AND 0 0
3 COMM_PRODUCT PRODUCT_GUID JL EQ 0 0
4 COMM_PR_MATERIAL PRODUCT_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT COMM_PRODUCT CLIENT   MANDT Client
2 PRODUCT_GUID COMM_PRODUCT PRODUCT_GUID   COMT_PRODUCT_GUID Internal Unique ID of Product
3 PRODUCT_ID COMM_PRODUCT PRODUCT_ID   COMT_PRODUCT_ID Product ID
4 LOGSYS COMM_PR_MATERIAL LOGSYS   COMT_OLTP_LOGSYS Logical System for OLTP System (Display Only)
5 PRODUCT_TYPE COMM_PRODUCT PRODUCT_TYPE   COMT_PRODUCT_TYPE Product Type
6 CONFIG COMM_PRODUCT CONFIG   COMT_PRODUCT_CONFIGURABLE Determines Whether a Product Is Configurable
7 OBJECT_FAMILY COMM_PRODUCT OBJECT_FAMILY   COMT_PRODUCT_OBJECT_FAMILY Object Family
8 BATCH_DEDICATED COMM_PRODUCT BATCH_DEDICATED   COMT_BATCH_DEDICATED Specifies Whether Batches Are Maintained for Product
9 VALID_FROM COMM_PRODUCT VALID_FROM   COMT_VALID_FROM Valid From (Time Stamp)
10 VALID_TO COMM_PRODUCT VALID_TO   COMT_VALID_TO Valid To (Time Stamp)
11 UPNAME COMM_PRODUCT UPNAME   COMT_UPNAME Name of the User Who Last Changed the Set
12 HISTEX COMM_PRODUCT HISTEX   COMT_HISTEX History Exists
                 
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 400