Problem with custom table created

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[rajkumarnarasimman]

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:

1. *24 - Zero / Space Issue
2. 24* - Space Issue
3. *24* - Zero / Space Issue

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

Regards

Rajkumar Narasimman

[Former Member]

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.

[Former Member]

Hi,

     What values your are passing , Can U Share,

     May to due to upper or Lowercase or Preceding zero.