I_ScrtyClassGenClassfctnText

DDL: I_SCRTYCLASSGENCLASSFCTNTEXT SQL: ISCRTGENCLS Type: view BASIC Package: FTR_SECURITIES_CORE
5 Fields 1 Data Sources 2 Associations 2 OData Services

Security Class Gen Classification - Text

I_ScrtyClassGenClassfctnText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

ScrtyClGenClassificationText · Financial Operations

I_ScrtyClassGenClassfctnText is a Basic CDS View that provides data about "Security Class Gen Classification - Text" in SAP S/4HANA. It reads from 1 data source (tw22t) and exposes 5 fields with key fields Language, ScrtyClassGenClassification. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F1867, ASQL_F3966). Part of development package FTR_SECURITIES_CORE.

SAP Help Documentation

CategorySecurity Class General Classification
Data CategoryText
StatusReleased
Purpose
This CDS view provides access to the general security classification text in different languages. This CDS view provides the prerequisites for answering the following business questions: What is the name of the general security classification in a particular language?

Structure
Main CDS parameters and filters The main filters are: Language key Measures and attributes Some important attributes are: Language key General security classification General security classification text

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Language-Dependent Text,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the general security classification text in different languages.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What is the name of the general security classification in a particular language?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tw22t tw22t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_SecurityClassGenClassfctn _SecurityClassGenClassfctn $projection.ScrtyClassGenClassification = _SecurityClassGenClassfctn.ScrtyClassGenClassification

Annotations (17)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ISCRTGENCLS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Security Class Gen Classification - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ScrtyClassGenClassification view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name ScrtyClGenClassificationText view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F1867 ASQL_F1867 C2 NOT_RELEASED
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY ScrtyClassGenClassification alwpkl General Security Classification
ScrtyClassGenClassfctnName Name of the General Security Class Classification
_Language _Language
_SecurityClassGenClassfctn _SecurityClassGenClassfctn

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 I_ScrtyClassGenClassfctnText.
-- 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: ISCRTGENCLS

CREATE VIEW I_ScrtyClassGenClassfctnText AS
SELECT
  spras AS Language,
  alwpkl AS ScrtyClassGenClassification,
  cast (xlangbez as ftr_gen_gen_secu_class_name preserving type) AS ScrtyClassGenClassfctnName
FROM tw22t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_SecurityClassGenClassfctn AS _SecurityClassGenClassfctn ON ScrtyClassGenClassification = _SecurityClassGenClassfctn.ScrtyClassGenClassification  -- association [0..1]
;

Learn More