P_VBKPF_COM

 @AbapCatalog.entityBuffer.definitionAllowed: false
 @VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true 
define view entity P_VBKPF_COM
as select from vbkpf inner join t001 on t001.bukrs = vbkpf.bukrs

{

key                                                       vbkpf.ausbk,
key cast( vbkpf.bukrs as fis_bukrs preserving type )   as bukrs,
key cast( vbkpf.belnr as farp_belnr_d preserving type )      as belnr,
key cast( vbkpf.gjahr as fis_gjahr_no_conv preserving type ) as gjahr,

cast( t001.ktopl as fis_ktopl preserving type ) as ktopl,

cast( vbkpf.blart as farp_blart preserving type ) as blart,
cast( vbkpf.bldat as fis_bldat preserving type ) as bldat,
cast( vbkpf.budat as fis_budat preserving type ) as budat,
cast( concat( '0', vbkpf.monat ) as abap.numc( 3 ) ) as monat,
cast( vbkpf.cpudt as farp_cpudt preserving type ) as cpudt,
cast( vbkpf.cputm as ttet_dt_cr_time preserving type ) as cputm,
vbkpf.aedat,
cast(vbkpf.upddt as ttet_dt_chg_date preserving type ) as upddt,
cast( vbkpf.wwert as vdm_v_exchange_rate_date preserving type ) as wwert,
cast( vbkpf.usnam as fis_usnam preserving type ) as usnam,
vbkpf.tcode,
cast( vbkpf.bvorg as fac_bvorg preserving type ) as bvorg,
vbkpf.xblnr,
vbkpf.bktxt,

vbkpf.waers as waers,

cast( vbkpf.kursf as ukurs_curr preserving type ) as kursf,

cast( vbkpf.bstat as farp_bstat_d preserving type ) as bstat,
@Semantics.amount.currencyCode: 'HWAE3' 
vbkpf.frath,
cast( vbkpf.awtyp as fis_awtyp preserving type ) as awtyp,
cast( vbkpf.awkey as fac_awkey preserving type ) as awkey,
vbkpf.fikrs,
vbkpf.vbund,

vbkpf.hwaer as hwaer,
vbkpf.hwae2 as hwae2,
vbkpf.hwae3 as hwae3,

vbkpf.kurs2,
vbkpf.kurs3,
vbkpf.basw2,
vbkpf.basw3,
vbkpf.umrd2,
vbkpf.umrd3,
vbkpf.xmwst,
vbkpf.curt2,
vbkpf.curt3,
vbkpf.kuty2,
vbkpf.kuty3,
cast( vbkpf.xsnet as xmwsn preserving type ) as xsnet,
vbkpf.awsys,
vbkpf.txkrs,
vbkpf.lotkz,
vbkpf.brnch,
vbkpf.numpg,
vbkpf.reindat,
vbkpf.ldgrp,
cast( vbkpf.propmano as fis_re_mandat ) as propmano,
vbkpf.vatdate,
vbkpf.kursx,
vbkpf.kur2x,
vbkpf.kur3x,
vbkpf.xmca,
vbkpf.ccins,
vbkpf.ccnum

}