I_FldLogsRcvdHndlgUnitItemBase

DDL: I_FLDLOGSRCVDHNDLGUNITITEMBASE Type: view_entity COMPOSITE Package: FLOG_RETURN_PROCG_BASE
59 Fields 1 Data Sources 2 Associations

FL received handling unit item at base

I_FldLogsRcvdHndlgUnitItemBase is a Composite CDS View that provides data about "FL received handling unit item at base" in SAP S/4HANA. It reads from 1 data source (I_FldLogsRcvdHndlgUntItmBasic) and exposes 59 fields with key fields FldLogsShptItemUUID, FldLogsShptItmHndlgUnitID, FldLogsReferenceDocumentNumber. It has 2 associations to related views. Part of development package FLOG_RETURN_PROCG_BASE.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsRcvdHndlgUntItmBasic I_FldLogsRcvdHndlgUntItmBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FldLogsReturnItem _ReturnItms _ReturnItms.OutboundDelivery = $projection.OutboundDelivery and _ReturnItms.OutboundDeliveryItem = $projection.OutboundDeliveryItem and _ReturnItms.OutboundDelivery is not initial
[1..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 (6)

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

Fields (59)

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.
FldLogsAuxValue _FldLogsSupplierItem FldLogsAuxValue Auxiliary Value
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
ReferenceOrder _ReturnItms ReferenceOrder Reference Order
FldLogsRecommendedAction _ReturnItms FldLogsRecommendedAction Recommended Action
ReferencePurchasingDocument _ReturnItms ReferencePurchasingDocument Purchasing Doc.
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_FldLogsRcvdHndlgUnitItemBase.
-- 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_FldLogsRcvdHndlgUnitItemBase AS
SELECT
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  FldLogsReferenceDocumentNumber,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  FldLogsReferenceDocCategory,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsSupplyProcess,
  FldLogsItemType,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  MaterialDocument,
  _FldLogsSupplierItem.FldLogsAuxValue AS FldLogsAuxValue,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsStorageType,
  Batch,
  ValuationType,
  SerialNumber,
  FieldLogisticsReceivingPlant,
  FieldLogisticsProcessType,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  IsMarkedForDeletion,
  FldLogsCtnItmChangeDateTime,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsContainerUnitUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  PackagingMaterial,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  '' AS IsEndOfPurposeBlocked,
  _ReturnItms.ReferenceOrder AS ReferenceOrder,
  _ReturnItms.FldLogsRecommendedAction AS FldLogsRecommendedAction,
  _ReturnItms.ReferencePurchasingDocument AS ReferencePurchasingDocument,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  WarehouseTask
FROM I_FldLogsRcvdHndlgUntItmBasic
LEFT OUTER JOIN I_FldLogsReturnItem AS _ReturnItms ON _ReturnItms.OutboundDelivery = OutboundDelivery AND _ReturnItms.OutboundDeliveryItem = 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 [1..1]
;

Learn More