A_ReturnsDeliveryAddress

Returns Delivery Address | view: ARETSDELIVERYAD | Extraction: Not supported | Component: Basic Functions
Tables used: ADCP, ADRC
Column Name Description
AddressID Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
AdditionalStreetPrefixName Street 3 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
Building Building (Number or Code) TEXT20
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
CareOfName c/o name TEXT40
CityName City TEXT40
CitySearch City name in Uppercase for Search Help CHAR25
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
County County TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
District District TEXT40
FaxNumber First Fax No.: Area Code + Number CHAR30
Floor Floor in building TEXT10
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
HomeCityName City (different from postal city) TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
PhoneNumber First telephone no.: dialling code+number CHAR30
POBox PO Box CHAR10
POBoxDeviatingCityName PO Box city TEXT40
POBoxLobbyName PO Box Lobby TEXT40
POBoxPostalCode PO Box Postal Code CHAR10
PostalCode City postal code CHAR10
RoomNumber Room or Apartment Number TEXT10
SearchTerm1 Search Term 1 CHAR20
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
StreetSearch Street Name in Uppercase for Search Help CHAR25
StreetSuffixName Street 4 TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
Master Data Relations Join Conditions
Address time zone
  • Client
  • Address time zone
  • A_RETURNSDELIVERYADDRESS.MANDT == TTZZ.CLIENT
  • A_RETURNSDELIVERYADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
City code for city/street file
  • Country/Region Key
  • City code for city/street file
  • Client
  • A_RETURNSDELIVERYADDRESS.COUNTRY == ADRCITY.COUNTRY
  • A_RETURNSDELIVERYADDRESS.CITYCODE == ADRCITY.CITY_CODE
  • A_RETURNSDELIVERYADDRESS.MANDT == ADRCITY.CLIENT
Language key A_RETURNSDELIVERYADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region Key
  • Client
  • A_RETURNSDELIVERYADDRESS.COUNTRY == T005.LAND1
  • A_RETURNSDELIVERYADDRESS.MANDT == T005.MANDT
Address Delivery service type text table
  • Type of Delivery Service
  • ?
  • A_RETURNSDELIVERYADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
  • A_RETURNSDELIVERYADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • A_RETURNSDELIVERYADDRESS.FORMOFADDRESS == TSAD3.TITLE
  • A_RETURNSDELIVERYADDRESS.MANDT == TSAD3.CLIENT
Version ID for International Addresses A_RETURNSDELIVERYADDRESS.NATION == TSADV.NATION
Key of person
  • Person Number
  • Version ID for International Addresses
  • ?
  • Client
  • A_RETURNSDELIVERYADDRESS.PERSON == ADRP.PERSNUMBER
  • A_RETURNSDELIVERYADDRESS.NATION == ADRP.NATION
  • A_RETURNSDELIVERYADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • A_RETURNSDELIVERYADDRESS.MANDT == ADRP.CLIENT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • A_RETURNSDELIVERYADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • A_RETURNSDELIVERYADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • A_RETURNSDELIVERYADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • A_RETURNSDELIVERYADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
  • A_RETURNSDELIVERYADDRESS.MANDT == T005S.MANDT
Communication Method A_RETURNSDELIVERYADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • A_RETURNSDELIVERYADDRESS.REGION == T005S.BLAND
  • A_RETURNSDELIVERYADDRESS.COUNTRY == T005S.LAND1
  • A_RETURNSDELIVERYADDRESS.MANDT == T005S.MANDT
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • A_RETURNSDELIVERYADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • A_RETURNSDELIVERYADDRESS.COUNTRY == TZONE.LAND1
  • A_RETURNSDELIVERYADDRESS.MANDT == TZONE.MANDT