/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