/SCWM/T340D

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.

-- Define Values for Warehouse Number
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCWM/T340D (
    MANDT,                   -- Client [MANDT]
    LGNUM,                   -- Warehouse No. [/SCWM/LGNUM]
    NRGM,                    -- NRI Whse Doc. [/SCWM/DE_NRGM]
    NRWV,                    -- NRI Wave [/SCWM/DE_NRWV]
    NUKTA,                   -- NRI Whse Task [/SCWM/LVS_NUKTA]
    GEWEI,                   -- Weight Unit [/SCWM/DE_WGT_UOM]
    KAPPC,                   -- Link to subsys. [/SCWM/T340DKAPPC]
    ZEIEI,                   -- Time Unit [/SCWM/LVS_ZEIEI]
    VOLEH,                   -- Volume Unit [/SCWM/DE_VOL_UOM]
    PARALLEL,                -- Parallel Proc. [/SCWM/DE_PARALLEL]
    NRWHO,                   -- NRI Whse Order [/SCWM/DE_NRWHO]
    WHOLOG,                  -- Generate Log [/SCWM/DE_WHOLOG]
    WHOCTLIST,               -- Pick-HU Proced. [/SCWM/DE_WHO_CTLIST]
    SPR_CTLIST,              -- Proc. Decons. [/SCWM/DE_SPR_CTLIST]
    QM_CTLIST,               -- Proc. Q. Qty [/SCWM/DE_QM_CTLIST]
    FLG_BINN,                -- Use No. of Bins [/SCWM/DE_FLG_BINN]
    FLG_ACAP,                -- Use Committed Cap. [/SCWM/DE_FLG_ACAP]
    BINNOLIM,                -- Dest.Stor.Bins [/SCWM/DE_BINNOLIM]
    BINNOSRT,                -- Interprtn Bin No. [/SCWM/DE_BINNOSRT]
    L2SKR,                   -- Two-Step Pick. [/SCWM/DE_L2SKR]
    L2SKM,                   -- 2-St.Prod.-Dep. [/SCWM/LVS_2SKMAT]
    L2SKP,                   -- Chk 2-step rel. [/SCWM/T3262KPRUE]
    PROCTY_1ST,              -- Process Type [/SCWM/DE_PROCTY_1ST]
    WVPLP,                   -- Parallel WT Wave [/SCWM/DE_WVPLP]
    MAXWP,                   -- Max. Processes [/SCWM/DE_MAXWP]
    SRVGRP,                  -- SvrGrp [/SCWM/DE_SVRGRP]
    MXITMS,                  -- Max. Items [/SCWM/DE_MXITMS]
    MXITMS_FIRST_STEP,       -- Max. Items Withdraw. [/SCWM/DE_MXITMS_FIRST_STEP]
    MXWHO,                   -- Pack. Size WO [/SCWM/DE_MXWHO]
    MAX_SYSERR,              -- Max.Syst.Errors [/SCWM/DE_MXSYSERR]
    MAX_RESERR,              -- Max.Res.Errors [/SCWM/DE_MXRESERR]
    MAX_REPEAT,              -- Max. Rept. when Lckd [/SCWM/DE_MAX_REPEAT]
    RATIOLWH,                -- Dimension Ratio [/SCWM/DE_RATIODIM]
    NRICON,                  -- No.Rge Int. f. Slotg [/SCWM/DE_NRICON]
    PACK_PROCTY,             -- Repack WPT [/SCWM/DE_PACK_PROCTY]
    LDEST,                   -- Printer Name [/SCWM/LVS_LDEST]
    DIST_UOM,                -- Unit of Length [/SCWM/DE_DIST_UOM]
    PRIO_TYP,                -- Priority:Stor.Type [/SCWM/DE_PRIO_TYP]
    PRIO_SEC,                -- Prio.: Storage Sec. [/SCWM/DE_PRIO_SEC]
    PRIO_BT,                 -- Priority: Bin Type [/SCWM/DE_PRIO_BT]
    FLG_BINDET,              -- No BinDet. w/o Slot. [/SCWM/DE_FLG_BINDET]
    PUTUPN,                  -- Val. f. Bin Determ. [/SCWM/DE_PUTUPN]
    WAERS,                   -- Currency [/SCWM/DE_WAERS]
    PAL_CTLIST,              -- Palletiz. Proc. [/SCWM/DE_PAL_CTLIST]
    PDENIAL,                 -- Activate Pick Denial [/SCWM/DE_PDENIAL]
    REPLCAT,                 -- Replenishment St.Tpe [/SCWM/DE_REPLCAT]
    PROCPRFL_ACT,            -- Act.ProcBlkProf. [/SCWM/DE_PROCPRFL_ACT]
    PT_REAR,                 -- ProcType Rearr. [/SCWM/DE_PT_REAR]
    PT_INVPICK,              -- WPT Distr. Ptwy [/SCWM/DE_INVPICK_PROCTY]
    FACTORY_CALENDAR,        -- Factory Calend. [/SCWM/DE_FACTORY_CALENDAR]
    PERIV,                   -- Fisc. Year Var. [/SCWM/PI_DE_PERIV]
    PI_CTLIST,               -- PhysInv Print. Proc. [/SCWM/DE_PI_CTLIST]
    PI_CAT,                  -- Dflt PI Stock Type [/SCWM/DE_PI_STAG_CAT]
    PROCTY_UNLO,             -- WPT UnldAddlHUs [/SCWM/DE_PROCTY_UNLO]
    PT_LOAD,                 -- WPT Loading RF [/SCWM/DE_LOAD_PROCTY]
    PT_REV_LOAD,             -- WPT Load. Rev. RF [/SCWM/DE_REV_LOAD_PROCTY]
    DEMTYP_SOIIND,           -- Req. Type Order [/SCWM/DE_DEMTYP_SOIIND]
    DEMTYP_DEMIIND,          -- Req. Type Req. [/SCWM/DE_DEMTYP_DEMIIND]
    DEMTYP_TRGSTIND,         -- Req. Type Target [/SCWM/DE_DEMTYP_TRGSTIND]
    DEMTYP,                  -- Req.forMax.QtStorTyp [/SCWM/DE_DEMTYP]
    SR_ACTIVE,               -- Deact. S&R [/SCWM/DE_SR_ACTIVE]
    YM_ACTIVE,               -- YM Actv. [/SCWM/DE_YM_ACTIVE]
    GTSBSKEY,                -- GTS BusinessSys [/SCWM/DE_GTSBSKEY]
    GTS_PROCTY_CBR,          -- PrcTypeRel. CBS [/SCWM/DE_GTS_PROCTY_CBR]
    PT_CANCPICK,             -- WPT Putback [/SCWM/DE_PT_CANCPICK]
    PT_HUMOVE,               -- WPT HU on DestL [/SCWM/DE_PT_HUMOVE]
    WM_CTLIST,               -- Procedure [/SCWM/DE_WM_CTLIST]
    WAVEEXC,                 -- Exception Wave [/SCWM/DE_WAVEEXC]
    PT_HURES,                -- WPT HU for Res. [/SCWM/DE_PT_HURES]
    VAS_PERFORMER,           -- Performing Ent. [/SCWM/DE_PS_PERFORM]
    VAS_GRPTYPE_DET,         -- PS Prod. Group Type [/SCWM/DE_VAS_GRPTYPE_DET]
    VASCAT,                  -- VAS Util. Stock Type [/SCWM/DE_VASCAT]
    PRES_PRF,                -- Present. Prof. [/SCWM/DE_PRES_PRF]
    VAS_GRPTYPE_DUR,         -- PlndTime ProdGrpType [/SCWM/DE_VAS_GRPTYPE_DUR]
    SER_LENGTH,              -- SN Length [/SCWM/DE_SER_LENGTH]
    SER_TEMP,                -- Prov. SerialNos [/SCWM/DE_SER_TEMP]
    NRVAS,                   -- NRI VAS Order [/SCWM/DE_NRVS]
    AIMREAR,                 -- Control Data [/SCWM/DE_AIMREAR]
    IND_OWNER,               -- Owner [/SCWM/PI_DEF_OWNER]
    IND_ENTITLED,            -- Party to Disp. [/SCWM/PI_DEF_ENTITLED]
    CORR_DIFF,               -- Corr. Permitted [/SCWM/DE_CORR_DIFF]
    COUNT_TOL,               -- All. Perc. Diff [/SCWM/DE_COUNT_TOL]
    NO_COUNT_TOL,            -- No Tol. Check [/SCWM/DE_NO_COUNT_TOL]
    WAVTIMEREAR,             -- Time [/SCWM/DE_TIME_TO_EXEC]
    WAVUNITREAR,             -- Time Unit [/SCWM/DE_UNIT_T]
    STSMA,                   -- Stat. Prof. Bin [/SCWM/DE_STSMA]
    EPC,                     -- RFID Active [/SCWM/DE_EPC_RFID_ENABLED]
    LM_ACTIVE,               -- LM Is Active [/SCWM/DE_LM_ACTIVE]
    EPC_SEND,                -- Send RFID Data [/SCWM/DE_EPC_RFID_SEND]
    TDC,                     -- TDC [/SCWM/DE_TDC_ACTIVATE]
    USE_EUCLID,              -- Use Euclid. Mtrc [/SCWM/DE_USE_EUCLID]
    NRILT,                   -- NRI Ind.Lab.Tsk [/SCWM/DE_NRILT]
    NRPI,                    -- NRI PI Document [/SCWM/DE_NRPI]
    GEWEI_OLD,               -- Weight Unit [/SCWM/DE_WGT_UOM]
    VOLEH_OLD,               -- Volume Unit [/SCWM/DE_VOL_UOM]
    ZEIEI_OLD,               -- Time Unit [/SCWM/LVS_ZEIEI]
    DIST_UOM_OLD,            -- Unit of Length [/SCWM/DE_DIST_UOM]
    INBPLP,                  -- Par.InboundWTs [/SCWM/DE_INB_PLP]
    MFS_SVRGRP,              -- MFS SvrGrp [/SCWM/DE_MFS_SVRGRP]
    MFS_SVRGRP_BG,           -- Btch Srv Grp for MFS [/SCWM/DE_MFS_SVRGRP_BG]
    GRPTYPE_PSA,             -- Prd. Grp. Tpe [/SCWM/DE_GRPTYPE_PSA]
    INBMAXWP,                -- Max. Work Pr. [/SCWM/DE_INBMAXWP]
    INBSRVGRP,               -- Srv. Grp. Par. [/SCWM/DE_INBSRVGRP]
    INBMINWT,                -- Threshold [/SCWM/DE_INBMINWT]
    PSR_CTLIST,              -- CPRepl. Proced. [/SCWM/DE_PSR_CTLIST]
    PGRPTYPE_INB,            -- PrGrType CD Inb [/SCWM/DE_PGRPTYPE_INB]
    PGRPTYPE_OUT,            -- PrGr.Type Out. [/SCWM/DE_PGRPTYPE_OUT]
    DLV_ESL_ACTIVE,          -- Activate ESL [/SCWM/DE_DLV_ESL_ACTIVE]
    GI_PARALLEL,             -- Parallel GI [/SCWM/DE_GI_PARALLEL]
    CI_PARALLEL,             -- Parallel CI/YM [/SCWM/DE_CI_PARALLEL]
    BT_SPLIT_CTRL,           -- Avoid Batch Split [/SCWM/DE_DLV_BT_SPLIT_CTRL]
    IGNORE_RSRCMSG,          -- Deactivate Msg [/SCWM/DE_IGNORE_RSRCMSG]
    PI_COMPL_WHN,            -- CC Compl. at WhN [/SCWM/DE_PI_COMPL_LGNUM]
    WV_TU_NOUPD,             -- No Wave Upd [/SCWM/DE_WVTU_NOUPD]
    PSHU_CTLIST,             -- Det. Proc. [/SCWM/DE_PSHU_CTLIST]
    WRKSTTYP,                -- Work Center Layout [/SCWM/DE_WRKSTTYP_PSHU]
    PACKED_QTY_CALC,         -- No Packed Qty [/SCWM/DE_PACKED_QTY_CALC]
    PT_GPHUMOVE,             -- WPT HU with UKC [/SCWM/DE_PT_GPHUMOVE]
    PMAT_COLHU,              -- Pack. Material [/SCWM/DE_PMATID]
    CANCPICK_SI,             -- Sk ID Canc [/SCWM/DE_CANCPICK_SI]
    LM_PUTW_WL,              -- Plnd WL Inac Ptwy WT [/SCWM/DE_PUTW_WL]
    LM_DLV_WL,               -- pWL Deliveries [/SCWM/DE_DLV_WL]
    MFS_PRDCHK_USER,         -- Repetition User [/SCWM/DE_MFS_PRDCHK_USER]
    LDP_ACTIVE,              -- LDP Active [/SCWM/DE_LDP_ACTIVE]
    SLED_IPRKZ_ACTIVE,       -- Use Period Ind. [/SCWM/DE_SLED_IPRKZ_ACTIVE]
    RCV_CTLIST,              -- Receive HUs Proc. [/SCWM/DE_RCV_CTLIST]
    MFG_STAGE_CAT,           -- Production St. Type [/SCWM/DE_MFG_STAG_CAT]
    TW_PT_MOVE2PACK,         -- WPT to HUC Load [/SCWM/DE_TW_PROCTY_MOVE2PACK]
    TW_SH_CTLIST,            -- Transit HU Procedure [/SCWM/DE_TW_SH_CTLIST]
    TW_ULD_CTLIST,           -- HU Container Proc. [/SCWM/DE_TW_ULD_CTLIST]
    TW_DSCTY_DEF,            -- Discrp.TM [/SCWM/DE_TW_DSCTY_DEFAULT]
    AUTFO_MERGE_QUEU,        -- Single Process [/SCWM/DE_AUTFO_MERGE_QUEUES]
    PROD_ENT_CHECK,          -- Prod./Entitled Check [/SCWM/DE_PROD_ENT_CHECK]
    EXT_FLAG,                -- WM Usage Mode [/SCWM/EXT_FLAG]
    LM_ELS_USE_BRMS,         -- Use BRFplus for ELS [/SCWM/DE_ELS_USE_BRMS_FLG]
    LM_PROCS_RH,             -- Extrn. Step RcvPrd [/SCWM/DE_PROCS_RH]
    LM_PROCS_RV,             -- Extrn. Step RcvVnd [/SCWM/DE_PROCS_RV]
    WORKSTATION,             -- Work Center [/SCWM/DE_WORKSTATION]
    TATT_CD_ACTIVE,          -- Act. Chg. Documents [/SCWM/DE_TATT_CD_ACTIVE]
    BIN_CD_ACTIVE,           -- Storage Bins [/SCWM/BIN_CD_IND]
    GM_SYNC_ACTIVE,          -- Sync. GM Active [/SCWM/DE_GM_SYNC_ACTIVE]
    OC_MODE,                 -- Output Control [/SCWM/DE_OUTPUT_CONTROL_MODE]
    GI_SINGLE_OD,            -- Separate GI [/SCWM/DE_DLV_GI_SINGLE]
    PT_CLARIFICATION,        -- WPT Clarification [/SCWM/DE_CLARIFICATION_PROCTY]
    NO_CROSS_WO,             -- No WO Splitting [/SCWM/DE_NO_CROSS_WO]
    FIXBIN_CD_ACTIVE,        -- Fixed Bin Assignment [/SCWM/DE_FIXBIN_CD_ACTIVE]
    SAME_USER_TO_RECOUNT,    -- Different User [/SCWM/DE_SAME_USER_TO_RECOUNT]
    PSASTAGE_CD_ACTIVE,      -- PSA Assgmt Chg. Docs [/SCWM/DE_PSASTG_CD_ACTIVE]
    WSWO,                    -- No WO Simulation [/SCWM/DE_WSWHOSIM]
    WSSU,                    -- No Status Update [/SCWM/DE_WSSU]
    PT_REV_KANBAN,           -- WPT Kanban Reversal [/SCWM/DE_PT_REV_KANBAN]
    SER_CHECK_CNTRL,         -- Incons. Warning [/SCWM/DE_SER_CONF_CHANG_CHECK]
    PSHU_DIFF_PACKMAT_OK,    -- No Pack. Mat. Check [/SCWM/DE_PSHU_DIFF_PACKMAT_OK]
    PSHU_DIFF_WEIGHT_OK,     -- No Weight Check [/SCWM/DE_PSHU_DIFF_WEIGHT_OK]
    PSHU_DIFF_VOLUME_OK,     -- No Volume Check [/SCWM/DE_PSHU_DIFF_VOLUME_OK]
    PSHU_DIFF_CAPACITY_OK,   -- No Capacity Check [/SCWM/DE_PSHU_DIFF_CAPACITY_OK]
    PSHU_DIFF_MEASURE_OK,    -- No Measurement Check [/SCWM/DE_PSHU_DIFF_MEASURE_OK]
    PSHU_DIFF_QUANTITY_OK,   -- No Quantity Check [/SCWM/DE_PSHU_DIFF_QUANTITY_OK]
    PAS_CD_ACTIVE,           -- Act. Chg. Documents [/SCWM/DE_PAS_CD_IND]
    SGM_PROCTY_FOR_GMBIN,    -- Whse Proc. Type [/SCWM/DE_SGM_PROCTY_FOR_GMBIN]
    SGM_PO_PB_PROFILE_ID,    -- UPB Prof. Vendor [/SCWM/DE_SGM_PO_PB_PROFILE_ID]
    SGM_ORD_PB_PROFILE_ID,   -- UPB Prof. Production [/SCWM/DE_SGM_ORD_PB_PROFILE_ID]
    REPL_FLAG,               -- Use Stk Removal Ctrl [/SCWM/DE_REPL_FLAG]
    ACT_ASYNC_MES,           -- Async. Communication [/SCWM/DE_ACT_ASYNC_MES]
    ACT_WHR_STATUS,          -- Send Whse Req. Sts. [/SCWM/DE_ACT_WHR_STATUS]
    RCV_PBP,                 -- UPB Profile [/SCWM/DE_PBP_ID_RCV]
    SPR_PBP,                 -- UPB Profile Decons. [/SCWM/DE_PBP_ID_SPR]
    SGM_ACT_TRANSFER,        -- Transfer Movements [/SCWM/DE_SGM_ACT_TRANSFER]
    SGM_ACT_RECEIPT,         -- Receipt Movements [/SCWM/DE_SGM_ACT_RECEIPT]
    SGM_ACT_ISSUE,           -- Goods Issue Mvnts [/SCWM/DE_SGM_ACT_ISSUE]
    RR_ACTIVE,               -- Rounding Residuals [/SCWM/DE_RR_ACTIVE]
    RR_AUTO_POST_TO_ERP,     -- Post RR Automatic [/SCWM/DE_RR_AUTO_POST_TO_ERP]
    ACT_WIP_GR_STATUS,       -- Send WIP GR Sts. [/SCWM/DE_WIP_GR_STATUS]
    ACT_WIP_PT_STATUS,       -- Send Ptwy Sts. [/SCWM/DE_WIP_PT_STATUS]
    WIP_INT_NR,              -- WIP No. Interval [/SCWM/DE_WIP_INT_NR]
    WAVE_2STEP_OPT_ACTIVE,   -- Optimization [/SCWM/DE_WAVE_2STEP_OPT_ACT]
    WAVE_2STEP_OPT_TRIGGER,  -- Optimization Trigger [/SCWM/DE_WAVE_2STEP_OPT_TRIGGR]
    WAVE_2STEP_AUTO_ALLOC,   -- Auto Task Creation [/SCWM/DE_WAVE_2STEP_AUT_ALLOC]
    RR_REASON_WM,            -- Movement Reason [/SCWM/DE_REASON]
    PREDEF_SN_VERIF,         -- Verify Prdfnd SNs [/SCWM/DE_PREDEF_SER_VERF]
    NO_OVER_PICK_IND,        -- Prohibit Overpicking [/SCWM/DE_NO_OVER_PICK_IND]
    NO_DRCT_ODO_IND,         -- No Drct ODO Creation [/SCWM/DE_NO_DRCT_ODO_IND]
    PRIMARY KEY (MANDT, LGNUM)
);