I_FldLogsRcvdHndlgUnitItemRmte

DDL: I_FLDLOGSRCVDHNDLGUNITITEMRMTE Type: view_entity COMPOSITE

FL received handling unit item at remote

I_FldLogsRcvdHndlgUnitItemRmte is a Composite CDS View that provides data about "FL received handling unit item at remote" in SAP S/4HANA. It reads from 1 data source (I_FldLogsRcvdHndlgUntItmBasic) and exposes 55 fields with key fields FldLogsShptItemUUID, FldLogsShptItmHndlgUnitID, FldLogsReferenceDocumentNumber.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsRcvdHndlgUntItmBasic I_FldLogsRcvdHndlgUntItmBasic from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FL received handling unit item at remote view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY FldLogsShptItemUUID FldLogsShptItemUUID Shipment Item ID
KEY FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
DispatchedStartDate DispatchedStartDate Dispatch Date
FldLogsDispatchPlant FldLogsDispatchPlant Plant
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
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
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
FldLogsItemType FldLogsItemType Type
FldLogsReturnStatus FldLogsReturnStatus Return Status
FldLogsContainerItemStatus FldLogsContainerItemStatus Transfer Status
FldLogsCtnQuickAction FldLogsCtnQuickAction Handling Decision
MaterialDocument MaterialDocument Material Doc.
PurchasingDocument PurchasingDocument Purchasing Document
StockTransportOrder StockTransportOrder STO Number
FldLogsRetServicePurOrd FldLogsRetServicePurOrd Purchasing Doc.
FldLogsStorageType FldLogsStorageType Storage Type
Batch Batch Lot No.
ValuationType ValuationType Valuation Type
SerialNumber SerialNumber Serial Number
FieldLogisticsReceivingPlant FieldLogisticsReceivingPlant Receiving Plant
FieldLogisticsProcessType FieldLogisticsProcessType Process Type
FldLogsSubcontractingPO FldLogsSubcontractingPO Purchasing Doc.
FldLogsSubcontrgPOIsCreated FldLogsSubcontrgPOIsCreated Checkbox
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
FldLogsCtnItmChangeDateTime FldLogsCtnItmChangeDateTime Time Stamp
FldLogsRetPOOutbDelivIsCreated FldLogsRetPOOutbDelivIsCreated Checkbox
FldLogsContainerUnitUUID FldLogsContainerUnitUUID Container Unit ID
FldLogsShptVoyageUUID FldLogsShptVoyageUUID Voyage UUID
FldLogsShptVoyageNumber FldLogsShptVoyageNumber Voyage Number
FldLogsVoyageSrceStage FldLogsVoyageSrceStage Source Stage
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
PackagingMaterial PackagingMaterial Packaging Materials
HandlingUnitQuantity HandlingUnitQuantity Packed Quantity
HandlingUnitQuantityUnit HandlingUnitQuantityUnit UoM of HU item
IsEndOfPurposeBlocked
MaintenanceOrder MaintenanceOrder Order
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
FldLogsRefrbmtOrderReservation FldLogsRefrbmtOrderReservation Reservation
FldLogsRefrbmtOrderResvnItem FldLogsRefrbmtOrderResvnItem Reservation Item
InboundDelivery InboundDelivery LE Delivery
InboundDeliveryItem InboundDeliveryItem Item
FldLogsSuplrItemUUID FldLogsSuplrItemUUID Suplr Item UUID
FldLogsSuplrItemVislInspCode FldLogsSuplrItemVislInspCode Visual Inspection
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
WarehouseTask WarehouseTask Warehouse Task

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_FldLogsRcvdHndlgUnitItemRmte.
-- 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_FldLogsRcvdHndlgUnitItemRmte AS
SELECT
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  FldLogsReferenceDocumentNumber,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  FldLogsReferenceDocCategory,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsSupplyProcess,
  FldLogsItemType,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  MaterialDocument,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsStorageType,
  Batch,
  ValuationType,
  SerialNumber,
  FieldLogisticsReceivingPlant,
  FieldLogisticsProcessType,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  IsMarkedForDeletion,
  FldLogsCtnItmChangeDateTime,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsContainerUnitUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  PackagingMaterial,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  '' AS IsEndOfPurposeBlocked,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  WarehouseTask
FROM I_FldLogsRcvdHndlgUntItmBasic
;