P_MngProjDmndPurReqnOrd

Private View for calc measures of PR/PO | view: PMNGPRPO | Extraction: Not supported | Component: Project System

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EKKN, EKET, EBKN, PRTE, EKBE, EKBEH, TKA01, KNA1, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, FM01, MARA, MAKT, T001W, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PROJ, CNLDST_SHORTTX, T163B, T000, LFA1, USR21, T001K, PRPS, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (6)
💰 Amounts (4)
∑ Quantities (6)
📅 Dates (6)
☰ Categorical (5)
Other
🔗 Relations (13)

Column Name	Description
WBSElementInternalID FK	Work Breakdown Structure Element (WBS Element)
PurchaseRequisition	Purchase Requisition Number
PurchaseRequisitionItem FK	Item number of purchase requisition
PurchasingDocument FK	Purchase order number
PurchasingDocumentItem FK	Purchase order item number
AccountAssignmentNumber	Serial number for PReq account assignment segment

Column Name	Description
💲 Currency Key (DocumentCurrency):
NetValueAmountInDocCurrency	null
InvoiceReceiptAmount	null
GoodsReceiptAmount	null
PurchaseOrderAmount	null

Column Name	Description
📏 Purchase requisition unit of measure (BaseUnit):
OrderedQuantity	Quantity ordered against this purchase requisition
RequestedQuantity	Purchase requisition quantity
StockTransferDeliveredQuantity	null
StillToBeDeliveredQuantity	null
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity	Purchase Order Quantity
GoodsReceiptQty	null

Column Name	Description
CreationDate	Requisition (request) date
PurchaseOrderDate	Purchase Order Date
ScheduleLineDeliveryDate	null
SchedLineStscDeliveryDate	null
PerformancePeriodStartDate	null
PerformancePeriodEndDate	null

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
PurReqnReleaseStatus	Requisition Processing State	Show values
IsReturnsItem	Returns Item	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Purchase requisition unit of measure Client Purchase requisition unit of measure Purchase Order Unit of Measure	`P_MNGPROJDMNDPURREQNORD.MANDT == T006.MANDT` `P_MNGPROJDMNDPURREQNORD.BASEUNIT == T006.MSEHI` `P_MNGPROJDMNDPURREQNORD.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Currency Key Client Currency Key	`P_MNGPROJDMNDPURREQNORD.MANDT == TCURC.MANDT` `P_MNGPROJDMNDPURREQNORD.DOCUMENTCURRENCY == TCURC.WAERS`
Plant Client Plant	`P_MNGPROJDMNDPURREQNORD.MANDT == T001W.MANDT` `P_MNGPROJDMNDPURREQNORD.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`P_MNGPROJDMNDPURREQNORD.MANDT == T163.MANDT` `P_MNGPROJDMNDPURREQNORD.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchase Order Unit of Measure Client Purchase requisition unit of measure Purchase Order Unit of Measure	`P_MNGPROJDMNDPURREQNORD.MANDT == T006.MANDT` `P_MNGPROJDMNDPURREQNORD.BASEUNIT == T006.MSEHI` `P_MNGPROJDMNDPURREQNORD.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Requisition Document Type Purchase Requisition Document Type Purchasing Document Category Client	`P_MNGPROJDMNDPURREQNORD.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_MNGPROJDMNDPURREQNORD.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_MNGPROJDMNDPURREQNORD.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`P_MNGPROJDMNDPURREQNORD.PURCHASINGGROUP == T024.EKGRP` `P_MNGPROJDMNDPURREQNORD.MANDT == T024.MANDT`
Purchasing Organization Purchasing Organization Client	`P_MNGPROJDMNDPURREQNORD.PURCHASINGORGANIZATION == T024E.EKORG` `P_MNGPROJDMNDPURREQNORD.MANDT == T024E.MANDT`
Desired Vendor Client Desired Vendor	`P_MNGPROJDMNDPURREQNORD.MANDT == LFA1.MANDT` `P_MNGPROJDMNDPURREQNORD.SUPPLIER == LFA1.LIFNR`