I_FldLogsOutboundDelivEWM

DDL: I_FLDLOGSOUTBOUNDDELIVEWM SQL: IFLEWMOBD Type: view COMPOSITE
13 Fields 2 Data Sources

EWM RefDoc link from Outbound Delivery

I_FldLogsOutboundDelivEWM is a Composite CDS View that provides data about "EWM RefDoc link from Outbound Delivery" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsOutboundDelivIdEWM, I_FldLogsOutboundDel) and exposes 13 fields with key fields EWMOutboundDeliveryOrder, EWMOutboundDeliveryOrderItem, EWMWarehouse.

Data Sources (2)

SourceAliasJoin Type
I_FldLogsOutboundDelivIdEWM _EwmRefId inner
I_FldLogsOutboundDel _OutboundDelivery from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLEWMOBD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label EWM RefDoc link from Outbound Delivery view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY EWMOutboundDeliveryOrder I_FldLogsOutboundDelivIdEWM OutboundDeliveryOrder
KEY EWMOutboundDeliveryOrderItem I_FldLogsOutboundDelivIdEWM EWMOutboundDeliveryOrderItem Item Number
KEY EWMWarehouse I_FldLogsOutboundDelivIdEWM EWMWarehouse Warehouse No.
OutboundDeliveryOrder I_FldLogsOutboundDelivIdEWM EWMOutboundDeliveryOrder Document Number
OutboundDeliveryOrderUUID I_FldLogsOutboundDelivIdEWM OutboundDeliveryOrderUUID Document ID
OutboundDeliveryOrderItemUUID I_FldLogsOutboundDelivIdEWM OutboundDeliveryOrderItemUUID Item ID
FldLogsReferenceDocumentNumber I_FldLogsOutboundDel ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentItem I_FldLogsOutboundDel ReferenceDocumentItem Reference item
EWMWhseReqRefDocumentNumber _EWMRefDoc EWMWhseReqRefDocumentNumber
EWMWhseRequestRefDocumentItem _EWMRefDoc EWMWhseRequestRefDocumentItem
EWMReferenceDocumentCategory _EWMRefDoc EWMReferenceDocumentCategory
EWMWhseRequestDocumentCategory _EWMRefDoc EWMWhseRequestDocumentCategory
OverallGoodsMovementStatus I_FldLogsOutboundDel OverallGoodsMovementStatus

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_FldLogsOutboundDelivEWM.
-- 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: IFLEWMOBD

CREATE VIEW I_FldLogsOutboundDelivEWM AS
SELECT
  _EwmRefId.OutboundDeliveryOrder AS EWMOutboundDeliveryOrder,
  _EwmRefId.EWMOutboundDeliveryOrderItem AS EWMOutboundDeliveryOrderItem,
  _EwmRefId.EWMWarehouse AS EWMWarehouse,
  _EwmRefId.EWMOutboundDeliveryOrder AS OutboundDeliveryOrder,
  _EwmRefId.OutboundDeliveryOrderUUID AS OutboundDeliveryOrderUUID,
  _EwmRefId.OutboundDeliveryOrderItemUUID AS OutboundDeliveryOrderItemUUID,
  _OutboundDelivery.ReferenceDocumentNumber AS FldLogsReferenceDocumentNumber,
  _OutboundDelivery.ReferenceDocumentItem AS ReferenceDocumentItem,
  _EWMRefDoc.EWMWhseReqRefDocumentNumber AS EWMWhseReqRefDocumentNumber,
  _EWMRefDoc.EWMWhseRequestRefDocumentItem AS EWMWhseRequestRefDocumentItem,
  _EWMRefDoc.EWMReferenceDocumentCategory AS EWMReferenceDocumentCategory,
  _EWMRefDoc.EWMWhseRequestDocumentCategory AS EWMWhseRequestDocumentCategory,
  _OutboundDelivery.OverallGoodsMovementStatus AS OverallGoodsMovementStatus
FROM I_FldLogsOutboundDel AS _OutboundDelivery
INNER JOIN I_FldLogsOutboundDelivIdEWM AS _EwmRefId ON /* join condition not captured in parsed metadata */
;

Learn More