FINCS_FISCAL_YEAR_PEROID

DDL: FINCS_FISCAL_YEAR_PEROID SQL: FINCSFSCLYP Type: view
2 Fields 1 Data Sources

FINCS Fiscal year peroid

FINCS_FISCAL_YEAR_PEROID is a CDS View that provides data about "FINCS Fiscal year peroid" in SAP S/4HANA. It reads from 1 data source (finsc_fisc_date) and exposes 2 fields with key field FiscalYearPeriod.

Data Sources (1)

SourceAliasJoin Type
finsc_fisc_date finsc_fisc_date from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FINCSFSCLYP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label FINCS Fiscal year peroid view
Search.searchable true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearPeriod
fiscal_year finsc_fisc_date fiscal_year Tax Item Fiscal Year

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 FINCS_FISCAL_YEAR_PEROID.
-- 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: FINCSFSCLYP

CREATE VIEW FINCS_FISCAL_YEAR_PEROID AS
SELECT
  cast( finsc_fisc_date.fiscal_year_period as fincs_fiscalyearper) AS FiscalYearPeriod,
  finsc_fisc_date.fiscal_year AS fiscal_year
FROM finsc_fisc_date
;

Learn More