This is regarding database table???????

[Former Member]

Hi to all,

Here is a requirement.

there is a table with more than 200 fields.in that some fields are empty.

means the columns are there.but there is no data in that field.

now i want to list out all the fields which are empty.

Is there any procedure to follow to do this????????????

please tell me...

regarding,

swami

[Former Member]

Loop at table and check for the "initial" value.

IF NOT LFA1-NAME1 IS INITIAL

The above statement will tell you whether the field has a value or not for a particular record.

Reward Points if useful.

[Former Member]

Hi,

You can’t know this by program. U needs to see manually.

U can write a program but that will not be a ideal process.

[Former Member]

Hi,

U can check whether any data records r there or not using INITIAL statement,to display all the empty fields u should do it in program.

Example:

if itab is inital.

write:/ ' field name'

endif.

[Former Member]

Hi,

In SE11 go to table contents and in the selection screen include those fileds wich are empty (Using fields for selection options)

then cho0se Multiple options (at the end of every fileds) go to Single values and choose = option and come back and leave the field empty(do not enter any value that means u are selecting records for the fileds whose values are empty)

then execute or choose number of records option then u will get the recoords whose filed values are emptty or initial.

Regards,

Sathishkumar.V

[Former Member]

hi swaminath,

i think u can get the answer for ur query after going through this

select ebeln bukrs aedat ernam from ekko into table itab1 where ebeln in s_ebeln.

*WRITE :itab-ebeln,itab-bukrs,itab-aedat,itab-ernam.

if not itab1[] is initial.

select ebeln ebelp matnr txz01 peinh from ekpo into table itab2 for all entries in itab1 where ebeln = itab1-ebeln.

endif.

reward if found helpful.

[Former Member]

just get the data into excel and find it out..........