topic SQVI in Application Development and Automation Discussions

SQVI

Former Member — Tue, 06 Oct 2009 18:17:25 GMT

Created a query via SQVI using logical database KDF. The values in the table GSEG are all positive and has a debit/credit indicator. Need to multiply the credit values by negative one so the total subtracts the credit values. How is this done is SQVI?

Thanks,

Annette

Re: SQVI

Former Member — Tue, 06 Oct 2009 18:19:40 GMT

Kindly use a meaningful subject line and please read the rules of the forum before posting

Re: SQVI

Former Member — Wed, 03 Feb 2010 15:20:22 GMT

The following resolved this issue:

No negative postings is often caused by customization in TCodes

OBY6 and OBA7. F1 Help was long so I didn't want to copy and

paste them here but take a look at it since there are Dependancies

to take into account.

I also checked TCode SE11 for Data Element XNEGP_ACT (Negative Postings

Permitted field in both OBY6 and OBA7) and it is set as Data Type

CHAR with a Length of 1 and I seem to remember reading in one of my

searches that you need Length of 2 in order to display the negative

sign.