SAP Table EQBS
Serial Number Stock Segment
EQBS (Serial Number Stock Segment) 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 EQBS to other SAP tables.
EQBS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
EQUNR
Equipment Number
|
EQUNR | EQUI |
CHAR
|
18 | 0 | |
|
LBBSA
Stock Type of Goods Movement (Primary Posting)
|
LBBSA | T156C |
CHAR
|
2 | 0 | |
|
B_WERK
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |
|
B_LAGER
Storage Location
|
LGORT_D | T001L |
CHAR
|
4 | 0 | |
|
B_CHARGE
Batch Number
|
B_CHARGE |
CHAR
|
10 | 0 | ||
|
SOBKZ
Special Stock Indicator
|
SOBKZ | T148 |
CHAR
|
1 | 0 | |
|
KUNNR
Customer account number
|
B_KUNNR | KNA1 |
CHAR
|
10 | 0 | |
|
LIFNR
Account number of the vendor
|
B_LIFNR | LFA1 |
CHAR
|
10 | 0 | |
|
KDAUF
Sales Order Number
|
KDAUF | VBUK |
CHAR
|
10 | 0 | |
|
KDPOS
Item Number in Sales Order
|
KDPOS |
NUMC
|
6 | 0 | ||
|
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR |
NUMC
|
8 | 0 | ||
|
DISUB_OWNER
Owner of stock
|
OWNER_D |
CHAR
|
10 | 0 |
EQBS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EQBS | B_LAGER | EQBS | MANDT |
T001L
Storage Locations
|
MANDT |
| EQBS | B_LAGER | EQBS | B_WERK |
T001L
Storage Locations
|
WERKS |
| EQBS | B_LAGER | EQBS | B_LAGER |
T001L
Storage Locations
|
LGORT |
| EQBS | B_WERK | EQBS | B_WERK |
T001W
Plants/Branches
|
WERKS |
| EQBS | B_WERK | EQBS | MANDT |
T001W
Plants/Branches
|
MANDT |
| EQBS | EQUNR | EQBS | MANDT |
EQUI
Equipment master data
|
MANDT |
| EQBS | EQUNR | EQBS | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| EQBS | KDAUF | EQBS | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| EQBS | KDAUF | EQBS | KDAUF |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| EQBS | KUNNR | EQBS | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| EQBS | KUNNR | EQBS | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| EQBS | LBBSA | EQBS | LBBSA |
T156C
Stock Types and Their Values
|
LBBSA |
| EQBS | LBBSA | EQBS | SOBKZ |
T156C
Stock Types and Their Values
|
SOBKZ |
| EQBS | LIFNR | EQBS | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EQBS | LIFNR | EQBS | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EQBS | MANDT | EQBS | MANDT |
T000
Clients
|
MANDT |
| EQBS | SOBKZ | EQBS | MANDT |
T148
Special Stock Indicator
|
MANDT |
| EQBS | SOBKZ | EQBS | SOBKZ |
T148
Special Stock Indicator
|
SOBKZ |