- Home
- Resources
- SAP Tables
- MDNB - Net requirements
SAP Table MDNB
Net requirements
MDNB (Net requirements) 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 MDNB to other SAP tables.
Source: MDNB (Net requirements)
MDNB table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| PLAAB |
Material requirements planning segment |
PLAAB |
|
NUMC |
|
2 |
0 |
|
| PLANR |
Planning segment number |
PLANR |
|
CHAR |
|
20 |
0 |
|
| DAT00 |
Receipt/Requirements date |
DAT00 |
|
DATS |
|
8 |
0 |
|
| MNG01 |
Quantity received or quantity required |
MNG01 |
|
QUAN |
|
13 |
3 |
|
| MNG03 |
Shortage Quantity |
MNG03 |
|
QUAN |
|
13 |
3 |
|
| SERNR |
BOM explosion number |
SERNR |
|
CHAR |
|
8 |
0 |
|
| VERID |
Production Version |
VERID |
|
CHAR |
|
4 |
0 |
|
| CUOBJ |
Configuration (internal object number) |
CUOBJ |
|
NUMC |
|
18 |
0 |
|
| KNTTP |
Account Assignment Category |
KNTTP |
|
CHAR |
|
1 |
0 |
|
| SOBKZ |
Special Stock Indicator |
SOBKZ |
|
CHAR |
|
1 |
0 |
|
| KZVBR |
Consumption Posting |
KZVBR |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No consumption |
| V |
Consumption |
| A |
Asset |
| E |
Sales order |
| P |
Project |
|
| KZBWS |
Valuation of Special Stock |
KZBWS |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No stock valuation |
| M |
Separate valuation with ref. to sales document/project |
| A |
Valuation without reference to sales document |
|
| KDAUF |
Sales Order Number |
KDAUF |
|
CHAR |
|
10 |
0 |
|
| KDPOS |
Item Number in Sales Order |
KDPOS |
|
NUMC |
|
6 |
0 |
|
| PSPEL |
WBS Element |
PS_POSNR |
|
NUMC |
|
8 |
0 |
|
| ARSNR |
Settlement reservation number |
ARSNR |
|
NUMC |
|
10 |
0 |
|
| ARSPS |
Item number of the settlement reservation |
ARSPS |
|
NUMC |
|
4 |
0 |
|
| MONKZ |
Indicator: for assembly order procedures |
MONKZ |
|
CHAR |
|
1 |
0 |
Possible values
|
| VRPLA |
Indicator: planning without final assembly |
VRPLA |
|
CHAR |
|
1 |
0 |
Possible values
|
| PBDNR |
Requirements Plan Number |
PBDNR |
|
CHAR |
|
10 |
0 |
|
| TECHS |
Parameter Variant/Standard Variant |
TECHS |
|
CHAR |
|
12 |
0 |
|
| EDGNO |
Internal number for edge of object dependencies tree |
EDGNO |
|
NUMC |
|
17 |
0 |
|
| UMREZ |
Numerator for Conversion to Base Units of Measure |
UMREZ |
|
DEC |
|
5 |
0 |
|
| UMREN |
Denominator for conversion to base units of measure |
UMREN |
|
DEC |
|
5 |
0 |
|
| ERFME |
Unit of Entry |
ERFME |
|
UNIT |
|
3 |
0 |
|
| DBSKZ |
Direct procurement indicator |
DBSKZ |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No direct procurement or direct production |
| E |
Direct production |
| F |
Direct procurement |
|
| WRK02 |
Planning/production plant |
WRK02 |
|
CHAR |
|
4 |
0 |
|
| STLTY |
BOM category |
STLTY |
|
CHAR |
|
1 |
0 |
Possible values
| D |
Document Structure |
| E |
Equipment BOM |
| K |
Order BOM |
| M |
Material BOM |
| S |
Standard BOM |
| T |
Functional Location BOM |
| P |
Work Breakdown Structure BOM |
|
| STLNR |
Bill of material |
STNUM |
|
CHAR |
|
8 |
0 |
|
| STLKN |
BOM item node number |
STLKN |
|
NUMC |
|
8 |
0 |
|
| STPOZ |
Internal counter |
CIM_COUNT |
|
NUMC |
|
8 |
0 |
|
| KUNNR |
Customer Number |
KUNNR |
|
CHAR |
|
10 |
0 |
|
