C_SustCompanyCodeAddressDEX

Company Code Address data extractor for PFM | view: CSUSTCCADRSDEX | TRAN | Extraction: Full only | Component: Sustainability integration topics with S4
Tables used: ADCPADRCT001TKA02
Column Name Description
CompanyCode Company Code
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AddressID Address ADRNR
CityName City TEXT40
PostalCode City postal code CHAR10
StreetName Street TEXT60
HouseNumber House Number TEXT10
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • C_SUSTCOMPANYCODEADDRESSDEX.MANDT == T005.MANDT
  • C_SUSTCOMPANYCODEADDRESSDEX.COUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_SUSTCOMPANYCODEADDRESSDEX.MANDT == T005S.MANDT
  • C_SUSTCOMPANYCODEADDRESSDEX.COUNTRY == T005S.LAND1
  • C_SUSTCOMPANYCODEADDRESSDEX.REGION == T005S.BLAND