A_PurCtrAddress

Delivery Address | view: APURCTRITMADRS | TRAN | Extraction: Not supported | Component: Contract
Column Name Description
PurchaseContract FK Purchasing Contract Header
AddressID Address Number
PurchaseContractItem Item Number of Purchasing Contract
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
ConsigneeName3 Name 3 TEXT40
ConsigneeName4 Name 4 TEXT40
CareOfName c/o name TEXT40
CityName City TEXT40
District District TEXT40
PostalCode City postal code CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
POBox PO Box CHAR10
POBoxDeviatingCityName PO Box city TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
TaxJurisdiction Tax Jurisdiction AD_TXJCD
PhoneNumber Telephone no.: dialling code+number CHAR30
FaxNumber Fax number: dialling code+number CHAR30
HouseNumberSupplementText House number supplement TEXT10
StreetSuffixName Street 4 TEXT40
Master Data Relations Join Conditions
Address time zone
  • Address time zone
  • Client
  • A_PURCTRADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
  • A_PURCTRADDRESS.MANDT == TTZZ.CLIENT
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • A_PURCTRADDRESS.CITYCODE == ADRCITY.CITY_CODE
  • A_PURCTRADDRESS.MANDT == ADRCITY.CLIENT
  • A_PURCTRADDRESS.COUNTRY == ADRCITY.COUNTRY
Language key A_PURCTRADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • A_PURCTRADDRESS.MANDT == T005.MANDT
  • A_PURCTRADDRESS.COUNTRY == T005.LAND1
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • A_PURCTRADDRESS.FORMOFADDRESS == TSAD3.TITLE
  • A_PURCTRADDRESS.MANDT == TSAD3.CLIENT
Communication Method A_PURCTRADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • A_PURCTRADDRESS.REGION == T005S.BLAND
  • A_PURCTRADDRESS.MANDT == T005S.MANDT
  • A_PURCTRADDRESS.COUNTRY == T005S.LAND1
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • A_PURCTRADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • A_PURCTRADDRESS.MANDT == TZONE.MANDT
  • A_PURCTRADDRESS.COUNTRY == TZONE.LAND1