1) Sales Order reports
The reports present the detailed level of all sales orders placed in SAP/PF1 system, being possible to determine:
- Sales Order on going and open
- Sales Orders Shipped Not Billed
- Sales Orders invoiced
The sales order book is defined at most detailed level. That means at the schedule line level. The concept of line is very important to understand how the order book works. Each sales document can generate an item, the combination of document number / item number is a line.
To generate the sales order book, the documents lines below are used:
- Order line
- Schedule line
- Delivery line
- Shipment(1)
- Billing line
- Schedule line
- Order line
Document line generation:
- Each sales order document can generate n order line.
- Each scheduled line can generate n delivery document.
- Each delivery document can generate n delivery line.
- Each delivery line can generate n billing document.
- Each Billing document can generate n billing line.
(1) the shipment line are not used in the reports. Information necessary to generate the sales order book are at the shipment to the end customer in the header level. Define shipment to the end customer
2) Purchase Order reports
3) Rules
3.1) Data excluded from the report
- All sales order with any Rejection code are excluded in the “To be invoiced”, “open order” and “shipped not billed” reports.
- For the invoiced part there are no restrictions.
(If an invoice has been issued for an order with rejection code, it will appear in the "Invoiced (M)" section).
NB : sometime, rejection code for the order is applied after the invoice creation
- by default in the prompt of the query, the following material types are excluded :
- PF1 Z703 Packaging & accessories
- WP1 ZDIE Services
- WP1 ZVER Packaging
- WP1 ZUNB Stocked and not valuated
- by default in the prompt of the query, the following material types are excluded :
- Order lines created more than 24 months ago are excluded



