I_ClfnClassDEX

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_ClfnClassDEX.
-- 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 I_ClfnClassDEX AS
SELECT
  Class.ClassInternalID AS ClassInternalID,
  Class.ClassType AS ClassType,
  Class.Class AS Class,
  Class.ClassStatus AS ClassStatus,
  Class.ClassGroup AS ClassGroup,
  Class.ClassSearchAuthGrp AS ClassSearchAuthGrp,
  Class.ClassClassfctnAuthGrp AS ClassClassfctnAuthGrp,
  Class.ClassMaintAuthGrp AS ClassMaintAuthGrp,
  Class.CreatedByUser AS CreatedByUser,
  Class.CreationDate AS CreationDate,
  Class.LastChangedByUser AS LastChangedByUser,
  Class.LastChangeDate AS LastChangeDate,
  Class.ValidityStartDate AS ValidityStartDate,
  Class.ValidityEndDate AS ValidityEndDate,
  Class. SameClassfctnReaction AS SameClassfctnReaction,
  Class.ClfnOrganizationalArea AS ClfnOrganizationalArea,
  Class.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  Class.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  Class.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  Class.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  Class.ClassStandardOrgName AS ClassStandardOrgName,
  Class.ClassStandardNumber AS ClassStandardNumber,
  Class.ClassStandardStartDate AS ClassStandardStartDate,
  Class.ClassStandardVersionStartDate AS ClassStandardVersionStartDate,
  Class.ClassStandardVersion AS ClassStandardVersion,
  Class.ClassStandardCharcTable AS ClassStandardCharcTable,
  Class.ClassBaseUnit AS ClassBaseUnit,
  Class.ClassIsUsableInBOM AS ClassIsUsableInBOM,
  Class.ClassIsLocal AS ClassIsLocal,
  Class.ClassLastChangedDateTime AS ClassLastChangedDateTime
FROM I_ClfnClass AS Class
LEFT OUTER JOIN I_ClfnClassDescriptionDEX AS _ClassDescription ON ClassInternalID = _ClassDescription.ClassInternalID  -- association [0..*]
LEFT OUTER JOIN I_ClfnClassKeywordDEX AS _ClassKeyword ON ClassInternalID = _ClassKeyword.ClassInternalID  -- association [0..*]
LEFT OUTER JOIN I_ClfnClassCharacteristicDEX AS _ClassCharacteristic ON ClassInternalID = _ClassCharacteristic.ClassInternalID  -- association [0..*]
LEFT OUTER JOIN I_ClfnClassStatus AS _ClassStatus ON ClassStatus = _ClassStatus.ClassStatus AND ClassType = _ClassStatus.ClassType  -- association [0..1]
LEFT OUTER JOIN I_ClfnClassGroup AS _ClassGroup ON ClassGroup = _ClassGroup.ClassGroup  -- association [0..1]
LEFT OUTER JOIN I_ClfnClassTypeBasic AS _ClassType ON _ClassType.ClassType = ClassType  -- association [0..1]
;