I_InspectionSubset

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_InspectionSubset.
-- 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 I_InspectionSubset AS
SELECT
  prueflos AS InspectionLot,
  probenr AS InspectionSubsetInternalID,
  vorglfnr AS InspPlanOperationInternalID,
  ppsortkey AS InspectionSubsetSortKey,
  phynr AS MaterialSample,
  phynrakt AS InspSbstMatlSmplProperty,
  equnr AS Equipment,
  equnrakt AS InspSbstEquipProperty,
  tplnr AS FunctionalLocation,
  tplnrakt AS InspSbstFuncnlLocProperty,
  sfi_id AS ShopFloorItem,
  sfi_akt AS InspSbstShopFloorItemProperty,
  vkatart AS InspSubsetUsageDecisionCatalog,
  vwerks AS SelectedCodeSetPlant,
  vauswahlmg AS SelectedCodeSet,
  vcodegrp AS InspSubsetUsageDcsnCodeGroup,
  vcode AS InspSubsetUsageDcsnCode,
  vbewertung AS InspSubsetUsageDcsnValuation,
  cast( usert1 as vdm_qusrtims preserving type ) AS InspectionSubsetTime,
  usert1akt AS InspSbstTimeFldProperty,
  cast( userd1 as vdm_qusrdats preserving type ) AS InspectionSubsetDate,
  userd1akt AS InspSbstDateFldProperty,
  usrtimezone AS InspectionSubsetTimeZone,
  cast( usern1 as vdm_qusrnumc10 preserving type ) AS InspSubsetLongNumericKey,
  usern1akt AS InspSbstLongNmbrFldProperty,
  cast( usern2 as vdm_qusrnumc3 preserving type ) AS InspSubsetShortNumericKey,
  usern2akt AS InspSbstShrtNmbrFldProperty,
  cast( userc1 as vdm_qusrchar18 preserving type ) AS InspectionSubsetLongCharKey,
  userc1akt AS InspSbstLongTxtFldProperty,
  cast( userc2 as vdm_qusrchar10 preserving type ) AS InspectionSubsetShortCharKey,
  userc2akt AS InspSbstShrtTxtFldProperty,
  teillos AS InspectionPartialLot,
  menge AS InspectionSubsetYieldQty,
  menge_a AS InspectionSubsetScrapQty,
  menge_n AS InspectionSubsetReworkQty,
  mengeneinh AS InspectionSubsetQtyUnit,
  pruefer AS Inspector,
  ersteller AS CreatedByUser,
  ersteldat AS CreationDate,
  cast( erstelzeit as vdm_qzeiterstl preserving type ) AS CreationTime,
  aenderer AS LastChangedByUser,
  aenderdat AS LastChangeDate,
  cast( aenderzeit as vdm_qzeitaend preserving type ) AS LastChangeTime,
  case qapp.changeddatetime when 0 then cast( '19000101010101' as tzntstmps ) else qapp.changeddatetime end as ChangedDateTime AS changeddatetimeendasChangedDateTime
FROM qapp
LEFT OUTER JOIN I_UsageDecisionCodeGroup AS _UsageDecisionCodeGroup ON InspSubsetUsageDcsnCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_UsageDecisionCode AS _UsageDecisionCode ON InspSubsetUsageDcsnCodeGroup = _UsageDecisionCode.UsageDecisionCodeGroup AND InspSubsetUsageDcsnCode = _UsageDecisionCode.UsageDecisionCode  -- association [0..1]
LEFT OUTER JOIN I_InspLotUsgeDcsnValn AS _InspSubsetUsageDcsnValn ON InspSubsetUsageDcsnValuation = _InspSubsetUsageDcsnValn.InspLotUsageDecisionValuation  -- association [0..1]
LEFT OUTER JOIN I_InspLotUsgeDcsnValnTxt AS _InspSubsetUsageDcsnValnTxt ON InspSubsetUsageDcsnValuation = _InspSubsetUsageDcsnValnTxt.InspLotUsageDecisionValuation  -- association [0..*]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetCharacteristic AS _InspectionSubsetInternalID ON InspectionLot = _InspectionSubsetInternalID.InspectionLot AND InspPlanOperationInternalID = _InspectionSubsetInternalID.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspectionSubsetInternalID.InspectionSubsetInternalID  -- association [0..*]
LEFT OUTER JOIN I_MaterialSample AS _MaterialSample ON MaterialSample = _MaterialSample.MaterialSample  -- association [0..1]
LEFT OUTER JOIN I_InspectionPartialLot AS _InspectionPartialLot ON InspectionPartialLot = _InspectionPartialLot.InspectionPartialLot AND InspectionLot = _InspectionPartialLot.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SelectedCodeSetPlant ON SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_InspUsgeDcsnSelectedSet AS _SelectedCodeSet ON SelectedCodeSetPlant = _SelectedCodeSet.SelectedCodeSetPlant AND SelectedCodeSet = _SelectedCodeSet.SelectedCodeSet  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _Unit ON InspectionSubsetQtyUnit = _Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_InspectionSubset AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionSubsetInternalID = _Extension.InspectionSubsetInternalID  -- association [1..1]
;