topic Re: ALV Report in Application Development and Automation Discussions

ALV Report

Former Member — Tue, 10 Dec 2013 06:13:18 GMT

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

Re: ALV Report

nabheetscn — Tue, 10 Dec 2013 06:20:01 GMT

Hi Abhay

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

Nabheet

Re: ALV Report

Former Member — Tue, 10 Dec 2013 06:27:09 GMT

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.

Re: ALV Report

Former Member — Tue, 10 Dec 2013 07:21:52 GMT

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

Re: ALV Report

Former Member — Tue, 10 Dec 2013 07:31:02 GMT

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-87b47adbe1a5?quicklink=index&overridelayout=true

Re: ALV Report

Former Member — Wed, 18 Dec 2013 12:08:14 GMT

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.

Re: ALV Report

former_member43585 — Wed, 18 Dec 2013 12:17:34 GMT

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.

Re: ALV Report

Former Member — Wed, 18 Dec 2013 13:09:15 GMT

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..

Re: ALV Report

Former Member — Wed, 18 Dec 2013 13:55:58 GMT

Re: ALV Report

Former Member — Wed, 18 Dec 2013 13:56:34 GMT

Problem Solved!!!

Re: ALV Report

former_member43585 — Thu, 19 Dec 2013 04:18:34 GMT

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

Re: ALV Report

Former Member — Thu, 19 Dec 2013 06:49:27 GMT

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

Re: ALV Report

former_member43585 — Sat, 21 Dec 2013 06:51:27 GMT

Hi Abhay,

Can u please provide the field catalog declaration code ?

Also, have you declared a customized GUI status?

Regards,

Ramiz.

Re: ALV Report

Former Member — Mon, 23 Dec 2013 12:01:47 GMT

Re: ALV Report

Former Member — Mon, 23 Dec 2013 12:02:26 GMT

Thanks..problem solved..

Re: ALV Report

former_member43585 — Mon, 23 Dec 2013 12:26:35 GMT

Hi Abhay,

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

Regards,

Ramiz.