C_SrcgProjQtnItmDelivAddress

Delivery Address for Item in SPQtn | view: CSPIETMDLVRADD | Extraction: Not supported | Component: Sourcing Project/Quotation
Tables used: MMSRCGPROJMMSRCGPADDRADCPADRCADR6T005G
Column Name Description
SrcgProjQtnAddressUUID Delivery Address UUID in Sourcing Project
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
SrcgProjQtnAddressID Address Number AD_ADDRNUM
AddressID Address Number AD_ADDRNUM
SourcingProjectUUID Sourcing Project UUID SYSUUID
SourcingProjectItemUUID Sourcing Project Item UUID SYSUUID
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 Address Full Name TEXT80
CityName City TEXT40
District District TEXT35
CityCode City Code CITYC
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 Code COUNC
CountyCode County code for county CNTY_CODE
TaxJurisdiction Tax Jurisdiction AD_TXJCD
PhoneNumber Phone Number: Area Code+Number CHAR30
FaxNumber Fax Number TEXT31
EmailAddress SMTP Address AD_SMTPADR
PurchasingOrganization Purchasing Organization EKORG
PurchasingGroup Purchasing Group EKGRP
SourcingProjectType Sourcing Project Type MM_PUR_SRCGPROJ_TYPE
CompanyCode Company Code BUKRS
MaterialGroup Material Group MATKL
Master Data Relations Join Conditions
Language key C_SRCGPROJQTNITMDELIVADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region
  • Client
  • C_SRCGPROJQTNITMDELIVADDRESS.COUNTRY == T005.LAND1
  • C_SRCGPROJQTNITMDELIVADDRESS.MANDT == T005.MANDT
Address Delivery service type text table
  • Type of Delivery Service
  • ?
  • C_SRCGPROJQTNITMDELIVADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
  • C_SRCGPROJQTNITMDELIVADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_SRCGPROJQTNITMDELIVADDRESS.MANDT == TSAD3.CLIENT
  • C_SRCGPROJQTNITMDELIVADDRESS.FORMOFADDRESS == TSAD3.TITLE
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • C_SRCGPROJQTNITMDELIVADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • C_SRCGPROJQTNITMDELIVADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Client
  • C_SRCGPROJQTNITMDELIVADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
  • C_SRCGPROJQTNITMDELIVADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • C_SRCGPROJQTNITMDELIVADDRESS.MANDT == T005S.MANDT
Communication Method C_SRCGPROJQTNITMDELIVADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Country/Region
  • Region (State, Province, County)
  • Client
  • C_SRCGPROJQTNITMDELIVADDRESS.COUNTRY == T005S.LAND1
  • C_SRCGPROJQTNITMDELIVADDRESS.REGION == T005S.BLAND
  • C_SRCGPROJQTNITMDELIVADDRESS.MANDT == T005S.MANDT
Transportation zone to or from which the goods are delivered
  • Country/Region
  • Transportation zone to or from which the goods are delivered
  • Client
  • C_SRCGPROJQTNITMDELIVADDRESS.COUNTRY == TZONE.LAND1
  • C_SRCGPROJQTNITMDELIVADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • C_SRCGPROJQTNITMDELIVADDRESS.MANDT == TZONE.MANDT