Abap Query

[Former Member]

hi

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

[Former Member]

HI,

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

[Former Member]

i am creating it on sq02 !!!

[Former Member]

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,

[Former Member]

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

and where should i add it ?

[Former Member]

Hi,

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

[Former Member]

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????

[Former Member]

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

[Former Member]

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?

[Former Member]

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

[Former Member]

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