Data is not showing using SE16n T-code even though it is available in table

[former_member619564]

Hi All,

I am facing a problem .Please do let me know the solution incase if it is known to any one.

There are some customized z-tables which is present in both production and development environment and for each of those development customized tables, the table structure and data are same to that of the production customized table. Now when I am executing any of those z-tables in development server using SE16n (General Table Display), itu2019s showing all the data for corresponding table But when I am browsing the table with any particular selection criteria say by providing the value (range of values) for any particular field, there are two problems arises.

1.For some tables the error message is coming like u201CNo Values Foundu201D even though the same table is showing data for that particular filtering selection criteria which

has been provided.

2.Moreover for some tables the output is coming which is containing only the table structure with column heading, but no row has been fetched from the table.

Eventually this problem is not happening in production environment. The reasons for this problem and any solution to solve the issue are highly appreciable.

[vinod_vemuru2]

Hi,

Welcome to SCN!!!.

This looks like user setting issue. Does your Ztable fields has conversion exits? You can activate/deactivate conversion exits through below path.

Se16=>menu=>Settings=>User parameters(F6). Here check/uncheck the check box "check conversion exits".

You can execute the Ztable without the selection criteria.Just copy some column data and execute the table again with the copied data.

If above wont work, then egenerate the Se16 program.

enter the table name in SE16. Goto menu=>Settings=>Fields for selection, click enter and try.

Thanks,

Vinod.

[former_member619564]

Dear Vinod,

The solution which you have given is not working. I have checked the conversion exits going through Se16=>menu=>Settings=>User parameters(F6) and "check conversion exits".

When I am executing the entire ztable ,the data are coming and it is also showing the total no. of entries also but when I am executing the same ztable using any particular value for selection criteria (In either of T-codes either SE16 or SE16n) ,The error message is coming like "No Table Entries Found For Specific Key" and When clicking the button "Number of Entries" it is giving the message "Number of entries which meet the selection criteria" ,Even though the record for the same key value exists and

showing the row when executing without any specific key value.This problem is not present for the SAP system tables.Moreover I don't understand the the process to regenerate SE16 Program ,Please provide the step wise solutions for the issue.

Looking forward for your(or anyone from your team member) support regarding the same.

Thanks & Regards,

Anand Prajapati.

[vinod_vemuru2]

Hi,

Regenerating the program is very simple. Just to to SE16 T-code. Enter the table name and click enter. You can see the selection screen. Now follow below path.

Menu=>Settings=>Fields for selection. Here select any unselected field or unselect any selected field and click enter. System will delete the existing program and regenerates the new program.

Usually program name will be /1BCDWB/DB(Z or standard Tablename)

Also can you let me know the data element attributes of the fields for which you are inputting the selection criteria?

Thanks,

Vinod.

[former_member619564]

Hi ,

Please find out the below 9 data elements which is used to build up one ztable.

1.VBELN char 10 0 (Sales and Distribution Document Number) key and initial values checkboxes are checked

2.KUNNR char 10 0 (Customer Number 1)

3.DMBTR curr 13 2 (Amount in Local Currency) field:ZDMBTR

4.DMBTR curr 13 2 (Amount in Local Currency) field:ZDMBTR1

5.ZDATE dats 8 0 (Booked on Date)

6.AUFNR char 12 0 (Order Number)

7.ZADMIN curr 13 2 (Admin Fees)

8.ZOTHER curr 13 2 (Others Amount)

9.ZTEXT char 25 0 (Other Description)

Now the data is coming ,if the selection criteria is given for some data elements but not for values provided against the data elements VBELN and KUNNR which are the main field in the table.even the data in last 5 field are zeroes.kindly Reply asap,if possible.

Thanks

Anand.

[Former Member]

Have you tried putting zeroes at the start of Document / Customer Number (to fill them) when selecting?

[former_member619564]

Hi,

yes,I have tried by putting preceeding zeroes with the Cocument Number/Customer Number,then the records are fetched in development server (especially when the data are present in the table with maximum no of length.e;g document Number = 0000123446 /customer Number = 0000001234).But in the production server the records are fetched even for those document Number/customer Number which is less than its max. no. of length and in the development server those data records are not coming. say for document Number = 123 /customer Number = 1234,the row is not coming in the development server whereas incase of production server the row is fetched.Please look into the matter and let me know if the reason is known to you.

Thanks

Anand.

[vinod_vemuru2]

Hi,

I can think of 2 possibilities.

1. Data might be written in wrong way to the database. Please delete the existing recod, recreate and check.

2. Conversion exit. Activate conversion exit as i told earlier and see.

Thanks,

Vinod.