I_CharcAttribSelectedSetCode

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_CharcAttribSelectedSetCode.
-- 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: ICHATTRSELSETCD

CREATE VIEW I_CharcAttribSelectedSetCode AS
SELECT
  qpac.werks AS SelectedCodeSetPlant,
  qpac.auswahlmge AS SelectedCodeSet,
  qpac.codegruppe AS CharacteristicAttributeCodeGrp,
  qpac.code AS CharacteristicAttributeCode,
  qpac.bewertung AS CharcAttributeValuation,
  qpac.geloescht AS CodeIsInactive,
  qpac.fehlklasse AS DefectClass,
  qpac.ersteller AS CharcAttribSeldSetCodeCrtedBy,
  qpac.e_datum AS CharcAttribSeldSetCodeCrtedOn,
  qpac.aenderer AS CharcAttribSeldSetCodeChgdBy,
  qpac.a_datum AS CharcAttribSeldSetCodeChgdOn
FROM qpac
LEFT OUTER JOIN I_CharcAttributeCodeGrp AS _CharcAttributeCodeGrp ON CharacteristicAttributeCodeGrp = _CharcAttributeCodeGrp.CharacteristicAttributeCodeGrp  -- association [0..1]
LEFT OUTER JOIN I_CharcAttributeCode AS _CharcAttributeCode ON CharacteristicAttributeCodeGrp = _CharcAttributeCode.CharacteristicAttributeCodeGrp AND CharacteristicAttributeCode = _CharcAttributeCode.CharacteristicAttributeCode  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _CodeIsInactive ON CodeIsInactive = _CodeIsInactive.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_CharcAttribSelectedCodeSet AS _CharcAttribSelectedCodeSet ON SelectedCodeSetPlant = _CharcAttribSelectedCodeSet.SelectedCodeSetPlant AND SelectedCodeSet = _CharcAttribSelectedCodeSet.SelectedCodeSet  -- association [0..1]
;