General presentation
Objective of the application
To upload forecast data (BFR and Budget) from non-SAP data, which is excel file to combine data into Global Sales.
Tool Leader + IT leader of the application: Anon Kasemvilas + Sandra Silveira
Usage information
File Template
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| In order to access the tcode ZBW_SD_PC | ||
ZR_*_CA_P05 | GBU | In order to load content of data base on GBU |
ZR_*_CA_P01 | Company Code | In order to load content of data base on Company code |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
- Access the program via transaction code ZBW_SD_PC
- Select the fore case file on you PC, which has to be excel and the correct file format
- Click on Preview in order to check the authorization of content and data correction. It may take some time
- Click on Check File to get the summary of the data correction.
- If data is incorrect, it will tell how many error and what line is incorrect on the file
- If data is OK, the Load File button will be available
- Click on Load File, it will save the data into BW system and run the PC in order to load from file to PSA and DSO DPSDFC01
- The data from DSO will go to the cube every 1 hour base on PC
Data loadings
Info providers and objects loaded
Loading frequency
Depend on users to load via T-Code ZBW_SD_PC. However, this loading will be load only upto propagation layer. In order to update on the reporting, it would spend around x hour
Average performance
The step 'Preview Data' mayl take time (less than 1 minute) in order to check the content of the data comparing to the master data.
The step 'Load File' may take time around 1 - 5 minutes in order to load the data into BW
Record Keeping
Log of loading data will be kept on DSO DPSDFC02 with the detail of filename, username, date and time that load data and the status of loading. However, it will display on the tcode only last 10 records.
Reporting
There is no query base on the forecast only. The data will combine with the global sales multi-provider