C_EWM_WarehouseOrder

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 C_EWM_WarehouseOrder.
-- 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: CEWMWO

CREATE VIEW C_EWM_WarehouseOrder AS
SELECT
  who.Warehouse AS Warehouse,
  who.WarehouseOrder AS WarehouseOrder,
  who.WarehouseOrderCreationRule AS WarehouseOrderCreationRule,
  who.WhseOrderCreationRuleCategory AS WhseOrderCreationRuleCategory,
  who.WhseProcessTypeDocumentHdr AS WhseProcessTypeDocumentHdr,
  who.Wave AS Wave,
  who.WarehouseOrderStatus AS WarehouseOrderStatus,
  who.ActivityArea AS ActivityArea,
  who.StorageType AS StorageType,
  who.StorageBin AS StorageBin,
  who.CreationDateTime AS CreationDateTime,
  tstmp_to_dats( who.CreationDateTime, _Whstz.TimeZoneID, $session.client, 'NULL' ) as WrhsTmZnCreationDate AS clientNULLasWrhsTmZnCreationDate,
  tstmp_to_tims( who.CreationDateTime, _Whstz.TimeZoneID, $session.client, 'NULL' ) as WrhsTmznCreationTime AS clientNULLasWrhsTmznCreationTime,
  who.CreatedByUser AS CreatedByUser,
  who.Queue AS Queue,
  who.WarehouseOrderStartDateTime AS WarehouseOrderStartDateTime,
  who.WarehouseOrderStartTimeIsFixed AS WarehouseOrderStartTimeIsFixed,
  who.WhseOrderConfirmedDateTime AS WhseOrderConfirmedDateTime,
  who.WarehouseOrderConfirmedBy AS WarehouseOrderConfirmedBy,
  who.Processor AS Processor,
  who.ExecutingResource AS ExecutingResource,
  who.ProcessorIsManualAssigned AS ProcessorIsManualAssigned,
  who.WarehouseOrderHasPhysInvtryDoc AS WarehouseOrderHasPhysInvtryDoc,
  who.WhseOrderForSplitWhseOrder AS WhseOrderForSplitWhseOrder,
  who.WarehouseOrderIsSplit AS WarehouseOrderIsSplit,
  who.ResourceStartBin AS ResourceStartBin,
  who.WhseOrderLatestStartDateTime AS WhseOrderLatestStartDateTime,
  who.WarehouseOrderPlannedDuration AS WarehouseOrderPlannedDuration,
  who.WhseOrderPlanDurationTimeUnit AS WhseOrderPlanDurationTimeUnit,
  who.LastChangeDateTime AS LastChangeDateTime,
  who.LastChangedByUser AS LastChangedByUser,
  who.WhseOrderHigherLevelWhseOrder AS WhseOrderHigherLevelWhseOrder,
  who.WhseOrderSubsequentWhseOrder AS WhseOrderSubsequentWhseOrder,
  who.WhseOrderHasSubsqntWhseOrder AS WhseOrderHasSubsqntWhseOrder,
  who.WarehouseOrderHasWhseTask AS WarehouseOrderHasWhseTask,
  who.WarehouseOrderLogicalNumber AS WarehouseOrderLogicalNumber,
  who.HzdsSubstanceIsRlvtForStorage AS HzdsSubstanceIsRlvtForStorage,
  who.WarehouseOrderUUID AS WarehouseOrderUUID
FROM I_EWM_WarehouseOrder AS who
LEFT OUTER JOIN I_EWM_AssgWhseBusinessPartner AS _Whsbupa ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_WarehouseTimezone AS _Whstz ON /* join condition not captured in parsed metadata */
;