I_ClfnClassForKeyDate

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_ClfnClassForKeyDate.
-- 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: INGCCLS6
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_ClfnClassForKeyDate 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.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  Class.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  Class.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  Class.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  Class.SameClassfctnReaction AS SameClassfctnReaction,
  Class.ClfnOrganizationalArea AS ClfnOrganizationalArea,
  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.ValidityStartDate AS ValidityStartDate,
  Class.ValidityEndDate AS ValidityEndDate,
  Class.CreatedByUser AS CreatedByUser,
  Class.CreationDate AS CreationDate,
  Class.LastChangedByUser AS LastChangedByUser,
  Class.LastChangeDate AS LastChangeDate,
  Class.ClassLastChangedDateTime AS ClassLastChangedDateTime
FROM I_ClfnClass AS Class
LEFT OUTER JOIN I_ClfnClassDescForKeyDate AS _ClassDescription ON ClassInternalID = _ClassDescription.ClassInternalID  -- association [0..*]
LEFT OUTER JOIN I_ClfnClassKeywordForKeyDate AS _ClassKeyword ON ClassInternalID = _ClassKeyword.ClassInternalID  -- association [0..*]
LEFT OUTER JOIN I_ClfnClassCharcForKeyDate AS _ClassCharc ON ClassInternalID = _ClassCharc.ClassInternalID  -- association [0..*]
;