I_IPUTSSeqCoverageRep

DDL: I_IPUTSSEQCOVERAGEREP Type: view_entity BASIC Package: IPUTS_MAIN
11 Fields 1 Data Sources 2 Associations

SQL Coverage Repository

I_IPUTSSeqCoverageRep is a Basic CDS View that provides data about "SQL Coverage Repository" in SAP S/4HANA. It reads from 1 data source (iputs_a_sqlcover) and exposes 11 fields with key fields IPUTSTestPlanGroupUUID, IPUTSTestPlanID, IPUTSTestProcessID, IPUTSCloudRelease, IPUTSObjectType. It has 2 associations to related views. Part of development package IPUTS_MAIN.

Data Sources (1)

SourceAliasJoin Type
iputs_a_sqlcover iputs_a_sqlcover from

Associations (2)

CardinalityTargetAliasCondition
[1..1] start_s_pr_hdr _hdr $projection.IPUTSTestProcessID = _hdr.process_id
[0..*] start_tp_vars _tp_variant $projection.IPUTSTestPlanID = _tp_variant.testplan_id

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SQL Coverage Repository view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY IPUTSTestPlanGroupUUID tpgroup_id Test Plan Group
KEY IPUTSTestPlanID testplan_id Testplan Id
KEY IPUTSTestProcessID process_id Process Instance ID
KEY IPUTSCloudRelease cloud_release Cloud Release
KEY IPUTSObjectType object_type Type
KEY IPUTSObjectName object_name Technical Name
IPUTSPackageName package_name Package Name
IPUTSApplicationComponent appl_component Component
IPUTSSystemID system_id System ID
IPUTSTestProcessName _hdr process_name Process Name
IPUTSVariantName _tp_variant variant_name Variant Name

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_IPUTSSeqCoverageRep.
-- 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_IPUTSSeqCoverageRep AS
SELECT
  tpgroup_id AS IPUTSTestPlanGroupUUID,
  testplan_id AS IPUTSTestPlanID,
  process_id AS IPUTSTestProcessID,
  cloud_release AS IPUTSCloudRelease,
  object_type AS IPUTSObjectType,
  object_name AS IPUTSObjectName,
  package_name AS IPUTSPackageName,
  appl_component AS IPUTSApplicationComponent,
  system_id AS IPUTSSystemID,
  _hdr.process_name AS IPUTSTestProcessName,
  _tp_variant.variant_name AS IPUTSVariantName
FROM iputs_a_sqlcover
LEFT OUTER JOIN start_s_pr_hdr AS _hdr ON IPUTSTestProcessID = _hdr.process_id  -- association [1..1]
LEFT OUTER JOIN start_tp_vars AS _tp_variant ON IPUTSTestPlanID = _tp_variant.testplan_id  -- association [0..*]
;

Learn More