I_FldLogsProcessReturnItem

DDL: I_FLDLOGSPROCESSRETURNITEM Type: view_entity COMPOSITE
12 Fields 1 Data Sources 4 Associations

Process Return Items

I_FldLogsProcessReturnItem is a Composite CDS View that provides data about "Process Return Items" in SAP S/4HANA. It reads from 1 data source (I_FldLogsProcReturnItemBasic) and exposes 12 fields with key field FldLogsReturnItemUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsProcReturnItemBasic I_FldLogsProcReturnItemBasic from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_FldLogsProcRetActyTypeText _ActivityTypeText $projection.FldLogsActivityType = _ActivityTypeText.FldLogsActivityType
[0..1] I_FldLogsProcessReturnActivity _Activity $projection.FldLogsActivityID = _Activity.FldLogsActivityID
[0..1] I_FldLogsProcRetDocumentCount _DocCount $projection.FldLogsReturnItemUUID = _DocCount.FldLogsReturnItemUUID
[0..1] I_FldLogsProcReturnItemComment _Comments $projection.FldLogsReturnItemUUID = _Comments.FldLogsReturnItemUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Process Return Items view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FldLogsReturnItemUUID FldLogsReturnItemUUID Return Item UUID
FldLogsReturnHeaderUUID FldLogsReturnHeaderUUID Return Header UUID
FldLogsActivitySequenceID FldLogsActivitySequenceID Activity Sequence ID
FldLogsActivityID FldLogsActivityID Activity ID
FldLogsRetdQtyInOrderUnit FldLogsRetdQtyInOrderUnit Quantity
FldLogsRetdQtyOrderUnit FldLogsRetdQtyOrderUnit Order Unit
FldLogsActivityType FldLogsActivityType Inward/Outward Acty
NmbrOfProcRetDocuments _DocCount NmbrOfProcRetDocuments
FldLogsActivityComment _Comments FldLogsActivityComment Content of note
CreatedOnDateTime CreatedOnDateTime Created On
LastChangeDateTime LastChangeDateTime Timestamp
_ActivityTypeText _ActivityTypeText

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_FldLogsProcessReturnItem.
-- 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.

CREATE VIEW I_FldLogsProcessReturnItem AS
SELECT
  FldLogsReturnItemUUID,
  FldLogsReturnHeaderUUID,
  FldLogsActivitySequenceID,
  FldLogsActivityID,
  FldLogsRetdQtyInOrderUnit,
  FldLogsRetdQtyOrderUnit,
  FldLogsActivityType,
  _DocCount.NmbrOfProcRetDocuments AS NmbrOfProcRetDocuments,
  _Comments.FldLogsActivityComment AS FldLogsActivityComment,
  CreatedOnDateTime,
  LastChangeDateTime
FROM I_FldLogsProcReturnItemBasic
LEFT OUTER JOIN I_FldLogsProcRetActyTypeText AS _ActivityTypeText ON FldLogsActivityType = _ActivityTypeText.FldLogsActivityType  -- association [0..*]
LEFT OUTER JOIN I_FldLogsProcessReturnActivity AS _Activity ON FldLogsActivityID = _Activity.FldLogsActivityID  -- association [0..1]
LEFT OUTER JOIN I_FldLogsProcRetDocumentCount AS _DocCount ON FldLogsReturnItemUUID = _DocCount.FldLogsReturnItemUUID  -- association [0..1]
LEFT OUTER JOIN I_FldLogsProcReturnItemComment AS _Comments ON FldLogsReturnItemUUID = _Comments.FldLogsReturnItemUUID  -- association [0..1]
;

Learn More