Provide an overview of the app (e.g Domain, key processes, purpose of the app, etc)
Describe the key User profiles that exist for the application.
General role/Viewer role:
Approver role:
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | dd.mm.yyyy | <Insert name> | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
Capture the business process that the application supports . This can be describe through a process diagram or a business capability model
3.0 Application Feature Overview
Information about the existent Workbooks and the respective BW queries.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
4.0 Functional Specification
4.1 General Data/Calculations
Key figures for Sales Follow-up
Extrapol KeyFigures are calculated using working days of the Plant
Billed KeyFigures are excluding the following Billing Document Types:
Document types | |
F2SR | Invoice for Services |
G2CC | Commission Credit |
G2CS | Cancelat. G2CC |
G2SS | Cancelat. G2VS |
G2VS | Credit Mem Serv. |
L2CC | Commission Debit |
L2CS | Cancelat. L2CC |
L2SS | Cancelat. L2VS |
L2VS | Debit Memo Serv |
ZL2A | Downpayment |
ZL2S | Cancelat. ZL2A |
IV | Intercompany Billing |
| Open Order: Total on quantity for sales orders not yet issued and not yet invoiced, with the TO BE INVOICED DATE on the Month M. Open Order confirmed: Total on quantity for sales orders not yet issued and not yet invoiced, with the TO BE INVOICED DATE on the Month M. It shows how much from the Open Orders Qty M, have a confirmed quantity after ATP analysis. | ||
| Shipped Not Billed: Total on quantity for sales orders have been issued (with Actual GI Date) on the month M, but not yet Invoiced | ||
Total Order: Open Order + Shipped not Billed *GI stands for Good Issue. The Goods Issue date is the date on which the goods physically leave the warehouse or stock and are issued for delivery or consumption. If qty is not confirmed (zero) => Last Requested GI date; | ||
| Billed: Total on quantity invoiced on the Month M | ||
Final Forecast: Total on quantity forecast to be shipped. Final Forecast is the forecast validated after the Demand Review (=Unconstrained Forecast). Business rule: - Past snapshots (M<1): frozen forecasts (snapshots taken on 6th of each month) - Current month (M) until 6th of the month: Final Forecast from Dynasys (updated 4x/day) - Current month (M) after 6th of the month: Frozen Forecasts (snapshots taken on 6th of each month) - Future forecast (M>1): Final Forecast from Dynasys (updated 4x/day) Constrained Forecast: Demand reviewed by the S&OP | ||
Budget: Total on quantity budget to be shipped in current year (user can expand the view to detailed months) as maintained in Dynasys under Budget Review Customer Forecast: Forecast provided directly from the customer and maintained in Dynasys BFR03/BFR06/BFR09: Total on quantity to be shipped in current year according to each BFR version as maintained in Dynasys under Budget Review Demand Orderbook: Coming from Dynasys (not SAP), corresponds to the Order Book as requested by the Customer in the future. Sales Team Forecast: forecast entered by Sales Team in Dynasys (before forecast review) Demand Review Forecast: Forecast entered by the Demand Planner during the Demand review exercise. Once it's validated (during/after the Demand review meeting), it becomes the "Final Forecast". CSR Forecast: forecast entered by Customer Service team in Dynasys (before forecast review) Statistical Forecast: this is the Forecast generated by the statistical engine in DynaSys taking into account the History. By default, the system chooses the best model fit, but user can manually choose the desired model. ST Net Sales: Sales team Forecast x Sales Price | ||
| Sales Team Forecast ETD: Offset to the Sales Team Forecast (ETA). The Offset can be 0 months (ETA = ETD), 1 month or 2 months (values higher than 2 are unusual but can happen). | ||
| Sales Price FF: Price calculated in BW based on Final Forecast Net Sales / Final Forecast | ||
| Constrained demand Net Sales: Demand reviewed by the S&OP x Sales Price | ||
| Y Final Forecast Net Sales: Final Forecast x Sales Price | ||
| Netback Sales: Final forecast in quantity valuated with the Netback price Last Leg: Transport cost between the Plant/warehouse and the customer Term Thru: Warehouse costs (R339 and R340) | ||
| Billing NETV: Total on value invoiced in the current year | ||
| Order line NETV: Total on value ordered in the current year based on the Last Requested GI date |
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | <insert name> |
|---|---|
| Application | >insert name> |
| Provider | <insert name> |
| Existing Documentation | <insert link> |
5.0 Non-functional Descriptions
Please populate the relevant section and delete those that are not applicable.
5.1 Usability
5.2 Regulatory Compliance
5.3 Security
5.4 Performance
5.5 Reliability
5.6 Scalability
5.7 Compatibility
5.8 Availability
5.9 Refresh of the Data
- Global Sales data are daily refreshed
- DynaSys data is refreshed 4 times a day (10am, 2pm, 6pm, 11pm