I_MaterialSampleDrawing

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_MaterialSampleDrawing.
-- 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: IMATLSMPLDRW

CREATE VIEW I_MaterialSampleDrawing AS
SELECT
  cast( qprn.pn_nr as vdm_qpznr preserving type ) AS MaterialSampleDrawing,
  qprn.plos AS InspectionLot,
  qprn.matnr AS Material,
  qprn.werks AS Plant,
  qprn.charg AS Batch,
  qprn.cvp_xblck AS IsBusinessPurposeCompleted,
  qprn.kunnr AS Customer,
  qprn.lifnr AS Supplier,
  qprn.hrstl AS Manufacturer,
  cast( qprn.qmatauth as vdm_qmatauth preserving type ) AS MatlQualityAuthorizationGroup,
  qprn.qmnum AS StabilityStudy,
  qprn.anlna AS CreatedByUser,
  qprn.anldt AS CreationDate,
  qprn.anlzt AS CreationTime,
  qprn.frgna AS MaterialSampleReleasedBy,
  qprn.frgdt AS MaterialSampleReleaseDate,
  qprn.frgzt AS MaterialSampleReleaseTime
FROM qprn
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_MaterialSample AS _MaterialSample ON MaterialSampleDrawing = _MaterialSample.MaterialSampleDrawing  -- association [0..*]
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_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Manufacturer ON Manufacturer = _Manufacturer.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MatlQualityAuthGroup AS _MatlQualityAuthGroup ON MatlQualityAuthorizationGroup = _MatlQualityAuthGroup.MatlQualityAuthorizationGroup  -- association [0..1]
LEFT OUTER JOIN E_MaterialSampleDrawing AS _Extension ON MaterialSampleDrawing = _Extension.MaterialSampleDrawing  -- association [1..1]
;