I_FiscalYearVariantText

DDL: I_FISCALYEARVARIANTTEXT Type: view_entity BASIC
4 Fields 1 Data Sources 1 Associations

Fiscal Year Variant Text

I_FiscalYearVariantText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_FiscalYearVariantText is a Basic CDS View that provides data about "Fiscal Year Variant Text" in SAP S/4HANA. It reads from 1 data source (t009t) and exposes 4 fields with key fields Language, FiscalYearVariant. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentBC-SRV-ASF-FYV
CapabilitiesLanguage-Dependent Text, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction, Data Source for Search
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t009t t009t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (15)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
Analytics.technicalName IFIFYEARVARTXT view
EndUserText.label Fiscal Year Variant Text view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.representativeKey FiscalYearVariant view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language t009t spras Off. Language
KEY FiscalYearVariant Fiscal Year Variant
FiscalYearVariantDescription Description of Fiscal Year Variant
_Language _Language

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_FiscalYearVariantText.
-- 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 I_FiscalYearVariantText AS
SELECT
  t009t.spras AS Language,
  cast( t009t.periv as fis_periv preserving type ) AS FiscalYearVariant,
  cast(t009t.ltext as fis_periv_desc preserving type ) AS FiscalYearVariantDescription
FROM t009t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More