Hi Guys,
I am looking at automating a process in SAP, but I am hoping to get the idea validated before mentioning it to the SAP team.
Process:
We have to pay a royalty for certain SKUs - it is calculated as (50% x revenue) - COS - allocated overhead. We currently download P&L data from BW after month-end to calculate the overhead allocation and the royalty charge, then create an invoice in SAP.
Idea to Automate:
The entire calculation uses master data attributes and follows simple and fixed rules. The calculation is currently performed in VBA in excel. I am wondering if we can create an ABAP code within FICO to produce this calculation. It can be run like how we calculate depreciation on Fixed Assets.
What are your thoughts? Is this a silly idea? I just feel that this calculation is so basic that it is a waste of effort to perform this manually.
Hi
I would suggest to do this calculation in BW report and show you the invoice amount for royalty
Than you can post the invoice in ECC. That would be easier to do, much simpler and cleaner way to do.
Regards
Sanil Bhandari