topic Re: Select corresponding text table field in Application Development and Automation Discussions

Select corresponding text table field

Former Member — Tue, 11 Dec 2012 03:37:41 GMT

Hi,

I wanna select the corresponding text table field according to the known infotype, subtype, fieldname and text table dynamically. For instance, for infotype 0008, field 'TRFGB'(pay scale area), I want to select 'TGBTX' dynamically in its corresponding text table T510G. How can I implement this dynamically using SQL statement or other ways? Coz usually the first non-key field is the corresponding text field. But I don't know the position of this field in the table.

Many thanks!

Nick

Re: Select corresponding text table field

Former Member — Tue, 11 Dec 2012 04:29:05 GMT

Hey Nick,

I dont remember the table name exactly might e DD03m/TADIR/DD03L or something. Most probably dd03l.

You can get the position of field at runtime using this table.

So in your example

Select * from dd03l into table it_dd03l where tabname = 'PA0008'.

Now We have got all the field names, their type(DE) and their position in it_dd03l. We can use this to position.

I Hope it helped.

Happy ABAPing

Re: Select corresponding text table field

Former Member — Tue, 11 Dec 2012 04:57:17 GMT

Your answer really helps! THX!