ViewProvGetConInfo

DDL: CVIEW_PROV_CON_INFO SQL: VIEWINFODETAL Type: view Package: ODATA_VIEW_PROVISIONING
4 Fields 2 Data Sources

GetCon Detail with countfor publish stat

ViewProvGetConInfo is a CDS View that provides data about "GetCon Detail with countfor publish stat" in SAP S/4HANA. It reads from 2 data sources (ViewReplGetDataBlkInfo, ViewProvGetConDetails) and exposes 4 fields with key field ReplicationID. Part of development package ODATA_VIEW_PROVISIONING.

Data Sources (2)

SourceAliasJoin Type
ViewReplGetDataBlkInfo _blackInfo right_outer
ViewProvGetConDetails _conDetails from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VIEWINFODETAL view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label GetCon Detail with countfor publish stat view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ReplicationID ViewReplGetDataBlkInfo ReplicationId TgtSysUUID
PublishingCount PublishingCount
ConnectionName ViewReplGetDataBlkInfo ConnectionName
DataBlockingFlag DataBlocking

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 ViewProvGetConInfo.
-- 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: VIEWINFODETAL

CREATE VIEW ViewProvGetConInfo AS
SELECT
  _blackInfo.ReplicationId AS ReplicationID,
  PublishingCount,
  _blackInfo.ConnectionName AS ConnectionName,
  DataBlocking AS DataBlockingFlag
FROM ViewProvGetConDetails AS _conDetails
RIGHT OUTER JOIN ViewReplGetDataBlkInfo AS _blackInfo ON /* join condition not captured in parsed metadata */
;

Learn More