C_PurReqnItemDeliveryAddress

Consumption View for Purchase Reqn Delivery address | view: CPRREQITMDELADD | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, ADCP, ADRC, FM01, TSAD3, TSAD3T, T001W, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
Column Name Description
Column Name Description
Column Name Description
AddressType Purchase Requisition Address Type Show values
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
AddressID Address Number AD_ADDRNUM
DeliveryAddressID Address ADRNR
CareOfName c/o name TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
POBoxDeviatingCityName PO Box city TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
CityName City TEXT40
District District TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 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
County County TEXT40
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
PhoneNumber First telephone no.: dialling code+number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
SearchTerm1 Search Term 1 CHAR20
StreetSearch Street Name in Uppercase for Search Help CHAR25
CitySearch City name in Uppercase for Search Help CHAR25
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
FormOfAddressName Title text TEXT30
Master Data Relations Join Conditions
Address time zone
  • Address time zone
  • Client
  • C_PURREQNITEMDELIVERYADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == TTZZ.CLIENT
City code for city/street file
  • City code for city/street file
  • Country/Region Key
  • Client
  • C_PURREQNITEMDELIVERYADDRESS.CITYCODE == ADRCITY.CITY_CODE
  • C_PURREQNITEMDELIVERYADDRESS.COUNTRY == ADRCITY.COUNTRY
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == ADRCITY.CLIENT
Language key C_PURREQNITEMDELIVERYADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region Key
  • Client
  • C_PURREQNITEMDELIVERYADDRESS.COUNTRY == T005.LAND1
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T005.MANDT
Address Delivery service type text table
  • Type of Delivery Service
  • ?
  • C_PURREQNITEMDELIVERYADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
  • C_PURREQNITEMDELIVERYADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == TSAD3.CLIENT
  • C_PURREQNITEMDELIVERYADDRESS.FORMOFADDRESS == TSAD3.TITLE
Number of delivery address
  • ?
  • ?
  • Number of delivery address
  • Client
  • C_PURREQNITEMDELIVERYADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURREQNITEMDELIVERYADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURREQNITEMDELIVERYADDRESS.ITEMDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == ADRC.CLIENT
Link to Central Address Management
  • ?
  • ?
  • Client
  • Manual address number in purchasing document item
  • C_PURREQNITEMDELIVERYADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURREQNITEMDELIVERYADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == ADRC.CLIENT
  • C_PURREQNITEMDELIVERYADDRESS.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
Version ID for International Addresses C_PURREQNITEMDELIVERYADDRESS.NATION == TSADV.NATION
Key of person
  • ?
  • Version ID for International Addresses
  • Client
  • Person Number
  • C_PURREQNITEMDELIVERYADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_PURREQNITEMDELIVERYADDRESS.NATION == ADRP.NATION
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == ADRP.CLIENT
  • C_PURREQNITEMDELIVERYADDRESS.PERSON == ADRP.PERSNUMBER
Plant
  • Client
  • Plant
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T001W.MANDT
  • C_PURREQNITEMDELIVERYADDRESS.PLANT == T001W.WERKS
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T005.MANDT
  • C_PURREQNITEMDELIVERYADDRESS.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, ...)
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T005S.MANDT
  • C_PURREQNITEMDELIVERYADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • C_PURREQNITEMDELIVERYADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method C_PURREQNITEMDELIVERYADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • ?
  • C_PURREQNITEMDELIVERYADDRESS.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T161.MANDT
  • C_PURREQNITEMDELIVERYADDRESS.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T024.MANDT
  • C_PURREQNITEMDELIVERYADDRESS.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURREQNITEMDELIVERYADDRESS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T024E.MANDT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_PURREQNITEMDELIVERYADDRESS.COUNTRY == T005S.LAND1
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == T005S.MANDT
  • C_PURREQNITEMDELIVERYADDRESS.REGION == T005S.BLAND
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • C_PURREQNITEMDELIVERYADDRESS.COUNTRY == TZONE.LAND1
  • C_PURREQNITEMDELIVERYADDRESS.MANDT == TZONE.MANDT
  • C_PURREQNITEMDELIVERYADDRESS.TRANSPORTZONE == TZONE.ZONE1