Mbv_Macku

DDL: MBV_MACKU SQL: MBVMACKU Type: view

Compatibility view for MACKU view (ML integration)

Mbv_Macku is a CDS View that provides data about "Compatibility view for MACKU view (ML integration)" in SAP S/4HANA. It reads from 2 data sources (mara, Mbv_Mbew) and exposes 38 fields.

2 data source(s) 38 fields

Data Sources (2)

SourceAliasJoin Type
mara mara from
Mbv_Mbew Mbv_Mbew inner

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName MBVMACKU view
EndUserText.label Compatibility view for MACKU view (ML integration) view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (38)

KeyFieldSource TableSource FieldDescription
mandt mara mandt
matnr mara matnr
bwkey Mbv_Mbew bwkey
bwtar Mbv_Mbew bwtar
mtart mara mtart
matkl mara matkl
kzkfg mara kzkfg
vprsv Mbv_Mbew vprsv
verpr Mbv_Mbew verpr
stprs Mbv_Mbew stprs
peinh Mbv_Mbew peinh
bklas Mbv_Mbew bklas
bwtty Mbv_Mbew bwtty
zkprs Mbv_Mbew zkprs
zkdat Mbv_Mbew zkdat
bwprs Mbv_Mbew bwprs
bwprh Mbv_Mbew bwprh
bwps1 Mbv_Mbew bwps1
bwph1 Mbv_Mbew bwph1
vjbws Mbv_Mbew vjbws
vjbwh Mbv_Mbew vjbwh
zplp1 Mbv_Mbew zplp1
zplp2 Mbv_Mbew zplp2
zplp3 Mbv_Mbew zplp3
zpld1 Mbv_Mbew zpld1
zpld2 Mbv_Mbew zpld2
zpld3 Mbv_Mbew zpld3
kalnr Mbv_Mbew kalnr
kaln1 Mbv_Mbew kaln1
vmstp Mbv_Mbew vmstp
vmpei Mbv_Mbew vmpei
hrkft Mbv_Mbew hrkft
ekalr Mbv_Mbew ekalr
zplpr Mbv_Mbew zplpr
hkmat Mbv_Mbew hkmat
bwpei Mbv_Mbew bwpei
cwmxcwmat mara /cwm/xcwmat
cwmvalum mara /cwm/valum 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'MBVMACKU'
@EndUserText.label: 'Compatibility view for MACKU view (ML integration)'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
define view Mbv_Macku as select from mara 
    inner join Mbv_Mbew  on mara.mandt  = Mbv_Mbew.mandt and
                            mara.matnr  = Mbv_Mbew.matnr 
{
    mara.mandt,
    mara.matnr,
    Mbv_Mbew.bwkey,
    Mbv_Mbew.bwtar,
    mara.mtart,
    mara.matkl,
    mara.kzkfg,
    Mbv_Mbew.vprsv,
    Mbv_Mbew.verpr,
    Mbv_Mbew.stprs,
    Mbv_Mbew.peinh,
    Mbv_Mbew.bklas,
    Mbv_Mbew.bwtty,
    Mbv_Mbew.zkprs,
    Mbv_Mbew.zkdat,
    Mbv_Mbew.bwprs,
    Mbv_Mbew.bwprh,
    Mbv_Mbew.bwps1,
    Mbv_Mbew.bwph1,
    Mbv_Mbew.vjbws,
    Mbv_Mbew.vjbwh,
    Mbv_Mbew.zplp1,
    Mbv_Mbew.zplp2,
    Mbv_Mbew.zplp3,
    Mbv_Mbew.zpld1,
    Mbv_Mbew.zpld2,
    Mbv_Mbew.zpld3,
    Mbv_Mbew.kalnr,
    Mbv_Mbew.kaln1,
    Mbv_Mbew.vmstp,
    Mbv_Mbew.vmpei,
    Mbv_Mbew.hrkft,
    Mbv_Mbew.ekalr,
    Mbv_Mbew.zplpr,
    Mbv_Mbew.hkmat,
    Mbv_Mbew.bwpei,
    mara./cwm/xcwmat,
    mara./cwm/valum    
}           
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"MBV_MBEW",
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More