P_RAFiscalYear

DDL: P_RAFISCALYEAR Type: view_entity COMPOSITE
10 Fields 1 Data Sources

P_RAFiscalYear is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RAFiscalYearPeriod) and exposes 10 fields with key fields FiscalYearVariant, FiscalYearPeriod.

Data Sources (1)

SourceAliasJoin Type
P_RAFiscalYearPeriod RAFiscalYearPeriod1 from

Annotations (3)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearVariant P_RAFiscalYearPeriod FiscalYearVariant FY Variant
KEY FiscalYearPeriod P_RAFiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYear P_RAFiscalYearPeriod FiscalYear G/L Fiscal Year
FiscalQuarter P_RAFiscalYearPeriod FiscalQuarter
FiscalPeriod P_RAFiscalYearPeriod FiscalPeriod Tax period
FiscalYearStartDate P_RAFiscalYearPeriod FiscalYearStartDate
FiscalYearEndDate P_RAFiscalYearPeriod FiscalYearEndDate
FiscalPeriodStartDate P_RAFiscalYearPeriod FiscalPeriodStartDate
FiscalPeriodEndDate P_RAFiscalYearPeriod FiscalPeriodEndDate
PreviousFiscalYear

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_RAFiscalYear.
-- 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_RAFiscalYear AS
SELECT
  RAFiscalYearPeriod1.FiscalYearVariant AS FiscalYearVariant,
  RAFiscalYearPeriod1.FiscalYearPeriod AS FiscalYearPeriod,
  RAFiscalYearPeriod1.FiscalYear AS FiscalYear,
  RAFiscalYearPeriod1.FiscalQuarter AS FiscalQuarter,
  RAFiscalYearPeriod1.FiscalPeriod AS FiscalPeriod,
  RAFiscalYearPeriod1.FiscalYearStartDate AS FiscalYearStartDate,
  RAFiscalYearPeriod1.FiscalYearEndDate AS FiscalYearEndDate,
  RAFiscalYearPeriod1.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  RAFiscalYearPeriod1.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  coalesce(RAFiscalYearPeriod2.FiscalYear, '0000') AS PreviousFiscalYear
FROM P_RAFiscalYearPeriod AS RAFiscalYearPeriod1
;

Learn More