SAP ABAP View CRMV_SPL_BUT_S10 (BW Extraction: CRM ECR Data)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MD-BP (Application Component) Business Partners
     CRM_BUPA_EXT_FRG (Package) CRM BP Extraction BW for Business Partner (CRM Enhancements)
Basic Data
View Type D Database View 
Database View CRMV_SPL_BUT_S10  
Short Description BW Extraction: CRM ECR Data    
Root table BUT000   BP: General data I 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT000 BUT000
2 CRMMSPL_BP_L0011  
3 CRMMSPL_BP_S0010  
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 CRMMSPL_BP_L0011 CLIENT JR EQ AND 0 0
3 BUT000 CLIENT JL EQ 0 0
4 CRMMSPL_BP_S0010 CLIENT JR EQ AND 0 0
5 BUT000 PARTNER_GUID JL EQ 0 0
6 CRMMSPL_BP_L0011 PARTNER_GUID JR EQ AND 0 0
7 CRMMSPL_BP_L0011 SET_GUID JL EQ 0 0
8 CRMMSPL_BP_S0010 SET_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT BUT000 CLIENT   MANDT Client
2 PARTNER BUT000 PARTNER   BU_PARTNER Business Partner Number
3 PARTNER_GUID CRMMSPL_BP_L0011 PARTNER_GUID   BU_PARTNER_GUID Business Partner GUID
4 SALES_ORG CRMMSPL_BP_L0011 SALES_ORG   CRMT_SALES_ORG Sales Organization ID
5 CHANNEL CRMMSPL_BP_L0011 CHANNEL   CRMT_DISTRIBUTION_CHANNEL Distribution Channel
6 DIVISION CRMMSPL_BP_L0011 DIVISION   CRMT_DIVISION Division
7 CARRIER_NOTE CRMMSPL_BP_S0010 CARRIER_NOTE   CRMT_SPL_CARRIER_NOTE Indicator: Information to Carrier
8 EXTERNAL_REMAN CRMMSPL_BP_S0010 EXTERNAL_REMAN   CRMT_SPL_EXT_REMAN External Remanufacturer
9 SET_GUID CRMMSPL_BP_S0010 SET_GUID   CRMT_BU_SET_GUID GUID for sets of business partner
10 VALID_TO CRMMSPL_BP_S0010 VALID_TO   TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11 ACC_APP_EXP CRMMSPL_BP_S0010 ACC_APP_EXP   CRMT_SPL_ACC_APP_EXP Confirmation of Delivery
12 SCRAP_INSTR_LOW CRMMSPL_BP_S0010 SCRAP_INSTR_LOW   CRMT_SPL_SCRAP_INSTR_LOW Procedure for Values under Threshold
13 SCRAP_INSTR_HIGH CRMMSPL_BP_S0010 SCRAP_INSTR_HIGH   CRMT_SPL_SCRAP_INSTR_HIGH Procedure for Values over Threshold
14 CORE_SCRAP_LOW CRMMSPL_BP_S0010 CORE_SCRAP_LOW   CRMT_SPL_CORE_SCRAP_INSTR_LOW Procedure for Values under Threshold
15 CORE_SCRAP_HIGH CRMMSPL_BP_S0010 CORE_SCRAP_HIGH   CRMT_SPL_CORE_SCRAP_INSTR_HIGH Procedure for Values over Threshold
                 
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 400