cancel
Showing results for 
Search instead for 
Did you mean: 

billing document value

Former Member
0 Kudos

Dear sd experts

I have one requirement may be i am i am thing i can achieve this by doing transaction variant only

ex i have created so many billing documents now my clinte wants to see which invoice documents  value is more than 35000 rs

any Alternative method is there in sap

Thanks a lot

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

this can be acheived directly by looking at the table level for VBRK - NETWR > 35,000 ( provided all the documents where of doc. currency INR).

if the documents belong to different currency, you can do an SQVI query of Fields that will include VBRK - NETWR, + table TCURR of type exchange rate type P ( field name KURST) & read field Exchange rate (field name - UKURS) with the appropriate Valid from & from the downloaded excel file you can do the appropriate filter & proceed.

Regards

Ilango

Answers (0)