C_InspUsgDesc

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 C_InspUsgDesc.
-- 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 C_InspUsgDesc AS
SELECT
  InspectionLot,
  InspectionLotQualityScore,
  InspLotUsageDecisionCodeGroup,
  I_InspLotUsgeDcsnTP._UsageDecisionCode._Text[1:Language=$session.system_language].UsageDecisionCodeText AS UsageDecisionCodeText,
  InspectionLotUsageDecisionCode,
  SelectedCodeSetPlant,
  InspLotUsgeDcsnSelectedSet,
  InspLotUsageDecisionValuation,
  InspLotUsgeDcsnFollowUpAction,
  InspectionLotUsageDecidedBy,
  InspectionLotUsageDecidedOn,
  InspLotUsageDecisionChangedBy,
  InspLotUsageDecisionChangedOn,
  InspLotUsgeDcsnChangedTime,
  InspLotUsageDecisionTime,
  cast (InspLotUsageDecisionLongText as vdm_insplotusagedcsnlongtext preserving type ) AS InspLotUsageDecisionLongText,
  InspLotUsageDcsnLongTxtHistory,
  InspLotIsCompletionForced
FROM I_InspLotUsgeDcsnTP
LEFT OUTER JOIN C_InspUsgDescMng AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN C_InspUsgDescCF AS _CalFields ON InspectionLot = _CalFields.InspectionLot  -- association [0..1]
LEFT OUTER JOIN C_InspLotUsgeDcsnCodeVH AS _InspLotUsgeDcsnCodeVH ON InspLotUsageDecisionCodeGroup = _InspLotUsgeDcsnCodeVH.UsageDecisionCodeGroup AND InspectionLotUsageDecisionCode = _InspLotUsgeDcsnCodeVH.UsageDecisionCode AND InspLotUsgeDcsnSelectedSet = _InspLotUsgeDcsnCodeVH.SelectedCodeSet AND SelectedCodeSetPlant = _InspLotUsgeDcsnCodeVH.SelectedCodeSetPlant AND InspectionLot = _InspLotUsgeDcsnCodeVH.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_UsageDecisionCode AS _UsageDecisionCode ON InspLotUsageDecisionCodeGroup = _UsageDecisionCode.UsageDecisionCodeGroup AND InspectionLotUsageDecisionCode = _UsageDecisionCode.UsageDecisionCode  -- association [1..1]
;