ALV Report

[Former Member]

Hi, As per user requirement I have to add two field in existing Alv report. But in that report field catalog is like deferent format I am not getting it,can anyone help me out of this.. as I am getting the value in internal table but now I have to display it on output screen thrugh field catalog. Please find the attachment. Thanks Abhay Manna

[nabheetscn]

Hi Abhay

Is this report genearated through SAP query sQ01/SQ02 etc...? It looks like the same.

Nabheet

[Former Member]

Hi,

I gree with Nabheet!

This is the SAP query, please find the info set and user group to adjust the report from SQ01 transaction.

from that you can adjust the fields for output accordingly.

example screen shot.

[Former Member]

Hi, How to find the infoset and usergroup????as I am new in ABAP.. Thanks Abhay Manna

[Former Member]

Hi,

Query creating and building is the user friendly and not required more technical skills.

Please find the user friendly manual to understand the sap query creation.

You will solve your issues so easily.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10eab7af-0e54-2c10-28a5-87b47adbe...

[Former Member]

Hi I am creating one ALV Report..in that when I am fetching fkimg field from VBRP Table...it is showing quantity with 3 decimal..like 1.000 but I need it with out decimal point..like I want quantity as only 1 not 1.000 how would I convert that from 1.000 to 1. please share your knowledge. Thanks Abhay Manna.

[former_member43585]

Hi Abhay,

Pl. find sample code below:

DATA : menge1 TYPE menge_d.
DATA : menge2 TYPE i.


menge1 = 1.
menge2 = menge1.

ouput :

menge1 = 1.000

menge2 = 1.

Regards,

Ramiz.

[Former Member]

Sorry I did not get your answer..please explain with good example...as I am using field catalog..in alv report...where quantity shuld be 1 but it is showing 1.000...how do I remove decimal..

[Former Member]

H

[Former Member]

Problem Solved!!!

[former_member43585]

Hi Abhay,

By previous code, I meant to say that instead of displaying the quantity field directly, move that quantity to an integer variable (menge2) and then display it in ALV.

E.g menge2 = menge1.

When you move decimal number to integer field its decimal part gets truncated.

As your problem has been solved , please close the thread with solution.

Regards,

Ramiz

[Former Member]

Hi, I have created a ALV Report..every thing is working fine but I am not able do the sum in report for column data..even I am not able to display the summation button in report out put.. how to display the Summation button..and operation of that button... please share ur knowledge.. Thanks , Abhay Manna

[former_member43585]

Hi Abhay,

Can u please provide the field catalog declaration code ?

Also, have you declared a customized GUI status?

Regards,

Ramiz.

[Former Member]

T

[Former Member]

Thanks..problem solved..

[former_member43585]

Hi Abhay,

As your problem has been solved, please close the thread with solution.

Regards,

Ramiz.