Question:
We want to have 2lis_13_vditm feeding an invoice ODS object and an InfoCube is built upon it.
Depending on the invoice type, we would expect that the Key Figures are reversed. e.g. for invoice type RE (return), the amounts should be subtracted when cumulating.
We have set the "Inverse" flag on the DataSource for all the relevant fields. Would this take care of subtracting when cumulating? Or do we have to inverse in the update rule routine?
If it's done automatically, is it done for all invoice types that are of return nature? Does SAP know this via some config?
We also have some Z invoice types. Would SAP know about these, too? Or do we need to code some logic in the update rules for inversing the figures
Thanks,
Answer:
We didn't use any inverse-flags in the DataSource, but reversed the signs manually in the StartRoutine in the UpdateRules.
Is a little more work to set-up the 1ste time (a lot of copy/paste), but i prefer taking these kind of things in my hands personally, rather then letting SAP do it in a 'black box'..
Answer:
Inversing in Start Routine is probably the best way to do this. I assume that you had unchecked the Inverse Flags on all the InfoObjects in the DataSource.
Also, we are loading first to ODS and then on to InfoCube. We will be doing the Inversion in Start Routine for ODS. InfoCube will be loaded without inversion (to state the obvious)
Please let me know if there are any pitfalls down this road...
Thanks,