T5JXL

Contact Information for Office | #transactional | Component: Japan
Column Name Description
MANDT FK Client
CTTID Sequence Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CTTXT Item Text TEXT40
PSTLZ Postal Code PSTLZ
ADKN1 Line of Address in Katakana TEXT60
ADKN2 Line of Address in Katakana TEXT60
ADKN3 Line of Address in Katakana TEXT60
ORT01 Line of Address in Kanji TEXT30
ORT02 Line of Address in Kanji TEXT30
STRAS Line of Address in Kanji TEXT30
TELNR Telephone Number TELNR
FAXNR Fax Number CHAR14
EMADR E-mail Address TEXT80
JNMKN Company Name in Katakana (Legal Person) TEXT100
JGNNM Name of Company (Legal Person) TEXT50
JDPKN Department Name (Kana) TEXT80
JGNDP Department Name TEXT80
JPRKN Name of Representative (Kana) TEXT80
JGNPR Name of Representative Person TEXT40
JGNPS Title of Representative Person TEXT20
Master Data Relations Join Conditions
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • T5JXL.MANDT == T005E.MANDT
  • T5JXL.COUNC == T005E.COUNC
  • T5JXL.LAND1 == T005E.LAND1
  • T5JXL.STATE == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • T5JXL.LAND1 == T005.LAND1
  • T5JXL.MANDT == T005.MANDT
Client T5JXL.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T5JXL.MANDT == T005S.MANDT
  • T5JXL.LAND1 == T005S.LAND1
  • T5JXL.STATE == T005S.BLAND