SAP table SCUSTOM (Flight customers)

SAP table SCUSTOM 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 SBUSPART S_CUSTOMER
NAME Customer name CHAR 25 0 S_CUSTNAME
FORM Form of address CHAR 15 0 S_FORM
STREET Street CHAR 30 0 S_STREET
POSTBOX PO Box CHAR 10 0 S_POSTBOX
POSTCODE Postal Code CHAR 10 0 POSTCODE
CITY City CHAR 25 0 CITY
COUNTRY Country Code CHAR 3 0 S_COUNTRY
REGION Region CHAR 3 0 S_REGION
TELEPHONE Telephone number of flight customer CHAR 30 0 S_PHONENO
CUSTTYPE Customer type CHAR 1 0 S_CUSTTYPE
B Business Customer
P Private Customer
DISCOUNT Discount rate NUMC 3 0 S_DISCOUNT
LANGU Language Key LANG 1 0 T002 SPRAS
EMAIL Customer e-mail address CHAR 40 0 S_EMAIL
WEBUSER Web user name for customer CHAR 25 0 S_WEBNAME

SCUSTOM foreign key relationships

Table Field Check Table Check Field
0 SCUSTOM ID SBUSPART Airline Partner MANDANT