/SCMTMS/C_IATAC

Transparent Table Customizing Table
9 Fields 2 CDS Views

IATA: Location Codes

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TranspIATALocationCode view from BASIC Obsolete Transp IATA Location Codes
I_TranspIATALocationCode_2 view_entity from BASIC Transportation IATA Location Code

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