ML4H_CDS_MLDOCAHD

@AbapCatalog.sqlViewName: 'ML4H_MLDOCAHD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'CKMLLAHD x MLDOC'
define view ML4H_CDS_MLDOCAHD
    as select from ckmllahd as ahd
       left outer join mldoc as doc
         on   ahd.kalnr   = doc.kalnr
{
ahd.werks     as bwkey,
doc.docref    as docref,
doc.curtp     as curtp,
doc.rldnr     as rldnr,
doc.kalnr     as kalnr,
doc.runref    as runref,
doc.acc_principle as acc_principle,
doc.jahrper       as jahrper,
doc.jahrper_wip   as jahrper_wip,
doc.current_per   as current_per,
doc.xabr      as xabr,
doc.glvor     as glvor,
doc.vgart     as vgart,
doc.posart    as posart,
doc.categ     as categ,
doc.ptyp      as ptyp,
doc.bewartgrp as bewartgrp,
doc.bvalt     as bvalt,
doc.process   as process,
doc.pkalnr    as pkalnr,
doc.quant     as quant,
doc.meins     as meins,
doc.stval     as stval,
doc.prd       as prd,
doc.kdm       as kdm,
doc.tpprd     as tpprd,
doc.altval    as altval,
doc.waers     as waers,
doc.lbkum     as lbkum,
doc.salk3     as salk3,
doc.salkv     as salkv,
doc.stprs     as stprs,
doc.pvprs     as pvprs,
doc.peinh     as peinh,
doc.xekrel    as xekrel,
doc.plqty     as plqty,
doc.markup    as markup,
doc.vkwrt     as vkwrt,
doc.vksal     as vksal,
doc.eqnum     as eqnum,
doc.timestamp as timestamp,
doc.budat     as budat,
doc.cyclenr   as cyclenr,
doc.aufnr     as aufnr,
doc.aufps     as aufps,
doc.belnr     as belnr,
doc.kjahr     as kjahr,
doc.posnr     as posnr_doc,
doc.awtyp     as awtyp,
doc.awsys     as wasys,
doc.aworg     as aworg,
doc.awref     as awref,
doc.awitem    as awitem,
doc.awitgrp   as awitgrp,
doc.usnam     as usnam,
doc.tcode     as tcode
}