Application Development and Automation 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: 
Read only

regarding database tables

former_member197425
Active Participant
0 Likes
789

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
Read only

varma_narayana
Active Contributor
0 Likes
768

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
Read only

former_member188829
Active Contributor
0 Likes
768

Hi,

DD02L Table..Here u will get all database Tables

Read only

Former Member
0 Likes
768

Hi,

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

Regrds,

Vani.

Read only

Former Member
0 Likes
768

Hi,

Use DD02L Table.

Regards,

Satish

Read only

Former Member
Read only

Former Member
0 Likes
768

HI

DD02L where you can the list of tables available in SAP

Read only

varma_narayana
Active Contributor
0 Likes
769

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>