I_Relstratclass

DDL: I_RELSTRATCLASS SQL: IRELCLASS Type: view BASIC Package: VDM_MM_PUR_REL_STRAT
12 Fields 1 Data Sources 2 Associations

Manage Class Basic View

I_Relstratclass is a Basic CDS View that provides data about "Manage Class Basic View" in SAP S/4HANA. It reads from 1 data source (klah) and exposes 12 fields with key field InternalClassNumber. It has 2 associations to related views. Part of development package VDM_MM_PUR_REL_STRAT.

Data Sources (1)

SourceAliasJoin Type
klah klah from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_Relstartcharinclass _Relstartcharinclass $projection.InternalClassNumber = _Relstartcharinclass.InternalClassNumber
[1..*] I_Relclassdescription _Text $projection.InternalClassNumber = _Text.InternalClassNumber

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IRELCLASS view
AbapCatalog.compiler.compareFilter true view
ObjectModel.compositionRoot true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Class Basic View view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InternalClassNumber clint Int class no.
ClassNumber class User Group
OriginalStatusText statu Vehicle Status
ValidityStartDate vondt Valid From
ValidityEndDate bisdt Valid to
CreatedByUser aname Creator
LastChangedByUser vname Volatility Name
ClassTypeName klart Class Type
RelStrgyClAuthorizationGroup klah bgrkp Class maint.
ClassDescription _Text ClassDescription Description
_Relstartcharinclass _Relstartcharinclass
_Text _Text

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_Relstratclass.
-- 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: IRELCLASS

CREATE VIEW I_Relstratclass AS
SELECT
  clint AS InternalClassNumber,
  class AS ClassNumber,
  statu AS OriginalStatusText,
  vondt AS ValidityStartDate,
  bisdt AS ValidityEndDate,
  aname AS CreatedByUser,
  vname AS LastChangedByUser,
  klart AS ClassTypeName,
  klah.bgrkp AS RelStrgyClAuthorizationGroup,
  _Text.ClassDescription AS ClassDescription
FROM klah
LEFT OUTER JOIN I_Relstartcharinclass AS _Relstartcharinclass ON InternalClassNumber = _Relstartcharinclass.InternalClassNumber  -- association [0..*]
LEFT OUTER JOIN I_Relclassdescription AS _Text ON InternalClassNumber = _Text.InternalClassNumber  -- association [1..*]
;

Learn More