SAP Table SCUSTOM
Flight customers
SCUSTOM (Flight 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 SCUSTOM to other SAP tables.
SCUSTOM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | S_MANDT | T000 | CLNT | 3 | 0 | ||||||
| ID | Customer Number | S_CUSTOMER | SBUSPART | NUMC | 8 | 0 | ||||||
| NAME | Customer name | S_CUSTNAME | CHAR | 25 | 0 | |||||||
| FORM | Form of address | S_FORM | CHAR | 15 | 0 | |||||||
| STREET | Street | S_STREET | CHAR | 30 | 0 | |||||||
| POSTBOX | PO Box | S_POSTBOX | CHAR | 10 | 0 | |||||||
| POSTCODE | Postal Code | POSTCODE | CHAR | 10 | 0 | |||||||
| CITY | City | CITY | CHAR | 25 | 0 | |||||||
| COUNTRY | Country code | S_COUNTRY | CHAR | 3 | 0 | |||||||
| REGION | Region | S_REGION | CHAR | 3 | 0 | |||||||
| TELEPHONE | Telephone number of flight customer | S_PHONENO | CHAR | 30 | 0 | |||||||
| CUSTTYPE | Customer type | S_CUSTTYPE | CHAR | 1 | 0 |
Possible values
|
||||||
| DISCOUNT | Discount rate | S_DISCOUNT | NUMC | 3 | 0 | |||||||
| LANGU | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||
| Customer e-mail address | S_EMAIL | CHAR | 40 | 0 | ||||||||
| WEBUSER | Web user name for customer | S_WEBNAME | CHAR | 25 | 0 | |||||||
SCUSTOM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SCUSTOM | ID | SCUSTOM | MANDT | SBUSPART | Airline Partner | MANDANT |
| SCUSTOM | ID | SCUSTOM | ID | SBUSPART | Airline Partner | BUSPARTNUM |
| SCUSTOM | LANGU | SCUSTOM | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| SCUSTOM | MANDT | SCUSTOM | MANDT | T000 | Clients | MANDT |
