I_FldLogsCtnItemsReceived

DDL: I_FLDLOGSCTNITEMSRECEIVED SQL: IFLCTNITMRCVD Type: view COMPOSITE
49 Fields 1 Data Sources

Container Items Received at base

I_FldLogsCtnItemsReceived is a Composite CDS View that provides data about "Container Items Received at base" in SAP S/4HANA. It reads from 1 data source (I_FldLogsReturnCtnItmsBasic) and exposes 49 fields with key fields FldLogsContainerID, DispatchedStartDate, FldLogsDispatchPlant, NumberOfCtnTripsPerDay, FldLogsReferenceDocumentNumber.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsReturnCtnItmsBasic I_FldLogsReturnCtnItmsBasic from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLCTNITMRCVD view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Container Items Received at base view

Fields (49)

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.
PurchasingDocument PurchasingDocument Purchasing Document
FldLogsCtnItmChangeDateTime FldLogsCtnItmChangeDateTime Time Stamp
FldLogsStorageType FldLogsStorageType Storage Type
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
Batch Batch Lot No.
ValuationType ValuationType Valuation Type
SerialNumber SerialNumber Serial Number
FieldLogisticsProcessType FieldLogisticsProcessType Process Type
FieldLogisticsReceivingPlant FieldLogisticsReceivingPlant Receiving Plant
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
FldLogsRetPOOutbDelivIsCreated FldLogsRetPOOutbDelivIsCreated Checkbox
FldLogsSubcontrgPOIsCreated FldLogsSubcontrgPOIsCreated Checkbox
FldLogsSubcontractingPO FldLogsSubcontractingPO Purchasing Doc.
FldLogsItemType FldLogsItemType Type
MaintenanceOrder MaintenanceOrder Order
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
FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID
WarehouseTask WarehouseTask Warehouse Task
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data

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_FldLogsCtnItemsReceived.
-- 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: IFLCTNITMRCVD

CREATE VIEW I_FldLogsCtnItemsReceived AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  FldLogsReferenceDocCategory,
  MaterialDocument,
  PurchasingDocument,
  FldLogsCtnItmChangeDateTime,
  FldLogsStorageType,
  FldLogsSupplyProcess,
  Batch,
  ValuationType,
  SerialNumber,
  FieldLogisticsProcessType,
  FieldLogisticsReceivingPlant,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontrgPOIsCreated,
  FldLogsSubcontractingPO,
  FldLogsItemType,
  MaintenanceOrder,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsShptItmHndlgUnitID,
  WarehouseTask,
  IsMarkedForDeletion
FROM I_FldLogsReturnCtnItmsBasic
;

Learn More