I_JVAFiscalYearPeriodForCoCode

DDL: I_JVAFISCALYEARPERIODFORCOCODE SQL: IJVFYPERDCOCD Type: view COMPOSITE Package: GJVA_UI_BACKEND
19 Fields 2 Data Sources

JVA Fiscal Year Period For Company Code

I_JVAFiscalYearPeriodForCoCode is a Composite CDS View that provides data about "JVA Fiscal Year Period For Company Code" in SAP S/4HANA. It reads from 2 data sources (I_FiscalYearPeriodForCmpnyCode, I_FiscalYearPeriodForCmpnyCode) and exposes 19 fields with key fields CompanyCode, CurrentFiscalYear, CurrentFiscalPeriod, PreviousFiscalYear, PreviousFiscalPeriod. Part of development package GJVA_UI_BACKEND.

Data Sources (2)

SourceAliasJoin Type
I_FiscalYearPeriodForCmpnyCode _CurrentYrPerd from
I_FiscalYearPeriodForCmpnyCode _PrevYearPerd inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJVFYPERDCOCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label JVA Fiscal Year Period For Company Code view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FiscalYearPeriodForCmpnyCode CompanyCode Receiver Company Code
KEY CurrentFiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear G/L Fiscal Year
KEY CurrentFiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod Tax period
KEY PreviousFiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear G/L Fiscal Year
KEY PreviousFiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod Tax period
FiscalYearVariant I_FiscalYearPeriodForCmpnyCode FiscalYearVariant FY Variant
FiscalPeriodStartDate I_FiscalYearPeriodForCmpnyCode FiscalPeriodStartDate
FiscalPeriodEndDate I_FiscalYearPeriodForCmpnyCode FiscalPeriodEndDate
IsSpecialPeriod I_FiscalYearPeriodForCmpnyCode IsSpecialPeriod
FiscalYearStartDate I_FiscalYearPeriodForCmpnyCode FiscalYearStartDate
FiscalYearEndDate I_FiscalYearPeriodForCmpnyCode FiscalYearEndDate
NextFiscalPeriod I_FiscalYearPeriodForCmpnyCode NextFiscalPeriod
NextFiscalPeriodFiscalYear I_FiscalYearPeriodForCmpnyCode NextFiscalPeriodFiscalYear
FiscalYearPeriod I_FiscalYearPeriodForCmpnyCode FiscalYearPeriod Period/Year
_CompanyCode I_FiscalYearPeriodForCmpnyCode _CompanyCode
_FiscalPeriodStartDate I_FiscalYearPeriodForCmpnyCode _FiscalPeriodStartDate
_FiscalYear I_FiscalYearPeriodForCmpnyCode _FiscalYear
_FiscalYearVariant I_FiscalYearPeriodForCmpnyCode _FiscalYearVariant
_Text I_FiscalYearPeriodForCmpnyCode _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_JVAFiscalYearPeriodForCoCode.
-- 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: IJVFYPERDCOCD

CREATE VIEW I_JVAFiscalYearPeriodForCoCode AS
SELECT
  _CurrentYrPerd.CompanyCode AS CompanyCode,
  _CurrentYrPerd.FiscalYear AS CurrentFiscalYear,
  _CurrentYrPerd.FiscalPeriod AS CurrentFiscalPeriod,
  _PrevYearPerd.FiscalYear AS PreviousFiscalYear,
  _PrevYearPerd.FiscalPeriod AS PreviousFiscalPeriod,
  _CurrentYrPerd.FiscalYearVariant AS FiscalYearVariant,
  _CurrentYrPerd.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  _CurrentYrPerd.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  _CurrentYrPerd.IsSpecialPeriod AS IsSpecialPeriod,
  _CurrentYrPerd.FiscalYearStartDate AS FiscalYearStartDate,
  _CurrentYrPerd.FiscalYearEndDate AS FiscalYearEndDate,
  _CurrentYrPerd.NextFiscalPeriod AS NextFiscalPeriod,
  _CurrentYrPerd.NextFiscalPeriodFiscalYear AS NextFiscalPeriodFiscalYear,
  _CurrentYrPerd.FiscalYearPeriod AS FiscalYearPeriod,
  _CurrentYrPerd._CompanyCode AS _CompanyCode,
  _CurrentYrPerd._FiscalPeriodStartDate AS _FiscalPeriodStartDate,
  _CurrentYrPerd._FiscalYear AS _FiscalYear,
  _CurrentYrPerd._FiscalYearVariant AS _FiscalYearVariant,
  _CurrentYrPerd._Text AS _Text
FROM I_FiscalYearPeriodForCmpnyCode AS _CurrentYrPerd
INNER JOIN I_FiscalYearPeriodForCmpnyCode AS _PrevYearPerd ON /* join condition not captured in parsed metadata */
;

Learn More