I_FldLogsCtnItmDispatchReady

DDL: I_FLDLOGSCTNITMDISPATCHREADY SQL: IFLCTNITMRDYDSP Type: view COMPOSITE
19 Fields 2 Data Sources 1 Associations

Container Items Ready to Dispatch

I_FldLogsCtnItmDispatchReady is a Composite CDS View that provides data about "Container Items Ready to Dispatch" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsReturnContainerBasic, I_FldLogsReturnItem) and exposes 19 fields with key fields FldLogsContainerID, DispatchedStartDate, FldLogsDispatchPlant, NumberOfCtnTripsPerDay, FldLogsReferenceDocumentNumber. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_FldLogsReturnContainerBasic _CntList inner
I_FldLogsReturnItem _ReturnItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_FldLogsMaterialText _MatText $projection.Material = _MatText.Material

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLCTNITMRDYDSP 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
EndUserText.label Container Items Ready to Dispatch view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerID I_FldLogsReturnItem FldLogsContainerID Container ID
KEY DispatchedStartDate I_FldLogsReturnContainerBasic DispatchedStartDate Dispatch Date
KEY FldLogsDispatchPlant I_FldLogsReturnItem FldLogsRemotePlant Plant
KEY NumberOfCtnTripsPerDay I_FldLogsReturnContainerBasic NumberOfCtnTripsPerDay Trip Counter
KEY FldLogsReferenceDocumentNumber I_FldLogsReturnItem FldLogsReferenceDocumentNumber Reference Doc Number
Material I_FldLogsReturnItem Material Vehicle Model
LoadingQtyInOrderUnit I_FldLogsReturnItem LoadingQtyInOrderUnit
RetblQtyOrderUnit I_FldLogsReturnItem RetblQtyOrderUnit
RetblQtyInBaseUnit I_FldLogsReturnItem RetblQtyInBaseUnit
RetblQtyBaseUnit I_FldLogsReturnItem RetblQtyBaseUnit
RemoteStorageLocation I_FldLogsReturnItem RemoteStorageLocation
SupplyingStorageLocation I_FldLogsReturnItem SupplyingStorageLocation Location
FldLogsReturnStatus I_FldLogsReturnItem FldLogsReturnStatus
FldLogsRecommendedAction I_FldLogsReturnItem FldLogsRecommendedAction Recommended Action
FldLogsSupplyProcess I_FldLogsReturnItem FldLogsSupplyProcess Supply Process
FldLogsCtnItmChangeDateTime I_FldLogsReturnContainerBasic FldLogsCtnChangeDateTime Changed On
MaterialName _MatText MaterialName Material Description
IsMarkedForDeletion I_FldLogsReturnItem IsMarkedForDeletion Purch.org. data
_MatText _MatText

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_FldLogsCtnItmDispatchReady.
-- 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: IFLCTNITMRDYDSP

CREATE VIEW I_FldLogsCtnItmDispatchReady AS
SELECT
  _ReturnItem.FldLogsContainerID AS FldLogsContainerID,
  _CntList.DispatchedStartDate AS DispatchedStartDate,
  _ReturnItem.FldLogsRemotePlant AS FldLogsDispatchPlant,
  _CntList.NumberOfCtnTripsPerDay AS NumberOfCtnTripsPerDay,
  _ReturnItem.FldLogsReferenceDocumentNumber AS FldLogsReferenceDocumentNumber,
  _ReturnItem.Material AS Material,
  _ReturnItem.LoadingQtyInOrderUnit AS LoadingQtyInOrderUnit,
  _ReturnItem.RetblQtyOrderUnit AS RetblQtyOrderUnit,
  _ReturnItem.RetblQtyInBaseUnit AS RetblQtyInBaseUnit,
  _ReturnItem.RetblQtyBaseUnit AS RetblQtyBaseUnit,
  _ReturnItem.RemoteStorageLocation AS RemoteStorageLocation,
  _ReturnItem.SupplyingStorageLocation AS SupplyingStorageLocation,
  _ReturnItem.FldLogsReturnStatus AS FldLogsReturnStatus,
  _ReturnItem.FldLogsRecommendedAction AS FldLogsRecommendedAction,
  _ReturnItem.FldLogsSupplyProcess AS FldLogsSupplyProcess,
  _CntList.FldLogsCtnChangeDateTime AS FldLogsCtnItmChangeDateTime,
  _MatText.MaterialName AS MaterialName,
  _ReturnItem.IsMarkedForDeletion AS IsMarkedForDeletion
FROM I_FldLogsReturnItem AS _ReturnItem
INNER JOIN I_FldLogsReturnContainerBasic AS _CntList ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FldLogsMaterialText AS _MatText ON Material = _MatText.Material  -- association [0..*]
;

Learn More