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 Certificate Document Match UUID
KEY certdocmatch_proposal_uuid QLTYCERTDOCMATCH_PROPOSAL_UUID UUID of Certificate Doc. Match Proposal
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 Match Proposal Type
score QM_FUZZY_SCORE Fuzzy Search 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,           -- Certificate Document Match UUID [QLTYCERTDOCMATCH_UUID]
    CERTDOCMATCH_PROPOSAL_UUID,  -- UUID of Certificate Doc. Match Proposal [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,  -- Match Proposal Type [QLTYCERTDOCMATCH_PROPOSAL_TYPE]
    SCORE,                       -- Fuzzy Search Score [QM_FUZZY_SCORE]
    PRIMARY KEY (CLIENT, CERTDOCMATCH_UUID, CERTDOCMATCH_PROPOSAL_UUID)
);

Learn More