I_SADL_GW_CPLHDR

DDL: I_SADL_GW_CPLHDR SQL: IV_SADL_CPLHDR Type: view

CPL Header Interface

I_SADL_GW_CPLHDR is a CDS View that provides data about "CPL Header Interface" in SAP S/4HANA. It reads from 1 data source (sadl_gw_cplhdr) and exposes 10 fields with key field LogHandle. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
sadl_gw_cplhdr sadl_gw_cplhdr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SADL_GW_CPLDATA _Item $projection.LogHandle = _Item.ParentID
[1..1] I_SADL_GW_CPLUSER _User $projection.CreatedBy = _User.bname

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName IV_SADL_CPLHDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CPL Header Interface view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LogHandle loghandle LogsHandle
Process process Trans.
Object object TRFM Object
ObjectName object_name Technical Name
CreatedBy created_by Version Created By
CreatedOn created_on Variant created on
StartTime start_time Time Stamp
EndTime end_time Time Stamp
_Item _Item
_User _User

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_SADL_GW_CPLHDR.
-- 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: IV_SADL_CPLHDR

CREATE VIEW I_SADL_GW_CPLHDR AS
SELECT
  LogHandle,
  Process,
  Object,
  object_name AS ObjectName,
  created_by AS CreatedBy,
  created_on AS CreatedOn,
  start_time AS StartTime,
  end_time AS EndTime
FROM sadl_gw_cplhdr
LEFT OUTER JOIN I_SADL_GW_CPLDATA AS _Item ON LogHandle = _Item.ParentID  -- association [0..*]
LEFT OUTER JOIN I_SADL_GW_CPLUSER AS _User ON CreatedBy = _User.bname  -- association [1..1]
;