P_REPORTEDFINANCIALDATA_RT_02

CDS View

P_REPORTEDFINANCIALDATA_RT_02 is a CDS View in S/4HANA. It contains 48 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 48 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ReportedFinancialData_RT_03 view from COMPOSITE

Fields (48)

KeyField CDS FieldsUsed in Views
activ activ 1
aworg aworg 1
awtyp awtyp 1
belnr belnr 1
blart blart 1
bsl bsl 1
budat budat 1
csl csl 1
curr_group_send curr_group_send 1
docln docln 1
docln_fin docln_fin 1
dsl dsl 1
esl esl 1
fiscal_year_period fiscal_year_period 1
fsl fsl 1
gcurr gcurr,rgcurr 1
gjahr gjahr 1
gsl gsl 1
hsl hsl 1
ksl ksl 1
logsys logsys 1
msl msl 1
osl osl 1
poper poper 1
prctr prctr 1
racct racct 1
rassc rassc 1
rbunit rbunit 1
rbusa rbusa 1
rcntr rcntr 1
rdimen rdimen 1
refactiv refactiv 1
refdocnr refdocnr 1
refryear refryear 1
rfarea rfarea 1
rldnr rldnr 1
rldnr_fin rldnr_fin 1
rmvct rmvct 1
robukrs robukrs 1
rtcur rtcur 1
runit runit 1
rvers rvers 1
ryear ryear 1
sbusa sbusa 1
Segment Segment 1
tsl tsl 1
usnam usnam 1
vsl vsl 1 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PREPFINDRT_02'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@AccessControl.authorizationCheck: #NOT_ALLOWED

@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

// What data this view returns depends on the input parameters the caller passes (see explanation below).

// The two branches of the union are mutually exclusive, i.e. in any case only one of the two branches will return data.

define view P_ReportedFinancialData_RT_02
  with parameters
    p_timestamp_from :timestamp,
    p_timestamp_to   :timestamp

  as select from P_ReportedFinancialData_RT_01
                    (p_timestamp_from : 000000000000000, //no explicit restriction of timestamp

                     p_timestamp_to   : 999999999999999)
                                   
  // Evaluate data submission request

  // This join will only return results if the caller passes 000000000000000 for p_timestamp_from and p_timestamp_to.

  // With such a call, the view will return all data up to the close_time defined by the data submission request.

    inner join   P_DataSubmitRequest on  P_DataSubmitRequest.dimen                =  P_ReportedFinancialData_RT_01.rdimen
                                     and P_DataSubmitRequest.rvers                =  P_ReportedFinancialData_RT_01.rvers
                                     and P_DataSubmitRequest.bunit                =  P_ReportedFinancialData_RT_01.rbunit
                                     and P_DataSubmitRequest.fyear                =  P_ReportedFinancialData_RT_01.ryear 
                                     and P_DataSubmitRequest.fperi                =  P_ReportedFinancialData_RT_01.poper 
                                     and P_DataSubmitRequest.close_time           >= P_ReportedFinancialData_RT_01.timestamp
                                     and P_ReportedFinancialData_RT_01.const_zero =  :p_timestamp_from
                                     and P_ReportedFinancialData_RT_01.const_zero =  :p_timestamp_to
{
  P_ReportedFinancialData_RT_01.rdimen,
  P_ReportedFinancialData_RT_01.rldnr_fin,
  P_ReportedFinancialData_RT_01.docln_fin,
  P_ReportedFinancialData_RT_01.robukrs,
  P_ReportedFinancialData_RT_01.rassc,
  P_ReportedFinancialData_RT_01.rvers,
  P_ReportedFinancialData_RT_01.impvs,          //bbrCC1808

  P_ReportedFinancialData_RT_01.rbunit,
  P_ReportedFinancialData_RT_01.budat,
  P_ReportedFinancialData_RT_01.gjahr,
  P_ReportedFinancialData_RT_01.belnr,
  P_ReportedFinancialData_RT_01.docln,
  P_ReportedFinancialData_RT_01.rbusa,
  P_ReportedFinancialData_RT_01.sbusa,
  P_ReportedFinancialData_RT_01.rldnr,
  P_ReportedFinancialData_RT_01.rtcur,
  P_ReportedFinancialData_RT_01.runit,
  P_ReportedFinancialData_RT_01.racct,
  P_ReportedFinancialData_RT_01.ktopl,
  P_ReportedFinancialData_RT_01.poper,
  P_ReportedFinancialData_RT_01.ryear,
  P_ReportedFinancialData_RT_01.fiscal_year_period,             //bbrCC1808

  P_ReportedFinancialData_RT_01.rmvct,
  P_ReportedFinancialData_RT_01.rfarea,
  P_ReportedFinancialData_RT_01.rcntr,
  P_ReportedFinancialData_RT_01.prctr,
  P_ReportedFinancialData_RT_01.blart,
  P_ReportedFinancialData_RT_01.tsl,
  P_ReportedFinancialData_RT_01.hsl,
  P_ReportedFinancialData_RT_01.ksl,
  P_ReportedFinancialData_RT_01.osl,
  P_ReportedFinancialData_RT_01.vsl,
  P_ReportedFinancialData_RT_01.bsl,
  P_ReportedFinancialData_RT_01.csl,
  P_ReportedFinancialData_RT_01.dsl,
  P_ReportedFinancialData_RT_01.esl,
  P_ReportedFinancialData_RT_01.fsl,
  P_ReportedFinancialData_RT_01.gsl,
  P_ReportedFinancialData_RT_01.msl,
  P_ReportedFinancialData_RT_01.activ,
  P_ReportedFinancialData_RT_01.refdocnr,
  P_ReportedFinancialData_RT_01.refryear,
  P_ReportedFinancialData_RT_01.refactiv,
  P_ReportedFinancialData_RT_01.usnam,
  P_ReportedFinancialData_RT_01.awtyp,
  P_ReportedFinancialData_RT_01.aworg,
  P_ReportedFinancialData_RT_01.logsys,
  P_ReportedFinancialData_RT_01.curr_group_send,
  P_ReportedFinancialData_RT_01.gcurr,
  P_ReportedFinancialData_RT_01.Segment
}

// bbrCC2002

//union all

//

//select from P_ReportedFinancialData_RT_01

//              (p_timestamp_from : :p_timestamp_from,

//               p_timestamp_to   : :p_timestamp_to)                  

//{

//  P_ReportedFinancialData_RT_01.rdimen,

//  P_ReportedFinancialData_RT_01.rldnr_fin,

//  P_ReportedFinancialData_RT_01.docln_fin,

//  P_ReportedFinancialData_RT_01.robukrs,

//  P_ReportedFinancialData_RT_01.rassc,

//  P_ReportedFinancialData_RT_01.rvers,

//  P_ReportedFinancialData_RT_01.impvs,          //bbrCC1808

//  P_ReportedFinancialData_RT_01.rbunit,

//  P_ReportedFinancialData_RT_01.budat,

//  P_ReportedFinancialData_RT_01.gjahr,

//  P_ReportedFinancialData_RT_01.belnr,

//  P_ReportedFinancialData_RT_01.docln,

//  P_ReportedFinancialData_RT_01.rbusa,

//  P_ReportedFinancialData_RT_01.sbusa,

//  P_ReportedFinancialData_RT_01.rldnr,

//  P_ReportedFinancialData_RT_01.rtcur,

//  P_ReportedFinancialData_RT_01.runit,

//  P_ReportedFinancialData_RT_01.racct,

//  P_ReportedFinancialData_RT_01.ktopl,

//  P_ReportedFinancialData_RT_01.poper,

//  P_ReportedFinancialData_RT_01.ryear,

//  P_ReportedFinancialData_RT_01.fiscal_year_period,             //bbrCC1808

//  P_ReportedFinancialData_RT_01.rmvct,

//  P_ReportedFinancialData_RT_01.rfarea,

//  P_ReportedFinancialData_RT_01.rcntr,

//  P_ReportedFinancialData_RT_01.prctr,

//  P_ReportedFinancialData_RT_01.blart,

//  P_ReportedFinancialData_RT_01.tsl,

//  P_ReportedFinancialData_RT_01.hsl,

//  P_ReportedFinancialData_RT_01.ksl,

//  P_ReportedFinancialData_RT_01.osl,

//  P_ReportedFinancialData_RT_01.vsl,

//  P_ReportedFinancialData_RT_01.bsl,

//  P_ReportedFinancialData_RT_01.csl,

//  P_ReportedFinancialData_RT_01.dsl,

//  P_ReportedFinancialData_RT_01.esl,

//  P_ReportedFinancialData_RT_01.fsl,

//  P_ReportedFinancialData_RT_01.gsl,

//  P_ReportedFinancialData_RT_01.msl,

//  P_ReportedFinancialData_RT_01.activ,

//  P_ReportedFinancialData_RT_01.refdocnr,

//  P_ReportedFinancialData_RT_01.refryear,

//  P_ReportedFinancialData_RT_01.refactiv,

//  P_ReportedFinancialData_RT_01.usnam,

//  P_ReportedFinancialData_RT_01.awtyp,

//  P_ReportedFinancialData_RT_01.aworg,

//  P_ReportedFinancialData_RT_01.logsys,

//  P_ReportedFinancialData_RT_01.curr_group_send,

//  P_ReportedFinancialData_RT_01.gcurr,

//  P_ReportedFinancialData_RT_01.Segment

//}

//where

//     P_ReportedFinancialData_RT_01.const_zero <> :p_timestamp_from

//  or P_ReportedFinancialData_RT_01.const_zero <> :p_timestamp_to

//

//// This select will only return results if the caller passes something <> 000000000000000 for p_timestamp_from or p_timestamp_to.

//// With such a call, the view will return all data within a given time intervall, independent of the data submission requests.

Learn More