C_Materialsampleobjpage

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_Materialsampleobjpage.
-- 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_Materialsampleobjpage AS
SELECT
  MaterialSample,
  Plant,
  _Plant.PlantName AS PlantName,
  ObjectInternalID,
  MaterialSampleCategory,
  _MaterialSampleCategory._Text[1:Language = $session.system_language].MaterialSampleCategoryText AS MaterialSampleCategoryText,
  MatlSmplContainerType,
  SmplDrawingProcedure,
  I_MaterialSample.MaterialSampleSize AS MaterialSampleSize,
  cast( I_MaterialSample.MaterialSampleSizeUnit as vdm_qphysprme preserving type ) AS MaterialSampleSizeUnit,
  I_MaterialSample._MatlSmplContainerType._MatlSmplContainerTypeText[1:Language = $session.system_language].MatlSmplContainerTypeText AS MatlSmplContainerTypeText,
  SmplDrwgProcedPartialSampleTo,
  MaterialSampleType,
  _MaterialSampleType._Text[1:Language = $session.system_language].MaterialSampleTypeText AS MaterialSampleTypeText,
  I_MaterialSample._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  MaterialSampleText,
  Material,
  MaterialSampleDrawing,
  Batch,
  MaterialSampleDrawingLocation,
  MatlSmplDrawingLocDescription,
  MatlQualityAuthorizationGroup,
  _SampleDetails.Supplier AS Supplier,
  _SampleDetails.SupplierName AS SupplierName,
  _SampleDetails.Manufacturer AS Manufacturer,
  _SampleDetails.ManufacturerName AS ManufacturerName,
  _SampleDetails.Customer AS Customer,
  _SampleDetails.CustomerName AS CustomerName,
  MaterialSampleResponsibleName,
  MaterialSampleDrawingOnDate,
  InspectionLot,
  I_MaterialSample._InspectionLot.InspectionLotText AS InspectionLotText,
  I_MaterialSample._InspectionLot.InspectionLotContainer AS InspectionLotContainer,
  I_MaterialSample._InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  cast( I_MaterialSample._InspectionLot.InspectionLotQuantityUnit as vdm_insplotuom preserving type ) AS InspectionLotQuantityUnit,
  I_MaterialSample._InspectionLot.InspectionLotSampleQuantity AS InspectionLotSampleQuantity,
  cast( I_MaterialSample._InspectionLot.InspectionLotSampleUnit as vdm_insplotsampleuom preserving type ) AS InspectionLotSampleUnit,
  I_MaterialSample._InspectionLot.InspectionLotContainerUnit AS InspectionLotContainerUnit,
  I_MaterialSample._InspectionLot.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_MaterialSample._InspectionLot.BillOfOperationsVariant AS BillOfOperationsVariant,
  I_MaterialSample._InspectionLot.SmplDrwgProcedIsConfRequired AS SmplDrwgProcedIsConfRequired,
  I_MaterialSample._InspectionLot.InspLotHasMaterialSpec AS InspLotHasMaterialSpec,
  I_MaterialSample._InspectionLot._InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  I_MaterialSample._InspectionLot._InspLotUsageDecision._UsageDecisionCode.UsageDecisionCodeText AS UsageDecisionCodeText,
  I_MaterialSample.StorageLocation AS StorageLocation,
  I_MaterialSample._StorageLocation.StorageLocationName AS StorageLocationName,
  I_MaterialSample.MaterialSampleStorageLocation AS MaterialSampleStorageLocation,
  I_MaterialSample._MatlSampleStorageLocation._Text[1:Language = $session.system_language].MatlSampleStorageLocationText AS MatlSampleStorageLocationText,
  I_MaterialSample.MatlSmplStorageInformation AS MatlSmplStorageInformation,
  I_MaterialSample.MatlSmplStorageEndDate AS MatlSmplStorageEndDate,
  I_MaterialSample.MatlSmplStorageDuration AS MatlSmplStorageDuration,
  _SampleDetails.CreatedByUser AS CreatedByUser,
  _SampleDetails.FullName AS FullName,
  cast( _SampleDetails.CreationDate as vdm_qprs_anldt preserving type ) AS CreationDate,
  cast( _SampleDetails.CreationTime as vdm_qprs_anlzt preserving type ) AS CreationTime,
  I_MaterialSample.MaterialSampleChangedBy AS MaterialSampleChangedBy,
  _UserChangedBy.UserDescription AS UserDescription,
  cast( I_MaterialSample.MaterialSampleChangedOn as vdm_qprs_aendt preserving type ) AS MaterialSampleChangedOn,
  cast( I_MaterialSample.MaterialSampleChangeTime as vdm_qprs_aenzt preserving type ) AS MaterialSampleChangeTime,
  _MaterialSampleDrawing.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_MaterialSample._StorageLocation AS _StorageLocation,
  I_MaterialSample._MatlSampleStorageLocation AS _MatlSampleStorageLocation,
  I_MaterialSample._MatlSampleStorageLocation._Plant AS _MatlSampleStorageLocPlant,
  I_MaterialSample._MatlSampleStorageLocation.MatlSamplePlant AS MatlSamplePlant
FROM I_MaterialSample
LEFT OUTER JOIN C_Materialsamplestatus AS _StatusObjectStatus ON ObjectInternalID = _StatusObjectStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN C_MtrlSmplSameDrwbngOp AS _MtrlSmplSameDrwbngOp ON MaterialSampleDrawing = _MtrlSmplSameDrwbngOp.MaterialSampleDrawing  -- association [0..*]
LEFT OUTER JOIN I_MaterialSample AS _Samples ON MaterialSampleDrawing = _Samples.MaterialSampleDrawing  -- association [0..*]
LEFT OUTER JOIN I_MaterialSampleDetails AS _SampleDetails ON MaterialSample = _SampleDetails.MaterialSample  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON MaterialSampleDrawingLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_MatlSmplContainerType AS _MatlSmplContainerType ON MatlSmplContainerType = _MatlSmplContainerType.MatlSmplContainerType  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _SampleStoredStatus ON ObjectInternalID = _SampleStoredStatus.StatusObject AND _SampleStoredStatus.StatusCode = 'I0363'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _SampleExistStatus ON ObjectInternalID = _SampleExistStatus.StatusObject AND _SampleExistStatus.StatusCode = 'I0362'  -- association [0..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _StsObjConcatActvStatus ON _StsObjConcatActvStatus.StatusObject = ObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserChangedBy ON _UserChangedBy.UserID = I_MaterialSample.MaterialSampleChangedBy  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotVH AS _InspectionLotVH ON InspectionLot = _InspectionLotVH.InspectionLot  -- association [0..1]
;