Calculating CO Line amount

Gehan Perera

Hello everyone,

Has anyone worked on calculating the customer order (CO) line amount using data from the OOLINE table?

I'm trying to build a solution that accurately calculates line-level amounts, factoring in discounts, alternate sales quantities, and alternate sales prices (e.g., in tons or other units).

Any insights, examples, or suggestions would be greatly appreciated.

Thanks in advance!

Note: I understand OBLNAM and OBLNA2 fields are working differently and no use in calculating the above requirement.

JuanSz

Hi Gehan, 

had in the past also a couple times requirements to calculate "own" line amounts. So I am not gonna tell you that doing own calculations might not be best practice. Some take-aways:
- OOLINE might not be enough; other tables might be needed to consult f.e. to get charge details
- Discounts in % are in DIPx fields and of type amount are in DIAx.
- If you use APIs you might want to use a MDBREADMI (or CMS100MI) to have all fields nicely there
- There was/is something goofy with cost per unit field but it is cost amount
- Be aware of rounding differences; specifically when working with a mix of alternative UoMs of type weight
- Understand business process and M3; have full set of test scenarios; these solutions tend to be specific implementation driven. Process changes or unknown exceptions can cause wrong calculations and trouble. So be as complete and generic as possible. Business statements: "price quantity is always 1" so no need to get field from M3 should be ignored. Because it is 1 until the day it is not!