The data admin reports in the global sales folder of BW serves specific functions related to customer data, customer group retrieval, end-use mapping, and material conversion within the SAP BW system. |
Describe the key User profiles that exist for the application. General role/Viewer role: Approver role: |
Target Users: All the users of the marketing and sales related reports in BW |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 20.12.2023 | Azadeh Nasiri | Initial draft |
|
Not applicable
| Workbooks | Technical names |
|---|---|
| Data Admin - Customer Corporate Group | BW_WBK_SD_CPSDSO54_0001 |
| Data Admin - Customer Group | BW_WBK_SD_ADM_0002 |
| Data Admin - Customer Master Data | BW_WBK_SD_MVSDAD02_0005 |
| Data Admin - End Use | BW_WBK_SD_ADM_0001 |
| Data Admin - Material Master Data | BW_WBK_SD_MVSDAD02_0006 |
| Data Admin - Material not Converted | BW_WBK_SD_MVSDSO44_SD0009 |
| Data Admin - Ship-to KA | BW_WBK_SD_MVSDSO44_SD0002_ADMIN |
Data Admin - Customer
This workbook works directly with Customer's Master-Data, whether or not the customer has sales.
It is possible to control the GBR(*) customer Corporate group, even if the customer still has no sales in SAP. This report works directly with master data and for that reason the GBU can't be used in prompts (GBU defined only when the customer has sales).
Data Admin - Customer Group
This report retrieves all customers' groups (Corporate and GBU), for customers with sales in SAP. It is possible to be refreshed by GBU.
Data Admin - End Use
This report provides data to control the mapping done for 2 axis recorded in GBR(*) and was developed to help the data mapping for the CRM Analytics tool (depending of the GBU’s decision to use it or not).
The axis are:
Tabs in the report:
For the Billing date we suggest to use always 1 year period.
For the END USE mapping always use the Corporate end use TO LINK, to identify easily the customers and products to update in Quikload (GBR).
Data Admin - Material not converted
It’s not possible to convert sales unit into prompted quantity unit (PUQ) when that conversion don't exist in SAP.
After choosing the PUQ the report retrieves all materials that are not converted in that unit.
Tip! To convert most quantities in Tonnes or Kilograms, you can use “VTN” (for tonnes) or “VKG” (for kilogram) in the “Prompt Unit Quantity”
(*)GBR - It is a global data repository for the data mapping done in the Quikload Tool
Data loaded in GBR at day D it will be updated in BW at D+1.