topic Retrieve INCLUDES in a database table in Application Development and Automation Discussions

Retrieve INCLUDES in a database table

Former Member — Thu, 15 Apr 2010 07:38:31 GMT

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 — Thu, 15 Apr 2010 08:08:01 GMT

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 — Thu, 15 Apr 2010 09:10:59 GMT

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 — Thu, 15 Apr 2010 09:24:29 GMT

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 — Thu, 15 Apr 2010 09:58:28 GMT

Thanks Vinod. It was very helpful.