P_MatlCtrlRecdLdgrFiscalPeriod

DDL: P_MATLCTRLRECDLDGRFISCALPERIOD SQL: PMCRLDRFISCPER Type: view BASIC
17 Fields 1 Data Sources 1 Associations

P_MatlCtrlRecdLdgrFiscalPeriod is a Basic CDS View 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.

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 (7)

NameValueLevelField
AbapCatalog.sqlViewName PMCRLDRFISCPER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC 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
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.
-- SQL view name: PMCRLDRFISCPER

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,
  cast(_PrevFsclYear.FiscalYearPeriod as fml_yearper_nconv) 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