Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to do calculation before import of data

Hi Experts,

I have a situation here where I need to map accounts to specific BPC accounts and use them in formula at the same time:

Ex. I have accounts Stock Value A and Stock Value B both mapped to account Stock Value, Product A and Product B both mapped to account Product. Then, I have an account Total Net Cost which is Stock Value less Product. Now, I need to break Net Cost into two child Net Cost A and Net Cost B wherein Net Cost A = Stock Value A - Product A and Net Cost B = Stock Value B - Product B. But in my structure I only have:

Stock Value

Product

Net Cost

-


Net Cost A

-


Net Cost B

Of course I could simply create sub-accounts for Stock Value and Product and map the data accordingly to arrive at individual values of Net Cost A and B but I have conflict the Planning side of our application, so I'm thinking if there is a way I could use the conversion file to do the calculation so that before the values for Stock Value and Product are imported, I've already calculated the individual values of Net Cost A and B.

Thanks,

Marvin

Former Member
Not what you were looking for? View more on this topic or Ask a question