T5JL1

HR Address Infomation 1 of Personnel Subarea for LI JP | #other | Component: Japan
Column Name Description
MANDT FK Client
LBIMF Labour Insurance Modifier
Column Name Description
Column Name Description
Column Name Description
Column Name Description
EIRUL Employment insurance premium calculation rule Show values
Column Name Description Domain name
PSTLZ Postal Code PSTLZ
ORT01 Line of Address in Kanji TEXT30
ORT02 Line of Address in Kanji TEXT30
STRAS Line of Address in Kanji TEXT30
JGSNM Name of Branch office TEXT50
TELNR Telephone Number TELNR
LBICC Labour Insurance Code TEXT14
LBINO Number of Branch office for LI TEXT11
HWORK Labour insurance office TEXT20
HWKID Labor Insurance Office Number CHAR5
JURID Jurisdiction ID of LI Modifier CHAR1
DSTID Destination Identifier CHAR23
DSTXT Text of Destination Identifier TEXT80
Master Data Relations Join Conditions
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • T5JL1.MANDT == T005E.MANDT
  • T5JL1.COUNC == T005E.COUNC
  • T5JL1.LAND1 == T005E.LAND1
  • T5JL1.STATE == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • T5JL1.LAND1 == T005.LAND1
  • T5JL1.MANDT == T005.MANDT
Client T5JL1.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T5JL1.MANDT == T005S.MANDT
  • T5JL1.LAND1 == T005S.LAND1
  • T5JL1.STATE == T005S.BLAND