topic Re: Abap Query in Application Development and Automation Discussions

Abap Query

Former Member — Sun, 14 Dec 2008 11:31:39 GMT

i am creating an abap query

i am adding filed p0006-rctvc into the infoset this filed is marked with T ( it means it add a text )

this filed is Municipal city code and the text of this code

when i run the abap q i get this 2 columns - the column with the code contain data and the column which contain the code's text is empty

how can i solve it ???????????

elad

Re: Abap Query

Former Member — Sun, 14 Dec 2008 11:40:30 GMT

HI,

You need to populate the text field...by writing the Select query on the field.

Re: Abap Query

Former Member — Sun, 14 Dec 2008 11:42:49 GMT

i am creating it on sq02 !!!

Re: Abap Query

Former Member — Sun, 14 Dec 2008 11:58:26 GMT

HI,

yes the p0006 doosn't have the text field for rctvc. the table T5J63 has the text for RCTVC.

So you need to write the select query to fetch the text from this table and populate the field.

Press Shift+F9 ...then select the Code Tab..

Coding Section - Record Processiing

in below container write the select query to populate the field,

Re: Abap Query

Former Member — Sun, 14 Dec 2008 12:09:15 GMT

r u sure it shiftF9 and not shistF8?????

and where should i add it ?

Re: Abap Query

Former Member — Sun, 14 Dec 2008 12:12:20 GMT

Hi,

Shift+F9 (i.e Application-specific Ehanchement button on the application tool bar)

Re: Abap Query

Former Member — Sun, 14 Dec 2008 12:19:59 GMT

sorry for asking again i cannt find it

i am in sq02 i chose the infoset i want to change i press the 'change' button

i have a line there ' authorization check for data ' and under interface 'IF_QUERY_TAB_ACCESS_AUTHORITY'

where do i add the code????

Re: Abap Query

Former Member — Sun, 14 Dec 2008 12:27:47 GMT

HI,

Refer to this link....read from page 241...it gives you the idea

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

Re: Abap Query

Former Member — Sun, 14 Dec 2008 13:09:03 GMT

when i press double click on the Data Filed 'Municipal city code' at the References section i see that the

text filed is working with Function module: TXID_0006_RCTVC_ITENTIFIER

but it doesnt bring the 'Municipal city code' text

is there any way to fix it?

Re: Abap Query

Former Member — Mon, 15 Dec 2008 07:53:08 GMT

Hi,

At the time of creating this query, Text tab is checked by default. so you need to uncheck it.

Try it.

It will work.

-Maharshi

Re: Abap Query

Former Member — Mon, 15 Dec 2008 09:18:31 GMT

can u please give me more explenation of where to go in the screen of SQ02 ?