I_QltyProcmtCert

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_QltyProcmtCert.
-- 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: IQLTYPROCMTCERT

CREATE VIEW I_QltyProcmtCert AS
SELECT
  cast( certno as vdm_qccertno preserving type ) AS QualityProcurementCertificate,
  zgtyp AS QualityCertificateType,
  cast( status as vdm_qcstatus preserving type ) AS QltyProcmtCertStatus,
  cast( ebeln as fis_ebeln preserving type ) AS PurchaseOrder,
  cast( ebelp as vdm_ebelp preserving type ) AS PurchaseOrderItem,
  cast( mjahr as vdm_mjahr preserving type ) AS MaterialDocumentYear,
  cast( qcpr.zeile as vdm_mblpo preserving type ) AS MaterialDocumentItem,
  mblnr AS MaterialDocument,
  matnr AS Material,
  cast( lifnr as vdm_qelifn preserving type ) AS Supplier,
  werks AS Plant,
  cast( budat as vdm_qm_gr_budat preserving type ) AS GoodsReceiptPostingDate,
  cast( certdat as vdm_qcertdat preserving type ) AS QltyProcmtCertReceiptDate,
  lichn AS BatchBySupplier,
  charg AS Batch,
  lfsnr AS DeliveryNote,
  ersteller AS QltyProcmtCertCrtedByUsr,
  ersteldat AS QltyProcmtCertCrtnDte,
  erstelzeit AS QltyProcmtCertCrtnTme,
  creationtzone AS QltyProcmtCertCrtnTmeZn,
  aenderer AS QltyProcmtCertChgdBy,
  aenderdat AS QltyProcmtCertChgDte,
  aenderzeit AS QltyProcmtCertChgTme,
  certrec AS QltyProcmtCertRcptEnteredBy,
  cvp_xblck AS IsBusinessPurposeCompleted,
  dox_autom_interact_level AS QltyCertDocAutomnIntactnLvl
FROM qcpr
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchaseOrder = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchaseOrder = _PurchasingDocumentItem.PurchasingDocument AND PurchaseOrderItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_QltyProcmtCertStatus AS _QltyProcmtCertStatus ON QltyProcmtCertStatus = _QltyProcmtCertStatus.QltyProcmtCertStatus  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentItem AS _MaterialDocumentItem ON MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem AND MaterialDocument = _MaterialDocumentItem.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocument ON MaterialDocumentYear = _MaterialDocument.MaterialDocumentYear AND MaterialDocument = _MaterialDocument.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_QualityCertificateType AS _QualityCertificateType ON QualityCertificateType = _QualityCertificateType.QualityCertificateType  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON QltyProcmtCertCrtedByUsr = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByUserContactCard ON QltyProcmtCertChgdBy = _ChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _QltyProcmtCertRcptEnteredBy ON QltyProcmtCertRcptEnteredBy = _QltyProcmtCertRcptEnteredBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_QltyCertDocAutomnIntactnLvl AS _AutomationInteractionLevel ON QltyCertDocAutomnIntactnLvl = _AutomationInteractionLevel.DomainValueLow  -- association [0..1]
LEFT OUTER JOIN I_QltyCertDocMatch AS _QltyCertDocMatch ON QualityProcurementCertificate = _QltyCertDocMatch.QualityProcurementCertificate  -- association [0..*]
LEFT OUTER JOIN I_QltyCertLatestDocMatch AS _QltyCertLatestDocMatch ON QualityProcurementCertificate = _QltyCertLatestDocMatch.QualityProcurementCertificate  -- association [0..1]
;