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

[vimal]

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

[Former Member]

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]

Hi Priya,

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

Thanks,

VIMAL

[SuhaSaha]

Hello Vimal,

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

BR,

Suhas

[daniel_cunha1]

Hi,

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

Best Regards,

Daniel