P_CmplRqVersListTypeCount

DDL: P_CMPLRQVERSLISTTYPECOUNT SQL: PCRVREGLTYPECNT Type: view CONSUMPTION Package: EHFND_BO_COMPLIANCE_REQ
3 Fields 1 Data Sources

Counts Lists per CmplRqVers and ListType

P_CmplRqVersListTypeCount is a Consumption CDS View that provides data about "Counts Lists per CmplRqVers and ListType" in SAP S/4HANA. It reads from 1 data source (I_CmplRqVersSubstanceList) and exposes 3 fields with key fields CmplRqVersUUID, SubstanceListType. Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqVersSubstanceList I_CmplRqVersSubstanceList from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCRVREGLTYPECNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersUUID CmplRqVersUUID NodeID
KEY SubstanceListType SubstanceListType Regulatory List Type
NumberOfLists

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 P_CmplRqVersListTypeCount.
-- 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: PCRVREGLTYPECNT

CREATE VIEW P_CmplRqVersListTypeCount AS
SELECT
  CmplRqVersUUID,
  SubstanceListType,
  count(*) AS NumberOfLists
FROM I_CmplRqVersSubstanceList
;

Learn More