P_MatlCtrlRecdLdgrFiscalPeriod

DDL: P_MATLCTRLRECDLDGRFISCALPERIOD Type: view_entity COMPOSITE Package: FINS_ML_UTIL_PERIOD
17 Fields 1 Data Sources 1 Associations

Period Dates for CoCode Leading Ledger

P_MatlCtrlRecdLdgrFiscalPeriod is a Composite CDS View that provides data about "Period Dates for CoCode Leading Ledger" in SAP S/4HANA. It reads from 1 data source (P_CCLdgrShiftedPeriods) and exposes 17 fields with key fields CompanyCode, Ledger. It has 1 association to related views. Part of development package FINS_ML_UTIL_PERIOD.

Data Sources (1)

SourceAliasJoin Type
P_CCLdgrShiftedPeriods cclsp from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FiscalCalendarDate _PrevFsclYear _PrevFsclYear.FiscalYearVariant = cclsp.FiscalYearVariant and _PrevFsclYear.CalendarDate = cclsp.PreviousFiscalYearEndDate

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_CCLdgrShiftedPeriods CompanyCode Receiver Company Code
KEY Ledger P_CCLdgrShiftedPeriods Ledger Ledger
CurrentFiscalPeriod P_CCLdgrShiftedPeriods CurrentFiscalPeriod Fiscal Period
CurrentFiscalYear P_CCLdgrShiftedPeriods CurrentFiscalYear Fiscal Year
CurrentFiscalYearPeriod P_CCLdgrShiftedPeriods CurrentFiscalYearPeriod
CurrentFiscalPeriodStartDate P_CCLdgrShiftedPeriods CurrentFiscalPeriodStartDate
CurrentFiscalPeriodEndDate P_CCLdgrShiftedPeriods CurrentFiscalPeriodEndDate
PreviousFiscalPeriod P_CCLdgrShiftedPeriods PreviousFiscalPeriod Tax period
PreviousFiscalPeriodFiscalYear P_CCLdgrShiftedPeriods PreviousFiscalPeriodFiscalYear G/L Fiscal Year
PreviousFiscalYearPeriod P_CCLdgrShiftedPeriods PreviousFiscalYearPeriod
PreviousFiscalPeriodStartDate P_CCLdgrShiftedPeriods PreviousFiscalPeriodStartDate
PreviousFiscalPeriodEndDate P_CCLdgrShiftedPeriods PreviousFiscalPeriodEndDate
PrevFiscalYearLastFiscalPeriod _PrevFsclYear FiscalPeriod Tax period
PreviousFiscalYear _PrevFsclYear FiscalYear G/L Fiscal Year
PrevFsclYearLastFsclYearPeriod _PrevFsclYear FiscalYearPeriod Period/Year
PrevFsclYrLastFsclPerdStrtDate _PrevFsclYear FiscalPeriodStartDate
PrevFsclYrLastFsclPerdEndDate _PrevFsclYear FiscalPeriodEndDate

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_MatlCtrlRecdLdgrFiscalPeriod.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_MatlCtrlRecdLdgrFiscalPeriod AS
SELECT
  cclsp.CompanyCode AS CompanyCode,
  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
FROM P_CCLdgrShiftedPeriods AS cclsp
LEFT OUTER JOIN I_FiscalCalendarDate AS _PrevFsclYear ON _PrevFsclYear.FiscalYearVariant = cclsp.FiscalYearVariant AND _PrevFsclYear.CalendarDate = cclsp.PreviousFiscalYearEndDate  -- association [0..1]
;

Learn More