I_FldLogsRcvdHndlgUntItmEnhcd

DDL: I_FLDLOGSRCVDHNDLGUNTITMENHCD Type: view_entity COMPOSITE
30 Fields 1 Data Sources 1 Associations

FL received HndlgUnt Item Addl details

I_FldLogsRcvdHndlgUntItmEnhcd is a Composite CDS View that provides data about "FL received HndlgUnt Item Addl details" in SAP S/4HANA. It reads from 1 data source (I_FldLogsRcvdHndlgUntItmBasic) and exposes 30 fields with key fields FldLogsShptItemUUID, FldLogsShptItmHndlgUnitID, FldLogsReferenceDocumentNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsRcvdHndlgUntItmBasic I_FldLogsRcvdHndlgUntItmBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsPlntStorLocWrhsNmbr _WarehouseNumber _WarehouseNumber.Plant = $projection.FldLogsItmActualReceivingPlant and _WarehouseNumber.StorageLocation = $projection.FldLogsDestStorLocID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FL received HndlgUnt Item Addl details view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY FldLogsShptItemUUID FldLogsShptItemUUID Shipment Item ID
KEY FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
MaterialDocument MaterialDocument Material Doc.
PurchasingDocument PurchasingDocument Purchasing Document
StockTransportOrder StockTransportOrder STO Number
FldLogsRetServicePurOrd FldLogsRetServicePurOrd Purchasing Doc.
FldLogsItmActualReceivingPlant FldLogsItmActualReceivingPlant Plant
FldLogsSubcontractingPO FldLogsSubcontractingPO Purchasing Doc.
FldLogsSubcontrgPOIsCreated FldLogsSubcontrgPOIsCreated Checkbox
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
MaintenanceOrder MaintenanceOrder Order
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
InboundDelivery InboundDelivery LE Delivery
InboundDeliveryItem InboundDeliveryItem Item
FldLogsDestStorLocID FldLogsDestStorLocID Location
WarehouseTask WarehouseTask Warehouse Task
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
FldLogsCtnQuickAction FldLogsCtnQuickAction Handling Decision
FldLogsRetPOOutbDelivIsCreated FldLogsRetPOOutbDelivIsCreated Checkbox
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
FieldLogisticsProcessType FieldLogisticsProcessType Process Type
FldLogsRcvdItmIsAcctAssgd FldLogsRcvdItmIsAcctAssgd Checkbox
_OutboundDelivery _OutboundDelivery
_WarehouseNumber _WarehouseNumber

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_FldLogsRcvdHndlgUntItmEnhcd.
-- 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_FldLogsRcvdHndlgUntItmEnhcd AS
SELECT
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  FldLogsReferenceDocumentNumber,
  FldLogsReferenceDocCategory,
  MaterialDocument,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsItmActualReceivingPlant,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  OutboundDelivery,
  OutboundDeliveryItem,
  MaintenanceOrder,
  FldLogsRefurbishmentOrder,
  Reservation,
  ReservationItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsDestStorLocID,
  WarehouseTask,
  DeliveryDocument,
  DeliveryDocumentItem,
  FldLogsCtnQuickAction,
  FldLogsRetPOOutbDelivIsCreated,
  IsMarkedForDeletion,
  FieldLogisticsProcessType,
  FldLogsRcvdItmIsAcctAssgd
FROM I_FldLogsRcvdHndlgUntItmBasic
LEFT OUTER JOIN I_FldLogsPlntStorLocWrhsNmbr AS _WarehouseNumber ON _WarehouseNumber.Plant = FldLogsItmActualReceivingPlant AND _WarehouseNumber.StorageLocation = FldLogsDestStorLocID  -- association [0..1]
;

Learn More