C_QltyInProcurementObjPage

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_QltyInProcurementObjPage.
-- 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_QltyInProcurementObjPage AS
SELECT
  Material,
  QltyInProcmtIntID,
  MaterialRevisionLevel,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Plant,
  _QualityInProcurement._Plant.PlantName AS PlantName,
  QltyInProcmtReleaseValidTo,
  QltyInProcmtRelQtyIsActive,
  ReleasedQuantity,
  OrderedQuantity,
  BaseUnit,
  QltyInProcmtResetOnDate,
  ProcurementBlock,
  BlockReason,
  SupplierProcurementBlock,
  cast('' as abap.char(1333) ) AS QltyInProcmtLongText,
  QualityManagementSystem,
  QltyInProcmtCertfnValidTo,
  SuplrQualityManagementSystem,
  SuplrQltyInProcmtCertfnValidTo,
  QltyInProcmtInspControl,
  InspectionLotType,
  QltyInProcmtLotCrtnLeadTime,
  QltyInProcmtNoFurtherInsp,
  QltyInProcmtCertificateCtrl,
  ControllingObject,
  _QualityInProcurement.StatusProfile AS StatusProfile,
  _StatusObjectActiveSqncStatus.StatusCode AS StatusCode,
  QltyInProcmtCurInspLot,
  cast('' as qestat2) AS QltyInProcmtNextStatus,
  QltyInProcmtNextInspLot,
  cast('' as qstatmore) AS QltyInProcmtHasFurtherStatus,
  CreationDate,
  CreatedByUser,
  cast( _CreatedByUserContactCard.FullName as vdm_createdbyuserdescription preserving type ) AS CreatedByUserFullName,
  LastChangeDate,
  LastChangedByUser,
  cast( _ChangedByUserContactCard.FullName as vdm_lastchangedbyuserdescripti preserving type ) AS LastChangedByUserFullName,
  LinkedSAPObjectKey,
  DocumentInfoRecordDocType,
  cast( ' ' as is_cloud_system preserving type ) AS IsCloudSystem,
  cast( _QualityInProcurement.IsDeleted as vdm_qltyinforecordddeleted preserving type ) AS IsDeleted,
  _QualityInProcurement._Material AS _Material,
  _QualityInProcurement._Plant AS _Plant,
  _QualityInProcurement._Supplier AS _Supplier
FROM I_QualityInProcurementTP AS _QualityInProcurement
LEFT OUTER JOIN I_QltyInProcmtActiveStatus AS _StatusObjectActiveSqncStatus ON ControllingObject = _StatusObjectActiveSqncStatus.StatusObject AND statuscode = _StatusObjectActiveSqncStatus.StatusCode AND StatusProfile = _StatusObjectActiveSqncStatus.StatusProfile AND _StatusObjectActiveSqncStatus.StatusSequenceNumber <> '00'  -- association [0..1]
LEFT OUTER JOIN I_StatusCodeText AS _StatusObjectActiveSqncStatusT ON statuscode = _StatusObjectActiveSqncStatusT.StatusCode AND StatusProfile = _StatusObjectActiveSqncStatusT.StatusProfile  -- association [0..*]
LEFT OUTER JOIN C_QltyInProcmtActiveStatus AS _QltyInProcmtActiveStatus ON ControllingObject = _QltyInProcmtActiveStatus.StatusObject AND StatusProfile = _QltyInProcmtActiveStatus.StatusProfile  -- association [0..*]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON Supplier = _SupplierValueHelp.Supplier  -- association [0..*]
LEFT OUTER JOIN E_QualityInProcurement AS _Extension ON Material = _Extension.Material AND QltyInProcmtIntID = _Extension.QltyInProcmtIntID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByUserContactCard ON LastChangedByUser = _ChangedByUserContactCard.ContactCardID  -- association [0..1]
;