STRAVELAG

Transparent Table Application Table
13 Fields 1 CDS Views

Reisebüro

STRAVELAG is an SAP database table in S/4HANA. Reisebüro. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FPMT_TRAVELAG view from Travel Agency

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt s_mandt Client
KEY agencynum s_agncynum Agency No.
name s_agncynam Travel agency name
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.
url s_url Travel agency URL
langu spras Language
currency s_curr_ag Trav.Agency.Curr

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.

-- Reisebüro
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STRAVELAG (
    MANDT,      -- Client [s_mandt]
    AGENCYNUM,  -- Agency No. [s_agncynum]
    NAME,       -- Travel agency name [s_agncynam]
    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]
    URL,        -- Travel agency URL [s_url]
    LANGU,      -- Language [spras]
    CURRENCY,   -- Trav.Agency.Curr [s_curr_ag]
    PRIMARY KEY (MANDT, AGENCYNUM)
);

Learn More