QCERTDOCMATCHPR

Transparent Table Application Table
13 Fields 1 CDS Views

Certificate Document Match Proposal

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QltyCertDocMatchPrpsl view_entity from BASIC Certificate Document Match Proposal

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY certdocmatch_uuid qltycertdocmatch_uuid
KEY certdocmatch_proposal_uuid qltycertdocmatch_proposal_uuid
qcert qccertno Certificate
supplier lifnum Supplier
material matnr Material
pur_doc fis_ebeln Purchasing Document
pur_doc_item fis_ebelp Purchasing Doc. Item
plant werks_d Plant
suppplier_batch lichn Supplier Batch
delivery_note lfsnr1 Delivery Note
certdocmatch_proposal_type qltycertdocmatch_proposal_type
score qm_fuzzy_score

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 Proposal
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QCERTDOCMATCHPR (
    CLIENT,                      -- Client [mandt]
    CERTDOCMATCH_UUID,           -- qltycertdocmatch_uuid
    CERTDOCMATCH_PROPOSAL_UUID,  -- qltycertdocmatch_proposal_uuid
    QCERT,                       -- Certificate [qccertno]
    SUPPLIER,                    -- Supplier [lifnum]
    MATERIAL,                    -- Material [matnr]
    PUR_DOC,                     -- Purchasing Document [fis_ebeln]
    PUR_DOC_ITEM,                -- Purchasing Doc. Item [fis_ebelp]
    PLANT,                       -- Plant [werks_d]
    SUPPPLIER_BATCH,             -- Supplier Batch [lichn]
    DELIVERY_NOTE,               -- Delivery Note [lfsnr1]
    CERTDOCMATCH_PROPOSAL_TYPE,  -- qltycertdocmatch_proposal_type
    SCORE,                       -- qm_fuzzy_score
    PRIMARY KEY (CLIENT, CERTDOCMATCH_UUID, CERTDOCMATCH_PROPOSAL_UUID)
);

Learn More