STRAVELAG

Transparent Table Application Table
13 Fields 1 CDS Views

Travel agency

STRAVELAG is an SAP database table in S/4HANA. Travel agency. 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.

-- Travel agency
-- 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