What is R_SecurityClassRatingTP in SAP S/4HANA?

R_SecurityClassRatingTP is a transactional CDS view in SAP S/4HANA. Security Class Rating It contains 11 fields.

Which tables does R_SecurityClassRatingTP read from?

R_SecurityClassRatingTP reads data from: I_SecuritiesClassRating.

What VDM layer is R_SecurityClassRatingTP?

R_SecurityClassRatingTP is classified as a Transactional view that supports create, update, and delete operations.

R_SecurityClassRatingTP

DDL: R_SECURITYCLASSRATINGTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_SEC_SC

11 Fields 1 Data Sources 2 Associations

Security Class Rating

R_SecurityClassRatingTP is a Transactional CDS View that provides data about "Security Class Rating" in SAP S/4HANA. It reads from 1 data source (I_SecuritiesClassRating) and exposes 11 fields with key fields SecurityClass, SecurityClassRatingProcedure, ScrtyClRatingValidityStartDate. It has 2 associations to related views. Part of development package RAP_FIN_TRM_SEC_SC.

Data Sources (1)

Source	Alias	Join Type
I_SecuritiesClassRating	I_SecuritiesClassRating	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_BPRatingTrend	_RatingTrend	`$projection.SecurityClassRatingTrend = _RatingTrend.BusinessPartnerRatingTrend`
[0..1]	I_BPRatingProcedure	_RatingProcedure	`$projection.SecurityClassRatingProcedure = _RatingProcedure.BusinessPartnerRatingProcedure`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
EndUserText.label	Security Class Rating	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (11)

Key	Field	Source Field	Description
KEY	SecurityClass	SecurityClass	Security Class
KEY	SecurityClassRatingProcedure	SecuritiesClassRatingProcedure	Valuation Procedure
KEY	ScrtyClRatingValidityStartDate	SecuritiesClRatgValdtyStrtDate
	ScrtyClRatingValidityEndDate	SecuritiesClRatgValdtyEndDate
	ScrtyClRatingEnteredOnDate	ScrtyClRatingEnteredOnDate
	SecurityClassRating	SecuritiesClassRating
	SecurityClassRatingTrend	SecuritiesClassRatingTrend
	SecurityClassRatingDescription	SecuritiesClassRatingDesc
	_SecurityClass	_SecurityClass
	_RatingTrend	_RatingTrend
	_RatingProcedure	_RatingProcedure

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 R_SecurityClassRatingTP.
-- 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 R_SecurityClassRatingTP AS
SELECT
  SecurityClass,
  SecuritiesClassRatingProcedure AS SecurityClassRatingProcedure,
  SecuritiesClRatgValdtyStrtDate AS ScrtyClRatingValidityStartDate,
  SecuritiesClRatgValdtyEndDate AS ScrtyClRatingValidityEndDate,
  ScrtyClRatingEnteredOnDate,
  SecuritiesClassRating AS SecurityClassRating,
  SecuritiesClassRatingTrend AS SecurityClassRatingTrend,
  SecuritiesClassRatingDesc AS SecurityClassRatingDescription
FROM I_SecuritiesClassRating
LEFT OUTER JOIN I_BPRatingTrend AS _RatingTrend ON SecurityClassRatingTrend = _RatingTrend.BusinessPartnerRatingTrend  -- association [0..1]
LEFT OUTER JOIN I_BPRatingProcedure AS _RatingProcedure ON SecurityClassRatingProcedure = _RatingProcedure.BusinessPartnerRatingProcedure  -- association [0..1]
;

Depth:

R_SecurityClassRatingTP view_entity

I_SecuritiesClassRating view