P_CntrlPurchasingSpend

Central Purchasing Spend | view: PCNTRLPURGSPND | Extraction: Not supported | Component: Central Purchase Order
Tables used: MMPUR_ANAEXTEKET
Column Name Description
PurchaseOrder Purchasing Document Number
PurchaseOrderItem Item Number of Purchasing Document
ScheduleLine Schedule Line Number
ProcurementHubSourceSystem Connected System ID
Column Name Description
💲 Reporting Currency 1 (AnalyticalReportingCurrency):
NetPriceInReportingCurrency Net Price: Reporting Currency 1
💲 Reporting Currency 2 (AnalyticalReportingCurrency2):
NetPriceInReportingCurrency2 Net Price: Reporting Currency 2
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
ScheduleLineOrderQuantity Scheduled Quantity
Column Name Description
ScheduleLineDeliveryDate Item delivery date
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
PurchaseOrderDate Purchasing Document Date
Column Name Description
IsReturnsItem Returns Item Show values
Column Name Description Domain name
Supplier Account Number of Supplier LIFNR
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
CompanyCode Company Code BUKRS
Material Material Number MATNR
MaterialGroup Material Group MATKL
Plant Plant WERKS
PurchasingDocumentItemCategory Item category in purchasing document PSTYP
PurchaseOrderType Order Type (Purchasing) BSART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserName Full Name of Person TEXT80
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
NetPriceQuantity Price unit DEC5