Select corresponding text table field

[Former Member]

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

[former_member196213]

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

[Former Member]

Your answer really helps! THX!