I_ClfnObjectClassForKeyDate

DDL: I_CLFNOBJECTCLASSFORKEYDATE SQL: INGCCLFN10 Type: view COMPOSITE

Clfn Class of Object for Key Date

I_ClfnObjectClassForKeyDate (Composite)

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

R&D Engineering

I_ClfnObjectClassForKeyDate is a Composite CDS View that provides data about "Clfn Class of Object for Key Date" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectClass) and exposes 14 fields with key fields ClfnObjectID, ClfnObjectTable, ClassInternalID, ClassType. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentCA-CL
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectClass ObjectClass from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ClfnClassForKeyDate _Class $projection.ClassInternalID = _Class.ClassInternalID

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCLFN10 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Clfn Class of Object for Key Date view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID I_ClfnObjectClass ClfnObjectID Key of Object to be Classified
KEY ClfnObjectTable I_ClfnObjectClass ClfnObjectTable Classifcation Object
KEY ClassInternalID I_ClfnObjectClass ClassInternalID Internal Class Number
KEY ClassType I_ClfnObjectClass ClassType Class Type
ClfnObjectInternalID I_ClfnObjectClass ClfnObjectInternalID Internal Object Number
ClfnStatus I_ClfnObjectClass ClfnStatus Classification status
ClassPositionNumber I_ClfnObjectClass ClassPositionNumber Sort position
ClassIsStandardClass I_ClfnObjectClass ClassIsStandardClass Class Is Standard Class Indicator
BOMIsRecursive I_ClfnObjectClass BOMIsRecursive Indicator: BOM is recursive
ChangeNumber I_ClfnObjectClass ChangeNumber Change Number
ValidityStartDate I_ClfnObjectClass ValidityStartDate Validity Start Date
ValidityEndDate I_ClfnObjectClass ValidityEndDate Valid-to date
LastChangeDateTime I_ClfnObjectClass LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
_Class _Class

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_ClfnObjectClassForKeyDate.
-- 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: INGCCLFN10
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_ClfnObjectClassForKeyDate AS
SELECT
  ObjectClass.ClfnObjectID AS ClfnObjectID,
  ObjectClass.ClfnObjectTable AS ClfnObjectTable,
  ObjectClass.ClassInternalID AS ClassInternalID,
  ObjectClass.ClassType AS ClassType,
  ObjectClass.ClfnObjectInternalID AS ClfnObjectInternalID,
  ObjectClass.ClfnStatus AS ClfnStatus,
  ObjectClass.ClassPositionNumber AS ClassPositionNumber,
  ObjectClass.ClassIsStandardClass AS ClassIsStandardClass,
  ObjectClass.BOMIsRecursive AS BOMIsRecursive,
  ObjectClass.ChangeNumber AS ChangeNumber,
  ObjectClass.ValidityStartDate AS ValidityStartDate,
  ObjectClass.ValidityEndDate AS ValidityEndDate,
  ObjectClass.LastChangeDateTime AS LastChangeDateTime
FROM I_ClfnObjectClass AS ObjectClass
LEFT OUTER JOIN I_ClfnClassForKeyDate AS _Class ON ClassInternalID = _Class.ClassInternalID  -- association [1..1]
;