I_InspLotUsageDecision

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_InspLotUsageDecision.
-- 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: IINSPLOTUSGDCSN

CREATE VIEW I_InspLotUsageDecision AS
SELECT
  qave.prueflos AS InspectionLot,
  qave.kzart AS InspLotUsageDecisionLevel,
  qave.zaehler AS InspLotUsageDecisionInternalID,
  qave.qkennzahl AS InspectionLotQualityScore,
  qave.vkatart AS InspLotUsageDecisionCatalog,
  qave.vwerks AS SelectedCodeSetPlant,
  qave.vauswahlmg AS InspLotUsgeDcsnSelectedSet,
  cast( qave.vcodegrp as vdm_qvgruppe preserving type ) AS InspLotUsageDecisionCodeGroup,
  qave.vcode AS InspectionLotUsageDecisionCode,
  qave.dbewertung AS InspLotUsgeDcsnDynValuation,
  qave.vbewertung AS InspLotUsageDecisionValuation,
  qave.vfolgeakti AS InspLotUsgeDcsnFollowUpAction,
  cast( qave.vname as vdm_qvname preserving type ) AS InspectionLotUsageDecidedBy,
  cast( qave.vdatum as vdm_qvedatum preserving type ) AS InspectionLotUsageDecidedOn,
  cast( qave.vezeiterf as vdm_qvezeiterf preserving type ) AS InspLotUsageDecisionTime,
  cast( qave.vaename as vdm_qvaename preserving type ) AS InspLotUsageDecisionChangedBy,
  cast( qave.vaedatum as vdm_qvaedatum preserving type ) AS InspLotUsageDecisionChangedOn,
  cast( qave.vezeitaen as vdm_qvezeitaen preserving type ) AS InspLotUsgeDcsnChangedTime,
  cast( qave.ltextkz as vdm_qltextave preserving type ) AS InspLotUsgeDcsnHasLongText
FROM qave
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspLotUsgeDcsnLongText AS _InspLotUsgeDcsnLongText ON InspectionLot = _InspLotUsgeDcsnLongText.InspectionLot  -- association [1..*]
LEFT OUTER JOIN I_InspectionSelectedSet AS _InspLotUsgeDcsnSelectedSet ON _InspLotUsgeDcsnSelectedSet.SelectedCodeSetPlant = SelectedCodeSetPlant AND _InspLotUsgeDcsnSelectedSet.InspectionCatalog = '3' AND _InspLotUsgeDcsnSelectedSet.SelectedCodeSet = InspLotUsgeDcsnSelectedSet  -- association [1..1]
LEFT OUTER JOIN I_UsageDcsnSelectedCodeSet AS _UsageDcsnSelectedCodeSet ON SelectedCodeSetPlant = _UsageDcsnSelectedCodeSet.SelectedCodeSetPlant AND InspLotUsgeDcsnSelectedSet = _UsageDcsnSelectedCodeSet.SelectedCodeSet  -- association [1..1]
LEFT OUTER JOIN I_UsageDecisionCodeGroup AS _UsageDecisionCodeGroup ON InspLotUsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup  -- association [1..1]
LEFT OUTER JOIN I_UsageDecisionCode AS _UsageDecisionCode ON InspLotUsageDecisionCodeGroup = _UsageDecisionCode.UsageDecisionCodeGroup AND InspectionLotUsageDecisionCode = _UsageDecisionCode.UsageDecisionCode  -- association [1..1]
LEFT OUTER JOIN I_User AS _InspectionLotUsageDecidedBy ON InspectionLotUsageDecidedBy = _InspectionLotUsageDecidedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _InspLotUsageDecisionChangedBy ON InspLotUsageDecisionChangedBy = _InspLotUsageDecisionChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UsgeDecidedByUserContactCard ON InspectionLotUsageDecidedBy = _UsgeDecidedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UsgeDcsnChgdByUserContactCard ON InspLotUsageDecisionChangedBy = _UsgeDcsnChgdByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SelectedCodeSetPlant ON SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _InspLotUsgeDcsnHasLongText ON InspLotUsgeDcsnHasLongText = _InspLotUsgeDcsnHasLongText.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_InspLotUsgeDcsnValn AS _UsageDecisionValuation ON InspLotUsageDecisionValuation = _UsageDecisionValuation.InspLotUsageDecisionValuation  -- association [0..1]
LEFT OUTER JOIN I_InspLotUsgeDcsnValnTxt AS _UsgeDcsnValuationText ON InspLotUsageDecisionValuation = _UsgeDcsnValuationText.QltyTechKeyWithPreservingType  -- association [0..*]
LEFT OUTER JOIN E_InspLotUsageDecision AS _Extension ON InspectionLot = _Extension.InspectionLot  -- association [1..1]
;