I_FldLogsContainerList

DDL: I_FLDLOGSCONTAINERLIST SQL: IFLCTNLIST Type: view COMPOSITE
28 Fields 1 Data Sources 1 Associations

View for active container list

I_FldLogsContainerList is a Composite CDS View that provides data about "View for active container list" in SAP S/4HANA. It reads from 1 data source (I_FldLogsReturnContainerBasic) and exposes 28 fields with key fields FldLogsContainerID, DispatchedStartDate, FldLogsDispatchPlant, NumberOfCtnTripsPerDay. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsReturnContainerBasic _RetCtn from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsShptCtnUnit _ShptCtnUnit $projection.FldLogsContainerUnitUUID = _ShptCtnUnit.FldLogsContainerUnitUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLCTNLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
EndUserText.label View for active container list view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerID FldLogsContainerID Container ID
KEY DispatchedStartDate DispatchedStartDate Dispatch Date
KEY FldLogsDispatchPlant FldLogsDispatchPlant Plant
KEY NumberOfCtnTripsPerDay NumberOfCtnTripsPerDay Trip Counter
FldLogsContainerStatus FldLogsContainerStatus Container Status
FldLogsCtnProcessingStartDate FldLogsCtnProcessingStartDate Processing Start Dat
FldLogsCtnProcessingEndDate FldLogsCtnProcessingEndDate Processing End Date
FldLogsShipmentID FldLogsShipmentID Shipment ID
FldLogsContainerUUID FldLogsContainerUUID Container UUID
FieldLogisticsProcessType FieldLogisticsProcessType Process Type
FldLogsContainerUnitUUID FldLogsContainerUnitUUID Container Unit ID
FldLogsShptVoyageUUID FldLogsShptVoyageUUID Voyage UUID
FldLogsShptVoyageNumber FldLogsShptVoyageNumber Voyage Number
FldLogsVoyageSrceStage FldLogsVoyageSrceStage Source Stage
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
FieldLogisticsReceivingPlant FieldLogisticsReceivingPlant Receiving Plant
FldLogsSealNumber1 _ShptCtnUnit FldLogsSealNumber1 Seal Number
FldLogsSealNumber2 _ShptCtnUnit FldLogsSealNumber2 Seal Number
FldLogsSealNumber3 _ShptCtnUnit FldLogsSealNumber3 Seal Number
FldLogsSealNumber4 _ShptCtnUnit FldLogsSealNumber4 Seal Number
FldLogsSealNumber5 _ShptCtnUnit FldLogsSealNumber5 Seal Number
FldLogsCtnChangeDateTime FldLogsCtnChangeDateTime Changed On
FldLogsRcvdContainerIsReleased FldLogsRcvdContainerIsReleased Checkbox
FldLogsContainerOwner FldLogsContainerOwner Owner
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
FldLogsCtnActualDispatchPlant FldLogsCtnActualDispatchPlant Plant
FldLogsCtnActualReceivingPlant FldLogsCtnActualReceivingPlant Plant
_ShptCtnUnit _ShptCtnUnit

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_FldLogsContainerList.
-- 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: IFLCTNLIST

CREATE VIEW I_FldLogsContainerList AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsContainerStatus,
  FldLogsCtnProcessingStartDate,
  FldLogsCtnProcessingEndDate,
  FldLogsShipmentID,
  FldLogsContainerUUID,
  FieldLogisticsProcessType,
  FldLogsContainerUnitUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FieldLogisticsReceivingPlant,
  _ShptCtnUnit.FldLogsSealNumber1 AS FldLogsSealNumber1,
  _ShptCtnUnit.FldLogsSealNumber2 AS FldLogsSealNumber2,
  _ShptCtnUnit.FldLogsSealNumber3 AS FldLogsSealNumber3,
  _ShptCtnUnit.FldLogsSealNumber4 AS FldLogsSealNumber4,
  _ShptCtnUnit.FldLogsSealNumber5 AS FldLogsSealNumber5,
  FldLogsCtnChangeDateTime,
  FldLogsRcvdContainerIsReleased,
  FldLogsContainerOwner,
  IsMarkedForDeletion,
  FldLogsCtnActualDispatchPlant,
  FldLogsCtnActualReceivingPlant
FROM I_FldLogsReturnContainerBasic AS _RetCtn
LEFT OUTER JOIN I_FldLogsShptCtnUnit AS _ShptCtnUnit ON FldLogsContainerUnitUUID = _ShptCtnUnit.FldLogsContainerUnitUUID  -- association [0..1]
;

Learn More