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
B Business Customer
P Private Customer
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