SAP Table CUSTOMERS
ABAP Book: Customers
CUSTOMERS (ABAP Book: Customers) 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 CUSTOMERS to other SAP tables.
CUSTOMERS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
S_MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
ID
Customer Number
|
S_CUSTOMER |
NUMC
|
8 | 0 | ||||||||
|
NAME
Customer name
|
S_CUSTNAME |
CHAR
|
25 | 0 | ||||||||
|
POSTCODE
Postal Code
|
POSTCODE |
CHAR
|
10 | 0 | ||||||||
|
CITY
City
|
CITY |
CHAR
|
25 | 0 | ||||||||
|
CUSTTYPE
Customer type
|
S_CUSTTYPE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
DISCOUNT
Discount rate
|
S_DISCOUNT |
NUMC
|
3 | 0 | ||||||||
|
TELEPHONE
Telephone number of flight customer
|
S_PHONENO |
CHAR
|
30 | 0 | ||||||||
CUSTOMERS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| CUSTOMERS | MANDT | CUSTOMERS | MANDT |
T000
Clients
|
MANDT |