I_FiscalPeriodRawData

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

Fiscal Periods Raw Data

I_FiscalPeriodRawData (Basic)

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

Accounting and Financial Close

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. 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
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

Documentation

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 Fiscal Year Variant
KEY FiscalPeriodEndYear t009b bdatj Posting Date YYYY
KEY FiscalPeriodEndMonth t009b bumon Posting date calendar month
KEY FiscalPeriodEndDay t009b butag Calendar day from the posting date
FiscalPeriod t009b poper Posting periods
FiscalYearShift t009b reljr Year shift relative to the current year
_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