P_ProjProcmtPurReqnOrd

Project Procurement Purchase Reqn Order | view: PPROJPROCMTPRPO | Extraction: Not supported | Component: Project System

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EKKN, EKET, EBKN, PRTE, TKA01, KNA1, FM01, T001W, PROJ, CNLDST_SHORTTX, T000, LFA1, USR21, T001K, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (6)
💰 Amounts (1)
∑ Quantities (2)
📅 Dates (3)
☰ Categorical (2)
Other (9)
🔗 Relations (21)

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
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
ProfitCenter	Profit Center	PRCTR
Project	Project definition	PS_PSPID
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name	TEXT40
ProjectDescription	Project Definition Name	TEXT40
FormattedPurchasingDocItem	null
PurchaseRequisitionItemText	Short Text	TEXT40
PurchasingDocumentPartnerType	null
IsCompletelyDelivered	null

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`P_PROJPROCMTPURREQNORD.MANDT == T163K.MANDT` `P_PROJPROCMTPURREQNORD.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Company code Company Code Client	`P_PROJPROCMTPURREQNORD.COMPANYCODE == T001.BUKRS` `P_PROJPROCMTPURREQNORD.MANDT == T001.MANDT`
Controlling area Controlling Area Client	`P_PROJPROCMTPURREQNORD.CONTROLLINGAREA == TKA01.KOKRS` `P_PROJPROCMTPURREQNORD.MANDT == TKA01.MANDT`
Currency Key Client Currency Key	`P_PROJPROCMTPURREQNORD.MANDT == TCURC.MANDT` `P_PROJPROCMTPURREQNORD.DOCUMENTCURRENCY == TCURC.WAERS`
Material Number Material Number Client	`P_PROJPROCMTPURREQNORD.MATERIAL == MARA.MATNR` `P_PROJPROCMTPURREQNORD.MANDT == MARA.MANDT`
Material Group Client Material Group	`P_PROJPROCMTPURREQNORD.MANDT == T023.MANDT` `P_PROJPROCMTPURREQNORD.MATERIALGROUP == T023.MATKL`
Purchase requisition unit of measure Client Purchase requisition unit of measure	`P_PROJPROCMTPURREQNORD.MANDT == T006.MANDT` `P_PROJPROCMTPURREQNORD.ORDERQUANTITYUNIT == T006.MSEHI`
Plant Plant Client	`P_PROJPROCMTPURREQNORD.PLANT == T001W.WERKS` `P_PROJPROCMTPURREQNORD.MANDT == T001W.MANDT`
Project Project (internal) Client	`P_PROJPROCMTPURREQNORD.PROJECTINTERNALID == PROJ.PSPNR` `P_PROJPROCMTPURREQNORD.MANDT == PROJ.MANDT`
Profile ID for project structure Project Profile Client	`P_PROJPROCMTPURREQNORD.PROJECTPROFILECODE == TCJ41.PROFIDPROJ` `P_PROJPROCMTPURREQNORD.MANDT == TCJ41.MANDT`
Project type Client Project type	`P_PROJPROCMTPURREQNORD.MANDT == TCJ1.MANDT` `P_PROJPROCMTPURREQNORD.PROJECTTYPE == TCJ1.PRART`
Purchase Requisition Document Type Purchasing Document Category Client Purchase Requisition Document Type	`P_PROJPROCMTPURREQNORD.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_PROJPROCMTPURREQNORD.MANDT == T161.MANDT` `P_PROJPROCMTPURREQNORD.PURCHASINGDOCUMENTTYPE == T161.BSART`
Purchasing Group Client Purchasing Group	`P_PROJPROCMTPURREQNORD.MANDT == T024.MANDT` `P_PROJPROCMTPURREQNORD.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Purchasing organization Client	`P_PROJPROCMTPURREQNORD.PURCHASINGORGANIZATION == T024E.EKORG` `P_PROJPROCMTPURREQNORD.MANDT == T024E.MANDT`
Storage location Storage location Plant Client	`P_PROJPROCMTPURREQNORD.STORAGELOCATION == T001L.LGORT` `P_PROJPROCMTPURREQNORD.PLANT == T001L.WERKS` `P_PROJPROCMTPURREQNORD.MANDT == T001L.MANDT`
Desired Vendor Client Desired Vendor	`P_PROJPROCMTPURREQNORD.MANDT == LFA1.MANDT` `P_PROJPROCMTPURREQNORD.SUPPLIER == LFA1.LIFNR`
Profit Center ? ? Profit Center Profit Center Client	`P_PROJPROCMTPURREQNORD.[column in domain "KOKRS"] == CEPC.KOKRS` `P_PROJPROCMTPURREQNORD.[column in domain "DATBI"] == CEPC.DATBI` `P_PROJPROCMTPURREQNORD.WBSELEMENTPROFITCENTER == CEPC.PRCTR` `P_PROJPROCMTPURREQNORD.PROFITCENTER == CEPC.PRCTR` `P_PROJPROCMTPURREQNORD.MANDT == CEPC.MANDT`