I_ClfnClassHierCharcForKeyDate

DDL: I_CLFNCLASSHIERCHARCFORKEYDATE SQL: INGCCLS10 Type: view COMPOSITE Package: NGC_CORE_VDM
21 Fields 3 Data Sources 1 Associations

Clfn Cl Hier Characteristic For Key Date

I_ClfnClassHierCharcForKeyDate is a Composite CDS View that provides data about "Clfn Cl Hier Characteristic For Key Date" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharcBasic, I_ClfnClassCharcBasic, I_ClfnClassSuperiorForKeyDate) and exposes 21 fields with key fields ClassInternalID, AncestorClassInternalID, CharcInternalID. It has 1 association to related views. Part of development package NGC_CORE_VDM.

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharcBasic Characteristic inner
I_ClfnClassCharcBasic ClassCharcBasic inner
I_ClfnClassSuperiorForKeyDate I_ClfnClassSuperiorForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ClfnClass _Class $projection.ClassInternalID = _Class.ClassInternalID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCLS10 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Clfn Cl Hier Characteristic For Key Date view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ClassInternalID ClassSuperior ClassInternalID Int class no.
KEY AncestorClassInternalID ClassSuperior AncestorClassInternalID Int class no.
KEY CharcInternalID I_ClfnClassCharcBasic CharcInternalID Characteristic Internal ID
CharcPositionNumber I_ClfnClassCharcBasic CharcPositionNumber WBS Element
ClassType ClassSuperior ClassType X Flag
Class ClassSuperior Class User Group
AncestorClass ClassSuperior AncestorClass User Group
ClassClassfctnAuthGrp ClassSuperior ClassClassfctnAuthGrp
Characteristic I_ClfnCharcBasic Characteristic Field Name
OverwrittenCharcInternalID I_ClfnClassCharcBasic OverwrittenCharcInternalID
ClfnOrganizationalArea I_ClfnClassCharcBasic ClfnOrganizationalArea
ChangeNumber I_ClfnClassCharcBasic ChangeNumber Change Number
CharcOriginText I_ClfnClassCharcBasic CharcOriginText Remote System
CharcIsPrintRelevant I_ClfnClassCharcBasic CharcIsPrintRelevant
CharcIsSearchRelevant I_ClfnClassCharcBasic CharcIsSearchRelevant
CharcIsDisplayRelevant I_ClfnClassCharcBasic CharcIsDisplayRelevant
CharcIsProposalRelevant I_ClfnClassCharcBasic CharcIsProposalRelevant Proposal Rel.
CharcIsPrptnOrProdUnitRelevant I_ClfnClassCharcBasic CharcIsPrptnOrProdUnitRelevant Prop./Prod. Unit Rel
ValidityStartDate I_ClfnClassCharcBasic ValidityStartDate Validity Start Date
ValidityEndDate I_ClfnClassCharcBasic ValidityEndDate ValidTo
_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_ClfnClassHierCharcForKeyDate.
-- 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: INGCCLS10
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_ClfnClassHierCharcForKeyDate AS
SELECT
  ClassSuperior.ClassInternalID AS ClassInternalID,
  ClassSuperior.AncestorClassInternalID AS AncestorClassInternalID,
  ClassCharcBasic.CharcInternalID AS CharcInternalID,
  ClassCharcBasic.CharcPositionNumber AS CharcPositionNumber,
  ClassSuperior.ClassType AS ClassType,
  ClassSuperior.Class AS Class,
  ClassSuperior.AncestorClass AS AncestorClass,
  ClassSuperior.ClassClassfctnAuthGrp AS ClassClassfctnAuthGrp,
  Characteristic.Characteristic AS Characteristic,
  ClassCharcBasic.OverwrittenCharcInternalID AS OverwrittenCharcInternalID,
  ClassCharcBasic.ClfnOrganizationalArea AS ClfnOrganizationalArea,
  ClassCharcBasic.ChangeNumber AS ChangeNumber,
  ClassCharcBasic.CharcOriginText AS CharcOriginText,
  ClassCharcBasic.CharcIsPrintRelevant AS CharcIsPrintRelevant,
  ClassCharcBasic.CharcIsSearchRelevant AS CharcIsSearchRelevant,
  ClassCharcBasic.CharcIsDisplayRelevant AS CharcIsDisplayRelevant,
  ClassCharcBasic.CharcIsProposalRelevant AS CharcIsProposalRelevant,
  ClassCharcBasic.CharcIsPrptnOrProdUnitRelevant AS CharcIsPrptnOrProdUnitRelevant,
  ClassCharcBasic.ValidityStartDate AS ValidityStartDate,
  ClassCharcBasic.ValidityEndDate AS ValidityEndDate
FROM I_ClfnClassSuperiorForKeyDate
INNER JOIN I_ClfnClassCharcBasic AS ClassCharcBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClfnCharcBasic AS Characteristic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ClfnClass AS _Class ON ClassInternalID = _Class.ClassInternalID  -- association [0..1]
;

Learn More