Fcdm_Keyfigures_Read_Custrq

@AbapCatalog.sqlViewName: 'V_FCDM_RD_CR'
@EndUserText.label: 'Read Customer Requirements for Forecast Demand Keyfigures'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #AUTOMATED
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
define view Fcdm_Keyfigures_Read_Custrq as select
   from vbak as vbak                  -- order header
   inner join vbap as vbap            -- order items
        on  vbak.vbeln = vbap.vbeln 
   inner join vbep as vbep            -- schedule lines
        on  vbap.vbeln = vbep.vbeln
        and vbap.posnr = vbep.posnr
    {
    key vbap.matnr,
    key vbap.werks,
    key vbap.werks  as berid,
    key vbep.vbeln,
    key vbep.posnr,
    key vbep.etenr,    
    vbap.lgort,
    case when vbap.abgru = '' and vbep.umvkn = 0 then vbep.cmeng
         when vbap.abgru = '' and vbep.umvkn <> 0       -- if not cancelled take requested quantity, else the already delivered quantity
         then division( vbep.cmeng                      -- we do not take directly the requested quantity (WMENG) but rather the rounded quantiy CMENG. it is in sales unit 
                       * vbep.umvkz, vbep.umvkn, 3 )             -- conversion factors
         else 0 
    end                                as quantity,    -- converted to base unit
    @Semantics.unitOfMeasure: true
    vbep.meins,       -- the quantity is now in MEINS, not in VRKME
    vbep.mbdat                         as mbdat        -- requested date scheduled when the material should be provided
    }
 where vbak.vbtyp = 'C'       -- only customer orders
   and vbep.lfrel = 'X'       -- only  delivery relevant items