@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'Journal Entry'
@AbapCatalog.sqlViewName: 'PFIBKPFCOM'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.preserveKey:true
@Metadata.ignorePropagatedAnnotations: true
define view P_BKPF_COM
as select from bkpf
{
key cast( 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( 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( monat as FINS_FISCALPERIOD ) as monat,
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,
cast( xblnr as fis_xblnr1 preserving type ) as xblnr,
cast( dbblg as fis_rjet_id preserving type ) as dbblg,
cast( stblg as fis_stblg preserving type ) as stblg,
cast( stjah as fis_stjah_no_conv preserving type ) as stjah,
bktxt,
@Semantics.currencyCode:true
waers as waers,
// DEC9.5 with conversion exit EXCRT --> CHAR13 without conversion exit 14.02.2019
//cast( kursf as fis_kursf_char ) as kursf,
cast( kursf as ukurs_curr preserving type ) as kursf,
@Semantics.currencyCode:true
kzwrs as kzwrs,
kzkrs,
cast( bstat as fis_bstat preserving type ) as bstat,
cast( xnetb as fis_xnetb preserving type ) as xnetb,
frath,
cast( xrueb as fis_xrueb preserving type ) as xrueb,
cast( glvor as fins_bttype preserving type ) as glvor,
cast( grpid as fis_grpid preserving type ) as grpid,
dokid,
arcid,
iblar,
cast( awtyp as fis_awtyp preserving type ) as awtyp,
cast( awkey as fac_awkey preserving type ) as awkey,
fikrs,
@Semantics.currencyCode:true
cast( hwaer as fis_hwaer ) as hwaer,
@Semantics.currencyCode:true
cast( hwae2 as fis_hwae2 ) as hwae2,
@Semantics.currencyCode:true
cast( hwae3 as fis_hwae3 ) as hwae3,
// DEC9.5 with conversion exit EXCRT --> not used in I-View I_JournalEntry
kurs2,
// DEC9.5 with conversion exit EXCRT --> not used in I-View I_JournalEntry
kurs3,
basw2,
basw3,
umrd2,
umrd3,
cast( xstov as fis_xstov ) as xstov,
cast( stodt as fis_stodt ) as stodt,
cast( xmwst as fis_xmwst ) as xmwst,
curt2,
curt3,
kuty2,
kuty3,
cast( xsnet as fis_xmwsn ) as xsnet,
ausbk,
xusvr,
duefl,
awsys,
// DEC9.5 with conversion exit EXCRT --> CHAR13 without conversion exit 14.02.2019
//cast( txkrs as fis_txkrs_char ) as txkrs,
cast( txkrs as fis_txkrs_bkpf ) as txkrs,
ctxkrs,
lotkz,
xwvof,
stgrd,
ppnam,
cast( brnch as fis_j_1abrnch preserving type) as brnch,
numpg,
adisc,
cast( xref1_hd as fins_xref1_hd ) as xref1_hd,
cast( xref2_hd as fins_xref2_hd ) as xref2_hd,
cast( reindat as fis_reindat ) as reindat,
cast( rldnr as fis_rldnr preserving type) as rldnr,
ldgrp,
cast( propmano as fis_re_mandat ) as propmano,
// cast( xblnr_alt as fis_xblnr_alt_wo_exit ) as xblnr_alt,
cast( xblnr_alt as fis_xblnr_alt ) as xblnr_alt,
vatdate,
fulfilldate,
cast( doccat as fis_accdoc_class preserving type) as doccat,
xsplit,
cash_alloc,
follow_on,
xreorg,
subset,
kurst,
kursx,
kur2x,
kur3x,
xmca,
resubmission,
cast( logsystem_sender as fis_logsystem_sender preserving type ) as logsystem_sender,
bukrs_sender,
cast( belnr_sender as fis_belnr_sender preserving type) as belnr_sender,
cast( gjahr_sender as fis_gjahr_sender_no_conv preserving type ) as gjahr_sender,
aworg_rev,
awref_rev,
ccins,
ccnum,
cast( penrc as fis_penrc ) as penrc,
cast( knumv as fis_knumv ) as knumv,
cast( xreversing as fins_xreversing ) as xreversing,
cast( xreversed as fins_xreversed ) as xreversed,
cast( glbtgrp as fis_glbtgrp ) as glbtgrp,
ppdat,
pptme,
co_valdt,
cast(tax_country_hd as fis_tax_country_hd preserving type ) as TAX_COUNTRY_HD,
cast(last_change_datetime as fis_je_lastchange_datetime preserving type ) as last_change_datetime,
reprocessing_status_code,
// .INCLUDE FAC_BKPF_EXT_GLO STRU 0 0 Document Header: Extension include for globalisation
glo_ref1_hd,
glo_dat1_hd,
glo_ref2_hd,
glo_dat2_hd,
glo_ref3_hd,
glo_dat3_hd,
glo_ref4_hd,
glo_dat4_hd,
glo_ref5_hd,
glo_dat5_hd,
glo_bp1_hd,
glo_bp2_hd,
whtdate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/