P_PurchaseRequisitionItm

Purchase Requisition Item | view: PMMPURREQITM | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
Column Name Description
Column Name Description
CreationDate Requisition (request) date
Column Name Description
PurReqnReleaseStatus Requisition Processing State Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
PurReqnItemClassification Purchase Reqn Item Classification Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseRequisitionStatus Release State FRGZU
ReleaseStrategy Release strategy in the purchase requisition FRGST
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_PURCHASEREQUISITIONITM.COMPANYCODE == T001.BUKRS
  • P_PURCHASEREQUISITIONITM.MANDT == T001.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_PURCHASEREQUISITIONITM.FIXEDSUPPLIER == LFA1.LIFNR
  • P_PURCHASEREQUISITIONITM.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • P_PURCHASEREQUISITIONITM.MANDT == MARA.MANDT
  • P_PURCHASEREQUISITIONITM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURCHASEREQUISITIONITM.MANDT == T023.MANDT
  • P_PURCHASEREQUISITIONITM.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • P_PURCHASEREQUISITIONITM.PLANT == T001W.WERKS
  • P_PURCHASEREQUISITIONITM.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • ?
  • P_PURCHASEREQUISITIONITM.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURCHASEREQUISITIONITM.MANDT == T161.MANDT
  • P_PURCHASEREQUISITIONITM.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASEREQUISITIONITM.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASEREQUISITIONITM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEREQUISITIONITM.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEREQUISITIONITM.MANDT == T024E.MANDT
Release Indicator
  • Release Indicator
  • Client
  • P_PURCHASEREQUISITIONITM.RELEASECODE == T161S.FRGKZ
  • P_PURCHASEREQUISITIONITM.MANDT == T161S.MANDT
Desired Vendor
  • Desired Vendor
  • Client
  • P_PURCHASEREQUISITIONITM.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEREQUISITIONITM.MANDT == LFA1.MANDT