topic Re: regarding database tables in Application Development and Automation Discussions

regarding database tables

former_member197425 — Wed, 21 Nov 2007 11:45:53 GMT

hi,

can anyone please tell me how to get list of all database tables in sap.

and also how to get an output of a report which has every field delimited by # at the end

former_member188829 — Wed, 21 Nov 2007 11:48:41 GMT

Hi,

DD02L Table..Here u will get all database Tables

Former Member — Wed, 21 Nov 2007 11:48:44 GMT

Hi,

se11---> table dd02l has all sap tables available.

Regrds,

Vani.

Former Member — Wed, 21 Nov 2007 11:49:25 GMT

Hi,

Use DD02L Table.

Regards,

Satish

Former Member — Wed, 21 Nov 2007 11:51:41 GMT

Former Member — Wed, 21 Nov 2007 11:54:29 GMT

DD02L where you can the list of tables available in SAP

varma_narayana — Wed, 21 Nov 2007 11:58:09 GMT

Hi..

1. Database tables are stored in table DD02L . Check it in SE11.

2. To process the fields with a Delimiter '#'. use the Split statement.

Eg:

DATA: V_RECORD(20) TYPE C VALUE 'ABC#123#USA'.

SPLIT V_RECORD AT '#' INTO V_NAME V_ID V_COUNTRY.

<b>Reward if Helpful.</b>