P_REPORTEDFINANCIALDATA_RT_02
Evaluate Data Submit Request
P_REPORTEDFINANCIALDATA_RT_02 is a CDS View in S/4HANA. Evaluate Data Submit Request. It contains 48 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ReportedFinancialData_RT_03 | view | from | COMPOSITE | Account mapping and Partner Consolidation Unit |
Fields (48)
| Key | Field | CDS Fields | Used 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.