What is C_SecurityClassTP in SAP S/4HANA?

C_SecurityClassTP is a consumption CDS view in SAP S/4HANA. Security Class It contains 65 fields.

Which tables does C_SecurityClassTP read from?

C_SecurityClassTP reads data from: R_SecurityClassTP.

What VDM layer is C_SecurityClassTP?

C_SecurityClassTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SecurityClassTP

DDL: C_SECURITYCLASSTP Type: view_entity CONSUMPTION Package: RAP_FIN_TRM_SEC_SC_UI

65 Fields 1 Data Sources 2 Associations 2 OData Services

Security Class

C_SecurityClassTP is a Consumption CDS View that provides data about "Security Class" in SAP S/4HANA. It reads from 1 data source (R_SecurityClassTP) and exposes 65 fields with key field SecurityClass. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F8717, UI_MANAGE_SECURITY_CLASS). Part of development package RAP_FIN_TRM_SEC_SC_UI.

Data Sources (1)

Source	Alias	Join Type
R_SecurityClassTP	R_SecurityClassTP	projection

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_UserContactCard	_CreatedByUserContactCard	`$projection.SecurityClassCreatedByUser = _CreatedByUserContactCard.ContactCardID`
[0..1]	I_UserContactCard	_LastChangedByUserContactCard	`$projection.SecurityClassLastChangedByUser = _LastChangedByUserContactCard.ContactCardID`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Security Class	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MASTER	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view

OData Services (2)

Service	Binding	Version	Contract	Release
ASQL_F8717	ASQL_F8717		C2	NOT_RELEASED
UI_MANAGE_SECURITY_CLASS	UI_MANAGE_SECURITY_CLASS	V4	C1	NOT_RELEASED

Fields (65)

Key	Field	Source Table	Source Field	Description
KEY	SecurityClass		SecurityClass	Security Class ID
	FinancialInstrProductCategory		FinancialInstrProductCategory
	FinancialInstrumentProductType		FinancialInstrumentProductType
	SecurityClassName		SecurityClassName
	SecurityClassDescription		SecurityClassDescription	Security Class Description
	Issuer		Issuer	User Name
	SecurityClassIsListed		SecurityClassIsListed
	SecurityClassQuotation		SecurityClassQuotation
	IssueCurrency		IssueCurrency
	ScrtyClassGenClassification		ScrtyClassGenClassification	Gen. Sec. Classification
	SecurityClassTransferType		SecurityClassTransferType
	SecurityClassStatus		SecurityClassStatus
	SecurityClassIssuePriceValue		SecurityClassIssuePriceValue
	IssueRateInPercent		IssueRateInPercent	Issue Rate (%)
	ScrtyClMinimalNumberOfUnits		ScrtyClMinimalNumberOfUnits	Minimal Number of Units
	SecurityClassCreatedByUser		SecurityClassCreatedByUser
	SecurityClassCreationDate		SecurityClassCreationDate
	SecurityClassCreationTime		SecurityClassCreationTime
	SecurityClassLastChangedByUser		SecurityClassLastChangedByUser
	SecurityClassLastChangedDate		SecurityClassLastChangedDate
	SecurityClassLastChangedTime		SecurityClassLastChangedTime
	SecurityClassIssueStartDate		SecurityClassIssueStartDate	Issue Start Date
	SecurityClassNomPerStockValue		SecurityClassNomPerStockValue	Nominal Value
	SecurityClassStockCategory		SecurityClassStockCategory
	SecurityClassStockForm		SecurityClassStockForm	Stock Form
	SecurityClassFundType		SecurityClassFundType
	SecurityClassFundCategory		SecurityClassFundCategory	Fund Category
	SecurityClassFundVolumeAmount		SecurityClassFundVolumeAmount
	ScrtyClIssuePremiumInPercent		ScrtyClIssuePremiumInPercent	Issue Premium (%)
	SecurityClassTaxClassification		SecurityClassTaxClassification
	BondClassification		BondClassification	Bond Classification
	BondCertificateNominalAmount		BondCertificateNominalAmount	Nominal Amount
	BondCertPerTrdgUnitNominalAmt		BondCertPerTrdgUnitNominalAmt	Nom. Amount per Trd Unit
	SecurityClassFinalDueDate		SecurityClassFinalDueDate
	ScrtyClCalcPeriodStartDate		ScrtyClCalcPeriodStartDate
	ScrtyClCompatibleTermEndDate		ScrtyClCompatibleTermEndDate	Compatible Term End Date
	ScrtyClExpectedTermEndDate		ScrtyClExpectedTermEndDate
	ScrtyClIsCalcdWthNomPerTrdgUnt		ScrtyClIsCalcdWthNomPerTrdgUnt	Calc. w. Nom. per Trd Unit
	ScrtyClTrancheClassification		ScrtyClTrancheClassification	Tranche Classification
	SecurityClassAssetPool		SecurityClassAssetPool	Asset Pool ID
	IntrstCalcFnlDuDteIsIncld		IntrstCalcFnlDuDteIsIncld	Final Due Date Included
	SecurityClassShareholdingType		SecurityClassShareholdingType	Shareholding Type
	ScrtyClShareholdingStructure		ScrtyClShareholdingStructure	Shareholding Structure
	_CreatedByUserContactCard		_CreatedByUserContactCard
	_LastChangedByUserContactCard		_LastChangedByUserContactCard
	SecurityClassStatusNamelocalized
	FinInstrProductCategoryNamelocalized			Product Category Name
	FinancialInstrProdTypeNamelocalized
	BusinessPartnerName	_IssuerCounterParty	BusinessPartnerName	Issuer Name
	ScrtyClassGenClassfctnNamelocalized
	ScrtyClTransfTypeDescriptionlocalized
	ScrtyClassFundTypeDescriptionlocalized
	BondClassificationNamelocalized
	SecurityClassQuotationNamelocalized
	SecurityClassStockCategoryNamelocalized
	SecurityClassStockFormNamelocalized
	SecurityClassFundCategoryNamelocalized
	ScrtyClTrancheClassfctnNamelocalized
	ScrtyClassShareholdingTypeNamelocalized
	ScrtyClShareholdingStrucNamelocalized
	ScrtyClTaxClassificationNamelocalized
	virtualUICT_Hide_FG_Stockabap_boolean
	virtualUICT_Hide_FG_Fundabap_boolean
	virtualUICT_Hide_ST_Swapabap_boolean
	virtualUICT_Critlty_ScrtyClStatusint1

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_SecurityClassTP.
-- 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 C_SecurityClassTP AS
SELECT
  SecurityClass,
  FinancialInstrProductCategory,
  FinancialInstrumentProductType,
  SecurityClassName,
  SecurityClassDescription,
  Issuer,
  SecurityClassIsListed,
  SecurityClassQuotation,
  IssueCurrency,
  ScrtyClassGenClassification,
  SecurityClassTransferType,
  SecurityClassStatus,
  SecurityClassIssuePriceValue,
  IssueRateInPercent,
  ScrtyClMinimalNumberOfUnits,
  SecurityClassCreatedByUser,
  SecurityClassCreationDate,
  SecurityClassCreationTime,
  SecurityClassLastChangedByUser,
  SecurityClassLastChangedDate,
  SecurityClassLastChangedTime,
  SecurityClassIssueStartDate,
  SecurityClassNomPerStockValue,
  SecurityClassStockCategory,
  SecurityClassStockForm,
  SecurityClassFundType,
  SecurityClassFundCategory,
  SecurityClassFundVolumeAmount,
  ScrtyClIssuePremiumInPercent,
  SecurityClassTaxClassification,
  BondClassification,
  BondCertificateNominalAmount,
  BondCertPerTrdgUnitNominalAmt,
  SecurityClassFinalDueDate,
  ScrtyClCalcPeriodStartDate,
  ScrtyClCompatibleTermEndDate,
  ScrtyClExpectedTermEndDate,
  ScrtyClIsCalcdWthNomPerTrdgUnt,
  ScrtyClTrancheClassification,
  SecurityClassAssetPool,
  IntrstCalcFnlDuDteIsIncld,
  SecurityClassShareholdingType,
  ScrtyClShareholdingStructure,
  _SecurityClassStatus._Text.SecurityClassStatusName : localized AS SecurityClassStatusNamelocalized,
  _FinancialInstrProdCat._Text.FinInstrProductCategoryName : localized AS FinInstrProductCategoryNamelocalized,
  _FinInstrProdTypeValueHelp._Text.FinancialInstrProdTypeName : localized AS FinancialInstrProdTypeNamelocalized,
  _IssuerCounterParty.BusinessPartnerName AS BusinessPartnerName,
  _SecurityClassGenClassfctn._Text.ScrtyClassGenClassfctnName : localized AS ScrtyClassGenClassfctnNamelocalized,
  _SecurityClassTransferType._Text.ScrtyClTransfTypeDescription : localized AS ScrtyClTransfTypeDescriptionlocalized,
  _SecurityClassFundType._Text.ScrtyClassFundTypeDescription : localized AS ScrtyClassFundTypeDescriptionlocalized,
  _BondClassification._Text.BondClassificationName : localized AS BondClassificationNamelocalized,
  _SecurityClassQuotation._Text.SecurityClassQuotationName : localized AS SecurityClassQuotationNamelocalized,
  _SecurityClassStockCategory._Text.SecurityClassStockCategoryName : localized AS SecurityClassStockCategoryNamelocalized,
  _SecurityClassStockForm._Text.SecurityClassStockFormName : localized AS SecurityClassStockFormNamelocalized,
  _SecurityClassFundCategory._Text.SecurityClassFundCategoryName : localized AS SecurityClassFundCategoryNamelocalized,
  _ScrtyClTrancheClassfctnVH._Text.ScrtyClTrancheClassfctnName : localized AS ScrtyClTrancheClassfctnNamelocalized,
  _ScrtyClShareholdingType._Text.ScrtyClassShareholdingTypeName : localized AS ScrtyClassShareholdingTypeNamelocalized,
  _ScrtyClShareholdingStructure._Text.ScrtyClShareholdingStrucName : localized AS ScrtyClShareholdingStrucNamelocalized,
  _ScrtyClTaxClassification._Text.ScrtyClTaxClassificationName : localized AS ScrtyClTaxClassificationNamelocalized,
  virtual UICT_Hide_FG_Stock : abap_boolean AS virtualUICT_Hide_FG_Stockabap_boolean,
  virtual UICT_Hide_FG_Fund : abap_boolean AS virtualUICT_Hide_FG_Fundabap_boolean,
  virtual UICT_Hide_ST_Swap : abap_boolean AS virtualUICT_Hide_ST_Swapabap_boolean,
  virtual UICT_Critlty_ScrtyClStatus : int1 AS virtualUICT_Critlty_ScrtyClStatusint1
FROM R_SecurityClassTP
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON SecurityClassCreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON SecurityClassLastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
;

Depth:

C_SecurityClassTP view_entity

R_SecurityClassTP view_entity