C_FldLogsHndlgUnitItemEmail

DDL: C_FLDLOGSHNDLGUNITITEMEMAIL SQL: CFLHUEMAIL Type: view CONSUMPTION Package: FLOG_RETURN_PROCG_BASE
16 Fields 1 Data Sources

Handling Unit Item Email Template

C_FldLogsHndlgUnitItemEmail is a Consumption CDS View that provides data about "Handling Unit Item Email Template" in SAP S/4HANA. It reads from 1 data source (I_FldLogsHndlgUnitItemEmail) and exposes 16 fields with key fields FldLogsShptItemUUID, FldLogsShptItmHndlgUnitID, FldLogsReferenceDocumentNumber. Part of development package FLOG_RETURN_PROCG_BASE.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsHndlgUnitItemEmail I_FldLogsHndlgUnitItemEmail from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFLHUEMAIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
EndUserText.label Handling Unit Item Email Template view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FldLogsShptItemUUID FldLogsShptItemUUID Shipment Item ID
KEY FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
FldLogsDispatchPlant FldLogsDispatchPlant Plant
DispatchedStartDate DispatchedStartDate Dispatch Date
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_FldLogsHndlgUnitItemEmail.
-- 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: CFLHUEMAIL

CREATE VIEW C_FldLogsHndlgUnitItemEmail AS
SELECT
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  FldLogsReferenceDocumentNumber,
  FldLogsDispatchPlant,
  DispatchedStartDate,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  FldLogsDestStorLocID,
  FldLogsSrceStorLocID,
  FldLogsCtnQuickAction,
  MaterialName,
  FldLogsCtnItmLastProcessingMsg,
  FldLogsCtnQuickActionText,
  SupplyingPlant,
  FldLogsRetContainerItemURL
FROM I_FldLogsHndlgUnitItemEmail
;

Learn More