@AbapCatalog.sqlViewName: 'RARJRNLENTRITM'
@EndUserText.label:'Revenue Accounting-ACDOCA Extended View'
@ObjectModel: {
usageType.serviceQuality: #C,
usageType.sizeCategory: #XXL,
usageType.dataClass: #TRANSACTIONAL
}
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view FARR_JournalEntryItem
as select from P_ACDOCA as _ACDOCA
inner join finsc_ld_cmp as _FINSC on _FINSC.bukrs = _ACDOCA.rbukrs
and _FINSC.rldnr = _ACDOCA.rldnr
inner join FARR_AcctgPrncpRepLdgrMapping as _FARR_MAPPING on _FARR_MAPPING.AccountingPrinciple = _FINSC.acc_principle
and _FARR_MAPPING.Ledger = _FINSC.rldnr
left outer to one join farr_pst_cat_map as _CAT_MAP on _CAT_MAP.slalittype = _ACDOCA.slalittype
left outer to one join farr_d_lcc_map as _LCC_MAP on _LCC_MAP.company_code = _ACDOCA.rbukrs
and _LCC_MAP.curc_old = _ACDOCA.rwcur
association [0..1] to I_WBSElementBasicData as _WBSElement on _ACDOCA.ps_psp_pnr = _WBSElement.WBSElementInternalID
{
key _CAT_MAP.posting_cat as POST_CAT,
key _FINSC.acc_principle as ACCT_PRINCIPLE,
key _ACDOCA.ra_contract_id as CONTRACT_ID,
key _ACDOCA.ra_pob_id as POB_ID,
key hextobin('00000000000000000000000000000000') as guid,
key _ACDOCA.rldnr as Rldnr,
key _ACDOCA.gjahr as Gjahr,
key _ACDOCA.belnr as Belnr,
key _ACDOCA.docln as Docln,
key _ACDOCA.rbukrs as COMPANY_CODE,
key _ACDOCA.drcrk as SHKZG,
key cast( ' ' as kscha preserving type ) as CONDITION_TYPE,
key cast( ' '
as farr_recon_key preserving type ) as RECON_KEY,
key cast( 'C' as farr_recon_key_status preserving type ) as Status,
@Semantics.amount.currencyCode: 'HWAE2'
cast(case
when _FINSC.curposo = '2' then _ACDOCA.osl
when _FINSC.curposv = '2' then _ACDOCA.vsl
when _FINSC.curposb = '2' then _ACDOCA.bsl
when _FINSC.curposc = '2' then _ACDOCA.csl
when _FINSC.curposd = '2' then _ACDOCA.dsl
when _FINSC.curpose = '2' then _ACDOCA.esl
when _FINSC.curposf = '2' then _ACDOCA.fsl
when _FINSC.curposg = '2' then _ACDOCA.gsl
when _FINSC.curposk = '2' then _ACDOCA.ksl
else cast( 0 as wertv12 )
end as farr_amount_lc2 preserving type ) as BETR2,
cast(case
when _FINSC.curposo = '2' then _ACDOCA.rocur
when _FINSC.curposv = '2' then _ACDOCA.rvcur
when _FINSC.curposb = '2' then _ACDOCA.rbcur
when _FINSC.curposc = '2' then _ACDOCA.rccur
when _FINSC.curposd = '2' then _ACDOCA.rdcur
when _FINSC.curpose = '2' then _ACDOCA.recur
when _FINSC.curposf = '2' then _ACDOCA.rfcur
when _FINSC.curposg = '2' then _ACDOCA.rgcur
when _FINSC.curposk = '2' then _ACDOCA.rkcur
else ''
end as hwae2 ) as HWAE2,
@Semantics.amount.currencyCode: 'HWAE3'
cast(case
when _FINSC.curposo = '3' then _ACDOCA.osl
when _FINSC.curposv = '3' then _ACDOCA.vsl
when _FINSC.curposb = '3' then _ACDOCA.bsl
when _FINSC.curposc = '3' then _ACDOCA.csl
when _FINSC.curposd = '3' then _ACDOCA.dsl
when _FINSC.curpose = '3' then _ACDOCA.esl
when _FINSC.curposf = '3' then _ACDOCA.fsl
when _FINSC.curposg = '3' then _ACDOCA.gsl
when _FINSC.curposk = '3' then _ACDOCA.ksl
else cast( 0 as wertv12 )
end as farr_amount_lc3 preserving type ) as BETR3,
cast(case
when _FINSC.curposo = '3' then _ACDOCA.rocur
when _FINSC.curposv = '3' then _ACDOCA.rvcur
when _FINSC.curposb = '3' then _ACDOCA.rbcur
when _FINSC.curposc = '3' then _ACDOCA.rccur
when _FINSC.curposd = '3' then _ACDOCA.rdcur
when _FINSC.curpose = '3' then _ACDOCA.recur
when _FINSC.curposf = '3' then _ACDOCA.rfcur
when _FINSC.curposg = '3' then _ACDOCA.rgcur
when _FINSC.curposk = '3' then _ACDOCA.rkcur
else ''
end as hwae3 ) as HWAE3,
cast( '' as farr_shkzg_va preserving type ) as SHKZG_VA,
cast( '' as kstat preserving type ) as STATISTIC,
cast( ' ' as farr_rai_srcco preserving type ) as SRCDOC_COMP,
cast( ' ' as farr_rai_srcls preserving type ) as SRCDOC_LOGSYS,
cast( ' ' as farr_rai_srcty preserving type ) as SRCDOC_TYPE,
cast( ' '
as farr_rai_srcid preserving type ) as SRCDOC_ID,
cast( _ACDOCA.wsl as farr_amount_tc preserving type ) as BETRW,
cast( _ACDOCA.rwcur as waers preserving type ) as WAERS,
cast( _ACDOCA.hsl as farr_amount_lc preserving type ) as BETRH,
cast( _ACDOCA.rhcur as hwaer preserving type ) as HWAER,
_ACDOCA.racct as HKONT,
_CAT_MAP.special_indicator as SPEC_INDICATOR,
_ACDOCA.valobjtype as ValobjType,
_ACDOCA.valobj_id as Valobj_Id,
_ACDOCA.rfarea as FKBER,
_ACDOCA.rbusa as GSBER,
_ACDOCA.rcntr as KOSTL,
_ACDOCA.poper,
_ACDOCA.segment,
_ACDOCA.prctr,
_ACDOCA.paobjnr,
_ACDOCA.aufnr,
_ACDOCA.kdauf,
_ACDOCA.kdpos,
_WBSElement.WBSElementExternalID as ps_posid,
_ACDOCA.ps_psp_pnr,
_ACDOCA.awtyp,
_ACDOCA.awsys,
_ACDOCA.aworg,
_ACDOCA.awref,
_ACDOCA.bstat,
_ACDOCA.mig_source,
_ACDOCA.timestamp
}
where
(
_ACDOCA.vorgn = 'FIRA' // only select entries which were posted by RAR
and _LCC_MAP.curc_new is null // filter out entries with obsolete transaction currencies
)
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FARR_ACCTGPRNCPREPLDGRMAPPING",
"I_WBSELEMENTBASICDATA",
"P_ACDOCA",
"FARR_D_LCC_MAP",
"FARR_PST_CAT_MAP",
"FINSC_LD_CMP"
],
"ASSOCIATED":
[
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/