Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from john.louk on Aug 26 at 2:31 PM Interesting. Not sure about transaction ZSE50. The Z usually indicates a custom transaction. So, I am not sure what it is looking at.
But going through my system in transaction SE11 on the table VBRP, your fields VBRP-NETWR and VBRP-MWSBP should allow for sign. Usually the '+' will not display. But, the '-' should display. At least if editing formats allow it. Now, I do not play with queries.
Is your query just select (logical DB) and displaying the fields?
Cheers
John
| | | ---------------Original Message---------------
From: AGJ_Besac
Sent: Tuesday, August 26, 2014 11:58 AM
Subject: SAP Query Invoices Based On VFV - How to Sign Amounts?
Hi Stephen,
At least at Invoice Item lines level (but same at Header level):
VBRP-NETWR Net value of the billing item in document currency
VBRP-MWSBP Tax amount in document currency
I checked with SAP transaction ZSE50 and saw that my amounts were not signed - that gave my a gap in my results when comparing.
It depends on the 'Billing type' (VBRK-FKART) or maybe 'SD document category' (VBRK-VBTYP).
Here is the list (sorry, it's in French):
Billing type: Sign SD Doc category:
F1 Facture + M Facture
FERR Erreur Sortie Marcha + M Facture
G2 Note de cr?dit - O Avoir
GU Note de cr?dit - O Avoir
L2 Note de d?bit + P Note de D?bit
RE Note cr?dit: Retours - O Avoir
S1 Annulation facture - N Annulation Facture
S2 Annulat. note cr?dit + S Annulation Avoir
SG Ann. Cr?dit + S Annulation Avoir
SL Credit Memo Cancel - N Annulation Facture
SU Annulation facture - N Annulation Facture
SU1 Annulation facture - N Annulation Facture
UT Facture Outillages + P Note de D?bit
UT1 Fact. Outillages (2) + M Facture
But we have 104 billing types... I've found those 14 currently used in our company.
I don't know how many Categories exist.
Thanks a lot for your help...
Agn?s |
| 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.   _.____.__ |
