@ClientDependent
@AbapCatalog.sqlViewName: 'FACV_BSEG_BKPF'
@EndUserText.label: 'Entry View BSEG/BSEG_ADD with Header'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
define view fac_cds_bseg_bkpf
as select from fac_cds_bseg_add as bseg
left outer join t001 on t001.bukrs = bseg.bukrs
left outer join skb1 on skb1.bukrs = bseg.bukrs
and skb1.saknr = bseg.hkont
left outer join t880 on t880.rcomp = bseg.vbund
left outer join t001w on t001w.werks = bseg.werks
left outer join t005 on t005.land1 = t001.land1
left outer join fac_cds_bsec_ev as bsec on bsec.bukrs = bseg.bukrs
and bsec.belnr = bseg.belnr
and bsec.gjahr = bseg.gjahr
and bsec.buzei = bseg.buzei
association [1] to fis_cds_bkpf_ev as to_header on bseg.bukrs = to_header.bukrs
and bseg.belnr = to_header.belnr
and bseg.gjahr = to_header.gjahr
// at the moment at seems not yet feasible to model the correct join condition
// fis_cds_bseg_ev.buzei = to_next_item.buzei + 1 => So for the time beeing these associations
// need postprocessing (filtering) in the DPC_EXT-class of the oData service
association [*] to fac_cds_bseg_bkpf as to_next_item on bseg.bukrs = to_next_item.bukrs
and bseg.belnr = to_next_item.belnr
and bseg.gjahr = to_next_item.gjahr
association [*] to fac_cds_bseg_bkpf as to_previous_item on bseg.bukrs = to_previous_item.bukrs
and bseg.belnr = to_previous_item.belnr
and bseg.gjahr = to_previous_item.gjahr
association [0..1] to E_JournalEntryItem as _Extension on bseg.rldnr = _Extension.SourceLedger // This extension association is needed to enable extensibility for
and bseg.bukrs = _Extension.CompanyCode // OData model FAC_FINANCIAL_DOCUMENT_MDL. The OData service is
and bseg.gjahr = _Extension.FiscalYear // using this CDS view for modeling purposes only, not at runtime.
and bseg.belnr = _Extension.AccountingDocument // The extension of this CDS view actually doesn't work, as extension
and bseg.buzei = _Extension.LedgerGLLineItem // fields are available in ACDOCA only, not in BSEG. But it has to be modeled...
{
key bseg.bukrs,
key bseg.belnr,
key bseg.gjahr,
key bseg.rldnr,
key bseg.buzei,
bseg.bschl,
bseg.koart,
bseg.hkont,
bseg.shkzg,
bseg.dmbtr,
bseg.wrbtr,
bseg.dmbe2,
bseg.dmbe3,
bseg.xnegp,
bseg.sgtxt,
bseg.zuonr,
bseg.mwskz,
bseg.txbfw,
bseg.txjcd,
bseg.xskrl,
bseg.hwmet,
bseg.hwbas,
bseg.fwbas,
bseg.kursr,
bseg.augbl,
bseg.augdt,
cast(bseg.landl as fac_landl) as landl,
bseg.lzbkz,
bseg.xegdr,
bseg.stceg,
bseg.egbld,
bseg.hbkid,
bseg.hktid,
bseg.ccbtc,
bseg.uzawe,
bseg.kidno,
bseg.bupla,
bseg.vbund,
bseg.rstgr,
bseg.xref1,
bseg.xref2,
bseg.xref3,
bseg.prctr,
bseg.PPRCTR,
bseg.segment,
bseg.psegment,
bseg.gsber,
bseg.pargb,
bseg.KDAUF,
bseg.KDPOS,
bseg.KDEIN,
bseg.ebeln,
bseg.ebelp,
bseg.zekkn,
bseg.pernr,
bseg.abper,
bseg.werks,
bseg.matnr as matnr_ext,
bseg.menge,
bseg.meins,
bseg.RMVCT,
bseg.paobjnr,
bseg.projk, // as PS_PSP_PNR,
bseg.nplnr,
bseg.aufpl,
bseg.aplzl,
bseg.kokrs,
bseg.kostl,
bseg.kstrg,
bseg.lstar,
bseg.prznr,
bseg.aufnr,
bseg.imkey,
bseg.dabrz,
bseg.fipos,
bseg.gmvkz,
bseg.srtype,
bseg.fkber,
bseg.pfkber,
bseg.vname,
bseg.recid,
bseg.egrup,
bseg.vptnr,
bseg.prodper,
bseg.qsskz,
bseg.mwart,
bseg.pays_prov,
bseg.qsfbt,
bseg.qsshb,
bseg.gityp,
bseg.gricd,
bseg.grirg,
bseg.idxsp,
bseg.lifnr,
bseg.kunnr,
bseg.filkd,
bseg.umskz,
bseg.umsks,
bseg.zumsk,
bseg.hzuon,
bseg.wskto,
bseg.sknto,
bseg.skfbt,
bseg.zterm,
bseg.zfbdt,
bseg.zbd1p,
bseg.zbd1t,
bseg.zbd2p,
bseg.zbd2t,
bseg.zbd3t,
bseg.zbfix,
bseg.zlspr,
bseg.zlsch,
bseg.rebzg,
bseg.rebzj,
bseg.rebzz,
bseg.rebzt,
bseg.fdlev,
bseg.fdgrp,
bseg.empfb,
bseg.bvtyp,
bseg.saknr,
bseg.xcpdd,
bseg.diekz,
bseg.samnr,
bseg.vertn,
bseg.vertt,
bseg.vbewa,
bseg.dtws1,
bseg.dtws2,
bseg.dtws3,
bseg.dtws4,
bseg.pycur,
bseg.pyamt,
bseg.mndid,
bseg.secco,
bseg.maber,
bseg.madat,
bseg.manst,
bseg.mansp,
bseg.mschl,
bseg.kkber,
bseg.cession_kz,
bseg.zinkz,
bseg.btype,
bseg.vrskz,
bseg.vrsdt,
bseg.anfbn,
bseg.anfbu,
bseg.anfbj,
bseg.xinve,
bseg.zollt,
bseg.zolld,
bseg.valut,
bseg.vbeln,
bseg.xauto,
bseg.nebtr,
bseg.qsznr,
bseg.qbshb,
case bseg.shkzg
when 'S'
then bseg.dmbtr
else 0
end as dmsol,
case bseg.shkzg
when 'H'
then bseg.dmbtr
else 0
end as dmhab,
case bseg.shkzg
when 'S'
then bseg.wrbtr
else 0
end as wrsol,
case bseg.shkzg
when 'H'
then bseg.wrbtr
else 0
end as wrhab,
case bseg.shkzg
when 'S'
then bseg.dmbe2
else 0
end as dmso2,
case bseg.shkzg
when 'H'
then bseg.dmbe2
else 0
end as dmha2,
case bseg.shkzg
when 'S'
then bseg.dmbe3
else 0
end as dmso3,
case bseg.shkzg
when 'H'
then bseg.dmbe3
else 0
end as dmha3,
//// header data
// bkpf.budat,
// bkpf.waers,
// bkpf.hwaer,
// bkpf.hwae2,
// bkpf.hwae3,
// bkpf.kzwrs,
// bkpf.bstat,
// bkpf.bvorg,
// one-time account
bsec.name1 as bsec_name1,
bsec.name2 as bsec_name2,
bsec.name3 as bsec_name3,
bsec.name4 as bsec_name4,
bsec.pstlz as bsec_pstlz,
bsec.ort01 as bsec_ort01,
bsec.land1 as bsec_land1,
bsec.stras as bsec_stras,
bsec.pfach as bsec_pfach,
bsec.pstl2 as bsec_pstl2,
bsec.pskto as bsec_pskto,
bsec.bankn as bsec_bankn,
bsec.bankl as bsec_bankl,
bsec.banks as bsec_banks,
bsec.stcd1 as bsec_stcd1,
bsec.stcd2 as bsec_stcd2,
bsec.stkzu as bsec_stkzu,
bsec.stkza as bsec_stkza,
bsec.regio as bsec_regio,
bsec.bkont as bsec_bkont,
bsec.dtaws as bsec_dtaws,
bsec.dtams as bsec_dtams,
bsec.xcpdk as bsec_xcpdk,
bsec.empfg as bsec_empfg,
bsec.spras as bsec_spras,
bsec.fityp as bsec_fityp,
bsec.stcdt as bsec_stcdt,
bsec.stkzn as bsec_stkzn,
bsec.stcd3 as bsec_stcd3,
bsec.stcd4 as bsec_stcd4,
bsec.bkref as bsec_bkref,
bsec.j_1kfrepre as bsec_j_1kfrepre,
bsec.j_1kftbus as bsec_j_1kftbus,
bsec.j_1kftind as bsec_j_1kftind,
bsec.anred as bsec_anred,
bsec.adrnr as bsec_adrnr,
bsec.xrguh as bsec_xrguh,
bsec.po_box_num as bsec_po_box_num,
bsec.begru as bsec_begru,
bsec._dataaging as bsec_dataaging,
bsec.iban as bsec_iban,
bsec.iban_valid_from as bsec_iban_valid_from,
// reporting contry: for CDPs customers from BSEC, for other customer invoices from BSEG
//coalesce( bsec.land1, bseg.landl ) as egmld,
// other joined attributes
bseg.vkorg,
bseg.vtweg,
cast(bseg.kna1_land1 as fac_kna1_land1) as kna1_land1,
bseg.kna1_stceg,
bseg.kna1_begru,
bseg.kna1_xcpdk,
bseg.regio,
bseg.brsch,
bseg.kunnr_txt,
bseg.lifnr_txt,
bseg.lfa1_stceg,
cast(bseg.lfa1_land1 as fac_lfa1_land1) as lfa1_land1,
bseg.lfa1_begru,
bseg.lfa1_xcpdk,
skb1.begru as skb1_begru,
cast(t001.land1 as fac_t001_land1) as t001_land1,
t001.ktopl,
t005.land1,
t005.kalsm,
t001.butxt as bukrs_txt,
t880.name1 as vbund_txt,
t001w.name1 as werks_txt,
// Asset
bseg.anln1,
bseg.anln2,
bseg.bzdat,
bseg.anbwa,
to_next_item,
to_previous_item
// _Extension "not needed - extension fields are added by EXTEND view created by extensibility tool
}