TA23ADR

Predefined Addresses in Travel Management | #masterdata | Component: Travel Management
Column Name Description
MANDT FK Client
ADRKEY Key of Table TA23ADR (Sequence Number)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CITY City TEXT40
POST_CODE City postal code CHAR10
STREET Street TEXT60
HOUSE_NUM House Number TEXT10
LATITUDE Geo location latitude GEOLONLAT
LONGITUDE Geo location longitude GEOLONLAT
Master Data Relations Join Conditions
Custom Categories for Predefined Addresses
  • Custom Categories for Predefined Addresses
  • Client
Country/Region Key
  • Country/Region Key
  • Client
  • TA23ADR.COUNTRY == T005.LAND1
  • TA23ADR.MANDT == T005.MANDT
IATA Location for Airport
  • IATA Location for Airport
  • Client
  • TA23ADR.IATA_FLIGHT == TA21L.LOCID
  • TA23ADR.MANDT == TA21L.MANDT
IATA Location for Hotel
  • IATA Location for Hotel
  • Client
  • TA23ADR.IATA_GROUND == TA21L.LOCID
  • TA23ADR.MANDT == TA21L.MANDT
Client TA23ADR.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • TA23ADR.MANDT == T005S.MANDT
  • TA23ADR.COUNTRY == T005S.LAND1
  • TA23ADR.REGION == T005S.BLAND
Other Relations | to Master Data Relations ↑ Join Conditions
International Unique Train Station Number
  • International Unique Train Station Number
  • Client
  • ?
  • TA23ADR.TRAIN_STATION == TA22RSS.BFNR
  • TA23ADR.MANDT == TA22RSS.MANDT
  • TA23ADR.[column in domain "ENDDA"] == TA22RSS.ENDDA