I_FiscalYearVariant

DDL: I_FISCALYEARVARIANT Type: view_entity BASIC Package: SFBX
8 Fields 1 Data Sources 15 OData Services

Fiscal Year Variant

I_FiscalYearVariant (Basic)

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

FiscalYearVariant · Accounting and Financial Close

I_FiscalYearVariant is a Basic CDS View (Dimension) that provides data about "Fiscal Year Variant" in SAP S/4HANA. It reads from 1 data source (t009) and exposes 8 fields with key field FiscalYearVariant. It is exposed through 15 OData services (ASQL_F2331, ASQL_F2564, ASQL_F3098, ...). Part of development package SFBX.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentBC-SRV-ASF-FYV
CapabilitiesData Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the details of a fiscal year variant. These attributes of business entities include the indicators that the fiscal periods match the calendar months or that the assignment of fiscal periods to calendar days is defined for each individual year. Additional information is the number of posting periods and the number of special periods per fiscal year.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul><li><p>Does the fiscal year variant define a fiscal year in the same way as a calendar year?</p></li> <li><p>Is the fiscal year always maintained in the same way for this fiscal year variant?</p></li> <li><p>How many posting periods and how many special posting periods are maintained per fiscal year?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
t009 t009 from

Annotations (17)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.technicalName IFIFISCYEARVAR view
EndUserText.label Fiscal Year Variant view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey FiscalYearVariant view
ObjectModel.sapObjectNodeType.name FiscalYearVariant view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view

OData Services (15)

ServiceBindingVersionContractRelease
ASQL_F2331 ASQL_F2331 C2 NOT_RELEASED
ASQL_F2564 ASQL_F2564 C2 NOT_RELEASED
ASQL_F3098 ASQL_F3098 C2 NOT_RELEASED
ASQL_F3940 ASQL_F3940 C2 NOT_RELEASED
ASQL_F4173A ASQL_F4173A C2 NOT_RELEASED
ASQL_F4174 ASQL_F4174 C2 NOT_RELEASED
ASQL_F4182 ASQL_F4182 C2 NOT_RELEASED
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F4765 ASQL_F4765 C2 NOT_RELEASED
ASQL_F6951 ASQL_F6951 C2 NOT_RELEASED
ASQL_F7308 ASQL_F7308 C2 NOT_RELEASED
ASQL_F7321 ASQL_F7321 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED
ASQL_F7335 ASQL_F7335 C2 NOT_RELEASED
ASQL_F8654 ASQL_F8654 C2 NOT_RELEASED

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearVariant Fiscal Year Variant
FiscalPeriodIsEqualMonth Indicator: Fiscal Period Is Equal Calendar Month
IsYearDependent t009 xjabh Indicator: Fiscal year variants year-dependent ?
PostingPeriodsNumberVal t009 anzbp Number of Posting Periods
NumberOfSpecialPeriods t009 anzsp Number of Special Periods
FsclWeekStartIsFsclYearStart t009 xweek Flag: Fiscal Weeks Calculated from Start of Fiscal Year
FiscalCalendarIsWeekBased t009 xweekquart Flag: Fiscal Year Variant as Week Calendar
_Text _Text

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_FiscalYearVariant.
-- 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_FiscalYearVariant AS
SELECT
  cast( t009.periv as fis_periv preserving type ) AS FiscalYearVariant,
  cast( t009.xkale as fis_xkale preserving type ) AS FiscalPeriodIsEqualMonth,
  t009.xjabh AS IsYearDependent,
  t009.anzbp AS PostingPeriodsNumberVal,
  t009.anzsp AS NumberOfSpecialPeriods,
  t009.xweek AS FsclWeekStartIsFsclYearStart,
  t009.xweekquart AS FiscalCalendarIsWeekBased
FROM t009
;

Learn More