@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.
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_DATASUBMITREQUEST",
"P_REPORTEDFINANCIALDATA_RT_01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/