@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'P_ACDOCA_COM'
@AbapCatalog.sqlViewName: 'PFIACDOCACOM'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.preserveKey:true
define view P_ACDOCA_COM
as select from acdoca
inner join finsc_ledger_rep on acdoca.rldnr = finsc_ledger_rep.rldnr_pers
// inner join finsc_ld_cmp on acdoca.rldnr = finsc_ld_cmp.rldnr and acdoca.rbukrs = finsc_ld_cmp.bukrs
{
key cast(acdoca.rldnr as fins_ledger_pers preserving type) as rldnr_pers,
key cast(acdoca.rbukrs as fis_bukrs preserving type) as rbukrs,
key cast(acdoca.gjahr as fis_gjahr_no_conv preserving type) as gjahr,
key cast(acdoca.belnr as fis_belnr preserving type) as belnr,
key cast(acdoca.docln as fis_docln preserving type) as docln,
key cast(finsc_ledger_rep.rldnr as fis_rldnr preserving type) as rldnr,
cast(acdoca.ryear as fis_ryear_no_conv preserving type) as ryear,
acdoca.rrcty,
///////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_00 Unified Journal Entry: Transaction, Currencies, Units
///////////////////////////////////////////////////////////////////////////////
cast(rmvct as fis_rmvct preserving type) as rmvct,
vorgn,
vrgng,
bttype,
cast(awtyp as fis_awtyp preserving type) as awtyp,
cast(awsys as logsystem preserving type) as awsys,
cast(aworg as fis_aworg preserving type) as aworg,
awref,
awitem,
awitgrp,
subta,
xreversing,
xreversed,
xtruerev,
awtyp_rev,
aworg_rev,
awref_rev,
subta_rev,
xsettling,
xsettled,
prec_awtyp,
prec_aworg,
prec_awref,
prec_awitem,
prec_subta,
src_awtyp,
src_awsys,
src_aworg,
src_awref,
src_awitem,
src_awsubit,
xcommitment,
obs_reason,
cast(racct as fis_racct preserving type) as racct,
////////////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_GL_ACCAS Unified Journal Entry: G/L additional account assignments
////////////////////////////////////////////////////////////////////////////////////
cast(rcntr as fis_kostl preserving type) as rcntr,
cast(prctr as fis_prctr preserving type) as prctr,
cast(rfarea as fm_farea preserving type) as rfarea,
cast(rbusa as fis_rbusa preserving type) as rbusa,
cast(kokrs as fis_kokrs preserving type) as kokrs,
segment,
cast(scntr as fis_skost preserving type) as scntr,
cast(pprctr as fis_pprctr preserving type) as pprctr,
cast(sfarea as fis_sfkber preserving type) as sfarea,
cast(sbusa as fis_pargb preserving type) as sbusa,
cast(rassc as fis_rassc preserving type) as rassc,
psegment,
/////////////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_VALUE_DATA Unified Journal Entry: Value Fields
/////////////////////////////////////////////////////////////////////////////////////
@Semantics.currencyCode:true
cast(rtcur as fis_rtcur preserving type) as rtcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rtcur'} }
cast(tsl as fis_tsl preserving type) as tsl,
@Semantics.currencyCode:true
cast(rwcur as fis_rwcur preserving type) as rwcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rwcur'} }
cast(wsl as fis_wsl preserving type) as wsl,
@Semantics.currencyCode:true
cast(rhcur as fis_hwaer preserving type) as rhcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rhcur'} }
cast(hsl as fis_hsl preserving type) as hsl,
@Semantics: { amount : {currencyCode: 'rhcur'} }
hvkwrt,
@Semantics.currencyCode:true
cast(rkcur as fis_rkcur preserving type) as rkcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
cast(ksl as fis_ksl preserving type) as ksl,
// Freely Defined Currency 1
@Semantics.currencyCode:true
cast(rocur as fis_rocur preserving type) as rocur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rocur'} }
cast(osl as fis_osl preserving type) as osl,
// Freely Defined Currency 2
@Semantics.currencyCode:true
cast(rvcur as fis_rvcur preserving type) as rvcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rvcur'} }
cast(vsl as fis_vsl preserving type) as vsl,
// Freely Defined Currency 3
@Semantics.currencyCode:true
rbcur as rbcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rbcur'} }
cast(bsl as fis_bsl preserving type) as bsl,
// Freely Defined Currency 4
@Semantics.currencyCode:true
rccur as rccur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rccur'} }
cast(csl as fis_csl preserving type) as csl,
// Freely Defined Currency 5
@Semantics.currencyCode:true
rdcur as rdcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rdcur'} }
cast(dsl as fis_dsl preserving type) as dsl,
// Freely Defined Currency 6
@Semantics.currencyCode:true
recur as recur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'recur'} }
cast(esl as fis_esl preserving type) as esl,
// Freely Defined Currency 7
@Semantics.currencyCode:true
cast(rfcur as fis_rfcur preserving type) as rfcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rfcur'} }
cast(fsl as fis_fsl preserving type) as fsl,
// Freely Defined Currency 8
@Semantics.currencyCode:true
rgcur as rgcur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rgcur'} }
cast(gsl as fis_gsl preserving type) as gsl,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
cast(kfsl as fis_kfsl preserving type) as kfsl,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
kfsl2 as kfsl2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
kfsl3 as kfsl3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
cast(psl as fis_psl preserving type) as psl,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
psl2 as psl2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
psl3 as psl3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
cast(pfsl as fis_pfsl preserving type) as pfsl,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
pfsl2 as pfsl2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rkcur'} }
pfsl3 as pfsl3,
@Semantics.currencyCode:true
rco_ocur as rco_ocur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rco_ocur'} }
co_osl,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rhcur'} }
hstprs,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rhcur'} }
hpvprs,
@Semantics.unitOfMeasure:true
runit as runit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'runit'} }
msl,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'runit'} }
mfsl,
@Semantics.unitOfMeasure:true
cast(rvunit as fis_co_meinh preserving type) as rvunit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'rvunit'} }
vmsl,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'rvunit'} }
vmfsl,
@Semantics.unitOfMeasure:true
qunit1 as qunit1,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'qunit1'} }
quant1,
@Semantics.unitOfMeasure:true
qunit2 as qunit2,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'qunit2'} }
quant2,
@Semantics.unitOfMeasure:true
qunit3 as qunit3,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'qunit3'} }
quant3,
/////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FIX Unified Journal Entry: Mandatory fields for G/L
////////////////////////////////////////////////////////////////////////////
cast(drcrk as fis_shkzg preserving type) as drcrk,
// cast(poper as FIS_POPER) as poper,
cast(poper as fins_fiscalperiod preserving type) as poper,
cast(acdoca.periv as fis_periv preserving type) as periv,
cast(fiscyearper as fis_jahrper_conv preserving type ) as fiscyearper,
cast(budat as fis_budat preserving type) as budat,
cast(bldat as fis_bldat preserving type) as bldat,
cast(blart as fis_blart preserving type) as blart,
// cast(blart as farp_blart) as blart,
cast(buzei as fis_buzei preserving type) as buzei,
// cast(buzei as farp_buzei) as buzei,
cast(zuonr as fis_zuonr preserving type) as zuonr,
cast(bschl as fis_bschl preserving type) as bschl,
cast(bstat as fis_bstat preserving type) as bstat,
// cast(bstat as farp_bstat_d) as bstat,
linetype,
cast(ktosl as fac_ktosl preserving type) as ktosl,
slalittype,
xsplitmod,
cast(usnam as fis_usnam preserving type) as usnam,
timestamp,
eprctr,
cast(rhoart as fis_hoart preserving type) as rhoart,
glaccount_type,
cast(ktopl as fis_ktopl preserving type) as ktopl,
cast(lokkt as fis_altkt_skb1 preserving type) as lokkt,
cast(ktop2 as fis_ktop2 preserving type) as ktop2,
///////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_GEN Unified Journal Entry: Fields for several subledgers
//////////////////////////////////////////////////////////////////////////
cast(rebzg as fis_rebzg preserving type) as rebzg,
cast(rebzj as fis_rebzj_no_conv preserving type) as rebzj,
cast(rebzz as fis_rebzz preserving type) as rebzz,
cast(rebzt as farp_rebzt preserving type) as rebzt,
cast(rbest as fis_refbtyp preserving type) as rbest,
cast(ebeln as fis_ebeln preserving type) as ebeln,
cast(ebelp as fis_ebelp preserving type) as ebelp,
zekkn,
// cast(sgtxt as FIS_SGTXT) as sgtxt,
cast(sgtxt as farp_sgtxt preserving type) as sgtxt,
cast(kdauf as vdm_sales_order preserving type) as kdauf,
cast(kdpos as sales_order_item preserving type) as kdpos,
matnr,
werks,
cast(lifnr as md_supplier preserving type) as lifnr,
cast(kunnr as kunnr preserving type) as kunnr,
fbuda,
coco_num,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FI Unified Journal Entry: Fields for FI subledgers
/////////////////////////////////////////////////////////////////////////
cast(koart as farp_koart preserving type) as koart,
cast(umskz as fac_umskz preserving type) as umskz,
cast(mwskz as fis_mwskz preserving type) as mwskz,
cast(hbkid as farp_hbkid preserving type) as hbkid,
cast(hktid as fac_hktid preserving type) as hktid,
cast(xopvw as fis_xopvw preserving type) as xopvw,
cast(augdt as fis_augdt preserving type) as augdt,
// cast(augbl as farp_augbl) as augbl,
cast(augbl as fis_augbl preserving type) as augbl,
cast(auggj as fis_auggj_no_conv preserving type) as auggj,
cast( case augdt when '00000000' then cast( ' ' as xaugp preserving type)
else cast( 'X' as xaugp preserving type)
end as xaugp preserving type) as XAUGP,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FAA Unified Journal Entry: Fields for Asset Accounting
/////////////////////////////////////////////////////////////////////////
cast(afabe as fis_afabe_d preserving type) as afabe,
cast(anln1 as fis_anln1 preserving type) as anln1,
cast(anln2 as fis_anln2 preserving type) as anln2,
bzdat,
anbwa,
movcat,
cast(depr_period as fis_peraf preserving type) as depr_period,
cast(anlgr as fis_anlgr preserving type) as anlgr,
cast(anlgr2 as fis_anlgr2 preserving type) as anlgr2,
settlement_rule,
anlkl,
ktogr,
panl1,
panl2,
//////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_ML Unified Journal Entry: Fields for Material Ledger
//////////////////////////////////////////////////////////////////////////
cast(kalnr as fis_kalnr preserving type) as kalnr,
vprsv,
mlast,
cast(kzbws as inventoryspecialstockvalntype preserving type) as kzbws,
xobew,
cast(sobkz as inventoryspecialstocktype preserving type) as sobkz,
// VTSTAMP,
mat_kdauf,
mat_kdpos,
mat_pspnr,
mat_ps_posid,
cast(mat_lifnr as fis_mlmat_lifnr preserving type) as mat_lifnr,
bwtar,
bwkey,
hpeinh,
// KPEINH,
// OPEINH,
// VPEINH,
mlptyp,
mlcateg,
qsbvalt,
qsprocess,
perart,
////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_CFIN Unified Journal Entry: Fields for Central Finance
//////////////////////////////////////////////////////////////////////////////
cast(racct_sender as fis_racct_sender preserving type) as racct_sender,
accas_sender,
accasty_sender,
////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_CO Unified Journal Entry: CO fields
///////////////////////////////////////////////////////////////////////////
objnr,
hrkft,
hkgrp,
parob1,
parobsrc,
cast( uspob as fis_uspob preserving type) as uspob,
co_belkz,
beltp,
muvflg,
cast(gkont as fis_gkont preserving type) as gkont,
cast(gkoar as farp_gkoar preserving type) as gkoar,
cast(erlkz as fis_kblerlkz preserving type) as erlkz,
pernr,
paobjnr,
xpaobjnr_co_rel,
cast(scope as fis_scope_cv_conv preserving type) as scope,
logsyso,
pbukrs,
cast(pscope as fis_pscope_cv_conv preserving type) as pscope,
logsysp,
bwstrat,
objnr_hk,
aufnr_org,
ukostl,
cast(ulstar as fis_usp_lstar preserving type) as ulstar,
uprctr,
accas,
accasty,
lstar,
cast(aufnr as fis_aufnr preserving type) as aufnr,
autyp,
cast(ps_psp_pnr as ps_posnr preserving type) as ps_psp_pnr,
ps_posid,
ps_prj_pnr,
ps_pspid,
nplnr,
nplnr_vorgn,
prznr,
kstrg,
cast(bemot as fis_bemot preserving type) as bemot,
cast(rsrce as fis_co_resource preserving type) as rsrce,
qmnum,
service_doc_type,
service_doc_id,
service_doc_item_id,
service_contract_type,
service_contract_id,
service_contract_item_id,
solution_order_id,
solution_order_item_id,
vtkey,
vtpos,
erkrs,
cast(paccas as fis_paccas preserving type) as paccas,
cast(paccasty as fis_paccasty preserving type) as paccasty,
cast(plstar as fis_par_lstar preserving type) as plstar,
cast(paufnr as fis_par_aufnr preserving type) as paufnr,
cast(pautyp as fis_par_auftyp preserving type) as pautyp,
cast(pps_posid as fis_par_posid preserving type) as pps_posid,
cast(pps_pspid as fis_par_pspid preserving type) as pps_pspid,
cast(pkdauf as fis_par_kdauf preserving type) as pkdauf,
cast(pkdpos as fis_par_kdpos preserving type) as pkdpos,
ppaobjnr,
pnplnr,
pnplnr_vorgn,
pprznr,
pkstrg,
co_accasty_n1,
co_accasty_n2,
co_accasty_n3,
co_zlenr,
co_belnr,
co_buzei,
co_refbz,
overtimecat,
work_item_id,
co_beknz,
uprznr,
pps_psp_pnr,
pps_prj_pnr,
pservice_doc_type,
pservice_doc_id,
pservice_doc_item_id,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_COPA Unified Journal Entry: CO-PA fields
//////////////////////////////////////////////////////////////////////
fkart,
vkorg,
vtweg,
spart,
matnr_copa,
matkl,
kdgrp,
land1,
brsch,
bzirk,
kunre,
kunwe,
konzs,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_PS Unified Journal Entry: Fields for Public Sector
/////////////////////////////////////////////////////////////////////
re_bukrs,
re_account,
fikrs,
cast(fistl as farp_fistl preserving type) as fistl,
measure,
rfund,
rgrant_nbr,
rbudget_pd,
sfund,
sgrant_nbr,
sbudget_pd,
bdgt_account,
bdgt_account_cocode,
bdgt_cnsmpn_date,
bdgt_cnsmpn_period,
bdgt_cnsmpn_year,
bdgt_relevant,
bdgt_cnsmpn_type,
bdgt_cnsmpn_amount_type,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_JVA Unified Journal Entry: Fields for Joint Venture Accounting
///////////////////////////////////////////////////////////////////////
vname,
egrup,
recid,
vptnr,
btype,
etype,
prodper,
billm,
pom,
cbrunid,
jvactivity,
pvname,
pegrup,
s_recind,
cbracct,
cbobjnr,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_RE STRU 0 0 Unified Journal Entry: Fields for Real Estate
///////////////////////////////////////////////////////////////////////
swenr,
sgenr,
sgrnr,
smenr,
recnnr,
snksl,
sempsl,
cast(dabrz as farp_dabrbez preserving type) as dabrz,
pswenr,
psgenr,
psgrnr,
psmenr,
precnnr,
psnksl,
psempsl,
pdabrz,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_ACR STRU 0 0 Universal Journal Entry: Fields for Accrual object
///////////////////////////////////////////////////////////////////////
acrobjtype,
acrobj_id,
acrsobj_id,
acritmtype,
acrvaldat,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_VAL STRU 0 0 Universal Journal Entry: Fields for Fin. Valuation Object
///////////////////////////////////////////////////////////////////////
valobjtype,
valobj_id,
valsobj_id,
cast(netdt as faedt_fpos preserving type) as netdt,
cast(risk_class as credit_risk_class preserving type) as risk_class,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_LOG Universal Journal Entry: Fields for Logistics
//////////////////////////////////////////////////////////////////////
arbid,
vornr,
aufps,
//////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_LOG_ACT: New Fields PM //
//////////////////////////////////////////////////
uvorn,
equnr,
tplnr,
istru,
ilart,
plknz,
artpr,
priok,
maufnr,
matkl_mm,
planned_parts_work,
@DefaultAggregation: #SUM
cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) as nbritm
}
where
(
bstat <> 'D'
)
and(
bstat <> 'M'
)
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LEDGER_REP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/