topic select statement needed in Application Development and Automation Discussions

select statement needed

Former Member — Wed, 17 Oct 2012 15:34:04 GMT

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

Re: select statement needed

Former Member — Wed, 17 Oct 2012 15:43:39 GMT

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

Max

Re: select statement needed

Former Member — Wed, 17 Oct 2012 15:56:06 GMT

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

Re: select statement needed

Former Member — Wed, 17 Oct 2012 16:11:36 GMT

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