SANS1

Address table | #masterdata | Component: Treasury and Risk Management
Column Name Description
MANDT FK Client
ADRNR Address number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
ORT02 District TEXT35
PSTBZ Post delivery district PSTBZ
STRAS Street and House Number TEXT35
STRA1 Street and House Number TEXT35
ORT01_MC IS-IS: City 1 in upper case characters for matchcode search CHAR16
STRAS_MC IS-IS: Street in upper case characters for matchcode search CHAR16
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Client
  • SANS1.LAND1 == T005.LAND1
  • SANS1.MANDT == T005.MANDT
Client SANS1.MANDT == T000.MANDT
Regional key
  • Country/Region Key
  • Region (State, Province, County)
  • SANS1.MANDT == T005S.MANDT
  • SANS1.LAND1 == T005S.LAND1
  • SANS1.REGIO == T005S.BLAND