SAP table CUSTOMERS (ABAP Book: Customers)

SAP table CUSTOMERS has 2 primary key fields being MANDT,ID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 S_MANDT
ID Customer Number NUMC 8 0 * S_CUSTOMER
NAME Customer name CHAR 25 0 S_CUSTNAME
POSTCODE Postal Code CHAR 10 0 POSTCODE
CITY City CHAR 25 0 CITY
CUSTTYPE Customer type CHAR 1 0 S_CUSTTYPE
B Business Customer
P Private Customer
DISCOUNT Discount rate NUMC 3 0 S_DISCOUNT
TELEPHONE Telephone number of flight customer CHAR 30 0 S_PHONENO

CUSTOMERS foreign key relationships

Table Field Check Table Check Field
0 CUSTOMERS MANDT T000 Clients MANDT