I_ProjProcmtPurReqnOrd

Project Procurement Purchase Reqn Order | view: IPROJPROCMTPRPO | Extraction: Not supported | Component: Project System
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EKKN, EKET, EBKN, PRTE, TKA01, KNA1, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, FM01, MARA, MAKT, T001W, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PROJ, CNLDST_SHORTTX, T000, LFA1, USR21, T001K, PRPS, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
WBSElementInternalID FK Work Breakdown Structure Element (WBS Element)
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
PurchaseOrder FK Purchase order number
PurchaseOrderItem FK Purchase order item number
AccountAssignmentNumber Serial number for PReq account assignment segment
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount null
Column Name Description
📏 Purchase requisition unit of measure (OrderQuantityUnit):
OrderedQuantity Quantity ordered against this purchase requisition
TotalQuantity Purchase requisition quantity
Column Name Description
CreationDate Requisition (request) date
DeliveryDate Item delivery date
ScheduleLineDeliveryDate Item delivery date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingReleaseStatus Requisition Processing State Show values
Column Name Description Domain name
FormattedPurchasingDocItem null
PurchaseRequisitionItemText Short Text TEXT40
Project Project definition PS_PSPID
ProfitCenter Profit Center PRCTR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
ProjectDescription Project Definition Name TEXT40
ProjectType Project Type PS_PRART
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
ProjectUUID Entity Guid /S4PPM/GUID
SupplierName Name of Supplier TEXT80
MaterialName Material Description TEXT40
PurchasingDocumentPartnerType null
IsCompletelyDelivered null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • I_PROJPROCMTPURREQNORD.MANDT == T163K.MANDT
  • I_PROJPROCMTPURREQNORD.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company code
  • Client
  • Company Code
  • I_PROJPROCMTPURREQNORD.MANDT == T001.MANDT
  • I_PROJPROCMTPURREQNORD.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_PROJPROCMTPURREQNORD.MANDT == TKA01.MANDT
  • I_PROJPROCMTPURREQNORD.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • I_PROJPROCMTPURREQNORD.MANDT == TCURC.MANDT
  • I_PROJPROCMTPURREQNORD.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • I_PROJPROCMTPURREQNORD.MANDT == MARA.MANDT
  • I_PROJPROCMTPURREQNORD.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_PROJPROCMTPURREQNORD.MANDT == T023.MANDT
  • I_PROJPROCMTPURREQNORD.MATERIALGROUP == T023.MATKL
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • I_PROJPROCMTPURREQNORD.MANDT == T006.MANDT
  • I_PROJPROCMTPURREQNORD.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_PROJPROCMTPURREQNORD.MANDT == T001W.MANDT
  • I_PROJPROCMTPURREQNORD.PLANT == T001W.WERKS
Project Category
  • Project Category
  • Client
Project
  • Client
  • Project (internal)
  • I_PROJPROCMTPURREQNORD.MANDT == PROJ.MANDT
  • I_PROJPROCMTPURREQNORD.PROJECTINTERNALID == PROJ.PSPNR
Profile ID for project structure
  • Client
  • Project Profile
  • I_PROJPROCMTPURREQNORD.MANDT == TCJ41.MANDT
  • I_PROJPROCMTPURREQNORD.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Purchase Requisition Document Type
  • Client
  • Purchasing Document Category
  • Purchase Requisition Document Type
  • I_PROJPROCMTPURREQNORD.MANDT == T161.MANDT
  • I_PROJPROCMTPURREQNORD.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_PROJPROCMTPURREQNORD.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • I_PROJPROCMTPURREQNORD.MANDT == T024.MANDT
  • I_PROJPROCMTPURREQNORD.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • I_PROJPROCMTPURREQNORD.MANDT == T024E.MANDT
  • I_PROJPROCMTPURREQNORD.PURCHASINGORGANIZATION == T024E.EKORG
Storage location
  • Client
  • Plant
  • Storage location
  • I_PROJPROCMTPURREQNORD.MANDT == T001L.MANDT
  • I_PROJPROCMTPURREQNORD.PLANT == T001L.WERKS
  • I_PROJPROCMTPURREQNORD.STORAGELOCATION == T001L.LGORT
Desired Vendor
  • Desired Vendor
  • Client
  • I_PROJPROCMTPURREQNORD.SUPPLIER == LFA1.LIFNR
  • I_PROJPROCMTPURREQNORD.MANDT == LFA1.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • Profit Center
  • I_PROJPROCMTPURREQNORD.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJPROCMTPURREQNORD.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJPROCMTPURREQNORD.MANDT == CEPC.MANDT
  • I_PROJPROCMTPURREQNORD.PROFITCENTER == CEPC.PRCTR
  • I_PROJPROCMTPURREQNORD.WBSELEMENTPROFITCENTER == CEPC.PRCTR