R_ClfnHistlObjectClassTP

DDL: R_CLFNHISTLOBJECTCLASSTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 1 Associations

Clfn Historical Object Class - TP

R_ClfnHistlObjectClassTP is a Transactional CDS View that provides data about "Clfn Historical Object Class - TP" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectClass) and exposes 16 fields with key fields SAPObjectNodeType, ClfnObjectID, ClassType, Class, ChangeNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectClass ObjectClass from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ClfnClass _Class $projection.ClassType = _Class.ClassType and $projection.class = _Class.Class

Annotations (10)

NameValueLevelField
EndUserText.label Clfn Historical Object Class - TP view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.query.implementedBy ABAP:CL_NGC_RAP_EML_QRY view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SAPObjectNodeType
KEY ClfnObjectID I_ClfnObjectClass ClfnObjectID
KEY ClassType I_ClfnObjectClass ClassType X Flag
KEY Class _Class Class User Group
KEY ChangeNumber I_ClfnObjectClass ChangeNumber Change Number
ClassInternalID I_ClfnObjectClass ClassInternalID Int class no.
ClfnObjectInternalID I_ClfnObjectClass ClfnObjectInternalID
ClassPositionNumber I_ClfnObjectClass ClassPositionNumber Pos.
ClfnStatus I_ClfnObjectClass ClfnStatus Status
ClassIsStandardClass I_ClfnObjectClass ClassIsStandardClass Class Is Standard Class
LastChangeDateTime I_ClfnObjectClass LastChangeDateTime Timestamp
ValidityStartDate I_ClfnObjectClass ValidityStartDate Validity Start Date
ValidityEndDate I_ClfnObjectClass ValidityEndDate ValidTo
IsDeleted I_ClfnObjectClass IsDeleted TRUE
_Class _Class
_Object _Object

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_ClfnHistlObjectClassTP.
-- 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_ClfnHistlObjectClassTP AS
SELECT
  cast ('' as sbo_node_type ) AS SAPObjectNodeType,
  ObjectClass.ClfnObjectID AS ClfnObjectID,
  ObjectClass.ClassType AS ClassType,
  _Class.Class AS Class,
  ObjectClass.ChangeNumber AS ChangeNumber,
  ObjectClass.ClassInternalID AS ClassInternalID,
  ObjectClass.ClfnObjectInternalID AS ClfnObjectInternalID,
  ObjectClass.ClassPositionNumber AS ClassPositionNumber,
  ObjectClass.ClfnStatus AS ClfnStatus,
  ObjectClass.ClassIsStandardClass AS ClassIsStandardClass,
  ObjectClass.LastChangeDateTime AS LastChangeDateTime,
  ObjectClass.ValidityStartDate AS ValidityStartDate,
  ObjectClass.ValidityEndDate AS ValidityEndDate,
  ObjectClass.IsDeleted AS IsDeleted
FROM I_ClfnObjectClass AS ObjectClass
LEFT OUTER JOIN I_ClfnClass AS _Class ON ClassType = _Class.ClassType AND class = _Class.Class  -- association [1..1]
;

Learn More