I_FiscalTimeUnitValueHelp

DDL: I_FISCALTIMEUNITVALUEHELP SQL: IFIFTUVH Type: view COMPOSITE Package: FINS_PERIOD_VDM

Fiscal Time Unit

I_FiscalTimeUnitValueHelp is a Composite CDS View that provides data about "Fiscal Time Unit" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 2 fields with key field FiscalTimeUnit. Part of development package FINS_PERIOD_VDM.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIFTUVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey FiscalTimeUnit view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
EndUserText.label Fiscal Time Unit view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY FiscalTimeUnit
FiscalTimeUnitName ddtext
@AbapCatalog.sqlViewName: 'IFIFTUVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@VDM.viewType: #COMPOSITE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'FiscalTimeUnit'

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE, #VALUE_HELP_PROVIDER]
@ObjectModel.modelingPattern: #VALUE_HELP_PROVIDER

@EndUserText.label: 'Fiscal Time Unit'
define view I_FiscalTimeUnitValueHelp
  as select from dd07t
{
      @ObjectModel.text.element: ['FiscalTimeUnitName']
      key cast( domvalue_l as fins_fscl_tperiod_offset_unit ) as FiscalTimeUnit,
      
      @Semantics.text: true
      ddtext as FiscalTimeUnitName      
}
where 
    domname = 'FINS_FSCL_TPERIOD_OFFSET_UNIT' 
and as4local = 'A'
and ddlanguage = $session.system_language