P_VBKPF_COM

//@EndUserText.label: 'Operational Accounting Document'

@AbapCatalog.sqlViewName: 'PFIVBKPFCOM'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true 
define view P_VBKPF_COM
as select from vbkpf inner join t001 on t001.bukrs = vbkpf.bukrs

{

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

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

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

@Semantics.currencyCode:true
vbkpf.waers as waers,

cast( kursf as ukurs_curr preserving type ) as kursf,

cast( bstat as farp_bstat_d preserving type ) as bstat,
frath,
cast( awtyp as fis_awtyp preserving type ) as awtyp,
cast( awkey as fac_awkey preserving type ) as awkey,
vbkpf.fikrs,
vbkpf.vbund,

@Semantics.currencyCode:true
hwaer as hwaer,
@Semantics.currencyCode:true
hwae2 as hwae2,
@Semantics.currencyCode:true
hwae3 as hwae3,

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

}        
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001",
"VBKPF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/