I_FldLogsCtnItemsDispatched

DDL: I_FLDLOGSCTNITEMSDISPATCHED SQL: IFLCTNITMDISP Type: view COMPOSITE
55 Fields 1 Data Sources 2 Associations

FL Dispatched Container Items

I_FldLogsCtnItemsDispatched is a Composite CDS View that provides data about "FL Dispatched Container Items" in SAP S/4HANA. It reads from 1 data source (I_FldLogsReturnCtnItmsBasic) and exposes 55 fields with key fields FldLogsContainerID, DispatchedStartDate, FldLogsDispatchPlant, NumberOfCtnTripsPerDay, FldLogsReferenceDocumentNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsReturnCtnItmsBasic I_FldLogsReturnCtnItmsBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FldLogsReturnItem _ReturnItms $projection.OutboundDelivery = _ReturnItms.OutboundDelivery and $projection.OutboundDeliveryItem = _ReturnItms.OutboundDeliveryItem and _ReturnItms.OutboundDelivery is not initial
[0..1] I_FldLogsSupplierItemAux _FldLogsSupplierItem _FldLogsSupplierItem.FldLogsSuplrItemUUID = $projection.FldLogsSuplrItemUUID and _FldLogsSupplierItem.FldLogsAuxPrflID = 'REL_DOC' and _FldLogsSupplierItem.FldLogsAuxSubTypeCode = 'RET_PO' and $projection.FldLogsCtnQuickAction = '30' and $projection.FldLogsRetPOOutbDelivIsCreated is not initial

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLCTNITMDISP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label FL Dispatched Container Items view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerID FldLogsContainerID Container ID
KEY DispatchedStartDate DispatchedStartDate Dispatch Date
KEY FldLogsDispatchPlant FldLogsDispatchPlant Plant
KEY NumberOfCtnTripsPerDay NumberOfCtnTripsPerDay Trip Counter
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
Material Material Vehicle Model
RetblQtyInOrderUnit RetblQtyInOrderUnit Load Quantity
RetblQtyOrderUnit RetblQtyOrderUnit Order Unit
RetblQtyInBaseUnit RetblQtyInBaseUnit Quantity in Base Uni
RetblQtyBaseUnit RetblQtyBaseUnit UoM
FldLogsSrceStorLocID FldLogsSrceStorLocID Location
FldLogsDestStorLocID FldLogsDestStorLocID Location
FldLogsReturnStatus FldLogsReturnStatus Return Status
FldLogsContainerItemStatus FldLogsContainerItemStatus Transfer Status
FldLogsCtnQuickAction FldLogsCtnQuickAction Handling Decision
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
MaterialDocument MaterialDocument Material Doc.
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
PurchasingDocument PurchasingDocument Purchasing Document
ReferenceOrder _ReturnItms ReferenceOrder Reference Order
FldLogsCtnItmChangeDateTime FldLogsCtnItmChangeDateTime Time Stamp
FldLogsStorageType FldLogsStorageType Storage Type
FieldLogisticsProcessType FieldLogisticsProcessType Process Type
FieldLogisticsReceivingPlant FieldLogisticsReceivingPlant Receiving Plant
FldLogsRecommendedAction _ReturnItms FldLogsRecommendedAction Recommended Action
ReferencePurchasingDocument _ReturnItms ReferencePurchasingDocument Purchasing Doc.
Batch Batch Lot No.
ValuationType ValuationType Valuation Type
SerialNumber SerialNumber Serial Number
FldLogsRetPOOutbDelivIsCreated FldLogsRetPOOutbDelivIsCreated Checkbox
FldLogsSubcontrgPOIsCreated FldLogsSubcontrgPOIsCreated Checkbox
FldLogsSubcontractingPO FldLogsSubcontractingPO Purchasing Doc.
FldLogsContainerUnitUUID FldLogsContainerUnitUUID Container Unit ID
FldLogsShptItemUUID FldLogsShptItemUUID Shipment Item ID
FldLogsShptVoyageUUID FldLogsShptVoyageUUID Voyage UUID
FldLogsShptVoyageNumber FldLogsShptVoyageNumber Voyage Number
FldLogsVoyageSrceStage FldLogsVoyageSrceStage Source Stage
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
FldLogsItemType FldLogsItemType Type
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
MaintenanceOrder MaintenanceOrder Order
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
FldLogsRefrbmtOrderReservation FldLogsRefrbmtOrderReservation Reservation
FldLogsRefrbmtOrderResvnItem FldLogsRefrbmtOrderResvnItem Reservation Item
InboundDelivery InboundDelivery LE Delivery
InboundDeliveryItem InboundDeliveryItem Item
FldLogsSuplrItemVislInspCode FldLogsSuplrItemVislInspCode Visual Inspection
FldLogsSuplrItemUUID FldLogsSuplrItemUUID Suplr Item UUID
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID
WarehouseTask WarehouseTask Warehouse Task
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
_FldLogsSupplierItem _FldLogsSupplierItem

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_FldLogsCtnItemsDispatched.
-- 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: IFLCTNITMDISP

CREATE VIEW I_FldLogsCtnItemsDispatched AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  FldLogsReferenceDocCategory,
  MaterialDocument,
  FldLogsSupplyProcess,
  PurchasingDocument,
  _ReturnItms.ReferenceOrder AS ReferenceOrder,
  FldLogsCtnItmChangeDateTime,
  FldLogsStorageType,
  FieldLogisticsProcessType,
  FieldLogisticsReceivingPlant,
  _ReturnItms.FldLogsRecommendedAction AS FldLogsRecommendedAction,
  _ReturnItms.ReferencePurchasingDocument AS ReferencePurchasingDocument,
  Batch,
  ValuationType,
  SerialNumber,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontrgPOIsCreated,
  FldLogsSubcontractingPO,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsItemType,
  FldLogsRefurbishmentOrder,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemVislInspCode,
  FldLogsSuplrItemUUID,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsShptItmHndlgUnitID,
  WarehouseTask,
  IsMarkedForDeletion
FROM I_FldLogsReturnCtnItmsBasic
LEFT OUTER JOIN I_FldLogsReturnItem AS _ReturnItms ON OutboundDelivery = _ReturnItms.OutboundDelivery AND OutboundDeliveryItem = _ReturnItms.OutboundDeliveryItem AND _ReturnItms.OutboundDelivery is not initial  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplierItemAux AS _FldLogsSupplierItem ON _FldLogsSupplierItem.FldLogsSuplrItemUUID = FldLogsSuplrItemUUID AND _FldLogsSupplierItem.FldLogsAuxPrflID = 'REL_DOC' AND _FldLogsSupplierItem.FldLogsAuxSubTypeCode = 'RET_PO' AND FldLogsCtnQuickAction = '30' AND FldLogsRetPOOutbDelivIsCreated is not initial  -- association [0..1]
;

Learn More