SQVI

[Former Member]

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

[Former Member]

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

[Former Member]

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.