P_MATLCTRLRECDLDGRFISCALPERIOD

CDS View

Period Dates for CoCode Leading Ledger

P_MATLCTRLRECDLDGRFISCALPERIOD is a CDS View in S/4HANA. Period Dates for CoCode Leading Ledger. It contains 17 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 17 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_MatlCtrlRecdLdgrFiscalPeriod view_entity from COMPOSITE MatlCtrlRecd Fiscal Periods per Ledger
P_MatVal_By_Period_Types view inner COMPOSITE Prices and values for app Mat. Val. Manage
P_Matval_Manage_Bal view inner COMPOSITE Base View for Mat.Val., Balances
P_Matval_Manage_Val_Chart view inner COMPOSITE Base View for Mat.Val., Balances

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY Ledger Ledger 1
CurrentFiscalPeriod CurrentFiscalPeriod 1
CurrentFiscalPeriodEndDate CurrentFiscalPeriodEndDate 1
CurrentFiscalPeriodStartDate CurrentFiscalPeriodStartDate 1
CurrentFiscalYear CurrentFiscalYear 1
CurrentFiscalYearPeriod CurrentFiscalYearPeriod 1
PrevFiscalYearLastFiscalPeriod PrevFiscalYearLastFiscalPeriod 1
PrevFsclYearLastFsclYearPeriod PrevFsclYearLastFsclYearPeriod 1
PrevFsclYrLastFsclPerdEndDate PrevFsclYrLastFsclPerdEndDate 1
PrevFsclYrLastFsclPerdStrtDate PrevFsclYrLastFsclPerdStrtDate 1
PreviousFiscalPeriod PreviousFiscalPeriod 1
PreviousFiscalPeriodEndDate PreviousFiscalPeriodEndDate 1
PreviousFiscalPeriodFiscalYear PreviousFiscalPeriodFiscalYear 1
PreviousFiscalPeriodStartDate PreviousFiscalPeriodStartDate 1
PreviousFiscalYear PreviousFiscalYear 1
PreviousFiscalYearPeriod PreviousFiscalYearPeriod 1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity 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,
      _PrevFsclYear.FiscalYearPeriod                            as PrevFsclYearLastFsclYearPeriod,
      _PrevFsclYear.FiscalPeriodStartDate                       as PrevFsclYrLastFsclPerdStrtDate,
      _PrevFsclYear.FiscalPeriodEndDate                         as PrevFsclYrLastFsclPerdEndDate

}

Learn More