I_TimeZoneRuleText

DDL: I_TIMEZONERULETEXT SQL: ITIMEZONERULETXT Type: view BASIC Package: SZTZ
5 Fields 1 Data Sources 2 Associations 1 OData Services

Time Zone Rule Text

I_TimeZoneRuleText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_TimeZoneRuleText is a Basic CDS View that provides data about "Time Zone Rule Text" in SAP S/4HANA. It reads from 1 data source (ttzrt) and exposes 5 fields with key fields TimeZoneRule, Language. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F4557). Part of development package SZTZ.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentBC-SRV-TIM-TZ
CapabilitiesData Source for Data Extraction
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
ttzrt ttzrt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TimeZoneRule _TimeZoneRule $projection.TimeZoneRule = _TimeZoneRule.TimeZoneRule
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ITIMEZONERULETXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
EndUserText.label Time Zone Rule Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TimeZoneRule view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4557 ASQL_F4557 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TimeZoneRule ttzrt zonerule Time Zone Rule
KEY Language ttzrt language Report Text Language
TimeZoneRuleText ttzrt descript Name of Time Zone Rule (Difference from UTC)
_TimeZoneRule _TimeZoneRule
_Language _Language

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TimeZoneRuleText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ITIMEZONERULETXT

CREATE VIEW I_TimeZoneRuleText AS
SELECT
  ttzrt.zonerule AS TimeZoneRule,
  ttzrt.language AS Language,
  ttzrt.descript AS TimeZoneRuleText
FROM ttzrt
LEFT OUTER JOIN I_TimeZoneRule AS _TimeZoneRule ON TimeZoneRule = _TimeZoneRule.TimeZoneRule  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More