Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

regarding database tables

former_member197425
Active Participant
0 Kudos

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

1 ACCEPTED SOLUTION

varma_narayana
Active Contributor
0 Kudos

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>

6 REPLIES 6

former_member188829
Active Contributor
0 Kudos

Hi,

DD02L Table..Here u will get all database Tables

Former Member
0 Kudos

Hi,

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

Regrds,

Vani.

Former Member
0 Kudos

Hi,

Use DD02L Table.

Regards,

Satish

Former Member

Former Member
0 Kudos

HI

DD02L where you can the list of tables available in SAP

varma_narayana
Active Contributor
0 Kudos

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>