I_QltyCertDocMatch

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_QltyCertDocMatch.
-- 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 I_QltyCertDocMatch AS
SELECT
  certdocmatch_uuid AS QltyCertDocMatchUUID,
  certdocmatch_ext_status AS InboundDocumentStatus,
  qltycertdocmatch_ext_doc_uuid AS InboundDocumentIdentifier,
  ext_doc_file_name AS QltyCertExtDocFileName,
  ext_doc_supplier_name AS QltyCertExtDocSupplierName,
  ext_doc_supplier_adr AS QltyCertExtDocSupplierAddress,
  ext_doc_supplier_mat AS QltyCertExtDocSupplierMaterial,
  ext_doc_supplier_mat_desc AS QltyCertExtDocSuplrMatlDesc,
  ext_doc_supplier_batch AS QltyCertExtDocSupplierBatch,
  ext_doc_delivery_doc AS QltyCertExtDocDeliveryDocument,
  ext_doc_pur_doc AS QltyCertExtDocPurgDocument,
  ext_doc_mat AS QltyCertExtDocMaterial,
  Supplier,
  Material,
  pur_doc AS PurchasingDocument,
  pur_doc_item AS PurchasingDocumentItem,
  Plant,
  cast( qcert as vdm_qccertno preserving type ) AS QualityProcurementCertificate,
  uploaded_on AS CreationDateTime,
  uploaded_by AS CreatedByUser,
  changed_on AS LastChangeDateTime,
  changed_by AS LastChangedByUser
FROM qcertdocmatch
LEFT OUTER JOIN I_QltyCertDocMatchPrpsl AS _QltyCertDocMatchPrpsl ON QltyCertDocMatchUUID = _QltyCertDocMatchPrpsl.QltyCertDocMatchUUID  -- association [0..*]
LEFT OUTER JOIN I_QltyProcmtCert AS _QltyProcmtCert ON QualityProcurementCertificate = _QltyProcmtCert.QualityProcurementCertificate  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..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_InboundDocumentStatusVH AS _InboundDocumentStatus ON InboundDocumentStatus = _InboundDocumentStatus.InboundDocumentStatus  -- association [0..1]
;