P_MATLCTRLRECDLDGRFISCALPERIOD

CDS View

P_MATLCTRLRECDLDGRFISCALPERIOD is a CDS View in S/4HANA. It contains 17 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 17 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_MatlCtrlRecdLdgrFiscalPeriod view from BASIC MatlCtrlRecd Fiscal Periods per Ledger
P_MatVal_By_Period_Types view inner BASIC
P_Matval_Manage_Bal view inner BASIC
P_Matval_Manage_Bal_Split view inner BASIC
P_Matval_Manage_Pnv_Pre view inner BASIC
P_Matval_Manage_Val_Chart view inner BASIC

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY CurrentFiscalPeriod CurrentFiscalPeriod,FiscalPeriod 2
KEY CurrentFiscalYear CurrentFiscalYear,FiscalYear 2
KEY Ledger Ledger 1
KEY PrevFiscalYearLastFiscalPeriod FiscalPeriod,PrevFiscalYearLastFiscalPeriod 2
KEY PreviousFiscalPeriod FiscalPeriod,PreviousFiscalPeriod 2
KEY PreviousFiscalPeriodFiscalYear FiscalYear,PreviousFiscalPeriodFiscalYear 2
KEY PreviousFiscalYear FiscalYear,PreviousFiscalYear 2
CurrentFiscalPeriodEndDate CurrentFiscalPeriodEndDate 1
CurrentFiscalPeriodStartDate CurrentFiscalPeriodStartDate 1
CurrentFiscalYearPeriod CurrentFiscalYearPeriod 1
PrevFsclYearLastFsclYearPeriod PrevFsclYearLastFsclYearPeriod 1
PrevFsclYrLastFsclPerdEndDate PrevFsclYrLastFsclPerdEndDate 1
PrevFsclYrLastFsclPerdStrtDate PrevFsclYrLastFsclPerdStrtDate 1
PreviousFiscalPeriodEndDate PreviousFiscalPeriodEndDate 1
PreviousFiscalPeriodStartDate PreviousFiscalPeriodStartDate 1
PreviousFiscalYearPeriod PreviousFiscalYearPeriod 1 
@AbapCatalog.sqlViewName: 'PMCRLDRFISCPER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
define view P_MatlCtrlRecdLdgrFiscalPeriod
  as select from P_CCLdgrShiftedPeriods as cclsp

  association [0..1] to I_FiscalCalendarDate as _PrevFsclYear on  _PrevFsclYear.FiscalYearVariant = cclsp.FiscalYearVariant
                                                              and _PrevFsclYear.CalendarDate      = cclsp.PreviousFiscalYearEndDate


{
  key cclsp.CompanyCode                                         as CompanyCode,
  key cclsp.Ledger                                              as Ledger,

      cclsp.CurrentFiscalPeriod                                 as CurrentFiscalPeriod,
      cclsp.CurrentFiscalYear                                   as CurrentFiscalYear,
      cclsp.CurrentFiscalYearPeriod                             as CurrentFiscalYearPeriod,
      cclsp.CurrentFiscalPeriodStartDate                        as CurrentFiscalPeriodStartDate,
      cclsp.CurrentFiscalPeriodEndDate                          as CurrentFiscalPeriodEndDate,

      cclsp.PreviousFiscalPeriod                                as PreviousFiscalPeriod,
      cclsp.PreviousFiscalPeriodFiscalYear                      as PreviousFiscalPeriodFiscalYear,
      cclsp.PreviousFiscalYearPeriod                            as PreviousFiscalYearPeriod,
      cclsp.PreviousFiscalPeriodStartDate                       as PreviousFiscalPeriodStartDate,
      cclsp.PreviousFiscalPeriodEndDate                         as PreviousFiscalPeriodEndDate,

      _PrevFsclYear.FiscalPeriod                                as PrevFiscalYearLastFiscalPeriod,
      _PrevFsclYear.FiscalYear                                  as PreviousFiscalYear,
      cast(_PrevFsclYear.FiscalYearPeriod as fml_yearper_nconv) as PrevFsclYearLastFsclYearPeriod,
      _PrevFsclYear.FiscalPeriodStartDate                       as PrevFsclYrLastFsclPerdStrtDate,
      _PrevFsclYear.FiscalPeriodEndDate                         as PrevFsclYrLastFsclPerdEndDate

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FISCALCALENDARDATE",
"P_CCLDGRSHIFTEDPERIODS"
],
"ASSOCIATED":
[
"I_FISCALCALENDARDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More