QINF_FAI

Transparent Table Application Table
8 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 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QltyFirstArticleInsp view_entity from BASIC First Article Inspection

Fields (8)

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.
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]
    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