R_ClfnClassCharcOrglAreaTP

DDL: R_CLFNCLASSCHARCORGLAREATP Type: view_entity TRANSACTIONAL Package: NGC_CORE_VDM
12 Fields 1 Data Sources 2 Associations

Clfn Class Characteristic Orgl Area - TP

R_ClfnClassCharcOrglAreaTP is a Transactional CDS View that provides data about "Clfn Class Characteristic Orgl Area - TP" in SAP S/4HANA. It reads from 1 data source (I_ClfnClassCharcOrglArea) and exposes 12 fields with key fields Class, ClassType, ChangeNumber, Characteristic, ClfnOrganizationalAreaCode. It has 2 associations to related views. Part of development package NGC_CORE_VDM.

Data Sources (1)

SourceAliasJoin Type
I_ClfnClassCharcOrglArea I_ClfnClassCharcOrglArea from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ClfnClassTP _Class $projection.Class = _Class.Class and $projection.ClassType = _Class.ClassType
[1..1] I_ClfnCharcTimeIndep _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Clfn Class Characteristic Orgl Area - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Class Class User Group
KEY ClassType ClassType X Flag
KEY ChangeNumber ChangeNumber Change Number
KEY Characteristic _Characteristic Characteristic Field Name
KEY ClfnOrganizationalAreaCode ClfnOrganizationalAreaCode
CharcInternalID CharcInternalID Characteristic Internal ID
ClassInternalID ClassInternalID Int class no.
LastChangedDateTime LastChangedDateTime Time Stamp
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
_Class _Class
_Parent _Parent

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_ClfnClassCharcOrglAreaTP.
-- 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_ClfnClassCharcOrglAreaTP AS
SELECT
  Class,
  ClassType,
  ChangeNumber,
  _Characteristic.Characteristic AS Characteristic,
  ClfnOrganizationalAreaCode,
  CharcInternalID,
  ClassInternalID,
  LastChangedDateTime,
  ValidityStartDate,
  ValidityEndDate
FROM I_ClfnClassCharcOrglArea
LEFT OUTER JOIN R_ClfnClassTP AS _Class ON Class = _Class.Class AND ClassType = _Class.ClassType  -- association [1..1]
LEFT OUTER JOIN I_ClfnCharcTimeIndep AS _Characteristic ON CharcInternalID = _Characteristic.CharcInternalID  -- association [1..1]
;

Learn More