P_PurFutureSpend

Purchasing Future Spend | view: PMMPOFUTRSPND | Extraction: Not supported | Component: Reporting
Tables used: EKKOEKPOEKET
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
ScheduleLine Delivery Schedule Line Counter
Column Name Description
💲 Currency Key (Currency):
NetPriceAmount null
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ScheduleLineOrderQuantity Scheduled Quantity
RoughGoodsReceiptQty Quantity of goods received
Column Name Description
PurchaseOrderDate Purchase Order Date
ScheduleLineDeliveryDate Item delivery date
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
ScheduleLineDeliveryTime Delivery Date Time-Spot
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
PurchaseRequisition Purchase Requisition Number BANFN
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
CreatedByUser User of person who created a purchasing document USNAM
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit UMBSZ
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit UMBSN
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURFUTURESPEND.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURFUTURESPEND.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_PURFUTURESPEND.COMPANYCODE == T001.BUKRS
  • P_PURFUTURESPEND.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_PURFUTURESPEND.MANDT == TCURC.MANDT
  • P_PURFUTURESPEND.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_PURFUTURESPEND.MANDT == MARA.MANDT
  • P_PURFUTURESPEND.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURFUTURESPEND.MANDT == T023.MANDT
  • P_PURFUTURESPEND.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURFUTURESPEND.MANDT == T001W.MANDT
  • P_PURFUTURESPEND.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_PURFUTURESPEND.MANDT == T163.MANDT
  • P_PURFUTURESPEND.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PURFUTURESPEND.MANDT == T006.MANDT
  • P_PURFUTURESPEND.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Client
  • Purchase Order Type
  • Purchasing Document Category
  • P_PURFUTURESPEND.MANDT == T161.MANDT
  • P_PURFUTURESPEND.PURCHASEORDERTYPE == T161.BSART
  • P_PURFUTURESPEND.PURCHASEORDERCATEGORY == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURFUTURESPEND.PURCHASINGGROUP == T024.EKGRP
  • P_PURFUTURESPEND.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURFUTURESPEND.MANDT == T024E.MANDT
  • P_PURFUTURESPEND.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_PURFUTURESPEND.MANDT == LFA1.MANDT
  • P_PURFUTURESPEND.SUPPLIER == LFA1.LIFNR