T399X

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.

-- Parameters dependent on order type
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T399X (
    MANDT,                      -- Client [mandt]
    WERKS,                      -- Plant [werks_d]
    AUART,                      -- Order Type [aufart]
    PLNTY,                      -- Task List Type [plnty]
    PRF_GROUPE,                 -- Group [netprfgrup]
    PRF_NAME,                   -- Name [netprfname]
    PRF_INDEX,                  -- Index [netprfindx]
    OBJNR_VORG,                 -- ActvtyAcctAsgn. [objnr_vorg]
    DFREG,                      -- Default Rule [dfreg]
    ARBPA,                      -- Routing Selec. [co_plaul]
    CAPID,                      -- BOM Application [capid]
    CPSLID,                     -- Selection ID [cpsid]
    AUTYP,                      -- Order category [auftyp]
    KLVARP,                     -- Plnd Costing Variant [kalkvarpln]
    KLVARI,                     -- Act. Costing Variant [kalkvarist]
    DPROBO,                     -- Op. detl. check [co_dprobo]
    DPROBC,                     -- CompDetlCheck [co_dprobc]
    FLG_DOC,                    -- Change document [co_flg_doc]
    AWSLS,                      -- Variance key [awsls]
    ABGSL,                      -- RA Key [abgr_schl_appl]
    ALTSEQ,                     -- Alt. sequences [co_alt_seq]
    FLG_STAT,                   -- Statist. order [co_flgstat]
    VORNR_DEL,                  -- Op./act. incrmt [del_vornr]
    FLG_ERF_H,                  -- Entry tool [flg_erf_h]
    RSTRA,                      -- Red. Strategy [rstra]
    STATISTIK,                  -- Statistics [co_statis]
    SEQ_CHANGE,                 -- Seq. exchange [co_seq_chg]
    CHGKZ_HEAD,                 -- OrdStatChangeDc [co_chgkz_h]
    CHGKZ_OPR,                  -- OpStatChangeDoc [co_chgkz_o]
    CHGKZ_CMP,                  -- MatStatChngeDoc [co_chgkz_c]
    CHGKZ_PRT,                  -- PRTStatChangeDc [co_chgkz_p]
    PLTRM,                      -- SchedlgResults [co_pltrm]
    AOB_KEY,                    -- Rel. view [aob_key]
    PROFIDGRAF,                 -- Order profile [profid_grf]
    AOB_DARST,                  -- Rel. display [aob_darst]
    VRG_DARST,                  -- Op. display [vrg_darst]
    PHS_DARST,                  -- Phase display [phs_darst]
    E_DISPO,                    -- Sub. MRP ctrlr. [co_edispo]
    E_FEVOR,                    -- SubProdSuperv [co_efevor]
    NAUCOST,                    -- NoAutomatCost [co_naucost]
    STRAT,                      -- Strategy [cn_strat]
    EBR_ERF,                    -- PDD required [ebr_erf]
    CHSCH,                      -- Search Proced. [kalsma_ch]
    MC_VHEAD,                   -- Header [mc_vhead]
    MC_VITEM,                   -- Item [mc_vitem]
    MC_VOPER,                   -- Operation [mc_voper]
    CO_STAUF,                   -- BOM selection [co_stauf]
    PRUEB,                      -- Net Order Price [co_prueb]
    ALT_PLANW,                  -- AltTaskListApplic. [alt_plnaw]
    WF_MAT_CHG,                 -- Wrkflw PO chg. [wf_mat_chg]
    PDC_ACTIVE,                 -- PDC active [pdc_active]
    NO_DISP,                    -- Eff. mat. plng [no_disp_plus]
    PROF_GR,                    -- Graph. profile [co_prof_gr]
    PRUEFART,                   -- Inspection Type [qpart]
    ORD_BANF,                   -- CollctveRequstn [ord_banf]
    MBWEB,                      -- Purchase order [mbweb]
    MBWEF,                      -- ProdOrder [mbwef]
    MBWAP,                      -- PlannedGoodsIss [mbwap]
    MBWAU,                      -- UnplanGoodsIss [mbwau]
    NOPCOST,                    -- No planned costs [co_nopcost]
    FLG_SCRAP,                  -- Scrap [flg_scrap]
    VAL_REC,                    -- Approval req. [flg_recipe]
    KZCHP,                      -- Check Batch [kzchp]
    CHP_ERF,                    -- Batch rec. req. [chp_erf]
    CHP_DAUER,                  -- Avail.batch rec [chp_dauer]
    PKOSA,                      -- Cost Collector [co_pkosa]
    PVSEL,                      -- Prod. Version [pvsel_kz]
    FTLPROF,                    -- ProfMissPrtsLstOrdNo [co_ftl_prof]
    FTLPROFNET,                 -- PrfMissPrtLstCollOrd [co_ftl_prof_netz]
    DWBPROF,                    -- Goods movements [co_prof_mm]
    KZFORT,                     -- Indicator:Progress [kzfort]
    OCM_PROF,                   -- Change profile [ocm_profile]
    ROUT_TEXT,                  -- Routing Text [co_rout_text]
    UPD_ONLY,                   -- Update costs [cn_upd_only]
    MBWEW,                      -- MD GR WIP Batch [mbwew]
    WIPBATCH_GM,                -- Post GM [co_wipb_flg_gm]
    LFE_DEF_RULE,               -- Default Rule [eaml_lfe_def_rule_ord]
    FLG_READ,                   -- BOM Explosion [read_mas]
    PROCMTINTEGRATIONSCENARIO,  -- Procurement Mode [procmtintegrationscenario]
    EAMCC4_CONT_DET,            -- Determine Contract [eamcc4_contract_det]
    PLORD_TEXT,                 -- Plnd Order Text [co_plord_text]
    ORDER_SPLIT,                -- Split Costs [co_order_split]
    EBW_KEY,                    -- Event-Based Proc Key [fco_ebw_key]
    PRIMARY KEY (MANDT, WERKS, AUART)
);