SAP ABAP View CRMV_SALESG_BW (Join via Product Master Data, Link and SetType Table(SALESG))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-ANA-MD-PRO (Application Component) Use BW-BCT-CRM-MD
     CRM_PRODUCT_BW_MD (Package) BW Extractors Product CRM Part
Basic Data
View Type D Database View 
Database View CRMV_SALESG_BW  
Short Description Join via Product Master Data, Link and SetType Table(SALESG)    
Root table COMM_PRODUCT   Product 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 COMM_PRODUCT COMM_PRODUCT
2 COMM_PR_FRG_ROD  
3 CRMM_PR_SALESG  
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_FRG_ROD CLIENT JR EQ AND 0 0
3 COMM_PRODUCT PRODUCT_GUID JL EQ 0 0
4 COMM_PR_FRG_ROD PRODUCT_GUID JR EQ AND 0 0
5 COMM_PR_FRG_ROD CLIENT JL EQ 0 0
6 CRMM_PR_SALESG CLIENT JR EQ AND 0 0
7 COMM_PR_FRG_ROD FRAGMENT_GUID JL EQ 0 0
8 CRMM_PR_SALESG FRG_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 PRODUCT_TYPE COMM_PRODUCT PRODUCT_TYPE   COMT_PRODUCT_TYPE Product Type
5 OBJECT_FAMILY COMM_PRODUCT OBJECT_FAMILY   COMT_PRODUCT_OBJECT_FAMILY Object Family
6 LOGSYS COMM_PRODUCT LOGSYS   COMT_LOGSYS Original System
7 SALES_ORG COMM_PR_FRG_ROD SALES_ORG   CRMT_SALES_ORG Sales Organization ID
8 DISTR_CHAN COMM_PR_FRG_ROD DISTR_CHAN   CRMT_DISTRIBUTION_CHANNEL Distribution Channel
9 PROD_PR_GROUP CRMM_PR_SALESG PROD_PR_GROUP   CRMT_PROD_PR_GROUP Product Group
10 PRC_GROUP1 CRMM_PR_SALESG PRC_GROUP1   CRMT_PRC_GROUP1 Product Group 1
11 PRC_GROUP2 CRMM_PR_SALESG PRC_GROUP2   CRMT_PRC_GROUP2 Product Group 2
12 PRC_GROUP3 CRMM_PR_SALESG PRC_GROUP3   CRMT_PRC_GROUP3 Product Group 3
13 PRC_GROUP4 CRMM_PR_SALESG PRC_GROUP4   CRMT_PRC_GROUP4 Product Group 4
14 PRC_GROUP5 CRMM_PR_SALESG PRC_GROUP5   CRMT_PRC_GROUP5 Product Group 5
15 REBATE_GROUP CRMM_PR_SALESG REBATE_GROUP   CRMT_REBATE_GROUP Volume Rebate Group
16 COMM_GROUP CRMM_PR_SALESG COMM_GROUP   CRMT_COMM_GROUP Commission Group
17 ACCTGRP_PROD CRMM_PR_SALESG ACCTGRP_PROD   CRMT_ACCTGRPPROD Account Assignment Group for Product
18 SALESCAT_GUID CRMM_PR_SALESG SALESCAT_GUID   CRMT_SALESCAT_GUID Distribution Chain Dependent Category
                 
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  20130604 
SAP Release Created in 40V