创建HANA的CDS视图

@AbapCatalog.sqlViewName: 'ZBSEG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: '扩展的bseg'
define view ZCDS_BSEG  as select from bseg
left outer join zfi036_xt
    on  bseg.mandt = zfi036_xt.mandt 
    and  bseg.bukrs = zfi036_xt.bukrs 
    and bseg.belnr = zfi036_xt.belnr 
    and bseg.gjahr = zfi036_xt.gjahr 
    and bseg.buzei = zfi036_xt.buzei { 
key bseg.mandt, 
key bseg.bukrs,
key bseg.belnr,
key bseg.gjahr,
key bseg.buzei,
buzid,
augdt,
augcp,
augbl,
bschl,
koart,
umskz,
umsks,
zumsk,
shkzg,
gsber,
pargb,
mwskz,
qsskz,
dmbtr,
wrbtr,
kzbtr,
pswbt,
pswsl,
txbhw,
txbfw,
mwsts,
wmwst,
hwbas,
fwbas,
hwzuz,
fwzuz,
shzuz,
stekz,
mwart,
txgrp,
ktosl,
qsshb,
kursr,
gbetr,
bdiff,
bdif2,
valut,
zuonr,
sgtxt,
zinkz,
vbund,
bewar,
altkt,
vorgn,
fdlev,
fdgrp,
fdwbt,
fdtag,
fkont,
kokrs,
kostl,
projn,
aufnr,
vbeln,
vbel2,
posn2,
eten2,
anln1,
anln2,
anbwa,
bzdat,
pernr,
xumsw,
xhres,
xkres,
xopvw,
xcpdd,
xskst,
xsauf,
xspro,
xserg,
xfakt,
xuman,
xanet,
xskrl,
xinve,
xpanz,
xauto,
xncop,
xzahl,
saknr,
hkont,
kunnr,
case when zfi036_xt.lifnr  is not null then zfi036_xt.lifnr
   else   bseg.lifnr end   as lifnr,
filkd,
xbilk,
gvtyp,
hzuon,
zfbdt,
zterm,
zbd1t,
zbd2t,
zbd3t,
zbd1p,
zbd2p,
skfbt,
sknto,
wskto,
zlsch,
zlspr,
zbfix,
hbkid,
bvtyp,
nebtr,
mwsk1,
dmbt1,
wrbt1,
mwsk2,
dmbt2,
wrbt2,
mwsk3,
dmbt3,
wrbt3,
rebzg,
rebzj,
rebzz,
rebzt,
zollt,
zolld,
lzbkz,
landl,
diekz,
samnr,
abper,
vrskz,
vrsdt,
disbn,
disbj,
disbz,
wverw,
anfbn,
anfbj,
anfbu,
anfae,
blnbt,
blnkz,
blnpz,
mschl,
mansp,
madat,
manst,
maber,
esrnr,
esrre,
esrpz,
klibt,
qsznr,
qbshb,
qsfbt,
navhw,
navfw,
matnr,
werks,
menge,
meins,
erfmg,
erfme,
bpmng,
bprme,
ebeln,
ebelp,
zekkn,
elikz,
vprsv,
peinh,
bwkey,
bwtar,
bustw,
rewrt,
rewwr,
bonfb,
bualt,
psalt,
nprei,
tbtkz,
spgrp,
spgrm,
spgrt,
spgrg,
spgrv,
spgrq,
stceg,
egbld,
eglld,
rstgr,
ryacq,
rpacq,
rdiff,
rdif2,
prctr,
xhkom,
vname,
recid,
egrup,
vptnr,
vertt,
vertn,
vbewa,
depot,
txjcd,
imkey,
dabrz,
popts,
fipos,
kstrg,
nplnr,
aufpl,
aplzl,
projk,
paobjnr,
pasubnr,
spgrs,
spgrc,
btype,
etype,
xegdr,
lnran,
hrkft,
dmbe2,
dmbe3,
dmb21,
dmb22,
dmb23,
dmb31,
dmb32,
dmb33,
mwst2,
mwst3,
navh2,
navh3,
sknt2,
sknt3,
bdif3,
rdif3,
hwmet,
glupm,
xragl,
uzawe,
lokkt,
fistl,
geber,
stbuk,
txbh2,
txbh3,
pprct,
xref1,
xref2,
kblnr,
kblpos,
sttax,
fkber,
obzei,
xnegp,
rfzei,
ccbtc,
kkber,
empfb,
xref3,
dtws1,
dtws2,
dtws3,
dtws4,
gricd,
grirg,
gityp,
xpypr,
kidno,
absbt,
idxsp,
linfv,
kontt,
kontl,
uebgdat,
txdat,
agzei,
pycur,
pyamt,
bupla,
secco,
lstar,
cession_kz,
prznr,
ppdiff,
ppdif2,
ppdif3,
penlc1,
penlc2,
penlc3,
penfc,
pendays,
penrc,
grant_nbr,
sctax,
fkber_long,
gmvkz,
srtype,
intreno,
measure,
auggj,
ppa_ex_ind,
docln,
segment,
psegment,
pfkber,
hktid,
kstar,
xlgclr,
taxps,
pays_prov,
pays_tran,
mndid,
xfrge_bseg,
awtyp,
awkey,
awsys,
posnr,
buzei_sender,
h_monat,
h_bstat,
h_budat,
h_bldat,
h_waers,
h_blart,
h_hwaer,
h_hwae2,
h_hwae3,
netdt,
sk1dt,
sk2dt,
_dataaging,
fqftype,
lqitem,
gkont,
gkart,
ghkon,
squan,
anln2_pn,
bwasl_pn,
bzdat_pn,
xvabg_pn,
anbtr_pn,
prozs_pn,
dummy_incl_eew_cobl,
re_bukrs,
re_account,
pgeber,
pgrant_nbr,
budget_pd,
pbudget_pd,
j_1tpbupl,
perop_beg,
perop_end,
fastpay,
ignr_ivref,
fmfgus_key,
fmxdocnr,
fmxyear,
fmxdocln,
fmxzekkn,
prodper,
recrf,
inward_no,
inward_dt,
pymtkey,
zzysbm,
zzlwgs
}