/SCMTMS/C_IATAC

Transparent Table Customizing Table
9 Fields 1 CDS Views

IATA: Location Codes

/SCMTMS/C_IATAC is an SAP database table in S/4HANA. IATA: Location Codes. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TranspIATALocationCode view from BASIC Transportation IATA Location Codes

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY iatac /scmtms/loc_iatacode IATA: Location
country land1 Country/Reg.
region regio Region
citycode /scmtms/city_iatacode IATA: City
exec_org_id /scmtms/exec_org_ext_id Execution Org
xpos /scmtms/longitude_deg Longitude
ypos /scmtms/latitude_deg Latitude
tzone /scmtms/tzone Time Zone

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.

-- IATA: Location Codes
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCMTMS/C_IATAC (
    CLIENT,       -- Client [mandt]
    IATAC,        -- IATA: Location [/scmtms/loc_iatacode]
    COUNTRY,      -- Country/Reg. [land1]
    REGION,       -- Region [regio]
    CITYCODE,     -- IATA: City [/scmtms/city_iatacode]
    EXEC_ORG_ID,  -- Execution Org [/scmtms/exec_org_ext_id]
    XPOS,         -- Longitude [/scmtms/longitude_deg]
    YPOS,         -- Latitude [/scmtms/latitude_deg]
    TZONE,        -- Time Zone [/scmtms/tzone]
    PRIMARY KEY (CLIENT, IATAC)
);

Learn More