Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_TranspOrdEventIsDelayedText

DDL: I_TRANSPORDEVENTISDELAYEDTEXT Type: view BASIC Package: VDM_TM_BASIC

TranspOrd Event is Dlyd Indicator - Text

I_TranspOrdEventIsDelayedText (Basic)

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

Supply Chain

I_TranspOrdEventIsDelayedText is a Basic CDS View that provides data about "TranspOrd Event is Dlyd Indicator - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields TranspOrdEventIsDelayed, Language. It has 2 associations to related views. Part of development package VDM_TM_BASIC.

SAP API Hub

CategoryBasic
StateDeprecated
Line of BusinessSupply Chain
Application ComponentTM-2CL
CapabilitiesData Source for Data Extraction,Language-Dependent Text,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageSupply Chain for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which shift definitions are maintained for a shift grouping?</p></li> <li><p>What are the start and end dates of the shifts?</p></li> <li><p>What is the work break schedule of a shift definition?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TranspOrdEventIsDelayed _TranspOrdEventIsDelayed $projection.TranspOrdEventIsDelayed = _TranspOrdEventIsDelayed.TranspOrdEventIsDelayed
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (17)

NameValueLevelField
EndUserText.label TranspOrd Event is Dlyd Indicator - Text view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey TranspOrdEventIsDelayed view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IISTOREVTDLYDT view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.status #DEPRECATED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdEventIsDelayed Transportation Order Event is Delayed
KEY Language ddlanguage Language Key
TranspOrdEventIsDelayedDesc ddtext Short Text for Fixed Values
_TranspOrdEventIsDelayed _TranspOrdEventIsDelayed
_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_TranspOrdEventIsDelayedText.
-- 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.

CREATE VIEW I_TranspOrdEventIsDelayedText AS
SELECT
  cast(substring(domvalue_l, 1, 1) as /scmtms/vdm_delayed_event preserving type) AS TranspOrdEventIsDelayed,
  ddlanguage AS Language,
  ddtext AS TranspOrdEventIsDelayedDesc
FROM dd07t
LEFT OUTER JOIN I_TranspOrdEventIsDelayed AS _TranspOrdEventIsDelayed ON TranspOrdEventIsDelayed = _TranspOrdEventIsDelayed.TranspOrdEventIsDelayed  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;