Retrieve INCLUDES in a database table

[Former Member]

Hi Colleague,

I have a database table that has 2 specific INCLUDES. The customers can use these INCLUDES to create their own database table.

I need to retrieve these INCLUDES and check for valid DB table.

How can i achieve this?

Thanks in advance

BR,

Piyush

[Former Member]

HI,

Select tabname fieldname precfield 
 from dd03l
where tabname = <table name>
and    fieldname = '.INCLUDE'.

Field "PRECFIELD" store the include structure name

Regards

Vinod

[Former Member]

Hi Vinod,

Thank you for your answer.

I tried the select statement which worked but not completely.

The database name can have more than one INLCUDE, i need to check whether the DB table contains exactly 2 specific INCLUDES.

The select only returns 1 INCLUDE .

Any solution for retrieving more than one INCLUDE.

Thanks and Regards,

Piyush

[Former Member]

Hi Piyush,

This will return all the includes in a specified table.. Check for table name "EKPO".

Select tabname fieldname precfield 
 from dd03l
where tabname = 'EKPO'
and    fieldname = '.INCLUDE'

Returned two rows.

TABNAME FIELDNAME PRECFIELD

=============== ========== =========

EKPO .INCLUDE EKPODATA

EKPO .INCLUDE CI_EKPODB

Regards

Vinod

[Former Member]

Thanks Vinod. It was very helpful.