I_EWM_WarehouseRequestOutItem

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_WarehouseRequestOutItem.
-- 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_EWM_WarehouseRequestOutItem AS
SELECT
  docid AS EWMWarehouseRequestUUID,
  itemid AS EWMWarehouseRequestItemUUID,
  doccat AS EWMWhseRequestDocumentCategory,
  itemno AS EWMWarehouseRequestItem,
  itemcat AS EWMWhseRequestItemCategory,
  itemtype AS EWMWarehouseRequestItemType,
  productid AS ProductUUID,
  productno AS Product,
  cast( productno_ext as char40 preserving type ) AS ProductExternalID,
  batchno AS ProductBatch,
  req_seg_long AS RequirementSegment,
  stk_seg_long AS StockSegment,
  /scwm/whno AS EWMWarehouse,
  /scwm/door AS WarehouseDoor,
  /scwm/stagarea AS StagingArea,
  /scwm/stagareagr AS StagingAreaGroup,
  /scwm/stagarbin AS StagingBay,
  status_gi AS GoodsIssueStatus,
  status_wm AS WarehouseActivityStatus,
  status_compl AS CompletionStatus,
  docno AS EWMWarehouseRequest,
  entitled AS EntitledToDisposeParty,
  /scwm/procty AS WarehouseProcessType,
  service_level AS ShippingCondition,
  status_pick AS PlannedPickingStatus,
  /scwm/stobin AS EWMStorageBin,
  /scwm/gmbin AS GoodsMovementBin,
  /scwm/psa AS EWMProductionSupplyArea,
  /scwm/split AS EWMPickingBinDataIsSplit,
  /scwm/waveflg AS EWMWhseReqItemIsWaveRelevant,
  cast( cretst as tzntstmps preserving type ) AS EWMWhseReqCreationUTCDateTime,
  cast( chgtst as tzntstmps preserving type ) AS EWMWhseReqLastChangeUTCDteTme,
  case when /scwm/split = ' ' then /scwm/stotype else '*' end AS EWMStorageType,
  case when /scwm/split = ' ' then /scwm/stosec else '*' end AS EWMStorageSection,
  case when /scwm/split = ' ' then /scwm/aarea else '*' end AS ActivityArea,
  qty AS ProductQuantity,
  uom AS QuantityUnit,
  tstfr_gi_date_wh AS WrhsTimeZonePlannedGIDate,
  tstfr_gi_time_wh AS WrhsTimeZonePlannedGITime,
  cast(tstfr_gi_wh as tzntstmps preserving type) AS WrhsTmznPlndGIStrtDateTime,
  cast(tstfr_gi as tzntstmps preserving type ) AS PlndGoodsIssueStartUTCDateTime,
  cast(tstfr_act_gi as tzntstmps preserving type ) AS ActlGoodsIssueStartUTCDateTime,
  cast(tstfr_act_gi_wh as tzntstmps preserving type ) AS WrhsTmznActlGIStrtDateTime,
  tstto_act_gi_date_wh AS WrhsTimeZoneActualGIDate,
  tstto_act_gi_time_wh AS WrhsTimeZoneActualGITime,
  cast(tstto_act_gi as tzntstmps preserving type ) AS EWMActlGIEndUTCDateTime,
  cast(tstto_act_gi_wh as tzntstmps preserving type ) AS EWMWhseTmznActlGIEndDateTime,
  cast(tsttobb as tzntstmps preserving type ) AS EWMWhseReqItmBBDEndUTCDteTme,
  cast(tstfrbb as tzntstmps preserving type ) AS EWMWhseReqItmBBDStrtUTCDteTme,
  cast(tsttose as tzntstmps preserving type ) AS EWMWhseReqItmSLEDEndUTCDteTme,
  cast(tstfrse as tzntstmps preserving type ) AS EWMWhseReqItmSLEDStrtUTCDteTme,
  stock_usage AS EWMStockUsage,
  stock_category AS EWMStockType,
  stock_owner AS EWMStockOwner,
  stock_owner_role AS StockOwnerPartnerRole,
  stock_cat_ind AS EWMWhseReqItmStockTypeDetnCode,
  stock_doccat AS StockDocumentCategory,
  stock_docno AS StockDocumentNumber,
  stock_itmno AS StockItemNumber,
  ocountry AS CountryOfOrigin,
  /scwm/goods_recipient AS EWMGoodsRecipient,
  /scwm/rcloc AS EWMRecipientLocationName,
  cast(substring(cast(refdocno_so as abap.char( 35 )),1,10) as vdm_sales_order) AS SalesOrder,
  cast(substring(cast(refitemno_so as abap.numc( 10 )),5,6) as sales_order_item) AS SalesOrderItem
FROM /scdl/db_proci_o
;