I_UsageDcsnSelectedCodeSet

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_UsageDcsnSelectedCodeSet.
-- 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: IUDSELCODESET

CREATE VIEW I_UsageDcsnSelectedCodeSet AS
SELECT
  qpam.werks AS SelectedCodeSetPlant,
  qpam.auswahlmge AS SelectedCodeSet,
  qpam.status AS InspectionSelectedSetStatus,
  qpam.defaultcodegr AS SelectedCodeSetDfltCodeGroup,
  qpam.defaultcode AS SelectedCodeSetDefaultCode,
  qpam.ersteller AS UsgeDcsnSeldSetCreatedBy,
  qpam.e_datum AS UsgeDcsnSeldSetCreatedOn,
  qpam.aenderer AS UsgeDcsnSeldSetLastChgdBy,
  qpam.a_datum AS UsgeDcsnSeldSetLastChangedOn
FROM qpam
LEFT OUTER JOIN I_Plant AS _SelectedCodeSetPlant ON SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UsageDcsnSelectedCodeSetTxt AS _Text ON SelectedCodeSetPlant = _Text.SelectedCodeSetPlant AND SelectedCodeSet = _Text.SelectedCodeSet  -- association [0..*]
LEFT OUTER JOIN I_UsgeDcsnSelectedSetCodeGrp AS _UsgeDcsnSelectedSetCodeGrp ON SelectedCodeSetPlant = _UsgeDcsnSelectedSetCodeGrp.SelectedCodeSetPlant AND SelectedCodeSet = _UsgeDcsnSelectedSetCodeGrp.SelectedCodeSet  -- association [0..*]
;