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: 

No of fields in a table

Former Member
0 Kudos

Hi Experts

How to know the no of fields in a table?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

You can use these FMs as well.

DDIF_TABL_GET

DB_GET_TABLE_FIELDS

Aman

6 REPLIES 6

former_member188685
Active Contributor
0 Kudos

use DD02L table and count the number of fields for a table.

former_member15255
Active Participant
0 Kudos

Hello,

I think DD03L table would give u fields and counts of fields in a table

regards

suresh nair

GauthamV
Active Contributor
0 Kudos

hi,

Use these tables.

All sap tables : DD02L.

All fields in table : DD03L.

Former Member
0 Kudos

Hi,

Goto SE84 in the objects tree list select ABAP Dictionary -> Fields -> Table Fields.

Now give the table name and clear the maximum number of hits before executing.

It will list out all the fields with short description.

DD03L does not give you the exact number of fields if you have includes or appends. ( For VBAP total fields is 216 but DD03L has 220 entries)

Regards

Karthik D

Former Member
0 Kudos

You can use these FMs as well.

DDIF_TABL_GET

DB_GET_TABLE_FIELDS

Aman

Former Member
0 Kudos

Hi Ganesh,

Simply call transaction SE11 and display your table. You will see the number of fields on the top under the TABs on the right side.

Good luck,

Heinz