PURREQNDELIVAD_D - T_PURCHASEREQN T_PURCHASEREQNDELIVERYADD

T_PURCHASEREQN T_PURCHASEREQNDELIVERYADD information is stored in SAP table PURREQNDELIVAD_D.
It is part of development package APPL_MM_PUR_REQ_PROFNL in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "S4HANA Artefacts : Manage Professional Purchase Requisition".

Fields for table PURREQNDELIVAD_D

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
DRAFTUUID	UUID serving as key (parent key, root key)	X	/BOBF/UUID	RAW	16
PARENTDRAFTUUID	UUID serving as key (parent key, root key)		/BOBF/UUID	RAW	16
ROOTDRAFTUUID	UUID serving as key (parent key, root key)		/BOBF/UUID	RAW	16
PURCHASEREQUISITION	Purchase requisition number		VDM_PURCHASEREQUISITION	CHAR	20
PURCHASEREQUISITIONITEM	Item number of purchase requisition		VDM_PURCHASEREQUISITIONITEM	NUMC	10
ADDRESSID	Address Number		AD_ADDRNUM	CHAR	20
ADDRESSIDFOREDIT	Address Number		AD_ADDRNUM	CHAR	20
ADDRESSTYPE	Purchase Requisition Address Type		PURREQNADDRTYPE	CHAR	2
PLANT	Plant		EWERK	CHAR	8
STORAGELOCATION	Storage location		LGORT_D	CHAR	8
MANUALDELIVERYADDRESSID	Manual address number in purchasing document item		ADRNR_MM	CHAR	20
ITEMDELIVERYADDRESSID	Number of delivery address		ADRN2	CHAR	20
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	Full name of a party (Bus. Partner, Org. Unit, Doc. address)		ADFULLNAME	CHAR	160
CITYNAME	City		AD_CITY1	CHAR	80
DISTRICT	District		AD_CITY2	CHAR	80
CITYCODE	City code for city/street file		AD_CITYNUM	CHAR	24
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 Key		LAND1	CHAR	6
REGION	Region (State, Province, County)		REGIO	CHAR	6
COUNTY	County		AD_COUNTY	CHAR	80
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	First telephone no.: dialling code+number		AD_TLNMBR1	CHAR	60
FAXNUMBER	First Fax No.: Area Code + Number		AD_FXNMBR1	CHAR	60
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
PLANTTEXT	Plant Name		WERKS_NAME	CHAR	60
HASACTIVEENTITY	Draft - Indicator - Has active document		SDRAFT_HAS_ACTIVE	CHAR	2
.INCLUDE				SDRAFT_WRITE_DRAFT_ADMIN	0
DRAFTENTITYCREATIONDATETIME	Draft Created On		SDRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On		SDRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document		SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft - Consistency Status		SDRAFT_CONSISTENCY_STATUS	CHAR	2
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SDRAFT_OPERATION_CODE	CHAR	2