sap table which holds the count of fieldname

hi Renu,

the fieldname you'll find in table DD03, however the number of fields in one table is not maintained directly, you have to count:

SELECT COUNT( * )
             FROM dd03l
             WHERE tabname EQ ...

hope this helps

ec

Dear Renu,

If you run transaction se11 and look for the number of fields in e.g. KNA1, you can see in the top right corner the number of fields. This number is being calculated by standard SAP in the following way:

DESCRIBE TABLE df-fld_tb LINES tc0_sec-count.

Therefore, it seems very likely to me that there is no table where the number of fields are maintained (also because you can extend tables with new fields).

Kind regards,

John.

Hi renu,

no table field for this but kernel function call 'DB_RD_NTABHDR' id 'NTABHDR' field x030l will return field count in x030l-FLDCNT.

Regards,

Clemens

DD03L

hi

try this function moudule

RFC_READ_TABLE

just give table name in parameters

it will give fields count

Please give points for good answers

Thanks

Siva Kumar

Use the function module:

'DDIF_FIELDINFO_GET'.Just pass the table name.

In the output, table DFIES_TAB will contain the fields and their description of the table.

Use describe DFIES_TAB to get the total no. of fields.

Note: If you look at the database table from SE11 the field count shown on the right hand top also includes the 'APPEND' and INCLUDE'.

I mean in MARA it may fields as 1/250 but the actual count of fields might be only 230 or so.

250 includes '.APPEND' and '.INCLUDE' if any.