select statement needed

[Former Member]

I am developing a tool in ABAP for that i need some select statements, the main aim of the tool is to filter out custom developed objects ( starting Z , Y or /gh/  etc ).

the tool consists of input field called as

name_space --------------

table name --------

when the customer enters in the field name_space for example Z or Y or /gh/

in table name field he is allowed only to enter objects starting with these names  for example like Zsamtab

                                                                                                                                           /gh/fitab.

                                                                                                                                             Ysd_tab  etc........

that means some restriction based on the field name_space.

can any one suggest me the select statements for this scenario.

Moderator message: please do not post duplicates.

Message was edited by: Thomas Zloch

[Former Member]

Hi

But which kind of selection you need? just to select the table name? if it's so you can use LIKE options

Max

[Former Member]

yes I need to select all table names starting with names that is entered in the field  Name_space.

[Former Member]

Hi,

You need to select from TADIR table where the development class DEVCLASS is the namespace. You will get all the table names or any other elements which you require by passing the program ID and Object ID. The required program ID and object are

Tables: R3TR / TABL

Table Contents: R3TR / TABU

Domain: R3TR / DOMA

Data Element: R3TR / DTEL

Class: R3TR / CLAS

Table Type: R3TR / TTYP

Transaction R3TR / TRAN

Form Object: R3TR / SFPF

Form Interface: R3TR / SFPI

Program: R3TR / PROG

Report: R3TR / REPS

Report Text: R3TR / REPT

Hope that this is useful to you. You can get everything from here. If you want the table fields of the given tables then you can take from DD03L table.

Regards,

Hardik Mehta