MBV_EBEW

CDS View

Compatibility view for EBEW table

MBV_EBEW is a CDS View in S/4HANA. Compatibility view for EBEW table. It contains 16 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 16 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Mbv_Ebew_Vbak view from Compatibility view for V_EBEW_VBAK view (ML integration)
Mbv_V_Ebew_Likp view from Compatibility view for V_EBEW_LIKP view (ML integration)
Mbv_V_Ebew_Vbak view from Compatibility view for V_EBEW_VBAK view (ML integration)
P_CurrentMatlPriceByCostEst view union_all COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
bklas bklas 3
bwkey bwkey 3
bwtar bwtar 3
bwtty bwtty 3
lbkum lbkum 3
mandt mandt 3
matnr matnr 3
peinh peinh 3
posnr posnr 3
salk3 salk3 3
salkv salkv 3
sobkz sobkz 3
stprs stprs 3
vbeln vbeln 3
verpr verpr 3
vprsv vprsv 3 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'MBVEBEW'
@EndUserText.label: 'Compatibility view for EBEW table'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #AUTOMATED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
define view Mbv_Ebew
  as select from ebew
  
    inner join R_MatlPriceDataMigrationStatus as tf on ( tf.MatlPriceDataMigrationStatus = 'X' ) 
                                                    or ( tf.MatlPriceDataMigrationStatus = 'R' )
                                                    or ( tf.MatlPriceDataMigrationStatus = 'F' )

    left outer to one join V_ML_ACDOC_EX_UL_DDL as ext on  ext.kalnr = ebew.kaln1
                                                       and ext.rclnt = ebew.mandt

    left outer to one join FMLV_XBEW_CKMLCR_SALKV as matprice   on  matprice.mandt = ebew.mandt
                                                            and matprice.kalnr = ebew.kaln1
                                                            and ( ( ( tf.MatlPriceDataMigrationStatus = 'X' or  tf.MatlPriceDataMigrationStatus = 'R' )
                                                                and matprice.bdatj = ebew.lfgja
                                                                and matprice.lfmonp = concat('0', ebew.lfmon ) ) 
                                                                or ( ( tf.MatlPriceDataMigrationStatus = 'R' or tf.MatlPriceDataMigrationStatus = 'F' )  and matprice.bdatj = '9999' ) )
{
  key ebew.mandt                                         as mandt,
  key ebew.matnr                                         as matnr,
  key ebew.bwkey                                         as bwkey,
  key ebew.bwtar                                         as bwtar,
  key ebew.sobkz                                         as sobkz,
  key ebew.vbeln                                         as vbeln,
  key ebew.posnr                                         as posnr,

      //LBKUM from acdoca extract table

      cast(COALESCE(ext.vmsl, 0) as lbkum)               as lbkum,

      //SALK3 from acdoca extract table

      cast(COALESCE(ext.hsl, 0) as salk3)                as salk3,
      ebew.vprsv                                         as vprsv,
      verpr,
      ebew.stprs                                         as stprs,
      ebew.peinh                                         as peinh,
      bklas,

      //SALKV from CR table

      cast(COALESCE(matprice.salkv, 0) as salkv)           as salkv,
      vmkum,
      vmsal,
      vmvpr,
      vmver,
      vmstp,
      vmpei,
      vmbkl,
      vmsav,
      vjkum,
      vjsal,
      vjvpr,
      vjver,
      vjstp,
      vjpei,
      vjbkl,
      vjsav,
      lfgja,
      lfmon,
      bwtty,
      stprv,
      laepr,
      zkprs,
      zkdat,
      timestamp,
      zplpr,
      kalkz,
      kalkl,
      kalkv,
      kaln1,
      bwva1,
      bwva2,
      bwva3,
      vers1,
      vers2,
      vers3,
      hrkft,
      kosgr,
      pprdz,
      pprdl,
      pprdv,
      pdatz,
      pdatl,
      pdatv,
      ekalr,
      vplpr,
      mlmaa,
      mlast,
      lplpr,

      //VKSAL from acdoca extract table

      cast(COALESCE(ext.hvkwrt, 0) as vksal)             as vksal,
      hkmat,
      bwspa,
      lplpx,
      vplpx,
      fplpx,
      lbwst,
      vbwst,
      fbwst,
      mbrue,
      oklas
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FMLV_XBEW_CKMLCR_SALKV",
"R_MATLPRICEDATAMIGRATIONSTATUS",
"V_ML_ACDOC_EX_UL_DDL",
"EBEW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More