topic Re: This is regarding database table??????? in Application Development and Automation Discussions

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

Former Member — Mon, 24 Dec 2007 07:52:46 GMT

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

Re: This is regarding database table???????

Former Member — Mon, 24 Dec 2007 08:31:40 GMT

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.

Re: This is regarding database table???????

Former Member — Mon, 24 Dec 2007 09:46:23 GMT

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.

Re: This is regarding database table???????

Former Member — Mon, 24 Dec 2007 10:36:17 GMT

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.

Re: This is regarding database table???????

Former Member — Mon, 24 Dec 2007 13:43:54 GMT

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

Re: This is regarding database table???????

Former Member — Wed, 26 Dec 2007 05:23:19 GMT

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.

Re: This is regarding database table???????

Former Member — Wed, 26 Dec 2007 09:34:40 GMT

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