topic Re: Problem with custom table created in Application Development and Automation Discussions

Problem with custom table created

Former Member — Fri, 11 Jul 2014 11:35:13 GMT

Hi all,

i have created 3 custom tables, and then uploaded data into all these tables one by one, now all of my three tables have data, when i am going to execute

one of the table by passing some key data (which it already holds), then it is not displaying any result , and showing that "No values found".

Please tell me the reason why it is happening. Any help will be appreciated.

P.S. : Please moderator do not delete this post, its not a interview questions.

Re: Problem with custom table created

Former Member — Fri, 11 Jul 2014 11:40:42 GMT

Hi,

First execute without any condition and check the value of key data is correct or not any space or any other value is wrongly update in the key data.

so please check data from table first.

Re: Problem with custom table created

Former Member — Fri, 11 Jul 2014 11:50:31 GMT

Hi Shewta..

I think you should be check in Database utiltiy.

Dictionary Display tables:

Utilites- Database objects-database utility and then click on create button ..

Regards

Niraj

Re: Problem with custom table created

rajkumarnarasimman — Fri, 11 Jul 2014 11:51:30 GMT

Hi Shweta,

Please check the table by giving condition in SE11/SE16 and apply the same condition in Select condition too.

Record is not fetching from the program:

If required, use Conversion Exit before Select condition

"Use Conversion Exit to append Zero before

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = l_cost

IMPORTING

output = l_cost.

Record is not showing in SE11/SE16 Itself

If value available in the table, but when we gave the correct condition in SE11/SE16, system throws error 'No Value Found'.

For the above case, do one thing give *(Star) in the Key before and after value as shown below.

Apply the below Possible Case:

*24 - Zero / Space Issue
24* - Space Issue
*24* - Zero / Space Issue

Click Execute button, if correct record shown, then either space or zero may be an issue.

Regards

Rajkumar Narasimman

Re: Problem with custom table created

Former Member — Fri, 11 Jul 2014 11:58:07 GMT

Hi Shweta,

If you are reading the table values via an ABAP program and your fields are numeric, you might want to use the "conversion_exit_alpha_input" Function module, before you read data from table.

(About this Function module: 'conversion_exit_alpha_input' | SCN)

This will prefix the data with zeroes (as the numeric data is stored in Database tables).

Then use the output variable of this Function module to read the database table.

Let me know if I can provide more details.

Thanks,

Arashdeep.

Re: Problem with custom table created

Former Member — Fri, 11 Jul 2014 11:59:54 GMT

Hi,

What values your are passing , Can U Share,

May to due to upper or Lowercase or Preceding zero.