C_ProdCmplncRatingVH

DDL: C_PRODCMPLNCRATINGVH SQL: CPCPRPTRTGVH Type: view CONSUMPTION Package: EHFND_PRODUCT_MASTER_COMN
3 Fields 1 Data Sources 7 OData Services 1 Fiori Apps

Rating of Product Compliance Property VH

C_ProdCmplncRatingVH is a Consumption CDS View that provides data about "Rating of Product Compliance Property VH" in SAP S/4HANA. It reads from 1 data source (I_ProdCmplncRating) and exposes 3 fields. It is exposed through 7 OData services (ASQL_F4510, ASQL_F4655, ASQL_F5034, ...). It is used in 1 Fiori application: Manage Uses. Part of development package EHFND_PRODUCT_MASTER_COMN.

Data Sources (1)

SourceAliasJoin Type
I_ProdCmplncRating I_ProdCmplncRating from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPCPRPTRTGVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Rating of Product Compliance Property VH view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey PCPrptyRating view
Search.searchable true view

OData Services (7)

ServiceBindingVersionContractRelease
ASQL_F4510 ASQL_F4510 C2 NOT_RELEASED
ASQL_F4655 ASQL_F4655 C2 NOT_RELEASED
ASQL_F5034 ASQL_F5034 C2 NOT_RELEASED
ASQL_F5087 ASQL_F5087 C2 NOT_RELEASED
ASQL_F5467 ASQL_F5467 C2 NOT_RELEASED
ASQL_F7929 ASQL_F7929 C2 NOT_RELEASED
UI_EHS_FND_USE_MAN UI_EHS_FND_USE_MAN V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5467 Manage Uses Transactional

Manage Uses

Business Role: Product Stewardship Specialist - Product Compliance

With this feature, you can create, edit, and release uses of an unpackaged product that you have selected in the Manage Basic Compliance Data - Unpackaged Products app. This information is required in section 1.2 of a safety data sheet.

Fields (3)

KeyFieldSource TableSource FieldDescription
Required
PCPrptyRatingText_H
PCPrptyRatingTextasPCPrptyRatingText

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 C_ProdCmplncRatingVH.
-- 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: CPCPRPTRTGVH

CREATE VIEW C_ProdCmplncRatingVH AS
SELECT
  _ProdCmplncRatingText[ 1: Language = $session.system_language ].PCPrptyRatingText AS PCPrptyRatingText_H,
  coalesce( _ProdCmplncRatingText[ 1: Language = $session.system_language ].PCPrptyRatingText, _ProdCmplncRatingText[ 1: Language = 'E' ].PCPrptyRatingText ) as PCPrptyRatingText AS PCPrptyRatingTextasPCPrptyRatingText
FROM I_ProdCmplncRating
;

Learn More