R_PurOrderItemDeliveryAddress

Purchase Order Item Delivery Address | view: RMMPOITMDLVRADDR | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKPO, ADRP, ADCP, ADRC, KNA1, T001W, LFA1, TWLAD
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
DeliveryAddressID Manual address number in purchasing document item
Column Name Description
Column Name Description
Column Name Description
Column Name Description
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
RegionalStructureCheckStatus City file test status Show values
Column Name Description Domain name
AddresseeFullName Full Name of Person TEXT80
OrganizationName1 Name 1 TEXT40
OrganizationName2 Name 2 TEXT40
OrganizationName3 Name 3 TEXT40
OrganizationName4 Name 4 TEXT40
AddressSearchTerm1 Search Term 1 CHAR20
AddressSearchTerm2 Search Term 2 CHAR20
CityName City TEXT40
DistrictName District TEXT40
VillageName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
StreetName Street TEXT60
StreetPrefixName1 Street 2 TEXT40
StreetPrefixName2 Street 3 TEXT40
StreetSuffixName1 Street 4 TEXT40
StreetSuffixName2 Street 5 TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
TaxJurisdiction Tax Jurisdiction AD_TXJCD
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
POBoxDeviatingCityName PO Box city TEXT40
CareOfName c/o name TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
Master Data Relations Join Conditions
Address key
  • Client
  • Version ID for International Addresses
  • ?
  • Address Number
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == ADRC.CLIENT
  • R_PURORDERITEMDELIVERYADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
  • R_PURORDERITEMDELIVERYADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • R_PURORDERITEMDELIVERYADDRESS.ADDRESSID == ADRC.ADDRNUMBER
Key of person
  • Client
  • Version ID for International Addresses
  • ?
  • Person Number
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == ADRP.CLIENT
  • R_PURORDERITEMDELIVERYADDRESS.ADDRESSREPRESENTATIONCODE == ADRP.NATION
  • R_PURORDERITEMDELIVERYADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • R_PURORDERITEMDELIVERYADDRESS.ADDRESSPERSONID == ADRP.PERSNUMBER
Version ID for International Addresses R_PURORDERITEMDELIVERYADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Address time zone
  • Client
  • Address time zone
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == TTZZ.CLIENT
  • R_PURORDERITEMDELIVERYADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Language R_PURORDERITEMDELIVERYADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == T005.MANDT
  • R_PURORDERITEMDELIVERYADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • R_PURORDERITEMDELIVERYADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • R_PURORDERITEMDELIVERYADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == TSAD3.CLIENT
  • R_PURORDERITEMDELIVERYADDRESS.FORMOFADDRESS == TSAD3.TITLE
Plant
  • Client
  • Plant
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == T001W.MANDT
  • R_PURORDERITEMDELIVERYADDRESS.PLANT == T001W.WERKS
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == T005.MANDT
  • R_PURORDERITEMDELIVERYADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == T005S.MANDT
  • R_PURORDERITEMDELIVERYADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • R_PURORDERITEMDELIVERYADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method R_PURORDERITEMDELIVERYADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == T005S.MANDT
  • R_PURORDERITEMDELIVERYADDRESS.COUNTRY == T005S.LAND1
  • R_PURORDERITEMDELIVERYADDRESS.REGION == T005S.BLAND
Storage Location
  • Storage Location
  • Client
  • Plant
  • R_PURORDERITEMDELIVERYADDRESS.STORAGELOCATION == T001L.LGORT
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == T001L.MANDT
  • R_PURORDERITEMDELIVERYADDRESS.PLANT == T001L.WERKS
Transportation zone to or from which the goods are delivered
  • Client
  • Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • R_PURORDERITEMDELIVERYADDRESS.MANDT == TZONE.MANDT
  • R_PURORDERITEMDELIVERYADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • R_PURORDERITEMDELIVERYADDRESS.COUNTRY == TZONE.LAND1