SSPREQ_ITM_D - I_PURCHASEREQUISITION_WD I_PURCHASEREQUISITIONITEM_WD

I_PURCHASEREQUISITION_WD I_PURCHASEREQUISITIONITEM_WD information is stored in SAP table SSPREQ_ITM_D.
It is part of development package APPL_MM_PUR_REQ in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "S4HANA Artifacts for SSP PR".

Fields for table SSPREQ_ITM_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
PURCHASEREQUISITION	Purchase requisition number		VDM_PURCHASEREQUISITION	CHAR	20
PURCHASEREQUISITIONITEM	Item number of purchase requisition		VDM_PURCHASEREQUISITIONITEM	NUMC	10
REQUESTEDQUANTITY	Purchase requisition quantity		BAMNG	QUAN	7
CURRENCY	Currency Key		WAERS	CUKY	10
PURCHASINGDOCUMENTITEMCATEGORY	Item category in purchasing document		PSTYP	CHAR	2
ACCOUNTASSIGNMENTCATEGORY	Account Assignment Category		KNTTP	CHAR	2
NETPRICEQUANTITY	Price unit		EPEIN	DEC	3
BASEUNIT	Purchase requisition unit of measure		BAMEI	UNIT	6
DELIVERYDATE	Item delivery date		EINDT	DATS	16
FIXEDSUPPLIER	Fixed Vendor		FLIEF	CHAR	20
SUPPLIER	Desired Vendor		WLIEF	CHAR	20
PURCHASINGINFORECORD	Number of purchasing info record		INFNR	CHAR	20
PURCHASECONTRACT	Number of principal purchase agreement		KONNR	CHAR	20
PURCHASECONTRACTITEM	Item number of principal purchase agreement		KTPNR	NUMC	10
MANUALDELIVERYADDRESSID	Manual address number in purchasing document item		ADRNR_MM	CHAR	20
MATERIAL	Material Number		MATNR	CHAR	80
MATERIALGROUP	Material Group		MATKL	CHAR	18
PLANT	Plant		EWERK	CHAR	8
PURCHASEREQUISITIONITEMTEXT	Short Text		TXZ01	CHAR	80
PURCHASEREQUISITIONPRICE	Price in Purchase Requisition		BAPRE	CURR	6
COMPANYCODE	Company Code		BUKRS	CHAR	8
TOTALNETAMOUNT	CURRENCY			CURR	8
SSPPURREQNITMISINCOMPOSING	SSP PR Item in Composing State		MMPUR_REQ_D_ITM_COMPOSING	CHAR	2
PURCHASINGORGANIZATION	Purchasing organization		EKORG	CHAR	8
PURCHASINGGROUP	Purchasing Group		EKGRP	CHAR	6
PURREQNSSPCATALOG	Technical Key of a Web Service (for Example - a Catalog)		BBP_WS_SERVICE_ID	CHAR	40
PURREQNSSPCATALOGITEM	Catalog Item		MMPUR_REQ_D_CATALOGITM	CHAR	80
PURREQNSSPCROSSCATALOGITEM	Catalog Item Key		MMPUR_CAT_D_ITM_KEY	INT4	4
ISDELETED	Deletion Indicator in Purchasing Document		ELOEK	CHAR	2
RESERVATION	Number of reservation/dependent requirements		RSNUM	NUMC	20
EXTMATERIALFORPURG	Material of External System		MM_PUR_HUB_MATNR	CHAR	80
EXTFIXEDSUPPLIERFORPURG	Fixed Supplier of External System		MM_PUR_HUB_FLIEF	CHAR	20
EXTDESIREDSUPPLIERFORPURG	Desired Supplier of External System		MM_PUR_HUB_WLIEF	CHAR	20
EXTCONTRACTFORPURG	Contract of External System		MM_PUR_HUB_KONNR	CHAR	20
EXTCONTRACTITEMFORPURG	Contract Item of External System		MM_PUR_HUB_KTPNR	NUMC	10
EXTINFORECORDFORPURG	Info Record of External System		MM_PUR_HUB_INFNR	CHAR	20
EXTPLANTFORPURG	Plant of External System		MM_PUR_HUB_WERKS	CHAR	8
EXTCOMPANYCODEFORPURG	Company Code of External System		MM_PUR_HUB_BUKRS	CHAR	8
EXTPURGORGFORPURG	Purchasing Organization		MM_PUR_HUB_EKORG	CHAR	8
EXTSOURCESYSTEM	Communication System ID		MMPUR_D_COMM_SYS	CHAR	120
EXTERNALAPPROVALSTATUS	External Processing Status		MMPUR_REQ_EXTAPPRVLSTS	CHAR	2
EXTPURCHASEREQUISITIONTYPE	PR Document Type of Connected System		MM_PUR_HUB_REQ_DOC_TYPE	CHAR	8
PROCUREMENTHUBSOURCESYSTEM	Connected System ID		MMPUR_D_SOURCE_SYS	CHAR	20
BUSINESSUSER	User ID		VDM_USERID	CHAR	24
SUPPLIERMATERIALNUMBER	Material Number Used by Supplier		IDNLF	CHAR	70
PURREQNISVALDINCNTRLREQNPROCG	Is PR relevant for Central PR Processing		MMPUR_PR_CEN_PURREQN_PROC_MODE	CHAR	2
STATUSCRITICALITY				INT1	1
PURREQNREJECTIONISCANCELLED	Cancellation Indicator for Rejected PR		MMPUR_PR_ISREJCANCELLED	CHAR	2
PURREQNITEMLIFECYCLESTATUS				CHAR	4
PURREQNRELEASESTATUS	Requisition Processing State		BANPR	CHAR	4
OPNCTLGMAINIMAGEURL	Catalog Main Image URL		MMPUR_CAT_URL	STRG	8
OPNCTLGHASPRICESCALE	If price scale exist		MMPUR_CAT_PRCSCL_EXIST	CHAR	2
ADDRESSTYPE	Purchase Requisition Address Type		PURREQNADDRTYPE	CHAR	2
FULLNAME	Full name of a party (Bus. Partner, Org. Unit, Doc. address)		ADFULLNAME	CHAR	160
CAREOFNAME	c/o name		AD_NAME_CO	CHAR	80
ADDRESSSTREETNAME	Street		AD_STREET	CHAR	120
ADDRESSHOUSENUMBER	House Number		AD_HSNM1	CHAR	20
ADDRESSPOSTALCODE	City postal code		AD_PSTCD1	CHAR	20
ADDRESSCITYNAME	City		AD_CITY1	CHAR	80
PHONENUMBER1	Telephone no.: dialling code+number		AD_TLNMBR	CHAR	60
FAXNUMBER	First Fax No.: Area Code + Number		AD_FXNMBR1	CHAR	60
ADDRESSREGION	Region (State, Province, County)		REGIO	CHAR	6
ADDRESSCOUNTRY	Country/Region Key		LAND1	CHAR	6
EMAILADDRESS	E-Mail Address		AD_SMTPADR	CHAR	482
FORMOFADDRESS	Form-of-Address Key		AD_TITLE	CHAR	8
LANGUAGE	Language Key		SPRAS	LANG	2
MULTIPLEACCTASSGMTDISTRIBUTION	Distribution Indicator for Multiple Account Assignment		VRTKZ	CHAR	2
PRODUCTTYPE	Product Type Group		PRODUCT_TYPE	CHAR	4
SERVICEPERFORMER	Service Performer		SERVICEPERFORMER	CHAR	20
PERFORMANCEPERIODSTARTDATE	Start Date for Period of Performance		MMPUR_SERVPROC_PERIOD_START	DATS	16
PERFORMANCEPERIODENDDATE	End Date for Period of Performance		MMPUR_SERVPROC_PERIOD_END	DATS	16
PROCESSINGSTATUS	Processing status of purchase requisition		BANST	CHAR	2
PURREQNITEMCURRENCY	Currency Key		WAERS	CUKY	10
PURCHASEORDERPRICETYPE	Use Requisition Price in Purchase Order		BPUEB	CHAR	2
EXPECTEDOVERALLLIMITAMOUNT	Expected Value of Overall Limit		COMMITMENT	CURR	7
OVERALLLIMITAMOUNT	Overall Limit		SUMLIMIT	CURR	7
COMMITMENTITEM	Commitment Item		FIPOS	CHAR	28
FUNDSCENTER	Funds Center		FISTL	CHAR	32
FUND	Fund		BP_GEBER	CHAR	20
GRANTID	Grant		GM_GRANT_NBR	CHAR	40
FUNCTIONALAREA	Functional Area		FKBER	CHAR	32
EARMARKEDFUNDSDOCUMENT	Document Number for Earmarked Funds		KBLNR	CHAR	20
EARMARKEDFUNDSDOCUMENTITEM	Earmarked Funds: Document Item		KBLPOS	NUMC	6
BUDGETPERIOD	Budget Period		FM_BUDGET_PERIOD	CHAR	20
FUNDEDPROGRAM				CHAR	48
COSTCENTER	Cost Center		KOSTL	CHAR	20
WBSELEMENT	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16
GLACCOUNT	G/L Account Number		SAKNR	CHAR	20
TAXCODE	Tax on sales/purchases code		MWSKZ	CHAR	4
FUNDMGMTISACTIVE	Truth Value: True/False		ABAP_BOOLEAN	CHAR	2
PURCHASEREQUISITIONTYPE	Purchase Requisition Document Type		BBSRT	CHAR	8
PURREQNSSPAUTHOR	Author of Requisition		MMPUR_REQ_D_AUTHOR	CHAR	24
PURREQNSSPREQUESTOR	Requestor		MMPUR_REQ_D_REQUESTOR	CHAR	120
SOURCEPURCHASEREQUISITION	Source Purchase Requisition		MMPUR_PR_SOURCE_REQUISITION	CHAR	20
SOURCEPURCHASEREQUISITIONITEM	Source Purchase Requisition Item		MMPUR_PR_SOURCE_REQUISITIONITM	NUMC	10
PURREQNLIFECYCLESTATUSNAME	Short Text for Fixed Values		MM_PUR_PR_STATUS_TEXT	CHAR	120
SUPPLIERNAME	Name of Supplier		MD_SUPPLIER_NAME	CHAR	160
PURREQNREWORKCOMMENTTEXT	Note Text		MMPUR_NOTE_TEXT	STRG	8
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
.INCLUDE				EBAN_INCL_EEW_PS	0
.INCLUDE				CI_EBANDB	0
DUMMY_EBAN_INCL_EEW_PS	Data element for purchase requisition extensibility		EBAN_INCL_EEW	CHAR	2