1.0 Overview



The quotation report is part of the BW global sales folder, playing a crucial role in enabling a comprehensive analysis of quotations generated in SAP for the AERO business line of Composite Material. The analysis covers material, customer, and pricing perspectives. The report report also monitors the status of each quote, indicating whether an order has been initiated in connection with the respective quotation. This functionality provides valuable insights into the entire quotation process within the AERO business line. 



Target Users:

Composite material (aero business line) sales team 

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

21.12.2023

Azadeh Nasiri

Initial draft










Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • Others <specify the name of the source> 

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.


ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name















4.0 Functional Specification

4.1 General Data/Calculations 

Key Figures 

Key figure

Comments

Quote quantity (PUQ)

Quantity from sales document item

Net value item (USD)

Amount based on the USD in the daily tax rate of creation document

NET Price (CP)

Amount per quantity

Net Value item (CP)

Amount based on the currency prompt tax rate of creation document

Unit Price (CP)

Amount from condition price (PR00 or ZPRE) divided by the quantity item.

Lead Time (days)

Replenishment time from material/plant master data 

4.2 Process Detail 

  • No filters applied;
  • Optional Date ranges: valid from, valid to, quotation creation date


“Overall status” (at Header Level) will show whether or not an order has been created with reference to the quote line:

  • Completely processed: Quote has been fully referenced
  • Partially processed: Quote has been partially referenced
  • Not yet processed: Quote is still not been referenced

4.2.1.  Report/Process Definition 

 Available files 

Account group

Material

Program

Sales Organization

BFC GBU

Material/Plant

Quote Creation month/year

Ship to

BFC Group of Activities

MRP Planner

Quote document

Sold to

Company Code

Non Spec Required

Quote line

Spec long description

CSR

Order Line creation date

Quoted Lead time

Sub Activity

Customer Quote ref

Overall Status (quote document)

Reason for rejection of quotations

Valid from

Division

Overall Status (quote line)

Reference document

Valid to

Document date

Plant

Sales account manager


DPAS

Price Group

Sales Office


This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.



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

Data in BW will be refreshed daily containing information from D-1 (CET time)