Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from hovering_yogi on Aug 26 at 12:35 PM OK then yes I think you need to look at the SD document category on the VBRK entry (VBTYP) and code accordingly for invoices and credits depending on what your billing types in use are assigned to.
Hopefully you aren't using too many but M and P positive and N and O, P, H negative - I'm not sure of anyway to decide on this via a soft coded method as SAP code itself is hard-coded in various places
As you're using SQ01 rather than SQVI then you can create a result field with this logic (perhaps as 1 or -1), and then even a result field that multiplies NETWR and MBSBP by that result field so the user or the query can see the actual values and sum them directly in the report rather than needing to download to Excel and put formulas in there.
Of course it's much easier to write a bespoke report and potentially more efficient but if you don't have the resources to do that then I fully sympathize with your situation (having been there many a time and being forced in to less than perfect solutions as a result)
| | | ---------------Original Message---------------
From: AGJ_Besac
Sent: Tuesday, August 26, 2014 11:01 AM
Subject: SAP Query Invoices Based On VFV - How to Sign Amounts?
Hi,
I made a Query with SQ01, based on logical DB VFV, but the amounts are not signed.
I checked everywhere but didn't find a way to have the sign of each amount, or a code saying + or - or at least, the table giving this information (and the way to join it)
NB: I'm new in SAP Queries, and in addition, I've no authorization to use ABAP code; but if I can extract a code + / - (or D / C) it will be OK.
I already made researches with google, but found "you've to calculate it" ; but how ?
Thanks a lot for all the help you'll provide me... |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
