Aggregated Queries

Historical Data: Sales orders

Data on sales order item documents. 

Based on Sales Order creation date.

Aggregated level + DETAIL Jump query

Historical Data: Sales deliveries

Data on sales outbound deliveries item documents. 

Based on the Actual Goods Issue date.

Aggregated level + DETAIL Jump query

Historical Data: Sales invoices

Data on billing/invoice item documents.

Based on the Billing date. Aggregated level + DETAIL Jump query

Logistic costs are calculated according to the following pricing conditions:

WP1 -> Pricing condition "account key" = ERF or ZFO

PF1 -> Pricing condition "type" = TU, ZZ01, ZZ02, RRFR, TFSD, RPCR, RTTR.

Historical Data: PO’s transfer orders

Data on Purchase Orders documents.

Based on Order creation date. 

Aggregated level + DETAIL Jump query

Historical Data: PO’s transfer deliveries

Data on Purchase Orders’ deliveries documents.

Based on the Actual Goods Issue date.

Aggregated level + DETAIL Jump query

Historical Data: PO’s transfer invoices

Data on Purchase Orders’ billing/invoice documents.

Based on the Billing date.

Aggregated level + DETAIL Jump query

Historical Data: Manual Pricing

Audit report on price changes in Sales Orders vs. standard price

Aggregated level

Historical Data: Sales overview

To refresh the query just one reference date is necessary:

• To determine the Order fields the reference date is the Scheduled Goods Issue date in the level of the order/item doc.
• To determine the Delivery fields the reference date is the Actual Goods Issue date
• To determine the Invoiced fields the reference date is the Billing document date

Historical Data: Sales Order by Last Req Goods Issue date

Detailed data on Sales Orders.

Based on the Last Requested Goods Issue date.