Co$ta - Non ERP - upload data
>> Back to the Co$ta project home page
Prepare files to be uploaded
Prepare the data to be uploaded in WBP using the dedicated template:
Click here to see the description of each template
For Cost centers master data: TEMPLATE Cost Center Master Data
For Cost elements master data: TEMPLATE Cost Element Master Data
For Costs: TEMPLATE ZCBS_BW
Transaction ZBW_CBS
Open the SAP Logon 
and double click "BW - Production - WBP"
Enter the transaction code ZBW_CBS in the search bar and click 
A new window will open with the following fields
- Source = Always ZCYT
- Click
to display the list of cost centers with the master data that were already loaded in BW or click 
to display the list of cost centers with the master data that were already loaded in BW. - Click
to export in excel the list of cost centers and 
to export in excel the list of cost elements. - Select the type of data to be loaded (costs or master data)
- Select the file to be loaded
- Click
to preview the file that was loaded - Click
to check if there are errors in the file - Click
to load the file once all errors are solved - Click
to see last files uploaded - Click
to leave the transaction
Upload the file
- Select the file to be uploaded. For instance "Cost Center Master data"
- Choose the excel file "Cost Center Master data" that was prepared
- Click . If the file was well prepared, the message "Congratulations ! Your file is OK and ready to be loaded in BW." is displayed.
- If there was an error in the file. the message " X errors in your file. Please correct it." is displayed. The list of errors are displayed with the description of the problem to be solved.
- When the file is ready to be loaded, click
. Once it is done a message is displayed to inform that the file was sent to BW and will be available in the reporting at the next data loading.
Appendix : description of each template
| Field | Definition | Description | Link to documentation | Example  |
|---|---|---|---|---|
| co_area | Controlling Area | The controlling Area is always:
| ZCYT | |
| fiscvarnt | Fiscal variant | The fiscal variant is always K4 | K4 | |
| fiscper | Fiscal period | Enter the fiscal period with the right format = YYYYMM (YYYY = year & MM = month) | 2020008 | |
| curtype | Currency type | The currency type is always 10 | 10 | |
| /bic/c_costctr | Cost center | Enter a cost center that was previously created in the system using the TEMPLATE Cost Center Master Data | 651-5702 | |
| costelmnt | Cost element | Enter a cost element that was previously created in the system using the TEMPLATE Cost Element Master Data | 6550 | |
| logsys | Non ERP source | Use the non-ERP source corresponding to your GBU / scope:
| NERPCYT | |
| /bic/c_compcde | Company code | Enter the company code | 7180 | |
| db_cr_ind | Debit or credit | By default enter S | S | |
| vtype | Value type | Enter the value type = 10 (=Actual data) | 10 | |
| currency | Currency | Enter the currency | USD | |
| SubPackage | Sub package | Enter the subpackage | List of subpackages | P20001 |
| amount | Amount | Enter the amount | 5 744,92 |
when the cell is red, the value doesn't change, when the cell is green, it has to be updated
| Field | Definition | Description | Link to documentation | Example |
|---|---|---|---|---|
| BAre | Controlling Area | The controlling Area is always:
| ZCYT | |
| CCenter | Cost center | Code of the cost center | 3008-5326 | |
| System | Non ERP source | Use the non-ERP source corresponding to your GBU / scope:
| NERPCYT | |
| Hierarchy | 1st level of the ZCBS hierarchy | Enter the 1st level of the ZCBS hierarchy | ZCBS | |
| Organisation | 2nd level of the ZCBS hierarchy | Enter the 2nd level of the ZCBS hierarchy | ZCBS-FUNCT | |
| Function | 3rd level of the ZCBS hierarchy | Enter the 3rd level of the ZCBS hierarchy | ZCBS-FPUR | |
| Sub-function Grouping | 4th level of the ZCBS hierarchy | Enter the 4th level of the ZCBS hierarchy | ZFPURBUY | |
| Sub-function | 5th level of the ZCBS hierarchy | Enter the 5th level of the ZCBS hierarchy | ZFPUREU | |
| Comp | Company code | Enter the company code | 7771 | |
| Dateto | Validity date | Enter the validity date (from - to) of the cost center with the right format = YYYYMM (YYYY = year, MM = month) | 99991231 | |
| Datefrom | 20170101 | |||
| Profitctr | Profit center | Leave it blank if you don't know the profit center | ||
| L | Language | Enter EN for english | EN | |
| Short description | Short description | Short description of the cost center | PF-Z-EU-TE | |
| Medium description | Medium description | Medium description of the cost center | PF-Z-EU-TE | |
| BFC Global Business | Global Business Unit | Enter the BFC code of the GBU who owns the cost center | Rules - Business structure | PA |
| BFC Group of activit | Group of Activities | Enter the BFC code of the Group of Activities of the cost center. You can leave it blank. | PADIP | |
| Plant | Plant | Enter the plant code of the cost center | CB00 |
when the cell is red, the value doesn't change, when the cell is green, it has to be updated
| Field | Definition | Description | Link to documentation | Example |
|---|---|---|---|---|
| BAre | Controlling Area | The controlling Area is:
| ZCYT | |
| Cost Elemn | Cost element | Code of the cost element | 6800 | |
| CE | Cost element category | Enter 01 for primary cost element | 01 | |
| System | Non ERP source system | Use the non-ERP source corresponding to your GBU / scope:
| NERPCYT | |
| FX Group 1 | ZRCS-FC hierarchy | 2nd level of the cost element hierarchy ZRCS-FC | Rules - Cost element Group ZRCS-FC | ZRCS-AC |
| FX Group 2 | ZRCS-FC hierarchy | 3rd level of the cost element hierarchy ZRCS-FC | ZRCS-30 | |
| FX Group 3 | ZRCS-FC hierarchy | 4th level of the cost element hierarchy ZRCS-FC | ZRCS-3020 | |
| FX Group 4 | ZRCS-FC hierarchy | 5th level of the cost element hierarchy ZRCS-FC | ZRCS-3021 | |
| Dateto | Validity date | Enter the validity date (from - to) of the cost center with the right format = YYYYMM (YYYY = year, MM = month) | 99991231 | |
| Datefrom | 20170101 | |||
| L | Language key | Enter EN for english | EN | |
| Short description | Short description | Short description of the cost center | INTEREST INCOME | |
| Medium description | Medium description | Medium description of the cost center | INTEREST INCOME |
when the cell is red, the value doesn't change, when the cell is green, it has to be updated