SAP QUERY

[Former Member]

HELLO EXPERTS,

1. I HAVE CREATED USER GROUP.

2. I HAVE CREATED INFOSET.

3. I HAVE CREATED QUERY.

AFTER THAT I WANT TO GENERATE A REPORT PROGRAM...

SO I USE QUERY->MORE FUNCTIONS->GENERATE PROGRAM...

the program name like AQA0PE==========Z_XKDKD====== IS GENERATED

in this case Z_XKDKD is the query name then you goto sq01 open the query.....

NOW HOW CAN I USE THIS PROGRAM .... WAT CAN I ALL DO IN IT......

GIVE ME THE STEPS AND USES OF IT ......

<b>

2ND PROBLEM IS .....</b>

WHEN I EXECUTE THE QUERY BY USING TEST BUTTON AND SELECTING OUTPUT OPTION AS ABAP LIST THE SELECTED FIELDS GET DISPLAYED ......

BUT FOR THOSE FIELDS WHO DOES NOT HAVE VALUE FOR ANY PARTICULAR RECORD BLANK LINE IS PRINTED INN LIST DISPLAY

E.G:

FLIGHT CODE

CONNNID

AIRLINE URL

AA

0017

WWW.ABC.COM

AB

0064

-

---

AC

0909

WWW.JHJ.COM

HERE IN SECOND RECORD THERE IS NO VALUE PRESENT IN THE DATABASE FOR URL OF FLIGHT CODE AB.. SO BLANK LINE GETS PRINTED .....

... I WANT TO REMOVE THAT LINE ...

HOW CAN I DO THIS ,.... PLEASE HELP......

[Former Member]

Hi,

Just Create the Tcode in SE93 for the program you generated thru tcode.

You can execute the tcode directly.

Reward points if it is helpful.

Regards,

Sangeetha.a