I_LastDayOfFsclDteFunctionVH

DDL: I_LASTDAYOFFSCLDTEFUNCTIONVH Type: view BASIC

Last day of fiscal date function

I_LastDayOfFsclDteFunctionVH is a Basic CDS View that provides data about "Last day of fiscal date function" in SAP S/4HANA. It reads from 2 data sources (P_LastDayOfFsclDteFunction, I_FiscalYearPeriodForCmpnyCode) and exposes 7 fields with key fields DateFunction, CompanyCode.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
P_LastDayOfFsclDteFunction DateFunction inner
I_FiscalYearPeriodForCmpnyCode FiscalYearPeriodForCmpnyCode from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ILSTDAYFSCDTEFNC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Last day of fiscal date function view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey DateFunction view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
UI.textArrangement #TEXT_LAST view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY DateFunction DateFunction
KEY CompanyCode I_FiscalYearPeriodForCmpnyCode CompanyCode
FiscalYearVariant P_LastDayOfFsclDteFunction FiscalYearVariant
DateFunctionDescription DateFunctionDescription
DateFunctionStartDate I_FiscalYearPeriodForCmpnyCode FiscalPeriodStartDate
DateFunctionEndDate DateFunctionEndDate
_FiscalPeriodStartDate _FiscalPeriodStartDate 
@AbapCatalog: {
    sqlViewName: 'ILSTDAYFSCDTEFNC',
    compiler.compareFilter: true,
    preserveKey: true
}
@EndUserText.label: 'Last day of fiscal date function'
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ObjectModel: {
    usageType: {
        dataClass: #CUSTOMIZING,
        serviceQuality:  #C,
        sizeCategory:  #S
    },
    dataCategory: #VALUE_HELP,
    representativeKey: 'DateFunction'
}
@ClientHandling: {
    algorithm: #SESSION_VARIABLE
}
@VDM.viewType: #BASIC
@UI.textArrangement: #TEXT_LAST
define view I_LastDayOfFsclDteFunctionVH
  as select from I_FiscalYearPeriodForCmpnyCode as FiscalYearPeriodForCmpnyCode
    inner join   P_LastDayOfFsclDteFunction     as DateFunction on  DateFunction.FiscalYearVariant               = FiscalYearPeriodForCmpnyCode.FiscalYearVariant
                                                                and DateFunction.DateFunctionEndDate             = FiscalYearPeriodForCmpnyCode.FiscalPeriodEndDate
                                                                and FiscalYearPeriodForCmpnyCode.IsSpecialPeriod = ''
{
  key DateFunction,
  key FiscalYearPeriodForCmpnyCode.CompanyCode,

      @UI.hidden: true
      DateFunction.FiscalYearVariant,
      DateFunctionDescription,
      FiscalYearPeriodForCmpnyCode.FiscalPeriodStartDate as DateFunctionStartDate,
      DateFunctionEndDate,

      _FiscalPeriodStartDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FISCALYEARPERIODFORCMPNYCODE",
"P_LASTDAYOFFSCLDTEFUNCTION"
],
"ASSOCIATED":
[
"I_CALENDARDATE"
],
"BASE":
[
"I_FISCALYEARPERIODFORCMPNYCODE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More