SAP ABAP View CRMV_BUT_SET0020 (BW Extraction: CRM Shipping 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_BUT_SET0020  
Short Description BW Extraction: CRM Shipping Data    
Root table BUT000   BP: General data I 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT000 BUT000
2 CRMM_BUT_LNK0021  
3 CRMM_BUT_SET0020  
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_SET0020 CLIENT JR EQ AND 0 0
3 BUT000 CLIENT JL EQ 0 0
4 CRMM_BUT_LNK0021 CLIENT JR EQ AND 0 0
5 BUT000 PARTNER_GUID JL EQ 0 0
6 CRMM_BUT_LNK0021 PARTNER_GUID JR EQ AND 0 0
7 CRMM_BUT_LNK0021 SET_GUID JL EQ 0 0
8 CRMM_BUT_SET0020 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 SALES_ORG CRMM_BUT_LNK0021 SALES_ORG   CRMT_SALES_ORG Sales Organization ID
4 CHANNEL CRMM_BUT_LNK0021 CHANNEL   CRMT_DISTRIBUTION_CHANNEL Distribution Channel
5 DIVISION CRMM_BUT_LNK0021 DIVISION   CRMT_DIVISION Division
6 INCOTERMS1 CRMM_BUT_SET0020 INCOTERMS1   CRMT_INCOTERMS1 Incoterms (Part 1)
7 INCOTERMS2 CRMM_BUT_SET0020 INCOTERMS2   CRMT_INCOTERMS2 Incoterms (Part 2)
8 SHIPPING_COND CRMM_BUT_SET0020 SHIPPING_COND   CRMT_SHIP_COND Shipping Conditions
9 OVER_DLV_TOL CRMM_BUT_SET0020 OVER_DLV_TOL   CRMT_OVER_DLV_TOL Overdelivery Tolerance Limit
10 UNDER_DLV_TOL CRMM_BUT_SET0020 UNDER_DLV_TOL   CRMT_UNDER_DLV_TOL Underdelivery Tolerance Limit
11 UNLIM_DLV_TOL CRMM_BUT_SET0020 UNLIM_DLV_TOL   CRMT_DELI_UNLIM_TOL Indicator: Unlimited Overdelivery Allowed
12 DLV_PRIORITY CRMM_BUT_SET0020 DLV_PRIORITY   CRMT_DLV_PRIO Delivery Priority
13 ORDER_COMBINED CRMM_BUT_SET0020 ORDER_COMBINED   CRMT_ORDERCOMBIND Indicator: Order Combination
14 PARTIAL_DLV CRMM_BUT_SET0020 PARTIAL_DLV   CRMT_PART_DLV Delivery Control
15 SET_GUID CRMM_BUT_LNK0021 SET_GUID   CRMT_BU_SET_GUID GUID for sets of business partner
16 PARTNER_GUID BUT000 PARTNER_GUID   BU_PARTNER_GUID Business Partner GUID
17 TRANS_MOT CRMM_BUT_SET0020 TRANS_MOT   CRMT_TRANS_MOT Mode of Transport
18 PART_DLV_ITM CRMM_BUT_SET0020 PART_DLV_ITM   CRMT_PART_DLV_ITM Delivery Control (Item)
19 INV_BEFORE_GI CRMM_BUT_SET0020 INV_BEFORE_GI   CRMT_BEFORE_LOADING Invoice Before Goods Issue (IBGI)
20 MAX_NO_DLV CRMM_BUT_SET0020 MAX_NO_DLV   CRMT_MAX_PL_DLV Maximum number of partial deliveries allowed per item
                 
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 20C