C_EWM_WhseOrderParamDet

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_WhseOrderParamDet.
-- 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: CEWMWOPRMDET

CREATE VIEW C_EWM_WhseOrderParamDet AS
SELECT
  who.Warehouse AS Warehouse,
  who.WarehouseOrder AS WarehouseOrder,
  who.WarehouseOrderStatus AS WarehouseOrderStatus,
  who.ActivityArea AS ActivityArea,
  who.StorageType AS StorageType,
  who.WarehouseOrderHasPhysInvtryDoc AS WarehouseOrderHasPhysInvtryDoc,
  who.WarehouseOrderHasWhseTask AS WarehouseOrderHasWhseTask,
  cast ( ' ' as /scwm/de_procty preserving type) AS WarehouseProcessType,
  cast ( ' ' as abap.numc( 1 )) AS WarehouseTaskEvent,
  cast ( ' ' as /scwm/lvs_trart preserving type) AS WarehouseProcessCategory,
  cast ( ' ' as /scwm/de_workstation preserving type) AS WorkCenter,
  cast ( ' ' as /scwm/de_exccode preserving type) AS WarehouseTaskExceptionCode,
  cast ( ' ' as /scwm/de_owner preserving type) AS StockOwner,
  cast ( ' ' as /scwm/de_entitled preserving type) AS EntitledToDisposeParty,
  cast ( ' ' as /scwm/flghuto preserving type) AS IsHandlingUnitWarehouseTask,
  cast ( ' ' as /scwm/de_actty preserving type) AS WarehouseActivityType,
  cast ( ' ' as /scwm/de_tostat preserving type) AS WarehouseTaskStatus,
  cast ( ' ' as /scwm/de_movehu preserving type) AS HomogeneousFullPalletPick
FROM I_EWM_WarehouseOrder AS who
;