PURREQNITM_D - T_PURCHASEREQN T_PURCHASEREQNITEM

T_PURCHASEREQN T_PURCHASEREQNITEM information is stored in SAP table PURREQNITM_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 PURREQNITM_D

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DRAFTUUIDUUID serving as key (parent key, root key)X/BOBF/UUIDRAW16
PARENTDRAFTUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
PURCHASEREQUISITIONPurchase requisition numberVDM_PURCHASEREQUISITIONCHAR20
PURCHASEREQUISITIONITEMItem number of purchase requisitionVDM_PURCHASEREQUISITIONITEMNUMC10
PURCHASEREQUISITIONITEMFOREDITItem number of purchase requisitionVDM_PURCHASEREQUISITIONITEMNUMC10
PURCHASINGDOCUMENTPurchase order numberBSTNRCHAR20
PURCHASINGDOCUMENTITEMPurchase order item numberBSTPONUMC10
PURREQNRELEASESTATUSRequisition Processing StateBANPRCHAR4
PURCHASEREQUISITIONTYPEPurchase Requisition Document TypeBBSRTCHAR8
PURCHASINGDOCUMENTITEMCATEGORYItem category in purchasing documentPSTYPCHAR2
PURCHASEREQUISITIONITEMTEXTShort TextTXZ01CHAR80
ACCOUNTASSIGNMENTCATEGORYAccount Assignment CategoryKNTTPCHAR2
MATERIALMaterial NumberMATNRCHAR80
MANUFACTURERMATERIALMaterial number corresponding to manufacturer part numberEMATNCHAR80
MANUFACTURERPARTPROFILEMfr part profileMPROFCHAR8
MANUFACTURERPARTNMBRManufacturer Part NumberMFRPNCHAR80
MATERIALGROUPMaterial GroupMATKLCHAR18
PURCHASINGDOCUMENTCATEGORYPurchasing Document CategoryBSTYPCHAR2
REQUESTEDQUANTITYPurchase requisition quantityBAMNGQUAN7
BASEUNITPurchase requisition unit of measureBAMEIUNIT6
PURCHASEREQUISITIONPRICEPrice in Purchase RequisitionBAPRECURR6
PURREQNPRICEQUANTITYPrice unitEPEINDEC3
MATERIALGOODSRECEIPTDURATIONGoods receipt processing time in daysWEBAZDEC2
RELEASECODERelease IndicatorFRGKZCHAR2
PURCHASEREQUISITIONRELEASEDATEPurchase Requisition Release DateFRGDTDATS16
PURCHASINGORGANIZATIONPurchasing organizationEKORGCHAR8
PURCHASINGGROUPPurchasing GroupEKGRPCHAR6
PLANTPlantEWERKCHAR8
SOURCEOFSUPPLYISASSIGNEDAssigned Source of SupplyDZUGBACHAR2
SUPPLYINGPLANTSupplying (issuing) plant in case of stock transport orderRESWKCHAR8
ORDEREDQUANTITYQuantity ordered against this purchase requisitionBSMNGQUAN7
PURREQNLIMITCONSUMPTIONAMTConsumption Value for Limit ItemsMMPUR_REQ_LMT_CNSMPN_VALUECURR7
DELIVERYDATEItem delivery dateEINDTDATS16
CREATIONDATERequisition (request) dateBADATDATS16
PROCESSINGSTATUSProcessing status of purchase requisitionBANSTCHAR2
PURCHASINGINFORECORDNumber of purchasing info recordINFNRCHAR20
SUPPLIERDesired VendorWLIEFCHAR20
ISDELETEDDeletion Indicator in Purchasing DocumentELOEKCHAR2
FIXEDSUPPLIERFixed VendorFLIEFCHAR20
REQUISITIONERNAMEName of requisitioner/requesterAFNAMCHAR24
PURREQNSSPREQUESTORRequestorMMPUR_REQ_D_REQUESTORCHAR120
CREATEDBYUSERName of Person Responsible for Creating the ObjectERNAMCHAR24
PURREQCREATIONDATERequisition (request) dateBADATDATS16
MANUALDELIVERYADDRESSIDManual address number in purchasing document itemADRNR_MMCHAR20
ITEMDELIVERYADDRESSIDNumber of delivery addressADRN2CHAR20
DELIVERYADDRESSIDAddressADRNRCHAR20
PURREQNITEMCURRENCYCurrency KeyWAERSCUKY10
MATERIALPLANNEDDELIVERYDURNPlanned Delivery Time in DaysPLIFZDEC2
DELIVDATECATEGORYCategory of delivery dateLPEINCHAR2
MULTIPLEACCTASSGMTDISTRIBUTIONDistribution Indicator for Multiple Account AssignmentVRTKZCHAR2
PARTIALINVOICEDISTRIBUTIONPartial invoice indicatorTWRKZCHAR2
STORAGELOCATIONStorage locationLGORT_DCHAR8
PURCHASECONTRACTNumber of principal purchase agreementKONNRCHAR20
PURREQNSOURCEOFSUPPLYTYPEPurchasing Document CategoryBSTYPCHAR2
PURCHASECONTRACTITEMItem number of principal purchase agreementKTPNRNUMC10
CONSUMPTIONPOSTINGConsumption postingKZVBRCHAR2
PURREQNORIGINCreation indicator (purchase requisition/schedule lines)ESTKZCHAR2
ISPURREQNBLOCKEDPurchase Requisition BlockedBLCKDCHAR2
LANGUAGELanguage KeySPRASLANG2
ISCLOSEDPurchase requisition closedEBAKZCHAR2
RELEASEISNOTCOMPLETEDRelease Not Yet Completely EffectedFRGRLCHAR2
SERVICEPERFORMERService PerformerSERVICEPERFORMERCHAR20
PRODUCTTYPEProduct Type GroupPRODUCT_TYPECHAR4
PURCHASEREQUISITIONSTATUSRelease StateFRGZUCHAR16
RELEASESTRATEGYRelease strategy in the purchase requisitionFRGSTCHAR4
PERFORMANCEPERIODSTARTDATEStart Date for Period of PerformanceMMPUR_SERVPROC_PERIOD_STARTDATS16
PERFORMANCEPERIODENDDATEEnd Date for Period of PerformanceMMPUR_SERVPROC_PERIOD_ENDDATS16
SUPPLIERMATERIALNUMBERMaterial Number Used by SupplierIDNLFCHAR70
BATCHBatch NumberCHARG_DCHAR20
MATERIALREVISIONLEVELRevision LevelREVLVCHAR4
MINREMAININGSHELFLIFEMinimum Remaining Shelf LifeMHDRZDEC3
GOODSRECEIPTISEXPECTEDGoods Receipt IndicatorWEPOSCHAR2
INVOICEISEXPECTEDInvoice receipt indicatorREPOSCHAR2
GOODSRECEIPTISNONVALUATEDGoods Receipt, Non-ValuatedWEUNBCHAR2
REQUIREMENTTRACKINGRequirement Tracking NumberBEDNRCHAR20
MRPCONTROLLERMRP ControllerDISPOCHAR6
TAXCODETax on sales/purchases codeMWSKZCHAR4
PURCHASEREQUISITIONISFIXEDPurchase requisition is fixedBAFIXCHAR2
PURCHASINGDOCUMENTSUBTYPEControl indicator for purchasing document typeBSAKZCHAR2
PURREQNCATALOGTechnical Key of a Web Service (for Example - a Catalog)BBP_WS_SERVICE_IDCHAR40
PURREQNCATALOGITEMCatalog Item IdMMPUR_REQ_D_CATALOGITEMCHAR80
PURREQNCROSSCATALOGITEMCatalog Item KeyMMPUR_CAT_D_ITM_KEYINT44
USERDESCRIPTIONUser DescriptionVDM_USERDESCRIPTIONCHAR160
EXPECTEDOVERALLLIMITAMOUNTExpected Value of Overall LimitCOMMITMENTCURR7
OVERALLLIMITAMOUNTOverall LimitSUMLIMITCURR7
PURCHASEREQNITEMUNIQUEIDKey to identify purchase requisition itemMM_PUR_PR_ITEM_KEYCHAR30
PURCHASEORDERPRICETYPEUse Requisition Price in Purchase OrderBPUEBCHAR2
ISPURREQNOVRLRELOverall release of purchase requisitionsGSFRGCHAR2
ITEMNETAMOUNTPURREQNITEMCURRENCYCURR8
EXTERNALAPPROVALSTATUSExternal Processing StatusMMPUR_REQ_EXTAPPRVLSTSCHAR2
COMMITMENTITEMCommitment ItemFIPOSCHAR28
FUNDSCENTERFunds CenterFISTLCHAR32
FUNDFundBP_GEBERCHAR20
GRANTIDGrantGM_GRANT_NBRCHAR40
FUNCTIONALAREAFunctional AreaFKBERCHAR32
EARMARKEDFUNDSDOCUMENTDocument Number for Earmarked FundsKBLNRCHAR20
EARMARKEDFUNDSDOCUMENTITEMEarmarked Funds: Document ItemKBLPOSNUMC6
BUDGETPERIODBudget PeriodFM_BUDGET_PERIODCHAR20
COSTCENTERCost CenterKOSTLCHAR20
GLACCOUNTG/L Account NumberSAKNRCHAR20
WBSELEMENTWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC16
FUNDEDPROGRAMCHAR48
FUNDMGMTISACTIVETruth Value: True/FalseABAP_BOOLEANCHAR2
PURREQNREWORKCOMMENTTEXTNote TextMMPUR_NOTE_TEXTSTRG8
PURREQNREJECTIONISCANCELLEDTruth Value: True/FalseABAP_BOOLEANCHAR2
ISOUTLINEIs OutlineMMPUR_REQ_IS_OUTLINECHAR2
PURCHASINGPARENTITEMParent Item NoMMPUR_REQ_PARENT_ITEM_NONUMC10
PURREQNITEMOUTLINETYPEOutline TypeMMPUR_REQ_OUTLINE_TYPECHAR2
PURGCONFIGURABLEITEMNUMBERHierarchy NumberEXLINCHAR80
PURGEXTERNALSORTNUMBERExternal Sort NumberEXSNRNUMC10
PURCHASINGSIBLINGHIERARCHYITEMSibling Item of HierarchyMMPUR_SIBLING_HIER_ITEMNUMC10
HIERARCHYNODEHierarchy nodeRSNODEEXTSSTR8
HIERARCHYPARENTNODEHierarchy nodeRSNODEEXTSSTR8
HIERARCHYLEVELINT44
HIERARCHYNODESUBTREESIZEINT44
HIERARCHYDRILLSTATECHAR44
HIERARCHYNODEORDINALNUMBERINT88
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
.INCLUDEEBAN_INCL_EEW_PS0
.INCLUDECI_EBANDB0
DUMMY_EBAN_INCL_EEW_PSData element for purchase requisition extensibilityEBAN_INCL_EEWCHAR2
Privacy Policy