C_FldLogsContainerItemEmail

DDL: C_FLDLOGSCONTAINERITEMEMAIL SQL: ICFLCTNEMAIL Type: view CONSUMPTION Package: FLOG_RETURN_PROCG_BASE
17 Fields 1 Data Sources

Container Item Email Template

C_FldLogsContainerItemEmail is a Consumption CDS View that provides data about "Container Item Email Template" in SAP S/4HANA. It reads from 1 data source (I_FldLogsContainerItemEmail) and exposes 17 fields with key fields FldLogsContainerID, DispatchedStartDate, FldLogsDispatchPlant, NumberOfCtnTripsPerDay, FldLogsReferenceDocumentNumber. Part of development package FLOG_RETURN_PROCG_BASE.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsContainerItemEmail I_FldLogsContainerItemEmail from

Annotations (11)

NameValueLevelField
EndUserText.label Container Item Email Template view
AbapCatalog.sqlViewName ICFLCTNEMAIL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (17)

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
KEY FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID
Material Material Vehicle Model
RetblQtyInOrderUnit RetblQtyInOrderUnit
RetblQtyOrderUnit RetblQtyOrderUnit
FldLogsDestStorLocID FldLogsDestStorLocID Location
FldLogsSrceStorLocID FldLogsSrceStorLocID Location
FldLogsCtnQuickAction FldLogsCtnQuickAction Handling Decision
MaterialName MaterialName Material Description
FldLogsCtnItmLastProcessingMsg FldLogsCtnItmLastProcessingMsg
FldLogsCtnQuickActionText FldLogsCtnQuickActionText
SupplyingPlant SupplyingPlant Supplying Plant
FldLogsRetContainerItemURL FldLogsRetContainerItemURL

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 C_FldLogsContainerItemEmail.
-- 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: ICFLCTNEMAIL

CREATE VIEW C_FldLogsContainerItemEmail AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  FldLogsShptItmHndlgUnitID,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  FldLogsDestStorLocID,
  FldLogsSrceStorLocID,
  FldLogsCtnQuickAction,
  MaterialName,
  FldLogsCtnItmLastProcessingMsg,
  FldLogsCtnQuickActionText,
  SupplyingPlant,
  FldLogsRetContainerItemURL
FROM I_FldLogsContainerItemEmail
;

Learn More