I_DeliveryPartnerAddress

Delivery Partner Address | view: IDLVPARTNERADDR | TRAN | Extraction: Not supported | Component: Interfaces for Delivery Documents (API)
Tables used: LIKP, VBPA, ADR6, ADR3, ADRP, ADR2, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
DeliveryDocument Sales and Distribution Document Number
PartnerFunction FK Partner Function
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
AddressID Address ADRNR
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
PersonFamilyName Last name TEXT40
PersonGivenName First name TEXT40
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
CareOfName c/o name TEXT40
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
District District TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
CityName City TEXT40
County County TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
POBox PO Box CHAR10
DeliveryServiceNumber Number of Delivery Service CHAR10
POBoxLobbyName PO Box Lobby TEXT40
POBoxPostalCode PO Box Postal Code CHAR10
POBoxDeviatingCityName PO Box city TEXT40
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
FaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
EmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • I_DELIVERYPARTNERADDRESS.MANDT == TSAD12.CLIENT
  • I_DELIVERYPARTNERADDRESS.ADDRESSPOSTBOXUNUSABLE == TSAD12.UNDELIVER
Address time zone
  • Client
  • Address time zone
  • I_DELIVERYPARTNERADDRESS.MANDT == TTZZ.CLIENT
  • I_DELIVERYPARTNERADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Language I_DELIVERYPARTNERADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • I_DELIVERYPARTNERADDRESS.MANDT == T005.MANDT
  • I_DELIVERYPARTNERADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • Type of Delivery Service
  • ?
  • I_DELIVERYPARTNERADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
  • I_DELIVERYPARTNERADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_DELIVERYPARTNERADDRESS.FORMOFADDRESS == TSAD3.TITLE
  • I_DELIVERYPARTNERADDRESS.MANDT == TSAD3.CLIENT
Partner function - Document partner
  • Partner Function
  • Client
  • I_DELIVERYPARTNERADDRESS.PARTNERFUNCTION == TPAR.PARVW
  • I_DELIVERYPARTNERADDRESS.MANDT == TPAR.MANDT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • I_DELIVERYPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • I_DELIVERYPARTNERADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • I_DELIVERYPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • I_DELIVERYPARTNERADDRESS.MANDT == T005S.MANDT
  • I_DELIVERYPARTNERADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method I_DELIVERYPARTNERADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_DELIVERYPARTNERADDRESS.MANDT == T005S.MANDT
  • I_DELIVERYPARTNERADDRESS.REGION == T005S.BLAND
  • I_DELIVERYPARTNERADDRESS.COUNTRY == T005S.LAND1
Transportation zone to or from which the goods are delivered
  • Client
  • Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • I_DELIVERYPARTNERADDRESS.MANDT == TZONE.MANDT
  • I_DELIVERYPARTNERADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • I_DELIVERYPARTNERADDRESS.COUNTRY == TZONE.LAND1