A_UsgeDcsnSeldSetCode

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 A_UsgeDcsnSeldSetCode.
-- 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 A_UsgeDcsnSeldSetCode AS
SELECT
  SelectedCodeSetPlant,
  SelectedCodeSet,
  UsageDecisionCodeGroup,
  UsageDecisionCode,
  InspLotUsageDecisionValuation,
  InspectionLotQualityScore
FROM I_UsgeDcsnSelectedSetCode
LEFT OUTER JOIN A_Plant_2 AS _SelectedCodeSetPlant ON SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN A_UsageDecisionCodeGrp AS _SelectedSetCodeGrp ON SelectedCodeSetPlant = _SelectedSetCodeGrp.SelectedCodeSetPlant AND SelectedCodeSet = _SelectedSetCodeGrp.SelectedCodeSet AND UsageDecisionCodeGroup = _SelectedSetCodeGrp.UsageDecisionCodeGroup  -- association [0..1]
LEFT OUTER JOIN A_UsageDcsnSeldCodeGrpTxt AS _UsageDcsnSeldCodeGrpTxt ON SelectedCodeSetPlant = _UsageDcsnSeldCodeGrpTxt.SelectedCodeSetPlant AND SelectedCodeSet = _UsageDcsnSeldCodeGrpTxt.SelectedCodeSet AND UsageDecisionCodeGroup = _UsageDcsnSeldCodeGrpTxt.UsageDecisionCodeGroup  -- association [0..*]
LEFT OUTER JOIN A_UsageDcsnSeldCodeTxt AS _UsageDcsnSeldCodeTxt ON SelectedCodeSetPlant = _UsageDcsnSeldCodeTxt.SelectedCodeSetPlant AND SelectedCodeSet = _UsageDcsnSeldCodeTxt.SelectedCodeSet AND UsageDecisionCodeGroup = _UsageDcsnSeldCodeTxt.UsageDecisionCodeGroup AND UsageDecisionCode = _UsageDcsnSeldCodeTxt.UsageDecisionCode  -- association [0..*]
;