on 08-05-2013 4:37 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.