/SCWM/BINMAT

Transparent Table Application Table
17 Fields 1 CDS Views

Assignment Table for Fixed Bins - Product

/SCWM/BINMAT is an SAP database table in S/4HANA. Assignment Table for Fixed Bins - Product. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWM_FixedBinAssignment view_entity from BASIC Warehouse Fixed Bin Assignment

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lgnum /SCWM/LGNUM Warehouse No.
KEY matid /SCWM/DE_MATID Product
KEY entitled /SCWM/DE_ENTITLED Disposal Party
KEY lgpla /SCWM/LGPLA Storage Bin
lgtyp /SCWM/LGTYP Storage Type
outcon /SCWM/DE_OUTCON Bin Improvable
datout /SCWM/DE_DATOUT Changed On
maxqty /SCWM/DE_MAXQTY Maximum Qty
maxqty_uom_dsp /SCWM/DE_MAXQTY_UOM_DSP DsplyUoMMax.Qty
minqty /SCWM/DE_MINQTY Minimum Qty
minqty_uom_dsp /SCWM/DE_MINQTY_UOM_DSP DsplyUoMMin.Qty
matnr /SCWM/DE_MATNR Product
rmmqty_fix /SCWM/DE_RMMQTY_FIX Qties Fixed
created_at /SCWM/DE_CREATED_DT Creation Time
created_by /SCWM/DE_CREATOR Created By
improv_fix /SCWM/DE_STBIN_IMPROV_FIX Impr Fixed

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.

-- Assignment Table for Fixed Bins - Product
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCWM/BINMAT (
    MANDT,           -- Client [MANDT]
    LGNUM,           -- Warehouse No. [/SCWM/LGNUM]
    MATID,           -- Product [/SCWM/DE_MATID]
    ENTITLED,        -- Disposal Party [/SCWM/DE_ENTITLED]
    LGPLA,           -- Storage Bin [/SCWM/LGPLA]
    LGTYP,           -- Storage Type [/SCWM/LGTYP]
    OUTCON,          -- Bin Improvable [/SCWM/DE_OUTCON]
    DATOUT,          -- Changed On [/SCWM/DE_DATOUT]
    MAXQTY,          -- Maximum Qty [/SCWM/DE_MAXQTY]
    MAXQTY_UOM_DSP,  -- DsplyUoMMax.Qty [/SCWM/DE_MAXQTY_UOM_DSP]
    MINQTY,          -- Minimum Qty [/SCWM/DE_MINQTY]
    MINQTY_UOM_DSP,  -- DsplyUoMMin.Qty [/SCWM/DE_MINQTY_UOM_DSP]
    MATNR,           -- Product [/SCWM/DE_MATNR]
    RMMQTY_FIX,      -- Qties Fixed [/SCWM/DE_RMMQTY_FIX]
    CREATED_AT,      -- Creation Time [/SCWM/DE_CREATED_DT]
    CREATED_BY,      -- Created By [/SCWM/DE_CREATOR]
    IMPROV_FIX,      -- Impr Fixed [/SCWM/DE_STBIN_IMPROV_FIX]
    PRIMARY KEY (MANDT, LGNUM, MATID, ENTITLED, LGPLA)
);

Learn More