I_ATPResultShippingDates

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_ATPResultShippingDates.
-- 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: IATPRESULTSCHED

CREATE VIEW I_ATPResultShippingDates AS
SELECT
  cid AS ATPCheckUUID,
  atpcat AS ATPRelevantDocumentCategory,
  delnr AS ATPRelevantDocument,
  delps AS ATPRelevantDocumentItem,
  delet AS ATPRelevantDocScheduleLine,
  item_type AS ATPCheckItemType,
  resind AS ATPCheckResultIndicator,
  atpdate AS ATPCheckRelevantDate,
  mat_avail_date AS ProductAvailabilityDate,
  mat_avail_time AS ProductAvailabilityTime,
  mat_avail_timezone AS ProductAvailabilityTimeZone,
  cast(dats_tims_to_tstmp(mat_avail_date, mat_avail_time, mat_avail_timezone, $session.client, 'NULL') as timestamp preserving type) AS ProductAvailabilityUTCDateTime,
  trans_dispo_date AS TransportationPlanningDate,
  trans_dispo_time AS TransportationPlanningTime,
  trans_dispo_timezone AS TransportationPlanningTimeZone,
  cast(dats_tims_to_tstmp(trans_dispo_date, trans_dispo_time, trans_dispo_timezone, $session.client, 'NULL') as timestamp preserving type) AS TranspPlanningUTCDateTime,
  loading_date AS LoadingDate,
  loading_time AS LoadingTime,
  loading_timezone AS LoadingTimeZone,
  cast(dats_tims_to_tstmp(loading_date, loading_time, loading_timezone, $session.client, 'NULL') as timestamp preserving type) AS LoadingUTCDateTime,
  goods_issue_date AS GoodsIssueDate,
  goods_issue_time AS GoodsIssueTime,
  goods_issue_timezone AS GoodsIssueTimeZone,
  cast(dats_tims_to_tstmp(goods_issue_date, goods_issue_time, goods_issue_timezone, $session.client, 'NULL') as timestamp preserving type) AS GoodsIssueUTCDateTime,
  delivery_date AS DeliveryDate,
  delivery_time AS DeliveryTime,
  delivery_timezone AS DeliveryTimeZone,
  cast(dats_tims_to_tstmp(delivery_date, delivery_time, delivery_timezone, $session.client, 'NULL') as timestamp preserving type) AS DeliveryUTCDateTime,
  unloading_date AS UnloadingDate,
  unloading_time AS UnloadingTime,
  unloading_timezone AS UnloadingTimeZone,
  cast(dats_tims_to_tstmp(unloading_date, unloading_time, unloading_timezone, $session.client, 'NULL') as timestamp preserving type) AS UnloadingUTCDateTime
FROM atp_result_sched
LEFT OUTER JOIN I_ATPResultHeader AS _Header ON ATPCheckUUID = _Header.ATPCheckUUID  -- association [1..1]
LEFT OUTER JOIN I_ATPResultDetail AS _Details ON ATPCheckUUID = _Details.ATPCheckUUID AND ATPRelevantDocument = _Details.ATPRelevantDocument AND ATPRelevantDocumentItem = _Details.ATPRelevantDocumentItem AND ATPRelevantDocScheduleLine = _Details.ATPRelevantDocScheduleLine AND ATPRelevantDocumentCategory = _Details.ATPRelevantDocumentCategory AND ATPCheckItemType = _Details.ATPCheckItemType AND ATPCheckResultIndicator = _Details.ATPCheckResultIndicator AND ATPCheckRelevantDate = _Details.ATPCheckRelevantDate  -- association [1..1]
LEFT OUTER JOIN I_ATPRlvtDocumentCategory AS _ATPRlvtDocumentCategory ON ATPRelevantDocumentCategory = _ATPRlvtDocumentCategory.ATPRelevantDocumentCategory  -- association [0..1]
;