rfm_scc_salesdata_basic_V

DDL: RFM_SCC_SALESDATA_BASIC_V SQL: RFMSCCSDBASICV Type: view

Salesdata basic view

rfm_scc_salesdata_basic_V is a CDS View that provides data about "Salesdata basic view" in SAP S/4HANA. It reads from 4 data sources (mara, vbak, vbap, vbep) and exposes 27 fields with key fields vbeln, posnr. It has 2 associations to related views.

4 data source(s) 27 fields

Data Sources (4)

SourceAliasJoin Type
mara mara inner
vbak vbak from
vbap vbap inner
vbep vbep inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] vbpa _vbpa_item $projection.vbeln = _vbpa_item.vbeln and $projection.posnr = _vbpa_item.posnr and _vbpa_item.parvw = 'WE'
[1..1] vbpa _vbpa_header ( $projection.vbeln = _vbpa_header.vbeln and _vbpa_header.posnr = '000000' and _vbpa_header.parvw = 'WE' )

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName RFMSCCSDBASICV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Salesdata basic view view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY vbeln vbap vbeln
KEY posnr vbap posnr
kunnr vbak kunnr
auart vbak auart
vkorg vbak vkorg
vtweg vbak vtweg
fsh_candate vbak fsh_candate
fsh_season vbap fsh_season
fsh_theme vbap fsh_theme
matnr vbap matnr
kwmeng vbap kwmeng
vrkme vbap vrkme
werks vbap werks
spart vbap spart
sgt_rcat vbap sgt_rcat
size1 mara size1
size2 mara size2
color mara color
color_atinn mara color_atinn
size1_atinn mara size1_atinn
size2_atinn mara size2_atinn
mtart mara mtart
matkl mara matkl
attyp mara attyp
edatu vbep edatu
_vbpa_item _vbpa_item
_vbpa_header _vbpa_header 
@AbapCatalog.sqlViewName: 'RFMSCCSDBASICV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MIXED
@EndUserText.label: 'Salesdata basic view'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view rfm_scc_salesdata_basic_V 

as select from vbak as vbak
      inner join vbap as vbap
        on ( vbak.vbeln = vbap.vbeln )

      inner join vbep as vbep
        on ( vbap.vbeln = vbep.vbeln
        and  vbap.posnr = vbep.posnr )      
      
      inner join mara as mara
       on (vbap.matnr = mara.matnr)  
       
        association [1..1] to vbpa as _vbpa_item  
                     on  $projection.vbeln  = _vbpa_item.vbeln
                     and $projection.posnr  = _vbpa_item.posnr
                     and _vbpa_item.parvw =  'WE'
        
         association [1..1] to vbpa as _vbpa_header  
                     on  ( $projection.vbeln  = _vbpa_header.vbeln
                     and _vbpa_header.posnr  = '000000'
                     and _vbpa_header.parvw =  'WE' )  
                                    
       
{
   
    key vbap.vbeln           as vbeln,
    key vbap.posnr           as posnr,
        vbak.kunnr           as kunnr ,
        vbak.auart           as auart,
        vbak.vkorg           as vkorg,
        vbak.vtweg           as vtweg,
        vbak.fsh_candate     as fsh_candate,
        vbap.fsh_season_year as fsh_season_year,
        vbap.fsh_season      as fsh_season,
        vbap.fsh_collection  as fsh_collection,
        vbap.fsh_theme       as fsh_theme,
        vbap.rfm_scc_indicator as seasoncompletenessindicator,
        vbap.matnr           as matnr,
        vbap.kwmeng          as kwmeng,
        vbap.vrkme           as vrkme,
        vbap.werks           as werks,
        vbap.spart           as spart,
        vbap.sgt_rcat        as sgt_rcat,
        mara.size1           as size1,
        mara.size2           as size2,       
        mara.color           as color,          
        mara.color_atinn,
        mara.size1_atinn, 
        mara.size2_atinn,
        mara.mtart           as mtart,
        mara.matkl           as matkl,
        mara.attyp           as attyp,                      
        vbep.edatu           as edatu,
        
         case when _vbpa_item.kunnr is not null  
             then _vbpa_item.kunnr
             else _vbpa_header.kunnr
             end as shiptoparty,
                    
_vbpa_item,
_vbpa_header       
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARA",
"VBAK",
"VBAP",
"VBEP",
"VBPA"
],
"ASSOCIATED":
[
"VBPA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More