I_FldLogsRetCtnItemEnhanced

DDL: I_FLDLOGSRETCTNITEMENHANCED Type: view_entity COMPOSITE Package: FLOG_RETURN_PROCG_BASE
33 Fields 1 Data Sources 1 Associations

FL Enhanced Received Item

I_FldLogsRetCtnItemEnhanced is a Composite CDS View that provides data about "FL Enhanced Received Item" in SAP S/4HANA. It reads from 1 data source (I_FldLogsReturnCtnItmsBasic) and exposes 33 fields with key fields FldLogsContainerID, DispatchedStartDate, FldLogsDispatchPlant, NumberOfCtnTripsPerDay, FldLogsReferenceDocumentNumber. It has 1 association to related views. Part of development package FLOG_RETURN_PROCG_BASE.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsReturnCtnItmsBasic I_FldLogsReturnCtnItmsBasic from

Associations (1)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FL Enhanced Received Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (33)

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
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
MaterialDocument MaterialDocument Material Doc.
PurchasingDocument PurchasingDocument Purchasing Document
StockTransportOrder StockTransportOrder STO Number
FldLogsRetServicePurOrd FldLogsRetServicePurOrd Purchasing Doc.
FldLogsRetPOOutbDelivIsCreated FldLogsRetPOOutbDelivIsCreated Checkbox
FldLogsSubcontrgPOIsCreated FldLogsSubcontrgPOIsCreated Checkbox
FldLogsSubcontractingPO FldLogsSubcontractingPO Purchasing Doc.
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
MaintenanceOrder MaintenanceOrder Order
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
InboundDelivery InboundDelivery LE Delivery
InboundDeliveryItem InboundDeliveryItem Item
FieldLogisticsReceivingPlant FieldLogisticsReceivingPlant Receiving Plant
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
FldLogsDestStorLocID FldLogsDestStorLocID Location
WarehouseTask WarehouseTask Warehouse Task
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
FldLogsCtnQuickAction FldLogsCtnQuickAction Handling Decision
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocumentItem MaterialDocumentItem Material Document Item
EWMWarehouse _WarehouseNumber EWMWarehouse Warehouse No.
_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_FldLogsRetCtnItemEnhanced.
-- 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_FldLogsRetCtnItemEnhanced AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  FldLogsReferenceDocCategory,
  MaterialDocument,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontrgPOIsCreated,
  FldLogsSubcontractingPO,
  FldLogsRefurbishmentOrder,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  InboundDelivery,
  InboundDeliveryItem,
  FieldLogisticsReceivingPlant,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsDestStorLocID,
  WarehouseTask,
  DeliveryDocument,
  DeliveryDocumentItem,
  FldLogsCtnQuickAction,
  IsMarkedForDeletion,
  MaterialDocumentYear,
  MaterialDocumentItem,
  _WarehouseNumber.EWMWarehouse AS EWMWarehouse
FROM I_FldLogsReturnCtnItmsBasic
LEFT OUTER JOIN I_FldLogsPlntStorLocWrhsNmbr AS _WarehouseNumber ON _WarehouseNumber.Plant = FieldLogisticsReceivingPlant AND _WarehouseNumber.StorageLocation = FldLogsDestStorLocID  -- association [0..1]
;

Learn More