SCUSTOM

Transparent Table Application Table
16 Fields 5 CDS Views

Flight customers

SCUSTOM is an SAP database table in S/4HANA. Flight customers. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
demo_cds_semantics_annotation view_entity from
Fdt_Test_Custom_Cds view from Customer
S_Customers view from Flight Customers
SADL_V_ExpVoc_Customer view from Integration Test CDS View
sdshhvcdsview view from

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt S_MANDT Client
KEY id S_CUSTOMER Customer Number
name S_CUSTNAME Customer name
form S_FORM Title
street S_STREET Street
postbox S_POSTBOX PO Box
postcode POSTCODE Postal Code
city CITY City
country S_COUNTRY Country/Region
region S_REGION Region
telephone S_PHONENO Tel.
custtype S_CUSTTYPE B/P customer
discount S_DISCOUNT Discount (%)
langu SPRAS Language
email S_EMAIL E-Mail Address
webuser S_WEBNAME Web name

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Flight customers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCUSTOM (
    MANDT,      -- Client [S_MANDT]
    ID,         -- Customer Number [S_CUSTOMER]
    NAME,       -- Customer name [S_CUSTNAME]
    FORM,       -- Title [S_FORM]
    STREET,     -- Street [S_STREET]
    POSTBOX,    -- PO Box [S_POSTBOX]
    POSTCODE,   -- Postal Code [POSTCODE]
    CITY,       -- City [CITY]
    COUNTRY,    -- Country/Region [S_COUNTRY]
    REGION,     -- Region [S_REGION]
    TELEPHONE,  -- Tel. [S_PHONENO]
    CUSTTYPE,   -- B/P customer [S_CUSTTYPE]
    DISCOUNT,   -- Discount (%) [S_DISCOUNT]
    LANGU,      -- Language [SPRAS]
    EMAIL,      -- E-Mail Address [S_EMAIL]
    WEBUSER,    -- Web name [S_WEBNAME]
    PRIMARY KEY (MANDT, ID)
);

Learn More