SAP Table MAT_RANGE

Range for Material Number (MATNR)

MAT_RANGE (Range for Material Number (MATNR)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MAT_RANGE to other SAP tables.

MAT_RANGE table fields

Field

Data element

Checktable

Datatype

Length

Decimals

SIGN

Selection operator SIGN (as per range table)

SIGN_RANGE

CHAR

Possible values

I	Inclusive of defined values/range
E	Exclusive of defined values/range

OPTION

Selection operator OPTION (as per range table)

OPT_RANGE

CHAR

Possible values

EQ	equal to (= Low)
NE	not equal to (<> Low)
BT	Between lower and upper value (Low <= x <= High)
NB	Outside lower and upper value (x < Low und High < x )
CP	Contains the pattern
NP	Does not contain the pattern
LT	Less than (< low)
LE	Less than or equal to (<= low)
GT	Greater than (> low)
GE	Greater than or equal to (>= low)

MATNR_LOW

From material number

MATNR_V

CHAR

MATNR_HIGH

To material number

MATNR_B

CHAR