F_FsclPerdDteFuncSglVal

DDL: F_FSCLPERDDTEFUNCSGLVAL Type: view DERIVATION_FUNCTION

Fiscal Period Single Date Functions

F_FsclPerdDteFuncSglVal is a CDS View that provides data about "Fiscal Period Single Date Functions" in SAP S/4HANA. It reads from 1 data source (I_FiscalDateFunctionValue) and exposes 1 field.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_FiscalDateFunctionValue I_FiscalDateFunctionValue from

Parameters (2)

NameTypeDefault
P_DateFunction datefunctionid
P_FiscalYearVariant fis_periv

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName FFPDFSGLVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey DateFunction view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #DERIVATION_FUNCTION view
ObjectModel.derivationFunction.result.type #SINGLE view
ObjectModel.derivationFunction.result.multipleRecords false view
ObjectModel.derivationFunction.result.element FiscalPeriod view
VDM.viewType #DERIVATION_FUNCTION view
EndUserText.label Fiscal Period Single Date Functions view

Fields (1)

KeyFieldSource TableSource FieldDescription
_FiscalYearVariant 
@AbapCatalog:{
  sqlViewName: 'FFPDFSGLVAL',
  compiler.compareFilter: true,
  preserveKey:true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions:false
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'DateFunction'
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
@ObjectModel: {
  supportedCapabilities: [#DERIVATION_FUNCTION],
  modelingPattern: #DERIVATION_FUNCTION
  }
@ObjectModel.derivationFunction: {
  applicableFor.element: ['FiscalPeriod'],
  result: {
    type: #SINGLE,
    multipleRecords: false,
    element: 'FiscalPeriod'
  }
}
@VDM.viewType: #DERIVATION_FUNCTION
@EndUserText.label: 'Fiscal Period Single Date Functions'
define view F_FsclPerdDteFuncSglVal
  with parameters
    @Consumption.valueHelpDefinition: [{
      entity: {
        name: 'I_FiscalPeriodDateFuncSingleVH',
        element: 'DateFunction'
        }
    }]
    P_DateFunction      : datefunctionid,
    @Consumption.valueHelpDefinition: [{
      entity: {
        name: 'I_FiscalYearVariant',
        element: 'FiscalYearVariant'
        }
    }]
    P_FiscalYearVariant : fis_periv

  as select from I_FiscalDateFunctionValue

{

  key I_FiscalDateFunctionValue.DateFunction,
      @ObjectModel.foreignKey.association: '_FiscalYearVariant'
  key I_FiscalDateFunctionValue.FiscalYearVariant,
      I_FiscalDateFunctionValue.FiscalPeriodSingle as FiscalPeriod,

      I_FiscalDateFunctionValue._FiscalYearVariant
}

where
      I_FiscalDateFunctionValue.DateFunction             = $parameters.P_DateFunction
  and I_FiscalDateFunctionValue.FiscalYearVariant        = $parameters.P_FiscalYearVariant
  and I_FiscalDateFunctionValue.DateFunctionValidityDate = $session.system_date
  and I_FiscalDateFunctionValue.FiscalYearPeriodSingle   is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FISCALDATEFUNCTIONVALUE"
],
"ASSOCIATED":
[
"I_FISCALYEARVARIANT"
],
"BASE":
[
"I_FISCALDATEFUNCTIONVALUE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More