ML4H_CDS_MLDOCCCSHD

@AbapCatalog.sqlViewName: 'ML4H_MLDOCCCSHD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'CKMLHD x MLDOC x MLDOCCCS'
define view ML4H_CDS_MLDOCCCSHD 
    as select from ckmlhd as hd 
       left outer join mldoc as doc 
         on   hd.kalnr   = doc.kalnr
         left outer join mldocccs as ccs
           on  doc.docref = ccs.docref
           and doc.curtp = ccs.curtp
{
hd.matnr      as matnr,
hd.bwkey      as bwkey,
hd.bwtar      as bwtar,
hd.sobkz      as sobkz,
hd.kzbws      as kzbws,
hd.xobew      as xobew,
hd.vbeln      as vbeln,
hd.posnr      as posnr,
hd.pspnr      as pspnr,
hd.lifnr      as lifnr,
hd.mlast      as mlast,
hd.kalnr      as kalnr,
doc.docref    as docref,
doc.curtp     as curtp,
doc.rldnr     as rldnr,
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,
// doc.vgabe     as vgabe,

// doc.hrkft     as hrkft,

// doc.kstar     as kstar,

// doc.bwart     as bwart,

// doc.werks     as werks,

// doc.storno    as storno,

ccs.elesmhk   as elesmhk,
ccs.element   as element,
ccs.patnr     as patnr,
ccs.dipa      as dipa,
ccs.svrel     as svrel,
ccs.mlcct     as mlcct,
ccs.keart     as keart,
ccs.waers     as waers,
ccs.tot       as tot,
ccs.fix       as fix,
ccs.totll     as toll,
ccs.fixll     as fixll
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD",
"MLDOC",
"MLDOCCCS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/