I_EWM_DeliveryDateAndTime

DDL: I_EWM_DELIVERYDATEANDTIME SQL: IEWMDLVDATETIME Type: view BASIC Package: VDM_EWM_DLV
12 Fields 1 Data Sources

EWM Delivery related Dates and Times

I_EWM_DeliveryDateAndTime is a Basic CDS View that provides data about "EWM Delivery related Dates and Times" in SAP S/4HANA. It reads from 1 data source (/scdl/db_date) and exposes 12 fields with key fields Client, DeliveryOrderUUID, DeliveryOrderItemUUID, DeliveryScheduleLineUUID, DeliveryDateTimeType. Part of development package VDM_EWM_DLV.

Data Sources (1)

SourceAliasJoin Type
/scdl/db_date /scdl/db_date from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEWMDLVDATETIME view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label EWM Delivery related Dates and Times view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Client mandt Editing Client
KEY DeliveryOrderUUID docid Snapshot ID
KEY DeliveryOrderItemUUID itemid Russia Statutory Reporting Report Land Tax, Run Item ID
KEY DeliveryScheduleLineUUID slineid Schedule Line ID
KEY DeliveryDateTimeType tsttype Date/Time Type
KEY DeliveryDateTimeCategory tst_category Date/Time Cat.
DeliveryDocumentCategory doccat Document Cat.
EWMDeliveryDocumentCategory doccat Document Cat.
TimeZoneName tzone Time Zone Difference
DeliveryRelatedStartDateTime Started On
DeliveryRelatedEndDateTime End Date/Time
DeliveryDataDeterminationInd date_indicator Determin. Ind.

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_EWM_DeliveryDateAndTime.
-- 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: IEWMDLVDATETIME

CREATE VIEW I_EWM_DeliveryDateAndTime AS
SELECT
  mandt AS Client,
  docid AS DeliveryOrderUUID,
  itemid AS DeliveryOrderItemUUID,
  slineid AS DeliveryScheduleLineUUID,
  tsttype AS DeliveryDateTimeType,
  tst_category AS DeliveryDateTimeCategory,
  doccat AS DeliveryDocumentCategory,
  doccat AS EWMDeliveryDocumentCategory,
  tzone AS TimeZoneName,
  cast ( tstfr as creation_timestamp preserving type ) AS DeliveryRelatedStartDateTime,
  cast ( tstto as creation_timestamp preserving type ) AS DeliveryRelatedEndDateTime,
  date_indicator AS DeliveryDataDeterminationInd
FROM /scdl/db_date
;

Learn More