I_FiscalYearWeek

DDL: I_FISCALYEARWEEK Type: view_entity BASIC
16 Fields 1 Data Sources 1 Associations

Fiscal Year Week with Next Fiscal Year Week

I_FiscalYearWeek (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_FiscalYearWeek is a Basic CDS View (Dimension) that provides data about "Fiscal Year Week with Next Fiscal Year Week" in SAP S/4HANA. It reads from 1 data source (P_FiscalYearWeek) and exposes 16 fields with key fields FiscalYearVariant, FiscalYear, FiscalYearWeek. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCA-GTF-GL-CAL
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the relevant fiscal calendar details of a fiscal year and a fiscal weekin a fiscal year variant. These attributes of business entities include the start and end date of the fiscal year and the fiscal period but also the next fiscal week together with the corresponding fiscal year.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul><li><p>What are the fiscal time frames of a fiscal year and a fiscal week?</p></li> <li><p>What is the next fiscal week of a combination of fiscal year and fiscal week?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_FiscalYearWeek P_FiscalYearWeek from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FiscalYear _FiscalYear $projection.FiscalYearVariant = _FiscalYear.FiscalYearVariant and $projection.FiscalYear = _FiscalYear.FiscalYear

Annotations (12)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Fiscal Year Week with Next Fiscal Year Week view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey FiscalYearWeek view
Analytics.technicalName IFIFYEARWEEK view
Analytics.dataCategory #DIMENSION view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearVariant P_FiscalYearWeek FiscalYearVariant Fiscal Year Variant
KEY FiscalYear P_FiscalYearWeek FiscalYear G/L Fiscal Year
KEY FiscalYearWeek P_FiscalYearWeek FiscalYearWeek Fiscal Year + Fiscal Week
FiscalYearStartDate P_FiscalYearWeek FiscalYearStartDate Start Date of Fiscal Year
FiscalYearEndDate P_FiscalYearWeek FiscalYearEndDate End Date of Fiscal Year
FiscalWeek P_FiscalYearWeek FiscalWeek Fiscal Week
FiscalWeekStartDate P_FiscalYearWeek FiscalWeekStartDate Start Date of Fiscal Week
FiscalWeekEndDate P_FiscalYearWeek FiscalWeekEndDate End Date of Fiscal Week
FiscalWeekConsecutiveNumber P_FiscalYearWeek FiscalWeekConsecutiveNumber Fiscal Year Week (Numbering)
NextFiscalYearWeek P_FiscalYearWeek NextFiscalYearWeek
NextFiscalWeek P_FiscalYearWeek NextFiscalWeek
NextFiscalWeekStartDate P_FiscalYearWeek NextFiscalWeekStartDate
NextFiscalWeekEndDate P_FiscalYearWeek NextFiscalWeekEndDate
NextFsclWeekConsecutiveNmbr P_FiscalYearWeek NextFsclWeekConsecutiveNmbr
_FiscalYearVariant P_FiscalYearWeek _FiscalYearVariant
_FiscalYear _FiscalYear

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_FiscalYearWeek.
-- 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_FiscalYearWeek AS
SELECT
  P_FiscalYearWeek.FiscalYearVariant AS FiscalYearVariant,
  P_FiscalYearWeek.FiscalYear AS FiscalYear,
  P_FiscalYearWeek.FiscalYearWeek AS FiscalYearWeek,
  P_FiscalYearWeek.FiscalYearStartDate AS FiscalYearStartDate,
  P_FiscalYearWeek.FiscalYearEndDate AS FiscalYearEndDate,
  P_FiscalYearWeek.FiscalWeek AS FiscalWeek,
  P_FiscalYearWeek.FiscalWeekStartDate AS FiscalWeekStartDate,
  P_FiscalYearWeek.FiscalWeekEndDate AS FiscalWeekEndDate,
  P_FiscalYearWeek.FiscalWeekConsecutiveNumber AS FiscalWeekConsecutiveNumber,
  P_FiscalYearWeek.NextFiscalYearWeek AS NextFiscalYearWeek,
  P_FiscalYearWeek.NextFiscalWeek AS NextFiscalWeek,
  P_FiscalYearWeek.NextFiscalWeekStartDate AS NextFiscalWeekStartDate,
  P_FiscalYearWeek.NextFiscalWeekEndDate AS NextFiscalWeekEndDate,
  P_FiscalYearWeek.NextFsclWeekConsecutiveNmbr AS NextFsclWeekConsecutiveNmbr,
  P_FiscalYearWeek._FiscalYearVariant AS _FiscalYearVariant
FROM P_FiscalYearWeek
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND FiscalYear = _FiscalYear.FiscalYear  -- association [0..1]
;

Learn More