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 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
||||||
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 |