I_FldLogsRmtePlntCtnItmsEnhcd

DDL: I_FLDLOGSRMTEPLNTCTNITMSENHCD SQL: IFLREMCTNITMENH Type: view COMPOSITE
51 Fields 1 Data Sources

Container items received at remote

I_FldLogsRmtePlntCtnItmsEnhcd is a Composite CDS View that provides data about "Container items received at remote" in SAP S/4HANA. It reads from 1 data source (I_FldLogsRemotePlantCtnItems) and exposes 51 fields with key fields FldLogsContainerID, DispatchedStartDate, FldLogsDispatchPlant, NumberOfCtnTripsPerDay, FldLogsReferenceDocumentNumber.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsRemotePlantCtnItems I_FldLogsRemotePlantCtnItems from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLREMCTNITMENH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Container items received at remote view

Fields (51)

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
RetblQtyOrderUnit RetblQtyOrderUnit
RetblQtyInBaseUnit RetblQtyInBaseUnit
RetblQtyBaseUnit RetblQtyBaseUnit
FldLogsSrceStorLocID FldLogsSrceStorLocID Location
FldLogsDestStorLocID FldLogsDestStorLocID Location
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
FldLogsReturnStatus FldLogsReturnStatus
FldLogsContainerItemStatus FldLogsContainerItemStatus
FldLogsCtnQuickAction FldLogsCtnQuickAction Handling Decision
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
Batch Batch Lot No.
ValuationType ValuationType Valuation Type
SerialNumber SerialNumber Serial Number
FieldLogisticsProcessType FieldLogisticsProcessType Process Type
FldLogsCtnItmChangeDateTime FldLogsCtnItmChangeDateTime
FldLogsRetPOOutbDelivIsCreated FldLogsRetPOOutbDelivIsCreated Checkbox
FldLogsSubcontrgPOIsCreated FldLogsSubcontrgPOIsCreated Checkbox
FldLogsSubcontractingPO FldLogsSubcontractingPO Purchasing Doc.
MaterialDocument MaterialDocument Material Doc.
PurchasingDocument PurchasingDocument Purchasing Document
FieldLogisticsReceivingPlant FieldLogisticsReceivingPlant
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
FldLogsItemType FldLogsItemType
FldLogsStorageType FldLogsStorageType
MaintenanceOrder MaintenanceOrder Order
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
FldLogsRefrbmtOrderReservation FldLogsRefrbmtOrderReservation
FldLogsRefrbmtOrderResvnItem FldLogsRefrbmtOrderResvnItem
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_FldLogsRmtePlntCtnItmsEnhcd.
-- 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: IFLREMCTNITMENH

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

Learn More