SAP ABAP View VCRMM_BUT_WP10 (BI Extraction: CRM Sales Data, with Profile)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MD-BP-DAT (Application Component) CRM Specific Business Partner Data
     CRMM_BUPA_PROFILE_FRG (Package) Profiles for CRM Datasets
Basic Data
View Type D Database View 
Database View VCRMM_BUT_WP10  
Short Description BI Extraction: CRM Sales Data, with Profile    
Root table BUT000   BP: General data I 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT000 BUT000
2 CRMM_BP10WPL11  
3 CRMM_BUT_SET0010  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 BUT000 CLIENT JL EQ 0 0
2 CRMM_BUT_SET0010 CLIENT JR EQ AND 0 0
3 BUT000 CLIENT JL EQ 0 0
4 CRMM_BP10WPL11 CLIENT JR EQ AND 0 0
5 BUT000 PARTNER_GUID JL EQ 0 0
6 CRMM_BP10WPL11 PARTNER_GUID JR EQ AND 0 0
7 CRMM_BP10WPL11 SET_GUID JL EQ 0 0
8 CRMM_BUT_SET0010 SET_GUID JR EQ AND 0 0
9 CRMM_BP10WPL11 VALID_TO JL EQ 0 0
10 CRMM_BUT_SET0010 VALID_TO JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CRMM_BP10WPL11 CLIENT   MANDT Client
2 PARTNER_GUID CRMM_BP10WPL11 PARTNER_GUID   BU_PARTNER_GUID Business Partner GUID
3 PROFILE_ID CRMM_BP10WPL11 PROFILE_ID   CRMT_SPL_BUPA_PROFILE_ID Profile ID
4 SALES_ORG CRMM_BP10WPL11 SALES_ORG   CRMT_SALES_ORG Sales Organization ID
5 CHANNEL CRMM_BP10WPL11 CHANNEL   CRMT_DISTRIBUTION_CHANNEL Distribution Channel
6 DIVISION CRMM_BP10WPL11 DIVISION   CRMT_DIVISION Division
7 PARTNER BUT000 PARTNER   BU_PARTNER Business Partner Number
8 CUSTOMER_GROUP1 CRMM_BUT_SET0010 CUSTOMER_GROUP1   CRMT_CUST_GROUP1 Customer Group 1
9 CUSTOMER_GROUP2 CRMM_BUT_SET0010 CUSTOMER_GROUP2   CRMT_CUST_GROUP2 Customer Group 2
10 CUSTOMER_GROUP3 CRMM_BUT_SET0010 CUSTOMER_GROUP3   CRMT_CUST_GROUP3 Customer Group 3
11 CUSTOMER_GROUP4 CRMM_BUT_SET0010 CUSTOMER_GROUP4   CRMT_CUST_GROUP4 Customer Group 4
12 CUSTOMER_GROUP5 CRMM_BUT_SET0010 CUSTOMER_GROUP5   CRMT_CUST_GROUP5 Customer Group 5
13 PAY_GUAR_PROC CRMM_BUT_SET0010 PAY_GUAR_PROC   COMT_CUST_PAY_GUAR_PROC Customer Payment Guarantee Procedure
14 CERR_GRP CRMM_BUT_SET0010 CERR_GRP   CRMT_CUST_ERR_GRP Incompleteness Group: Business Partner
15 VALID_TO CRMM_BP10WPL11 VALID_TO   TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
16 PODC_GROUP CRMM_BUT_SET0010 PODC_GROUP   CRMT_PODC_GROUP BP Group for Purchase Order Number Check
17 LOC_REQUIRED CRMM_BUT_SET0010 LOC_REQUIRED   CRMT_LOC_REQUIRED Letter of Credit required
                 
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  20140117 
SAP Release Created in 520