- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- External Services (MM-SRV)
- Information System (MM-IS)
- Inventory Management (MM-IM)
- Invoice Verification (MM-IV)
- Purchasing (MM-PUR)
- Basic Functions (MM-PUR-GF)
- Master Product Specification (MM-PUR-MPS)
- Procurement Hub (MM-PUR-HUB)
- Purchase Orders (MM-PUR-PO)
- Purchase Requisitions (MM-PUR-REQ)
- Purchasing Content (MM-PUR-CNT)
- RFQ/Quotation (MM-PUR-RFQ)
- Self-Service Procurement (MM-PUR-SSP)
- Service Procurement (MM-PUR-SVC)
- Sources of Supply (MM-PUR-SQ)
- Sourcing Project/Quotation (MM-PUR-SPQ)
- Vendor Outline Agreements (MM-PUR-OA)
- Vendor-Material Relationships and Conditions (MM-PUR-VM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
P_POItmSchedLineRunningAggrgn
PO item Running Aggregation for Week and month
| view: PORUNNNINGAGGRGN
| Extraction:
Not supported
| Component: Purchase Orders
Tables used:
SCAL_TT_DATE, EKKO, EKPO, EKET, MMPUR_ANA_EKET, MATDOC_EXTRACT, EKBE, EKBEH, MARA, MARA, T163B, MMPUR_ANA_CONF, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, /SAPSLL/TUNOS
- 🔑 Keys (3)
- 💰 Amounts
- ∑ Quantities (1)
- 📅 Dates (3)
- ☰ Categorical
- Other (47)
- 🔗 Relations (7)
| Column Name | Description | |
|---|---|---|
| PurchaseOrder | Purchasing Document Number | |
| PurchaseOrderItem | Item Number of Purchasing Document | |
| ScheduleLine | Delivery Schedule Line Counter |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| PurchaseOrderItemQty | Purchase Order Quantity |
| Column Name | Description | |
|---|---|---|
| PurchaseOrderDate | Purchase Order Date | |
| SchedLineStscDeliveryDate | Statistics-Relevant Delivery Date | |
| LastPostingDateOfMaterialDoc | null |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| Supplier | Account Number of Supplier | LIFNR | |
| Plant | Plant | WERKS | |
| MRPRelevantMaterial | null | ||
| MaterialClassification | ABC Indicator | MAABC | |
| POIncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
| POIncotermsLocation1 | Incoterms Location 1 | INCO_L | |
| POIncotermsLocation2 | Incoterms Location 2 | INCO_L | |
| ItemIncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
| ItemIncotermsLocation1 | Incoterms Location 1 | INCO_L | |
| ItemIncotermsLocation2 | Incoterms Location 2 | INCO_L | |
| ExpectedNoOfDays | null | ||
| ActualNoOfDays | null | ||
| DelayInNoOfDays | null | ||
| DeliveryBehavior | null | ||
| SupplierPlant | null | ||
| YearWeek | Year Week | NUM6 | |
| YearMonth | Year Month | NUM6 | |
| GoodsReceiptMaterialDocYear | Calendar Year | NUM4 | |
| diff_create_giposting | null | ||
| diff_giposting | null | ||
| diff_create | null | ||
| PreviousYearWeek | Year Week | NUM6 | |
| PreviousYearMonth | Year Month | NUM6 | |
| PreviousWeek | null | ||
| PreviousMonth | null | ||
| running_w_count | null | ||
| running_quant_w_sum | null | ||
| running_quant_w_min | null | ||
| running_quant_w_avg | null | ||
| running_quant_w_max | null | ||
| running_diff1_w_min | null | ||
| running_diff1_w_avg | null | ||
| running_diff1_w_max | null | ||
| running_diff2_w_min | null | ||
| running_diff2_w_avg | null | ||
| running_diff2_w_max | null | ||
| running_m_count | null | ||
| running_quant_m_sum | null | ||
| running_quant_m_min | null | ||
| running_quant_m_avg | null | ||
| running_quant_m_max | null | ||
| running_diff1_m_min | null | ||
| running_diff1_m_avg | null | ||
| running_diff1_m_max | null | ||
| running_diff2_m_min | null | ||
| running_diff2_m_avg | null | ||
| running_diff2_m_max | null |
| Master Data Relations | Join Conditions |
|---|---|
Account Assignment Category
| |
Incoterms (Part 1)
| |
Material Number
| |
Material Group
| |
Incoterms (Part 1)
| |
Purchase Order Unit of Measure
| |
Supplying (issuing) plant in case of stock transport order
|