Conditions in SQVI for amount depending upon the Debitcredit Indicator

[Former Member]

Hello ABAP's

I am new to this forum & learning. I am using SQVI for getting Information from Table BSEG. The data is getting extracted but I am unable to give any conditions for amount depending upon the Debitcredit Indicator. If it is "H" ie. Credit the Amount should change colour and if it is "S" it should be as it is.Just like in tcode MB51 when we get negative amount the Line is dispalyed in Pink and in case of Positive in Green.

Looking forward to your help.

With regards

Sandy

[Former Member]

I multiplied my quantity fields with -1 for the H indicator in the inforecord query.

So i could make out which one is debit and which one is credit.

[Former Member]

R/Sir,

Request to give me the Step by step explanation of How to Do it in SQVI.

[Former Member]

R/Sir,

Request to give me the Step by step explanation of How to Do it in SQVI.

[Former Member]

R/Sir,

Request to give step by step explanation of how to do it in SQVI. I expect a codefor that.

Thanks

[former_member215917]

Hi Sandesh,

You can not manipulate data in SQVI. For that you can write a query in infostructures transaction SQ01/02/03.

1. Go in SQ02, create an infoset and assign it to user-group available.

2. Inside infoset, declare table BSEG and click on button 'Extras'. here, you can write your code to multply by '-1' to a field depending upon some condition. Select 'Code' tab and code section as 'Record Processing'. Write code in window displayed.

3. In SQ01, select infoset you just created and select the query.

Execute the same and you will get required output.

Let me know if it helps.

Gouri.

[Former Member]

R/ Abapers,

With respect to my querry on SQVI, we have not enabled the cross clients queery, hence I can not use sq01/02. Ms. gauri thanks for the suggestion. Request to help as I am novice in this field.

Any other alternative?

Regards.

[former_member215917]

Hi Sandesh,

In SQVI, you can change color for complete column as a whole. In ECC 6.0, there are two modes in which you can view the query - layout and basis. If you select layout mode and keep all tools on, you will find some tools like - Trash can, Sort fields, totalling fields, tool box. Using this, you can modify output format a bit as in you can decide view for table or add colors for selected columns or add row for sum of values of selected fields as last row in output.I dont think you can modify based on some perticular value inside a field, but, if query is just for analysis, then this might serve your purpose.

Gouri.

[faisal_khan]

Hi,

How exactly can we sum rows and show as output in sqvi?

Best Regards

Faisal

[Clemenss]

Hi,

please do not post follow-up-questions.

Regards,

Clemens