C_PurCtrItemAddress

Contract Item Address Information | view: CPURCTRITMADDR | Extraction: Not supported | Component: Contract
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
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 Number AD_ADDRNUM
PurchaseContractItemForEdit Item Number of Purchasing Contract EBELP
AddressIDForEdit Address Number AD_ADDRNUM
CareOfName c/o name TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
POBox PO Box
POBoxLobbyName PO Box Lobby
POBoxPostalCode PO Box Postal Code CHAR10
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
ConsigneeName3 Name 3 TEXT40
ConsigneeName4 Name 4 TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
PhoneNumber Telephone no.: dialling code+number CHAR30
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
FaxNumber Fax number: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Address time zone
  • Client
  • Address time zone
  • C_PURCTRITEMADDRESS.MANDT == TTZZ.CLIENT
  • C_PURCTRITEMADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • C_PURCTRITEMADDRESS.CITYCODE == ADRCITY.CITY_CODE
  • C_PURCTRITEMADDRESS.MANDT == ADRCITY.CLIENT
  • C_PURCTRITEMADDRESS.COUNTRY == ADRCITY.COUNTRY
Language key C_PURCTRITEMADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • C_PURCTRITEMADDRESS.MANDT == T005.MANDT
  • C_PURCTRITEMADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • C_PURCTRITEMADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • C_PURCTRITEMADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_PURCTRITEMADDRESS.MANDT == TSAD3.CLIENT
  • C_PURCTRITEMADDRESS.FORMOFADDRESS == TSAD3.TITLE
Plant
  • Client
  • Plant
  • C_PURCTRITEMADDRESS.MANDT == T001W.MANDT
  • C_PURCTRITEMADDRESS.PLANT == T001W.WERKS
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • C_PURCTRITEMADDRESS.MANDT == T005.MANDT
  • C_PURCTRITEMADDRESS.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_PURCTRITEMADDRESS.MANDT == T005S.MANDT
  • C_PURCTRITEMADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • C_PURCTRITEMADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method C_PURCTRITEMADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_PURCTRITEMADDRESS.MANDT == T005S.MANDT
  • C_PURCTRITEMADDRESS.COUNTRY == T005S.LAND1
  • C_PURCTRITEMADDRESS.REGION == T005S.BLAND
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • C_PURCTRITEMADDRESS.MANDT == TZONE.MANDT
  • C_PURCTRITEMADDRESS.COUNTRY == TZONE.LAND1
  • C_PURCTRITEMADDRESS.TRANSPORTZONE == TZONE.ZONE1