P_NO_SAFTSUPADDR

SAFT NO Supplier Address Max | view: PNOSAFTSUPADM | Extraction: Not supported | Component: Financials Norway
Tables used: BSECACDOCABSEGADCPADRCADR6ADR3ADR12ADR2T001TKA02LFB1T001T014FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
Supplier FK Supplier
VATRegistration null
Column Name Description
Column Name Description
Column Name Description
PostingDate null
Column Name Description
Column Name Description Domain name
CompanyName null
StreetAddressName Street TEXT60
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
HouseNumber House Number TEXT10
CityName City TEXT40
PostalCode Postal Code PSTLZ
POBox PO Box PFACH
POBoxPostalCode P.O. Box Postal Code PSTLZ
AddressID Address ADRNR
PhoneNumber Telephone no.: dialling code+number CHAR30
FaxNumber Fax number: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
WebsiteURL URI address search field CHAR50
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_NO_SAFTSUPADDR.COMPANYCODE == T001.BUKRS
  • P_NO_SAFTSUPADDR.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_NO_SAFTSUPADDR.COUNTRY == T005.LAND1
  • P_NO_SAFTSUPADDR.MANDT == T005.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • P_NO_SAFTSUPADDR.REGION == T005S.BLAND
  • P_NO_SAFTSUPADDR.COUNTRY == T005S.LAND1
  • P_NO_SAFTSUPADDR.MANDT == T005S.MANDT
Supplier
  • Supplier
  • Client
  • P_NO_SAFTSUPADDR.SUPPLIER == LFA1.LIFNR
  • P_NO_SAFTSUPADDR.MANDT == LFA1.MANDT