P_Cc_JournalEntryFact

DDL: P_CC_JOURNALENTRYFACT SQL: PCCJRNLENTRFACT Type: view BASIC

P_Cc_JournalEntryFact is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (P_CnsldtnUnitYrDepdnt13, I_CnsldtnGlobalParameter, I_CnsldtnLedger, P_ECMCA) and exposes 58 fields with key field gl_sirid.

4 data source(s) 58 fields

Data Sources (4)

SourceAliasJoin Type
P_CnsldtnUnitYrDepdnt13 _ConsUnit left_outer
I_CnsldtnGlobalParameter _GlobalParameter inner
I_CnsldtnLedger _Ledger left_outer
P_ECMCA ecmca from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCCJRNLENTRFACT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY gl_sirid gl_sirid
rldnr rldnr
rrcty rrcty
rvers rvers
ryear P_ECMCA ryear
rtcur rtcur
runit runit
drcrk drcrk
poper poper
docct docct
docnr docnr
docln docln
rcomp rcomp
rdimen rdimen
rbunit rbunit
ritclg ritclg
ritem ritem
rbuptr rbuptr
rcongr rcongr
robukrs robukrs
sityp sityp
subit subit
plevl plevl
rpflg rpflg
rtflg rtflg
docty docty
yracq yracq
pracq pracq
coicu coicu
updhp updhp
tsl tsl
hsl hsl
ksl ksl
msl msl
sgtxt sgtxt
autom autom
activ activ
bvorg bvorg
budat budat
wsdat wsdat
refdocnr refdocnr
refryear refryear
refdocln refdocln
refdocct refdocct
refactiv refactiv
cpudt cpudt
cputm cputm
usnam usnam
rvsdocnr rvsdocnr
orndocnr orndocnr
coiac coiac
coinr coinr
revyear revyear
awtyp awtyp
aworg aworg
logsys logsys
rhcur P_CnsldtnUnitYrDepdnt13 curr
rkcur 
@AbapCatalog.sqlViewName: 'PCCJRNLENTRFACT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_Cc_JournalEntryFact
  as select from    P_ECMCA                 as ecmca
    left outer join P_CnsldtnUnitYrDepdnt13 as _ConsUnit        on  ecmca.rdimen = _ConsUnit.dimen
                                                                and ecmca.rbunit = _ConsUnit.bunit
                                                                and ecmca.ryear  = _ConsUnit.RYEAR
    left outer join I_CnsldtnLedger             as _Ledger          on ecmca.rldnr = _Ledger.ConsolidationLedger
    inner join      I_CnsldtnGlobalParameter    as _GlobalParameter on ecmca.rdimen = _GlobalParameter.ConsolidationDimension
{

  key gl_sirid,
      rldnr,
      rrcty,
      rvers,
      ecmca.ryear                                 as ryear,
      rtcur,
      runit,
      drcrk,
      poper,
      docct,
      docnr,
      docln,
      rcomp,
      rdimen,
      rbunit,
      ritclg,
      ritem,
      rbuptr,
      rcongr,
      robukrs,
      sityp,
      subit,
      plevl,
      rpflg,
      rtflg,
      docty,
      yracq,
      pracq,
      coicu,
      updhp,
      tsl,
      hsl,
      ksl,
      msl,
      sgtxt,
      autom,
      activ,
      bvorg,
      budat,
      wsdat,
      refdocnr,
      refryear,
      refdocln,
      refdocct,
      refactiv,
      cpudt,
      cputm,
      usnam,
      rvsdocnr,
      orndocnr,
      coiac,
      coinr,
      revyear,
      awtyp,
      aworg,
      logsys,
      _ConsUnit.curr                              as rhcur,
      cast(_Ledger.GroupCurrency as gcurr) as rkcur
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNGLOBALPARAMETER",
"I_CNSLDTNLEDGER",
"P_CNSLDTNUNITYRDEPDNT13",
"P_ECMCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More