I_TimeZoneIANACodeMap

DDL: I_TIMEZONEIANACODEMAP Type: view_entity BASIC

Time Zone Code According to IANA Time Zone Database

I_TimeZoneIANACodeMap is a Basic CDS View (Dimension) that provides data about "Time Zone Code According to IANA Time Zone Database" in SAP S/4HANA. It reads from 1 data source (tzonemap) and exposes 5 fields with key field TimeZoneIANACode. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
tzonemap tzonemap from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TimeZone _TimeZone $projection.TimeZoneID = _TimeZone.TimeZoneID

Annotations (13)

NameValueLevelField
EndUserText.label Time Zone Code According to IANA Time Zone Database view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name TimeZoneIANACode view
ObjectModel.representativeKey TimeZoneIANACode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TimeZoneIANACode ianatzone
TimeZoneID tzone
_TimeZone _TimeZone
IANACodeIsCustDefinedDefault flagdefault
IANACodeIsSAPDefinedDefault flagsapdefault 
@EndUserText.label: 'Time Zone Code According to IANA Time Zone Database'
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}  
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction.enabled: true
}
@ObjectModel: {
  sapObjectNodeType.name: 'TimeZoneIANACode',
  representativeKey:      'TimeZoneIANACode',
  usageType: {
    dataClass:      #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory:   #S
  },
  supportedCapabilities:  [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, 
                            #SQL_DATA_SOURCE, #ANALYTICAL_DIMENSION ],
  modelingPattern: #ANALYTICAL_DIMENSION
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_TimeZoneIANACodeMap
  as select from tzonemap

  association [0..1] to I_TimeZone as _TimeZone on $projection.TimeZoneID = _TimeZone.TimeZoneID

{
      @Semantics.timeZone: true 
  key ianatzone      as TimeZoneIANACode,
      @ObjectModel.foreignKey.association: '_TimeZone'
      tzone          as TimeZoneID,
                        _TimeZone,
      @Semantics.booleanIndicator: true
      flagdefault    as IANACodeIsCustDefinedDefault,
      @Semantics.booleanIndicator: true
      flagsapdefault as IANACodeIsSAPDefinedDefault
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TZONEMAP"
],
"ASSOCIATED":
[
"I_TIMEZONE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More