- Home
- Resources
- SAP Tables
- MDLB - Header data for subcontracting components
SAP Table MDLB
Header data for subcontracting components
MDLB (Header data for subcontracting components) 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 MDLB to other SAP tables.
Source: MDLB (Header data for subcontracting components)
MDLB table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| EBELN |
Purchasing Document Number |
EBELN |
|
CHAR |
|
10 |
0 |
|
| EBELP |
Item Number of Purchasing Document |
EBELP |
|
NUMC |
|
5 |
0 |
|
| EBELE |
Delivery Schedule Line Counter |
EETEN |
|
NUMC |
|
4 |
0 |
|
| BANFN |
Purchase Requisition Number |
BANFN |
|
CHAR |
|
10 |
0 |
|
| BNFPO |
Item Number of Purchase Requisition |
BNFPO |
|
NUMC |
|
5 |
0 |
|
| PLNUM |
Planned order number |
PLNUM |
|
CHAR |
|
10 |
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 |
|
| BESKZ |
Procurement Type |
BESKZ |
|
CHAR |
|
1 |
0 |
Possible values
| E |
In-house production |
| F |
External procurement |
| NULL |
No procurement |
| X |
Both procurement types |
|
| SOBES |
Special procurement type |
SOBES |
|
CHAR |
|
1 |
0 |
Possible values
| 0 |
Standard external procurement |
| 2 |
Consignment |
| 3 |
Subcontracting |
| 7 |
Stock transfer |
| E |
Standard in-house production |
| P |
Production in plant 2 |
| 9 |
IS-OIL only: Stock transfer reservation |
|
| KDAUF |
Sales Order Number |
KDAUF |
|
CHAR |
|
10 |
0 |
|
| KDPOS |
Item Number in Sales Order |
KDPOS |
|
NUMC |
|
6 |
0 |
|
| KDEIN |
Delivery Schedule for Sales Order |
KDEIN |
|
NUMC |
|
4 |
0 |
|
| PSPEL |
WBS Element |
PS_POSNR |
|
NUMC |
|
8 |
0 |
|
| WAMNG |
Issued Quantity |
WAMNG |
|
QUAN |
|
13 |
3 |
|
| WAWRT |
Sum of the values of goods issues |
WAWRT |
|
CURR |
|
13 |
2 |
|
| KZEAR |
Final Issue for This Reservation |
KZEAR |
|
CHAR |
|
1 |
0 |
Possible values
|
| LIFNR |
Account Number of Vendor or Creditor |
LIFNR |
LFA1
|
CHAR |
|
10 |
0 |
|
| AUFPL_ORD |
Routing number of operations in the order |
CO_AUFPL |
|
NUMC |
|
10 |
0 |
|
| APLZL_ORD |
General counter for order |
CO_APLZL |
|
NUMC |
|
8 |
0 |
|
MDLB foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| MDLB |
LIFNR |
SY |
MANDT |
LFA1 |
Vendor Master (General Section) |
MANDT |
| MDLB |
LIFNR |
MDLB |
LIFNR |
LFA1 |
Vendor Master (General Section) |
LIFNR |
