/XFT/QMPPAPT001

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 PPAP Header Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /XFT/QMPPAPT001 (
    MANDT,                          -- Client [MANDT]
    REC_ID,                         -- Record ID [/XFT/SRM_DYN_REC_REC_ID]
    PID,                            -- Sampling Number [/XFT/SRM_QM_PPAP_ID]
    MATNR,                          -- Material Number [/XFT/LO_MATNR_INT]
    REVLV,                          -- Revision Level [REVLV]
    NORM_ID,                        -- Standard [/XFT/SRM_QM_PPAP_NORM_ID]
    LEVEL_ID,                       -- Submission Level [/XFT/SRM_QM_PPAP_LEVEL_ID]
    SAMPL_TYPE_ID,                  -- Sampling Reason [/XFT/SRM_QM_PPAP_SAMPL_TYPE_ID]
    SAMPL_TYPE_IN_TEXT,             -- Sampl.Reason (Text) [/XFT/PPAP_REASON_TEXT]
    PROD_TYPE_ID,                   -- Production Type [/XFT/SRM_QM_PPAP_PROD_TYPE_ID]
    FOR_CUSTOMER_X,                 -- On Behalf of Cust. [/XFT/QM_PPAP_FOR_CUSTOMER_FLAG]
    WERKS,                          -- Plant [WERKS_D]
    DRAWING_NO,                     -- Drawing Number [/XFT/SRM_QM_PPAP_DRAWING_NO]
    LIFNR,                          -- Supplier [LIFNR]
    EKGRP,                          -- Purch. Group [EKGRP]
    EBELN,                          -- Purchasing Doc. [EBELN]
    EBELP,                          -- Item [EBELP]
    INFNR,                          -- Info record [INFNR]
    KUNNR,                          -- Customer [KUNNR]
    VKGRP,                          -- Sales Group [VKGRP]
    VBELN,                          -- Sales Document [VBELN_VA]
    POSNR,                          -- Sales Doc. Item [POSNR_VA]
    MATKL,                          -- Material Group [MATKL]
    NUMOF_SAMPLES,                  -- Number of Samples [/XFT/QM_PPAP_NUMBER_OF_SAMPLES]
    SAMPLE_WEIGHT,                  -- Sample Weight [/XFT/PPAP_SAMPLE_WEIGHT]
    UNIT_OF_WEIGHT,                 -- Unit of Weight [GEWEI]
    IMDS_ID,                        -- IMDS ID [/XFT/QM_PPAP_IMDS_ID]
    PLNNR,                          -- Task List Group [/XFT/LO_QM_PLNNR]
    PLNAL,                          -- Group Counter [/XFT/LO_QM_PLNAL]
    QPLOS,                          -- Insp.lot [/XFT/LO_QM_QPLOS]
    PS_PSPID,                       -- Project Def. [/XFT/LO_PS_PSPID]
    PS_POSID,                       -- WBS Element [/XFT/LO_PS_POSID]
    TOOL_NO,                        -- Tool Number [/XFT/QM_PPAP_TOOL_NO]
    NUMOF_CAVIT,                    -- No. Cavities [/XFT/QM_PPAP_NUMOF_TOOL_CAVIT]
    NUMOF_SAMPL_4_CAV,              -- No. Samples per Cav. [/XFT/QM_PPAP_NUMOF_SAMPL_4_CAV]
    PARENT_ID,                      -- Record ID [/XFT/SRM_DYN_REC_REC_ID]
    MATNR_OUT,                      -- Material No. [/XFT/QM_PPAP_MATNR_OUT]
    FAMILY_REC_ID,                  -- Record ID [/XFT/SRM_DYN_REC_REC_ID]
    FAMILY_PID,                     -- Reference PPAP [/XFT/QM_PPAP_FAMILY_HEAD_ID]
    RECORD_NOT_CREATED,             -- Record Not Created [/XFT/QM_PPAP_REC_NOT_CREATED_X]
    IS_ACCESS_SCOPE_INTERNAL,       -- Boolean [/XFT/BOOLEAN]
    IS_ACCESS_SCOPE_COLLAB,         -- Boolean [/XFT/BOOLEAN]
    SCHEDULED_START_DATE,           -- Scheduled Start Date [/XFT/PPAP_SCHEDULED_START_DATE]
    REQUIRED_END_DATE,              -- Requested Deadline [/XFT/PPAP_REQUIRED_END_DATE]
    COMPLET_PERCENT,                -- Degree of Processing [/XFT/QM_PPAP_COMPLET_PERCENT]
    IS_INTERNAL_COMPLETED,          -- Internal Completed [/XFT/PPAP_IS_INT_COMPLETED]
    IS_INTERNAL_POS_COMPLETED,      -- Int. Pos. Completed [/XFT/PPAP_IS_INT_POS_COMPLETED]
    INTERNAL_COMPLETED_STATUS,      -- Int.Completion Stat. [/XFT/PPAP_INT_COMPL_STATUS]
    INT_COMPLETED_AT,               -- Int. Completed [/XFT/QM_PPAP_INT_COMPLETED_AT]
    IS_CUSTOMER_DECISION_RELEVANT,  -- Cust.Decision Relev. [/XFT/PPAP_IS_CUSTOMER_DEC_RELV]
    IS_COMPLETED_BY_CUSTOMER,       -- Complet. by Customer [/XFT/PPAP_IS_COMPLETED_BY_CUS]
    IS_POS_COMPLETED_BY_CUSTOMER,   -- Pos.Completed Cust. [/XFT/PPAP_IS_POS_COMPL_BY_CUS]
    CUSTOMER_DECISION,              -- Customer Decision [/XFT/PPAP_CUSTOMER_DECISION]
    CUST_DECI_MADE_AT,              -- Customer Decision [/XFT/QM_PPAP_CUST_DECI_MADE_AT]
    STD_EDITION,                    -- Edition [/XFT/QM_PPAP_STD_EDITION]
    PROC_ORIENTATION,               -- PPAP Focus [/XFT/QM_PPAP_PROC_ORIENTATION]
    QUALITY_PLANNER,                -- Q Planner [/XFT/QM_PPAP_QUALITY_PLANNER]
    REQUAL_AGREED,                  -- Requalification [/XFT/PPAP_REQUAL_AGREED]
    REQUAL_PERIOD,                  -- Requalific.Interval [/XFT/PPAP_REQUAL_PERIOD_FACTOR]
    REQUAL_PERIOD_UNIT,             -- Time Unit [/XFT/QM_PPAP_V_TIME_UNIT]
    REQUAL_NOTIFY_CUSTOMER,         -- Inform Customer [/XFT/PPAP_REQUAL_NOTIFY_CUST]
    MATERIAL_IS_PLH,                -- Material Is Placeh. [/XFT/PPAP_MATERIAL_IS_PLH]
    PARTNER_MATERIAL_NO,            -- Partner Material [/XFT/PPAP_PARTNER_MATERIAL_NO]
    PARTNER_MATERIAL_DESCR,         -- Partner Materl Text [/XFT/PPAP_PARTNER_MAT_DESCR]
    PARTNER_COMM_LANGUAGE,          -- Comm. Language [/XFT/PPAP_PARTNER_COMM_LANG]
    AGREEMENT_COMPLETED,            -- Boolean [/XFT/BOOLEAN]
    ECM_NUMBER,                     -- ECM Number [/XFT/ECM_ECM_NUMBER]
    CHANGE_NO,                      -- Change No. [/XFT/LO_ECM_CHANGE_NO]
    HEAD_CHANGEABILITY_RULE_ID,     -- Rule ID Header Chng. [/XFT/PPAP_HEAD_CHNG_RULE_ID]
    COLLAB_INT_REF_REC_ID,          -- Collab.Ref.Record ID [/XFT/PPAP_COLLAB_REF_REC_ID]
    COLLAB_INT_REF_SAMPLING_NO,     -- Ref. PPAP No. [/XFT/PPAP_COLLAB_REF_PID]
    BEGIN_EXT,                      -- abap.char
    PRIMARY KEY (MANDT, REC_ID)
);