QINF

Transparent Table Application Table
40 Fields 3 CDS Views

QM-Info Record for Material and Supplier

QINF is an SAP database table in S/4HANA. QM-Info Record for Material and Supplier. It contains 40 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_QualityInProcurement view from EXTENSION Quality In Procurement Extension
I_QualityInProcurement view from BASIC Quality Info Record in Procurement
P_RevLvlForQltyInProcmt view from BASIC

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY zaehl Q_COUNT Counter
ersteller QINFERST Created By
erstelldat QINFERSTDT Created On
aenderer QINFAEND Changed By
aenderdat QINFAENDDT Changed On
changeddatetime TZNTSTMPS Time Stamp
lieferant ELIFN Supplier
werk WERKS_D Plant
frei_dat QFREIDAT Release Until
frei_mgkz QFREIMGKZ Quantity Active
me QBSTME Unit of Measure
frei_mng QFREIMG Release Qty
best_mg QBSTMG Ordered Qty
dat_rueck QRSDAT Reset On
sperrgrund QSPERRGR Block Reason
sprache SPRAS Language
sperrfkt QSPERRFKT Block Function
qvvorh QQSVVORH Q-AgrmntExists
noinsp QNOINSP Insp. Control
qssysfam QSSYS_IST Actual QM Sys.
qssysdat QQSSYSDAT QM System To
variabnahm QINFVAR1 Source insp.
ltextkz QLTEXTKZ Long text
spras SPRAS Language
plos QPLOSQINF With Insp. Lot
plos2 QPLOSQINF2 With Insp. Lot
ppap_is_required QPPAP_IS_REQUIRED PPAP Required
ppap_level QPPAP_LEVEL PPAP Level
ppap_status QPPAP_STATUS PPAP Status
ppap_id QPPAP_ID PPAP
stsma QSTSMAQINF Status Profile
objnr QINFOBJNR QINF object no.
noinspabn QNOWEABN Source insp.
vorlabn QVORLABN Lead time(days)
revlv REVLV Revision Level
loekz QLOEKZ Deletion Flag
certcontrol QCERTCONTROL Certificate
dummy_qinf_incl_eew_ps DUMMY Dummy function in length 1

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.

-- QM-Info Record for Material and Supplier
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QINF (
    MANDT,                   -- Client [MANDT]
    MATNR,                   -- Material [MATNR]
    ZAEHL,                   -- Counter [Q_COUNT]
    ERSTELLER,               -- Created By [QINFERST]
    ERSTELLDAT,              -- Created On [QINFERSTDT]
    AENDERER,                -- Changed By [QINFAEND]
    AENDERDAT,               -- Changed On [QINFAENDDT]
    CHANGEDDATETIME,         -- Time Stamp [TZNTSTMPS]
    LIEFERANT,               -- Supplier [ELIFN]
    WERK,                    -- Plant [WERKS_D]
    FREI_DAT,                -- Release Until [QFREIDAT]
    FREI_MGKZ,               -- Quantity Active [QFREIMGKZ]
    ME,                      -- Unit of Measure [QBSTME]
    FREI_MNG,                -- Release Qty [QFREIMG]
    BEST_MG,                 -- Ordered Qty [QBSTMG]
    DAT_RUECK,               -- Reset On [QRSDAT]
    SPERRGRUND,              -- Block Reason [QSPERRGR]
    SPRACHE,                 -- Language [SPRAS]
    SPERRFKT,                -- Block Function [QSPERRFKT]
    QVVORH,                  -- Q-AgrmntExists [QQSVVORH]
    NOINSP,                  -- Insp. Control [QNOINSP]
    QSSYSFAM,                -- Actual QM Sys. [QSSYS_IST]
    QSSYSDAT,                -- QM System To [QQSSYSDAT]
    VARIABNAHM,              -- Source insp. [QINFVAR1]
    LTEXTKZ,                 -- Long text [QLTEXTKZ]
    SPRAS,                   -- Language [SPRAS]
    PLOS,                    -- With Insp. Lot [QPLOSQINF]
    PLOS2,                   -- With Insp. Lot [QPLOSQINF2]
    PPAP_IS_REQUIRED,        -- PPAP Required [QPPAP_IS_REQUIRED]
    PPAP_LEVEL,              -- PPAP Level [QPPAP_LEVEL]
    PPAP_STATUS,             -- PPAP Status [QPPAP_STATUS]
    PPAP_ID,                 -- PPAP [QPPAP_ID]
    STSMA,                   -- Status Profile [QSTSMAQINF]
    OBJNR,                   -- QINF object no. [QINFOBJNR]
    NOINSPABN,               -- Source insp. [QNOWEABN]
    VORLABN,                 -- Lead time(days) [QVORLABN]
    REVLV,                   -- Revision Level [REVLV]
    LOEKZ,                   -- Deletion Flag [QLOEKZ]
    CERTCONTROL,             -- Certificate [QCERTCONTROL]
    DUMMY_QINF_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, MATNR, ZAEHL)
);

Learn More