I_MaterialSample

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_MaterialSample.
-- 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: IMATERIALSAMPLE

CREATE VIEW I_MaterialSample AS
SELECT
  qprs.phynr AS MaterialSample,
  qprs.prart AS MaterialSampleType,
  qprs.prtyp AS MaterialSampleCategory,
  qprs.abort AS MaterialSampleStorageLocation,
  cast( qprs.pnver as vdm_qprziehver preserving type ) AS SmplDrawingProcedure,
  qprs.pnvev AS SmplDrawingProcedureVersion,
  cast( qprs.pn_nr as vdm_qpznr preserving type ) AS MaterialSampleDrawing,
  qprs.matnr AS Material,
  qprs.charg AS Batch,
  qprs.werks AS Plant,
  qprs.lgort AS StorageLocation,
  qprs.ktext AS MaterialSampleText,
  qprs.plos2 AS InspectionLot,
  cast( qprs.qauth as vdm_qmatauth preserving type ) AS MatlQualityAuthorizationGroup,
  qprs.aendt AS MaterialSampleChangedOn,
  qprs.entdatum AS MaterialSampleDrawingOnDate,
  case qprs.entzeit when '' then '000000' else qprs.entzeit end as MaterialSampleDrawingOnTime AS entzeitendasMaterialSampleDrawingOnTime,
  qprs.primpack AS QualityRelevantPackaging,
  qprs.stabicon AS MatlSampleStorageCondition,
  cast( qprs.entort as vdm_qprsentort preserving type ) AS MaterialSampleDrawingLocation,
  cast( qprs.infeort as vdm_qprsinfeort preserving type ) AS MatlSmplDrawingLocDescription,
  qprs.bearbeiter AS MaterialSampleResponsibleName,
  qprs.abdat AS MatlSmplStorageEndDate,
  qprs.abinf AS MatlSmplStorageInformation,
  qprs.gbtyp AS MatlSmplContainerType,
  qprs.gebeh AS InspectionLotContainerUnit,
  qprs.abdau AS MatlSmplStorageDuration,
  qprs.infeort AS MatlSmplDrwgLocDescription,
  qprs.menge AS MaterialSampleSize,
  qprs.meinh AS MaterialSampleSizeUnit,
  qprs.aenna AS MaterialSampleChangedBy,
  qprs.aenzt AS MaterialSampleChangeTime,
  qprs.objnr AS ObjectInternalID,
  cast( qprs.tpbis as vdm_qprobnrbis preserving type ) AS SmplDrwgProcedPartialSampleTo
FROM qprs
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_MaterialSampleCategory AS _MaterialSampleCategory ON MaterialSampleCategory = _MaterialSampleCategory.MaterialSampleCategory  -- association [1..1]
LEFT OUTER JOIN I_MaterialSampleType AS _MaterialSampleType ON MaterialSampleType = _MaterialSampleType.MaterialSampleType  -- association [1..1]
LEFT OUTER JOIN I_MatlSampleStorageLocation AS _MatlSampleStorageLocation ON MaterialSampleStorageLocation = _MatlSampleStorageLocation.MaterialSampleStorageLocation AND Plant = _MatlSampleStorageLocation.MatlSamplePlant  -- association [1..1]
LEFT OUTER JOIN I_MaterialSampleDrawing AS _MaterialSampleDrawing ON MaterialSampleDrawing = _MaterialSampleDrawing.MaterialSampleDrawing  -- association [1..1]
LEFT OUTER JOIN I_SampleDrawingProcedure AS _SampleDrawingProcedure ON SmplDrawingProcedure = _SampleDrawingProcedure.SmplDrawingProcedure  -- association [1..1]
LEFT OUTER JOIN I_SmplDrwgProcedureVersion AS _SmplDrwgProcedureVersion ON SmplDrawingProcedure = _SmplDrwgProcedureVersion.SmplDrawingProcedure AND SmplDrawingProcedureVersion = _SmplDrwgProcedureVersion.SmplDrawingProcedureVersion  -- association [1..1]
LEFT OUTER JOIN I_MatlSmplContainerType AS _MatlSmplContainerType ON MatlSmplContainerType = _MatlSmplContainerType.MatlSmplContainerType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialSampleSizeUnit ON MaterialSampleSizeUnit = _MaterialSampleSizeUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspectionLotContainerUnit ON InspectionLotContainerUnit = _InspectionLotContainerUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_QualityRelevantPackaging AS _QualityRelevantPackaging ON QualityRelevantPackaging = _QualityRelevantPackaging.QualityRelevantPackaging  -- association [0..1]
LEFT OUTER JOIN I_MatlSampleStorageCondition AS _MatlSampleStorageCondition ON MatlSampleStorageCondition = _MatlSampleStorageCondition.MatlSampleStorageCondition  -- association [0..1]
LEFT OUTER JOIN I_MatlQualityAuthGroup AS _MatlQualityAuthGroup ON MatlQualityAuthorizationGroup = _MatlQualityAuthGroup.MatlQualityAuthorizationGroup  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN E_MaterialSample AS _Extension ON MaterialSample = _Extension.MaterialSample  -- association [1..1]
;