QCOMPL

Transparent Table Application Table
18 Fields 1 CDS Views

Quality Complaint

QCOMPL is an SAP database table in S/4HANA. Quality Complaint. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ComplaintAgainstSupplier view_entity from BASIC Complaint Against Supplier

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY complaint qcomplaint
category qcomplaintcategory
plant werks_d Plant
lifecyclestatus qcomplaintlifecyclestatus
prioritytype qcomplprioritytype
priority qcomplpriority
masterlanguage vdm_qm_masterlanguage
description qcomplaintdescription
qualityissuereference qextrefnum Reference Number
plannedstartdatetime qcomplaintplannedstart
plannedenddatetime qcomplaintplannedend
completedbyuser qcomplaintcompletedbyuser
completedondatetime qcomplaintcompletedon
createdbyuser vdm_qm_createdbyuser
createdondatetime vdm_qm_createdondatetime
lastchangedbyuser vdm_qm_lastchangedbyuser
lastchangedondatetime vdm_qm_lastchangedondatetime

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.

-- Quality Complaint
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QCOMPL (
    MANDT,                  -- Client [mandt]
    COMPLAINT,              -- qcomplaint
    CATEGORY,               -- qcomplaintcategory
    PLANT,                  -- Plant [werks_d]
    LIFECYCLESTATUS,        -- qcomplaintlifecyclestatus
    PRIORITYTYPE,           -- qcomplprioritytype
    PRIORITY,               -- qcomplpriority
    MASTERLANGUAGE,         -- vdm_qm_masterlanguage
    DESCRIPTION,            -- qcomplaintdescription
    QUALITYISSUEREFERENCE,  -- Reference Number [qextrefnum]
    PLANNEDSTARTDATETIME,   -- qcomplaintplannedstart
    PLANNEDENDDATETIME,     -- qcomplaintplannedend
    COMPLETEDBYUSER,        -- qcomplaintcompletedbyuser
    COMPLETEDONDATETIME,    -- qcomplaintcompletedon
    CREATEDBYUSER,          -- vdm_qm_createdbyuser
    CREATEDONDATETIME,      -- vdm_qm_createdondatetime
    LASTCHANGEDBYUSER,      -- vdm_qm_lastchangedbyuser
    LASTCHANGEDONDATETIME,  -- vdm_qm_lastchangedondatetime
    PRIMARY KEY (MANDT, COMPLAINT)
);

Learn More