topic Re: ABAP QUERY in Application Development and Automation Discussions

ABAP QUERY

Former Member — Mon, 22 Jun 2009 09:37:35 GMT

Hi every one,

This is regarding abap query. Is there any way thru which i can put one extra field in a report which we are creating in abap query means i wana put one more field which should be hardcoded like password field and value should always be user123.

Any help would b of great importance.

Regards

Abhishek Sinha

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 09:46:46 GMT

You can use parameter field and set the default value as as your password.

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 09:52:14 GMT

How can we add parameter field in tcode- sqvi. Can u tell me screens and fields.

Regards

Abhishek Sinha

Idhasoft

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 09:56:46 GMT

Hello Abhi,

You need to go to the infoset of the query and there select the tab EXTRAS.

After that u will find a create a icon .Click on it to cretae a new field.

After creation u will this entry in the Extras list.Double click on it to move to the code .

Pass the default value Password to the created field in this code.

Now u can find this field in the Field group Additional filed.

Go to the query and select it for theoutput display.

Regards,

Najam.

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 10:26:32 GMT

Thanx for reply. Do i need to change the standared query. Because when i m trying to put extra field system is not allowing me to do that. Can u tell me this in more brief.

Regards

Abhishek Sinha

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 10:33:07 GMT

R u modifying the Standard Query?

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 10:38:04 GMT

No, Actually i m functional consultant (PS). I am creating a report thru tcode sqvi. In that report i have selected the which have vendor data. and after joining them i have selected the fields as selection and output. Finally i need one extra field which is nt maintained in SAP . Say Password and the filed value for all the records should be user123. Now if i have done all these things . M i using std infoset or based on my field selection one more infoset would b created. I dont know much about abap query. This is the situation right now. Kindly suggest me wat to do next.

Regards

Abhishek Sinha

Idhasoft

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 10:46:05 GMT

When ever u create a new field from Extras , a new tabel by the name Additional fields is created on the left side of the window. If Additional fields already exists b4 creating the a new field ,then this filed while get attached in this Table.U can check it in ur case.

And Additional fields is automatically availeble in the query.Where u can select it ot display it in the o/p.

Regards,

Najam

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 11:56:22 GMT

Can u tell me in which tcode i can see my inforset. I am trying in sq02 but i cant find any of mine. Is there any tocde to find that.

Regards

Abhishek Sinha

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 14:33:21 GMT

Go to trasaction SQ03.

From Menu Options: Environment --> Query areas.Select Standard area

U r back in the initial screen .Give the User Group name now.

Again go to Environment --> Infoset .Now give ur infoset name in the screen .

regards,

Najam

Re: ABAP QUERY

Former Member — Mon, 22 Jun 2009 15:40:39 GMT

Hi Abhishek,

You have created an Infoset query using SQVI. There is no option in this type of Infoset query to add / modify / code.

You have a lot of process to follow.

You will need to convert this SQVI query to an Infoset Query.

For this you would need to

1. Go to Tcode SQ01.

2. In the top menu bar select Environment > query areas > select standard area

3. In the top menu bar select Query > Convert Quick View > "enter name of the quick view that you have created" if it is not already selected.

4. Enter any Name of the query and infoset you prefer

5. Continue. Your quick view will be converted to Infoset query.

Tell me once you hve reached this far. Afterwards i will give you the next set of steps.

Regards,

Subin John