topic Re: Help on SAP Query in Application Development and Automation Discussions

Help on SAP Query

Former Member — Thu, 20 Jul 2006 02:24:05 GMT

Hi friends,

I need to modify the query by removing the field VBAK-VKGRP ( Sales Group) from display and have to include the Sales Group Description (TVGRT-BEZEI) in that place.

I have added TVGRT-BEZEI in my function group, now how to display this in my query ? I am using 4.5B version. can anybody explain me the steps for this ?

Thanks in advance.

Regards,

Joseph

Re: Help on SAP Query

naimesh_patel — Thu, 20 Jul 2006 03:44:47 GMT

Hello,

GO to SQ01 > Ener query name and Change.

Click on to basic list.

If you have graphical painter, just drag and drop the field you want in display.

IF you want to remove the field, simply remove the tick from the field list avaliable in the left panel.

Regards,

Naimesh

Re: Help on SAP Query

Former Member — Thu, 20 Jul 2006 04:21:02 GMT

Hi Raj ,

1.Open query in Change Mode ,

2.Add table TVGRT,

3.check the sytax ,u can join VBAK-VKGRP = TVGRT-VKGRP.

4.Change output Fields ,include TVGRT-BEZEI

5.Save activate .

Regards

Prabhu