I_ClfnClass

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_ClfnClass.
-- 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: INGCCLS1

CREATE VIEW I_ClfnClass AS
SELECT
  Class.clint AS ClassInternalID,
  Class.klart AS ClassType,
  Class.class AS Class,
  Class.statu AS ClassStatus,
  Class.klagr AS ClassGroup,
  Class.bgrse AS ClassSearchAuthGrp,
  Class.bgrkl AS ClassClassfctnAuthGrp,
  Class.bgrkp AS ClassMaintAuthGrp,
  Class.aname AS CreatedByUser,
  Class.adatu AS CreationDate,
  Class.vname AS LastChangedByUser,
  Class.vdatu AS LastChangeDate,
  Class.vondt AS ValidityStartDate,
  Class.bisdt AS ValidityEndDate,
  cast( Class.praus as char1 preserving type ) AS SameClassfctnReaction,
  cast( Class.sicht as clfnorganizationalarea preserving type ) AS ClfnOrganizationalArea,
  Class.doknr AS DocumentInfoRecordDocNumber,
  Class.dokar AS DocumentInfoRecordDocType,
  Class.doktl AS DocumentInfoRecordDocPart,
  Class.dokvr AS DocumentInfoRecordDocVersion,
  Class.nnorm AS ClassStandardOrgName,
  Class.normn AS ClassStandardNumber,
  Class.ausgd AS ClassStandardStartDate,
  Class.versd AS ClassStandardVersionStartDate,
  Class.versi AS ClassStandardVersion,
  Class.leist AS ClassStandardCharcTable,
  Class.meins AS ClassBaseUnit,
  Class.vwstl AS ClassIsUsableInBOM,
  Class.locla AS ClassIsLocal,
  Class.lastchangeddatetime AS ClassLastChangedDateTime
FROM klah AS Class
LEFT OUTER JOIN I_ClfnClassDescription AS _ClassDescription ON ClassInternalID = _ClassDescription.ClassInternalID  -- association [0..*]
LEFT OUTER JOIN I_ClfnClassKeyword AS _ClassKeyword ON ClassInternalID = _ClassKeyword.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]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;