I_FiscCalendarDateForCompCode

DDL: I_FISCCALENDARDATEFORCOMPCODE SQL: IFIFCCLNDARDTCC Type: view BASIC
26 Fields 2 Data Sources 2 Associations

Fiscal Calendar Date For Company Code

I_FiscCalendarDateForCompCode (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_FiscCalendarDateForCompCode is a Basic CDS View (Dimension) that provides data about "Fiscal Calendar Date For Company Code" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_FiscalCalendarDate) and exposes 26 fields with key fields CalendarDate, CompanyCode. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to all fiscal calendar details of a calendar date in a fiscal year variant defined by company code. The most important attributes of business entities are included, such as fiscal year, fiscal quarter, fiscal period, fiscal week with the corresponding start and end date.</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 calendar date?</p></li> </ul>

Documentation

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_FiscalCalendarDate I_FiscalCalendarDate from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..*] I_FiscalYearPeriodText _Text $projection.FiscalYearVariant = _Text.FiscalYearVariant and $projection.FiscalYear = _Text.FiscalYear and $projection.FiscalPeriod = _Text.FiscalPeriod

Annotations (15)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IFIFCCLNDARDTCC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Fiscal Calendar Date For Company Code view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey CalendarDate view
Analytics.dataCategory #DIMENSION view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate I_FiscalCalendarDate CalendarDate Calendar Date
KEY CompanyCode Company Code
FiscalYearVariant I_FiscalCalendarDate FiscalYearVariant Fiscal Year Variant
FiscalYear FiscalYear G/L Fiscal Year
FiscalYearStartDate FiscalYearStartDate Start Date of Fiscal Year
FiscalYearEndDate FiscalYearEndDate End Date of Fiscal Year
FiscalPeriod FiscalPeriod Fiscal Period
FiscalPeriodStartDate FiscalPeriodStartDate Start Date of Fiscal Period
FiscalPeriodEndDate FiscalPeriodEndDate End Date of Fiscal Period
FiscalQuarter FiscalQuarter Fiscal Quarter
FiscalQuarterStartDate FiscalQuarterStartDate Start Date of Fiscal Quarter
FiscalQuarterEndDate FiscalQuarterEndDate End Date of Fiscal Quarter
FiscalWeek FiscalWeek Fiscal Week
FiscalWeekStartDate FiscalWeekStartDate Start Date of Fiscal Week
FiscalWeekEndDate FiscalWeekEndDate End Date of Fiscal Week
FiscalYearPeriod FiscalYearPeriod Fiscal Year + Fiscal Period
FiscalYearQuarter FiscalYearQuarter Fiscal Year + Fiscal Quarter
FiscalYearWeek FiscalYearWeek Fiscal Year + Fiscal Week
FiscalYearConsecutiveNumber FiscalYearConsecutiveNumber Fiscal Year (Integer)
FiscalPeriodConsecutiveNumber FiscalPeriodConsecutiveNumber Fiscal Year Period (Numbering)
FiscalQuarterConsecutiveNumber FiscalQuarterConsecutiveNumber Fiscal Year Quarter (Numbering)
FiscalWeekConsecutiveNumber FiscalWeekConsecutiveNumber Fiscal Year Week (Numbering)
_FiscalYearVariant I_FiscalCalendarDate _FiscalYearVariant
_CompanyCode _CompanyCode
_CalendarDate _CalendarDate
_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_FiscCalendarDateForCompCode.
-- 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: IFIFCCLNDARDTCC

CREATE VIEW I_FiscCalendarDateForCompCode AS
SELECT
  I_FiscalCalendarDate.CalendarDate AS CalendarDate,
  cast( I_CompanyCode.CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  I_FiscalCalendarDate.FiscalYearVariant AS FiscalYearVariant,
  FiscalYear,
  FiscalYearStartDate,
  FiscalYearEndDate,
  FiscalPeriod,
  FiscalPeriodStartDate,
  FiscalPeriodEndDate,
  FiscalQuarter,
  FiscalQuarterStartDate,
  FiscalQuarterEndDate,
  FiscalWeek,
  FiscalWeekStartDate,
  FiscalWeekEndDate,
  FiscalYearPeriod,
  FiscalYearQuarter,
  FiscalYearWeek,
  FiscalYearConsecutiveNumber,
  FiscalPeriodConsecutiveNumber,
  FiscalQuarterConsecutiveNumber,
  FiscalWeekConsecutiveNumber,
  I_FiscalCalendarDate._FiscalYearVariant AS _FiscalYearVariant
FROM I_FiscalCalendarDate
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodText AS _Text ON FiscalYearVariant = _Text.FiscalYearVariant AND FiscalYear = _Text.FiscalYear AND FiscalPeriod = _Text.FiscalPeriod  -- association [0..*]
;

Learn More