SQ01 Query Help for (MKPF and MSEG)

[Former Member]

Is their anyway to have the field MSEG-ERFMG show up on the query results as postive or negative color or use a "-" or "+". Need to try and show whether is was a negative or postive movement.

[csaba_szommer · Accepted solution]

F1 help for MSEG-SHKZG

Debit/credit indicator in revaluation
This indicator is used for internal program control.
Please do not change the entry in this field.
Any changes made could lead to program errors or terminations.

I guess the "sign" is defined trough this field ("S" - sollen (debit), "H" - haben (credit)). If my assumption is true, you won't be able to see + / - in MSEG-ERFMG simply because this field contains no information on the sign.

Using ABAP code you can solve it (or in SQ01 you can use calculated field in your query...I'm not sure you can define that calculated field to cover your requirement...).

Regards,

Csaba

Edited by: Csaba Szommer on May 12, 2009 11:20 PM

[Former Member]

you may not be able to get the value appear as anything other than the S or H values, but you can use local fields and simple formulas to do the same.

Turn on external names and give ERFMG a name. Call it "ERFMG" for example

Create a local field and assign it a formula - somthing like:

>=if ERFMG = "S" then "-" ELSE "+"

The formula may not be exact but it should be similar.

Then, output the local field, and not the original ERFMG

[Former Member]

How do you turn on external fields?

[abhijit_sadhu]

Hello,

When you are in SQ01, you can go to the third screen which is a select field screen. Here you can go to Edit --> Short names > switch on/off . & then edit>Local Field--> Create.

This will help you in getting to above proposed solution.

Thanks,