P_PurReqnItm

Purchase Requisition Item details | view: PPURGDOCITEMSPR | Extraction: Not supported | Component: Purchase Orders
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
PurchaseReqnAcctAssgmtNumber Serial number for PReq account assignment segment
Column Name Description
PurReqnItemTotalAmount null
PurgDocNetAmount Target Amount
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
Column Name Description
Quantity Purchase requisition quantity
OpenQuantity Open Quantity
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
Column Name Description
DeliveryDate Item delivery date
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
PurReqCreationDate Requisition (request) date
Column Name Description
PurReqnReleaseStatus Requisition Processing State Show values
Status Processing status of purchase requisition Show values
ObjectType Num1 Show values
Column Name Description Domain name
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
PurchaseRequisitionItemText Short Text TEXT40
FormattedPurRequisitionItem null
Batch Batch Number CHARG
MultipleAcctAssgmtDistrPercent null
RequirementTracking Requirement Tracking Number CHAR10
RequisitionerName Name of requisitioner/requester AFNAM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurReqnPriceQuantity Price unit DEC5
ServicePerformer Service Performer BU_PARTNER
SalesOrder Sales and Distribution Document Number VBELN
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
CustProjWorkPackageFullName null
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_PURREQNITM.MANDT == T163K.MANDT
  • P_PURREQNITM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • P_PURREQNITM.MANDT == T006.MANDT
  • P_PURREQNITM.BASEUNIT == T006.MSEHI
Company code
  • Client
  • Company Code
  • P_PURREQNITM.MANDT == T001.MANDT
  • P_PURREQNITM.COMPANYCODE == T001.BUKRS
Cost Center
  • ?
  • Client
  • ?
  • Cost Center
  • P_PURREQNITM.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PURREQNITM.MANDT == CSKS.MANDT
  • P_PURREQNITM.[column in domain "DATBI"] == CSKS.DATBI
  • P_PURREQNITM.COSTCENTER == CSKS.KOSTL
Desired Vendor
  • Client
  • Desired Vendor
  • P_PURREQNITM.MANDT == LFA1.MANDT
  • P_PURREQNITM.EXTDESIREDSUPPLIERFORPURG == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • P_PURREQNITM.MANDT == MARA.MANDT
  • P_PURREQNITM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURREQNITM.MANDT == T023.MANDT
  • P_PURREQNITM.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURREQNITM.MANDT == T001W.MANDT
  • P_PURREQNITM.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Client
  • Purchase Requisition Document Type
  • ?
  • P_PURREQNITM.MANDT == T161.MANDT
  • P_PURREQNITM.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURREQNITM.[column in domain "BSTYP"] == T161.BSTYP
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_PURREQNITM.MANDT == T163.MANDT
  • P_PURREQNITM.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURREQNITM.MANDT == T024.MANDT
  • P_PURREQNITM.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURREQNITM.MANDT == T024E.MANDT
  • P_PURREQNITM.PURCHASINGORGANIZATION == T024E.EKORG
Currency Key
  • Client
  • Currency Key
  • P_PURREQNITM.MANDT == TCURC.MANDT
  • P_PURREQNITM.PURREQNITEMCURRENCY == TCURC.WAERS
Storage location
  • Client
  • Plant
  • Storage location
  • P_PURREQNITM.MANDT == T001L.MANDT
  • P_PURREQNITM.PLANT == T001L.WERKS
  • P_PURREQNITM.STORAGELOCATION == T001L.LGORT
Fixed Vendor
  • Client
  • Fixed Vendor
  • P_PURREQNITM.MANDT == LFA1.MANDT
  • P_PURREQNITM.SUPPLIER == LFA1.LIFNR