P_PurgActualFutureSpend

Purchasing Actual Future Spend | view: PPURGACTFUTSPND | Extraction: Not supported | Component: Reporting

Tables used: SCAL_TT_DATE, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EKET, EKKO, EKPO, FM01, T001W, T161T, USR21, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (7)
💰 Amounts (5)
∑ Quantities
📅 Dates (1)
☰ Categorical (1)
Other (7)
🔗 Relations (12)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchase Order
SchedulingAgreement	Scheduling Agreement
SchedulingAgreementItem	Scheduling Agreement Item
ScheduleLine	Delivery Schedule Line Counter
PurchaseRequisition	Purchase Requisition Number
PurchaseRequisitionItem FK	Purchase Requisition Item

Column Name	Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy	Purchase Order Net Amount
PurRequisitionExpectedSpend	Expected Spend of Purchase Requisition
ScheduleLineExpectedSpend	Planned Spend for the Schedule Line
SchedulingAgreementSpend	Scheduling Agreement Amount
SchedgAgreementExpectedSpend	Expected Spend of Scheduling Agreement

Column Name	Description

Column Name	Description
PurchaseOrderDate	Purchase Order Date

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values

Column Name	Description	Domain name
CalendarMonth	Calendar Month	NUM2
CalendarQuarter	Calendar Quarter	NUM1
CalendarWeek	Calendar Week	NUM2
CalendarYear	Calendar Year	NUM4
YearQuarter	Year Quarter	NUM5
ServicePerformer	Service Performer	BU_PARTNER
ProductType	Product Type Group	CHAR2

Master Data Relations	Join Conditions
Company Code Company Code Client	`P_PURGACTUALFUTURESPEND.COMPANYCODE == T001.BUKRS` `P_PURGACTUALFUTURESPEND.MANDT == T001.MANDT`
Material Number Material Number Client	`P_PURGACTUALFUTURESPEND.MATERIAL == MARA.MATNR` `P_PURGACTUALFUTURESPEND.MANDT == MARA.MANDT`
Material Group Client Material Group	`P_PURGACTUALFUTURESPEND.MANDT == T023.MANDT` `P_PURGACTUALFUTURESPEND.MATERIALGROUP == T023.MATKL`
Plant Plant Client	`P_PURGACTUALFUTURESPEND.PLANT == T001W.WERKS` `P_PURGACTUALFUTURESPEND.MANDT == T001W.MANDT`
Item category in purchasing document Client Item category in purchasing document	`P_PURGACTUALFUTURESPEND.MANDT == T163.MANDT` `P_PURGACTUALFUTURESPEND.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchase Order Type Purchase Order Type Purchase Order Type Client Purchasing Document Category	`P_PURGACTUALFUTURESPEND.PURCHASEORDERTYPE == T161.BSART` `P_PURGACTUALFUTURESPEND.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_PURGACTUALFUTURESPEND.MANDT == T161.MANDT` `P_PURGACTUALFUTURESPEND.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP`
Purchase Order Type Purchase Order Type Purchase Order Type Client Purchasing Document Category	`P_PURGACTUALFUTURESPEND.PURCHASEORDERTYPE == T161.BSART` `P_PURGACTUALFUTURESPEND.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_PURGACTUALFUTURESPEND.MANDT == T161.MANDT` `P_PURGACTUALFUTURESPEND.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP`
Purchasing Group Client Purchasing Group	`P_PURGACTUALFUTURESPEND.MANDT == T024.MANDT` `P_PURGACTUALFUTURESPEND.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Purchasing organization Client	`P_PURGACTUALFUTURESPEND.PURCHASINGORGANIZATION == T024E.EKORG` `P_PURGACTUALFUTURESPEND.MANDT == T024E.MANDT`
Supplier Client Supplier	`P_PURGACTUALFUTURESPEND.MANDT == LFA1.MANDT` `P_PURGACTUALFUTURESPEND.SUPPLIER == LFA1.LIFNR`