I_LogsProcFlowStsCollItem

DDL: I_LOGSPROCFLOWSTSCOLLITEM Type: view_entity BASIC

LOPFT Status Collection Item

I_LogsProcFlowStsCollItem is a Basic CDS View that provides data about "LOPFT Status Collection Item" in SAP S/4HANA. It reads from 1 data source (lopft_status_itm) and exposes 5 fields with key field LogsProcFlwStsCollItemUUID.

Data Sources (1)

SourceAliasJoin Type
lopft_status_itm lopft_status_itm from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label LOPFT Status Collection Item view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY LogsProcFlwStsCollItemUUID item_uuid Item UUID
LogsProcFlwStsCollStatusUUID header_uuid UUID
LogsProcFlwStsCollStatusID status_id Trans Doc Status
LogsProcFlwStsCollStatusValue status_value Status Value
LastChangeDateTime lastchangedatetime Timestamp

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_LogsProcFlowStsCollItem.
-- 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_LogsProcFlowStsCollItem AS
SELECT
  item_uuid AS LogsProcFlwStsCollItemUUID,
  header_uuid AS LogsProcFlwStsCollStatusUUID,
  status_id AS LogsProcFlwStsCollStatusID,
  status_value AS LogsProcFlwStsCollStatusValue,
  LastChangeDateTime
FROM lopft_status_itm
;