Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Can we modify a query to add negative sign '-' in one field ?

vimal
Active Participant

‎09-23-2011 8:58 AM

0 Kudos

Hi All,

I have created a query from SQVI by linking VBRK and VBRP. I know we cannot delete tables from the query but can we add a negative sign to all the quantities when the type is 'RE' in query ?

Thanks,

Vimal

4 REPLIES 4

Former Member

‎09-23-2011 9:07 AM

0 Kudos

Hi,

You can write the code in start of selection(in SQ02 TCODE) to make the quantity as negative if the type is 'RE'

vimal
Active Participant
In response to Former Member

‎09-23-2011 10:00 AM

0 Kudos

Hi Priya,

I can not modify the query in code as it asks for the access key.

Thanks,

VIMAL

SuhaSaha
Advisor
Advisor
In response to Former Member

‎09-23-2011 11:06 AM

0 Kudos

Hello Vimal,

You need to create an Infoset & define your custom coding for that particular field!

BR,

Suhas

daniel_cunha1
Participant
In response to Former Member

‎02-15-2024 10:35 AM

0 Kudos

Hi,

How can I negative field for a document type in SQVI?

Best Regards,

Daniel