QINF_FAI

Transparent Table Application Table
12 Fields 1 CDS Views

First article inspection planning in Quality Info Record

QINF_FAI is an SAP database table in S/4HANA. First article inspection planning in Quality Info Record. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QltyFirstArticleInsp view from BASIC First Article Inspection

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY zaehl Q_COUNT Counter
KEY fai_id QFAI_ID First Article Insp.
ebeln BSTNR Purchase order
ebelp BSTPO Item
valuation QBEWERTUNG Code Valuation
fai_insp_exists QFAI_EXISTS FAI Exists
ersteller QINFERST Created By
erstelldat QINFERSTDT Created On
aenderer QINFAEND Changed By
changeddatetime TZNTSTMPS Time Stamp

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.

-- First article inspection planning in Quality Info Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QINF_FAI (
    MANDT,            -- Client [MANDT]
    MATNR,            -- Material [MATNR]
    ZAEHL,            -- Counter [Q_COUNT]
    FAI_ID,           -- First Article Insp. [QFAI_ID]
    EBELN,            -- Purchase order [BSTNR]
    EBELP,            -- Item [BSTPO]
    VALUATION,        -- Code Valuation [QBEWERTUNG]
    FAI_INSP_EXISTS,  -- FAI Exists [QFAI_EXISTS]
    ERSTELLER,        -- Created By [QINFERST]
    ERSTELLDAT,       -- Created On [QINFERSTDT]
    AENDERER,         -- Changed By [QINFAEND]
    CHANGEDDATETIME,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, MATNR, ZAEHL, FAI_ID)
);

Learn More