P_PurgSpendOpenReqn

Purchasing Spend for Open Requisition | view: PMMPSOPENREQN | Extraction: Not supported | Component: Reporting
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, FM01, T001W, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
ExpectedSpend Expected Spend of Purchase Requisition
Column Name Description
RequestedQuantity Purchase requisition quantity
Column Name Description
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurReqnReleaseStatus Requisition Processing State Show values
IsPurReqnCmplt Purchase Requisition not yet Complete Show values
PurReqnCmpltnsCat Category of Incompleteness Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • P_PURGSPENDOPENREQN.MANDT == T001.MANDT
  • P_PURGSPENDOPENREQN.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • P_PURGSPENDOPENREQN.MANDT == MARA.MANDT
  • P_PURGSPENDOPENREQN.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURGSPENDOPENREQN.MANDT == T023.MANDT
  • P_PURGSPENDOPENREQN.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURGSPENDOPENREQN.MANDT == T001W.MANDT
  • P_PURGSPENDOPENREQN.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • Purchasing Document Category
  • P_PURGSPENDOPENREQN.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURGSPENDOPENREQN.MANDT == T161.MANDT
  • P_PURGSPENDOPENREQN.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_PURGSPENDOPENREQN.MANDT == T163.MANDT
  • P_PURGSPENDOPENREQN.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURGSPENDOPENREQN.PURCHASINGGROUP == T024.EKGRP
  • P_PURGSPENDOPENREQN.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURGSPENDOPENREQN.MANDT == T024E.MANDT
  • P_PURGSPENDOPENREQN.PURCHASINGORGANIZATION == T024E.EKORG
Currency Key
  • Client
  • Currency Key
  • P_PURGSPENDOPENREQN.MANDT == TCURC.MANDT
  • P_PURGSPENDOPENREQN.PURREQNITEMCURRENCY == TCURC.WAERS
Fixed Vendor
  • Client
  • Fixed Vendor
  • P_PURGSPENDOPENREQN.MANDT == LFA1.MANDT
  • P_PURGSPENDOPENREQN.SUPPLIER == LFA1.LIFNR