MMSPQTNADDR_D - Draft table for entity R_SRCGPROJQTNDELIVERYADDRESSTP

Draft table for entity R_SRCGPROJQTNDELIVERYADDRESSTP information is stored in SAP table MMSPQTNADDR_D.
It is part of development package RAP_MM_PUR_SRCGPROJQTN in software component MM-PUR-SPQ. This development package consists of objects that can be grouped under "Sourcing Project Quotation".

Fields for table MMSPQTNADDR_D

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
SRCGPROJQTNADDRESSUUID	Delivery Address UUID in Supplier Quotation (Sourcing Proj.)	X	VDM_SRCGPROJQTNADDRESSUUID	RAW	16
SRCGPROJQTNADDRESSID	Address Number		AD_ADDRNUM	CHAR	20
ADDRESSID	Address Number		AD_ADDRNUM	CHAR	20
SOURCINGPROJECTQUOTATIONUUID	Supplier Quotation UUID		VDM_SRCGPROJQUOTATIONUUID	RAW	16
SRCGPROJQTNITEMUUID	Supplier Quotation Item UUID		VDM_SRCGPROJQTNITEMUUID	RAW	16
SOURCINGORIGIN	Sourcing Origin		VDM_SOURCINGORIGIN	CHAR	4
SOURCINGSCENARIO	Sourcing Integration Scenario		VDM_SOURCINGSCENARIO	CHAR	4
CAREOFNAME	c/o name		AD_NAME_CO	CHAR	80
ADDITIONALSTREETSUFFIXNAME	Street 5		AD_LCTN	CHAR	80
CORRESPONDENCELANGUAGE	Language Key		SPRAS	LANG	2
PRFRDCOMMMEDIUMTYPE	Communication Method (Key) (Business Address Services)		AD_COMM	CHAR	6
POBOX	PO Box		AD_POBX	CHAR	20
POBOXISWITHOUTNUMBER	Flag: PO Box Without Number		AD_POBXNUM	CHAR	2
POBOXPOSTALCODE	PO Box Postal Code		AD_PSTCD2	CHAR	20
POBOXLOBBYNAME	PO Box Lobby		AD_PO_BOX_LBY	CHAR	80
POBOXDEVIATINGCITYNAME	PO Box city		AD_POBXLOC	CHAR	80
POBOXDEVIATINGREGION	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	6
POBOXDEVIATINGCOUNTRY	PO Box of Country/Region		AD_POBXCTY	CHAR	6
DELIVERYSERVICETYPECODE	Type of Delivery Service		AD_DELIVERY_SERVICE_TYPE	CHAR	8
DELIVERYSERVICENUMBER	Number of Delivery Service		AD_DELIVERY_SERVICE_NUMBER	CHAR	20
ADDRESSTIMEZONE	Address time zone		AD_TZONE	CHAR	12
FULLNAME	Address Full Name		CAADDR_FULLNAME	CHAR	160
CITYNAME	City		AD_CITY1	CHAR	80
DISTRICT	District		ORT02_GP	CHAR	70
CITYCODE	City Code		CITYC	CHAR	8
HOMECITYNAME	City (different from postal city)		AD_CITY3	CHAR	80
POSTALCODE	City postal code		AD_PSTCD1	CHAR	20
COMPANYPOSTALCODE	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
STREETNAME	Street		AD_STREET	CHAR	120
STREETPREFIXNAME	Street 2		AD_STRSPP1	CHAR	80
ADDITIONALSTREETPREFIXNAME	Street 3		AD_STRSPP2	CHAR	80
STREETSUFFIXNAME	Street 4		AD_STRSPP3	CHAR	80
HOUSENUMBER	House Number		AD_HSNM1	CHAR	20
HOUSENUMBERSUPPLEMENTTEXT	House number supplement		AD_HSNM2	CHAR	20
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	40
FLOOR	Floor in building		AD_FLOOR	CHAR	20
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	20
COUNTRY	Country/Region		CAADDR_COUNTRY	CHAR	6
REGION	Region (State, Province, County)		REGIO	CHAR	6
COUNTY	County Code		COUNC	CHAR	6
COUNTYCODE	County code for county		AD_CNTYNUM	CHAR	16
FORMOFADDRESS	Form-of-Address Key		AD_TITLE	CHAR	8
BUSINESSPARTNERNAME1	Name 1		AD_NAME1	CHAR	80
BUSINESSPARTNERNAME2	Name 2		AD_NAME2	CHAR	80
NATION	Version ID for International Addresses		AD_NATION	CHAR	2
PHONENUMBER	Phone Number: Area Code+Number		CAADDR_PHONENR	CHAR	60
FAXNUMBER	Fax Number		TELFX	CHAR	62
SEARCHTERM1	Search Term 1		AD_SORT1	CHAR	40
STREETSEARCH	Street Name in Uppercase for Search Help		AD_MC_STRT	CHAR	50
CITYSEARCH	City name in Uppercase for Search Help		AD_MC_CITY	CHAR	50
BUSINESSPARTNERNAME3	Name 3		AD_NAME3	CHAR	80
BUSINESSPARTNERNAME4	Name 4		AD_NAME4	CHAR	80
TAXJURISDICTION	Tax Jurisdiction		AD_TXJCD	CHAR	30
TRANSPORTZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20
PERSON	Person Number		AD_PERSNUM	CHAR	20
ADDRESSTYPE	Address Type		BU_ADRKIND	CHAR	20
ADDRESSOWNEROBJECTID	Address owner object ID		AD_OBJKEY	CHAR	140
ADDRESSISCHANGEDMANUALLY	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
ACTIVEADDRESSISMANUAL	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
ADDRESSOWNERTABLENAME	Application table logical name (address management)		AD_APPLTAB	CHAR	20
ADDRESSOWNERREFERENCEFIELDNAME	Application table address where-used list logical field name		AD_APPLFLD	CHAR	20
ADDRESSOWNERMANUALFIELDNAME	Application table address where-used list logical field name		AD_APPLFLD	CHAR	20
REFERENCEADDRESSID	Address Number		AD_ADDRNUM	CHAR	20
REFERENCEOBJECTID	Address owner object ID		AD_OBJKEY	CHAR	140
REFERENCEADDRESSTYPE	Address Type		CAADDR_E_TYPE	CHAR	4
EMAILADDRESS	SMTP Address		CAADDR_SMTPADR	CHAR	482
.INCLUDE	%ADMIN			SYCH_BDL_DRAFT_ADMIN_INC	0
DRAFTENTITYCREATIONDATETIME	Draft Created At		SYCH_BDL_DRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed At		SYCH_BDL_DRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Draft Administration UUID		SYCH_BDL_DRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SYCH_BDL_DRAFT_OPERATION_CODE	CHAR	2
HASACTIVEENTITY	Draft Flag "Has Active Instance"		SYCH_BDL_DRAFT_HASACTIVE	CHAR	2
DRAFTFIELDCHANGES	Draft Field Changes as BLOB		SYCH_BDL_DRAFT_FIELD_CHANGES	RSTR	8