P_FiscalDateFunctionValueFY

DDL: P_FISCALDATEFUNCTIONVALUEFY SQL: PFIDATEFUNCVALFY Type: view COMPOSITE
10 Fields 3 Data Sources

P_FiscalDateFunctionValueFY is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_FiscalCalendarDate, I_FiscalDateFunctionValue, I_FiscalCalendarDate) and exposes 10 fields with key fields DateFunction, FiscalYearVariant, DateFunctionValidityDate.

Data Sources (3)

SourceAliasJoin Type
I_FiscalCalendarDate EndYear inner
I_FiscalDateFunctionValue I_FiscalDateFunctionValue from
I_FiscalCalendarDate StartYear inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFIDATEFUNCVALFY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DateFunction DateFunction Relative Date Function
KEY FiscalYearVariant I_FiscalDateFunctionValue FiscalYearVariant FY Variant
KEY DateFunctionValidityDate DateFunctionValidityDate Validity Date
DateFunctionStartDate DateFunctionStartDate Date Func Start Date
DateFunctionEndDate DateFunctionEndDate Date Func End Date
FiscalYear I_FiscalCalendarDate FiscalYear G/L Fiscal Year
FiscalYearStartDate I_FiscalCalendarDate FiscalYearStartDate Start Date
StartFiscalYear I_FiscalCalendarDate FiscalYear G/L Fiscal Year
EndFiscalYear I_FiscalCalendarDate FiscalYear G/L Fiscal Year
_DateFunction _DateFunction

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_FiscalDateFunctionValueFY.
-- 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: PFIDATEFUNCVALFY

CREATE VIEW P_FiscalDateFunctionValueFY AS
SELECT
  DateFunction,
  I_FiscalDateFunctionValue.FiscalYearVariant AS FiscalYearVariant,
  DateFunctionValidityDate,
  DateFunctionStartDate,
  DateFunctionEndDate,
  StartYear.FiscalYear AS FiscalYear,
  StartYear.FiscalYearStartDate AS FiscalYearStartDate,
  StartYear.FiscalYear AS StartFiscalYear,
  EndYear.FiscalYear AS EndFiscalYear
FROM I_FiscalDateFunctionValue
INNER JOIN I_FiscalCalendarDate AS StartYear ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalendarDate AS EndYear ON /* join condition not captured in parsed metadata */
;

Learn More