QCERTDOCMATCH

Transparent Table Application Table
23 Fields 1 CDS Views

Certificate Document Match

QCERTDOCMATCH is an SAP database table in S/4HANA. Certificate Document Match. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QltyCertDocMatch view_entity from BASIC Quality Certificate Document Match

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY certdocmatch_uuid QLTYCERTDOCMATCH_UUID Certificate Document Match UUID
certdocmatch_ext_status IIP_DOCUMENT_STATUS Document Status
qltycertdocmatch_ext_doc_uuid IIP_DOCUMENT_ID Document ID
ext_doc_file_name QCERT_EXT_DOC_FILE_NAME File Name
ext_doc_supplier_name QCERT_EXT_SUPPLIER_NAME Supplier Name
ext_doc_supplier_adr QCERT_EXT_SUPPLIER_ADDRESS Supplier Address
ext_doc_supplier_mat QCERT_EXT_SUPPLIER_MATERIAL Supplier Material
ext_doc_supplier_mat_desc QCERT_EXT_SUPPLIER_MAT_DESC Supplier Material Description
ext_doc_supplier_batch QCERT_EXT_SUPPLIER_BATCH Supplier Batch
ext_doc_delivery_doc QCERT_EXT_DELIVERY_DOC Delivery Note
ext_doc_pur_doc QCERT_EXT_PURCHASING_DOC Purchasing Document
ext_doc_mat QCERT_EXT_MATERIAL Material
supplier ELIFN Supplier
material MATNR Material
pur_doc QM_CERT_EBELN Purchasing Document
pur_doc_item QM_EBELP Purchasing Document Item
plant WERKS_D Plant
qcert QCCERTNO Certificate
uploaded_on QLTYCERTDOCMATCH_UPL_ON Uploaded On
uploaded_by QLTYCERTDOCMATCH_UPL_BY Uploaded By
changed_on QLTYCERTDOCMATCH_CHG_ON Last Changed On
changed_by QLTYCERTDOCMATCH_CHG_BY Last Changed By

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Certificate Document Match
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QCERTDOCMATCH (
    CLIENT,                         -- Client [MANDT]
    CERTDOCMATCH_UUID,              -- Certificate Document Match UUID [QLTYCERTDOCMATCH_UUID]
    CERTDOCMATCH_EXT_STATUS,        -- Document Status [IIP_DOCUMENT_STATUS]
    QLTYCERTDOCMATCH_EXT_DOC_UUID,  -- Document ID [IIP_DOCUMENT_ID]
    EXT_DOC_FILE_NAME,              -- File Name [QCERT_EXT_DOC_FILE_NAME]
    EXT_DOC_SUPPLIER_NAME,          -- Supplier Name [QCERT_EXT_SUPPLIER_NAME]
    EXT_DOC_SUPPLIER_ADR,           -- Supplier Address [QCERT_EXT_SUPPLIER_ADDRESS]
    EXT_DOC_SUPPLIER_MAT,           -- Supplier Material [QCERT_EXT_SUPPLIER_MATERIAL]
    EXT_DOC_SUPPLIER_MAT_DESC,      -- Supplier Material Description [QCERT_EXT_SUPPLIER_MAT_DESC]
    EXT_DOC_SUPPLIER_BATCH,         -- Supplier Batch [QCERT_EXT_SUPPLIER_BATCH]
    EXT_DOC_DELIVERY_DOC,           -- Delivery Note [QCERT_EXT_DELIVERY_DOC]
    EXT_DOC_PUR_DOC,                -- Purchasing Document [QCERT_EXT_PURCHASING_DOC]
    EXT_DOC_MAT,                    -- Material [QCERT_EXT_MATERIAL]
    SUPPLIER,                       -- Supplier [ELIFN]
    MATERIAL,                       -- Material [MATNR]
    PUR_DOC,                        -- Purchasing Document [QM_CERT_EBELN]
    PUR_DOC_ITEM,                   -- Purchasing Document Item [QM_EBELP]
    PLANT,                          -- Plant [WERKS_D]
    QCERT,                          -- Certificate [QCCERTNO]
    UPLOADED_ON,                    -- Uploaded On [QLTYCERTDOCMATCH_UPL_ON]
    UPLOADED_BY,                    -- Uploaded By [QLTYCERTDOCMATCH_UPL_BY]
    CHANGED_ON,                     -- Last Changed On [QLTYCERTDOCMATCH_CHG_ON]
    CHANGED_BY,                     -- Last Changed By [QLTYCERTDOCMATCH_CHG_BY]
    PRIMARY KEY (CLIENT, CERTDOCMATCH_UUID)
);

Learn More