I_MatlCtrlRecdLdgrFiscalPeriod

DDL: I_MATLCTRLRECDLDGRFISCALPERIOD SQL: IMCRLDRFISCPER Type: view BASIC
17 Fields 1 Data Sources

MatlCtrlRecd Fiscal Periods per Ledger

I_MatlCtrlRecdLdgrFiscalPeriod is a Basic CDS View that provides data about "MatlCtrlRecd Fiscal Periods per Ledger" in SAP S/4HANA. It reads from 1 data source (P_MatlCtrlRecdLdgrFiscalPeriod) and exposes 17 fields with key fields CompanyCode, Ledger.

Data Sources (1)

SourceAliasJoin Type
P_MatlCtrlRecdLdgrFiscalPeriod mcrlfp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMCRLDRFISCPER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label MatlCtrlRecd Fiscal Periods per Ledger view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

Fields (17)

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

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 I_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: IMCRLDRFISCPER

CREATE VIEW I_MatlCtrlRecdLdgrFiscalPeriod AS
SELECT
  mcrlfp.CompanyCode AS CompanyCode,
  mcrlfp.Ledger AS Ledger,
  mcrlfp.CurrentFiscalPeriod AS CurrentFiscalPeriod,
  mcrlfp.CurrentFiscalYear AS CurrentFiscalYear,
  mcrlfp.CurrentFiscalYearPeriod AS CurrentFiscalYearPeriod,
  mcrlfp.CurrentFiscalPeriodStartDate AS CurrentFiscalPeriodStartDate,
  mcrlfp.CurrentFiscalPeriodEndDate AS CurrentFiscalPeriodEndDate,
  mcrlfp.PreviousFiscalPeriod AS PreviousFiscalPeriod,
  mcrlfp.PreviousFiscalPeriodFiscalYear AS PreviousFiscalPeriodFiscalYear,
  mcrlfp.PreviousFiscalYearPeriod AS PreviousFiscalYearPeriod,
  mcrlfp.PreviousFiscalPeriodStartDate AS PreviousFiscalPeriodStartDate,
  mcrlfp.PreviousFiscalPeriodEndDate AS PreviousFiscalPeriodEndDate,
  mcrlfp.PrevFiscalYearLastFiscalPeriod AS PrevFiscalYearLastFiscalPeriod,
  mcrlfp.PreviousFiscalYear AS PreviousFiscalYear,
  mcrlfp.PrevFsclYearLastFsclYearPeriod AS PrevFsclYearLastFsclYearPeriod,
  mcrlfp.PrevFsclYrLastFsclPerdStrtDate AS PrevFsclYrLastFsclPerdStrtDate,
  mcrlfp.PrevFsclYrLastFsclPerdEndDate AS PrevFsclYrLastFsclPerdEndDate
FROM P_MatlCtrlRecdLdgrFiscalPeriod AS mcrlfp
;

Learn More