NSDM_E_LPO_MAT_DOCS

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'NSDM_V_LPO_MATDO'
@EndUserText.label:       'LPO_MAT_DOCS Compatibility View'

@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #AUTOMATED
@AccessControl.authorizationCheck: #NOT_ALLOWED
@AbapCatalog.viewEnhancementCategory: #PROJECTION_LIST

define view NSDM_E_LPO_MAT_DOCS as
select from  matdoc as ab 
            inner join t156          as c
         on  ab.mandt = c.mandt
         and ab.bwart = c.bwart
{ 
key ab.mandt,
key ab.mblnr, 
key ab.mjahr,
key ab.zeile,

ab.werks,
ab.matnr,
ab.shkzg,
ab.menge,
ab.meins,
ab.bldat,
ab.budat,
ab.cpudt,
ab.cputm,
c.xstbw,
ab.ematn,
ab.vgart,
ab.bktxt

}  where ab.record_type = 'MDOC'       

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC",
"T156"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/