P_FR_FECPrevFsclYearDet

DDL: P_FR_FECPREVFSCLYEARDET SQL: PFRFECPRVFISCYR Type: view CONSUMPTION

FR Audit FEC BCF previous fiscal details

P_FR_FECPrevFsclYearDet is a Consumption CDS View that provides data about "FR Audit FEC BCF previous fiscal details" in SAP S/4HANA. It reads from 2 data sources (I_FiscalCalendarDtePrevPeriods, I_CompanyCode) and exposes 7 fields with key fields CompanyCode, FiscalYearVariant, FiscalPeriod.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_FiscalCalendarDtePrevPeriods _DataSource2 inner
I_CompanyCode I_CompanyCode from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFRFECPRVFISCYR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label FR Audit FEC BCF previous fiscal details view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _DataSource1 CompanyCode
KEY FiscalYearVariant _DataSource1 FiscalYearVariant
KEY FiscalPeriod I_FiscalCalendarDtePrevPeriods FiscalPeriod
FiscalYear I_FiscalCalendarDtePrevPeriods FiscalYear
FiscalYearStartDate I_FiscalCalendarDtePrevPeriods FiscalYearStartDate
FiscalYearEndDate I_FiscalCalendarDtePrevPeriods FiscalYearEndDate
PreviousFiscalYearEndDate I_FiscalCalendarDtePrevPeriods PreviousFiscalYearEndDate 
@AbapCatalog.sqlViewName: 'PFRFECPRVFISCYR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FR Audit FEC BCF previous fiscal details'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #CUSTOMIZING
define view P_FR_FECPrevFsclYearDet
  as select from I_CompanyCode _DataSource1
    inner join   I_FiscalCalendarDtePrevPeriods as _DataSource2 on _DataSource1.FiscalYearVariant = _DataSource2.FiscalYearVariant
{
  key _DataSource1.CompanyCode,
  key _DataSource1.FiscalYearVariant,
  key _DataSource2.FiscalPeriod,
      _DataSource2.FiscalYear,
      _DataSource2.FiscalYearStartDate,
      _DataSource2.FiscalYearEndDate,
      _DataSource2.PreviousFiscalYearEndDate
}
where
  _DataSource2.FiscalPeriod = '001'
group by
  _DataSource1.CompanyCode,
  _DataSource1.FiscalYearVariant,
  _DataSource2.FiscalPeriod,
  _DataSource2.FiscalYear,
  _DataSource2.FiscalYearStartDate,
  _DataSource2.FiscalYearEndDate,
  _DataSource2.PreviousFiscalYearEndDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_FISCALCALENDARDTEPREVPERIODS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More