ABAP QUERY

[Former Member]

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

[Former Member]

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

[Former Member]

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

Regards

Abhishek Sinha

Idhasoft

[Former Member]

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.

[Former Member]

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

[Former Member]

R u modifying the Standard Query?

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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