I_JVAFiscalYearPeriodForCoCode

DDL: I_JVAFISCALYEARPERIODFORCOCODE SQL: IJVFYPERDCOCD Type: view COMPOSITE Package: GJVA_UI_BACKEND

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.

2 data source(s) 19 fields

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
KEY CurrentFiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear
KEY CurrentFiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod
KEY PreviousFiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear
KEY PreviousFiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod
FiscalYearVariant I_FiscalYearPeriodForCmpnyCode FiscalYearVariant
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
_CompanyCode I_FiscalYearPeriodForCmpnyCode _CompanyCode
_FiscalPeriodStartDate I_FiscalYearPeriodForCmpnyCode _FiscalPeriodStartDate
_FiscalYear I_FiscalYearPeriodForCmpnyCode _FiscalYear
_FiscalYearVariant I_FiscalYearPeriodForCmpnyCode _FiscalYearVariant
_Text I_FiscalYearPeriodForCmpnyCode _Text 
@AbapCatalog.sqlViewName: 'IJVFYPERDCOCD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'JVA Fiscal Year Period For Company Code'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
   }
define view I_JVAFiscalYearPeriodForCoCode
  as select from I_FiscalYearPeriodForCmpnyCode as _CurrentYrPerd
    inner join   I_FiscalYearPeriodForCmpnyCode as _PrevYearPerd on _PrevYearPerd.CompanyCode     =       _CurrentYrPerd.CompanyCode
                                                                 and(
                                                                   _PrevYearPerd.FiscalYear       <=      _CurrentYrPerd.FiscalYear
                                                                   and _PrevYearPerd.FiscalPeriod between '001' and '012'
                                                                 )
{

  key    _CurrentYrPerd.CompanyCode,
         @EndUserText: { label: 'Current Fiscal Year', quickInfo: 'Current Fiscal Year' }
  key    _CurrentYrPerd.FiscalYear   as CurrentFiscalYear,
         @EndUserText: { label: 'Current Fiscal Period',quickInfo: 'Current Fiscal Period' }
  key    _CurrentYrPerd.FiscalPeriod as CurrentFiscalPeriod,
         @EndUserText: { label: 'Previous Fiscal Year', quickInfo: 'Previous Fiscal year' }
  key    _PrevYearPerd.FiscalYear    as PreviousFiscalYear,
         @EndUserText: { label: 'Previous Fiscal Period', quickInfo: 'Previous Fiscal Period' }
  key    _PrevYearPerd.FiscalPeriod  as PreviousFiscalPeriod,
         _CurrentYrPerd.FiscalYearVariant,
         _CurrentYrPerd.FiscalPeriodStartDate,
         _CurrentYrPerd.FiscalPeriodEndDate,
         _CurrentYrPerd.IsSpecialPeriod,
         _CurrentYrPerd.FiscalYearStartDate,
         _CurrentYrPerd.FiscalYearEndDate,
         _CurrentYrPerd.NextFiscalPeriod,
         _CurrentYrPerd.NextFiscalPeriodFiscalYear,
         _CurrentYrPerd.FiscalYearPeriod,

         _CurrentYrPerd._CompanyCode,
         _CurrentYrPerd._FiscalPeriodStartDate,
         _CurrentYrPerd._FiscalYear,
         _CurrentYrPerd._FiscalYearVariant,
         _CurrentYrPerd._Text

}

Learn More