I_FiscalPeriodRawData

DDL: I_FISCALPERIODRAWDATA Type: view_entity BASIC
7 Fields 1 Data Sources 1 Associations

Fiscal Periods Raw Data

I_FiscalPeriodRawData is a Basic CDS View that provides data about "Fiscal Periods Raw Data" in SAP S/4HANA. It reads from 1 data source (t009b) and exposes 7 fields with key fields FiscalYearVariant, FiscalPeriodEndYear, FiscalPeriodEndMonth, FiscalPeriodEndDay. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t009b t009b from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FiscalYearVariant _FiscalYearVariant $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant

Annotations (13)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
EndUserText.label Fiscal Periods Raw Data view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.technicalName IFYPERRAWDATA view
ObjectModel.modelingPattern #NONE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearVariant
KEY FiscalPeriodEndYear t009b bdatj Year
KEY FiscalPeriodEndMonth t009b bumon Calendar month
KEY FiscalPeriodEndDay t009b butag Calendar day
FiscalPeriod t009b poper Posting periods
FiscalYearShift t009b reljr Year shift
_FiscalYearVariant _FiscalYearVariant

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_FiscalPeriodRawData.
-- 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_FiscalPeriodRawData AS
SELECT
  cast( t009b.periv as fis_periv preserving type ) AS FiscalYearVariant,
  t009b.bdatj AS FiscalPeriodEndYear,
  t009b.bumon AS FiscalPeriodEndMonth,
  t009b.butag AS FiscalPeriodEndDay,
  t009b.poper AS FiscalPeriod,
  t009b.reljr AS FiscalYearShift
FROM t009b
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
;

Learn More