2009 Jan 19 9:58 AM
Hi All,
I have 3 records in the table T2550. The values are as below.
MANDT WWSAL BEZEK
200 001 James
200 002 John
200 123456789012345678 test
If I want to see the first record in the table, if I enter 1 and execute to see it, it is not accepting. It is accepting only when I enter 001 and execute. I thought of using conversion exit for adding leading zeros. But the field WWSAL is having 18 characters. (if we use conversion exit, it will add the leading zeros to the total length, so now the lengthe will become 18 characters hence no results). But in the table it is having only 3 characters length.
Can any one help me, how can I retrieve the data from T2550 table.
Thanks in advance.
Regards
Ramesh .
Hi All,
I have 3 records in the table T2550. The values are as below.
MANDT WWSAL BEZEK
200 001 James
200 002 John
200 123456789012345678 test
If I want to see the first record in the table, if I enter 1 and execute to see it, it is not accepting. It is accepting only when I enter 001 and execute. I thought of using conversion exit for adding leading zeros. But the field WWSAL is having 18 characters. (if we use conversion exit, it will add the leading zeros to the total length, so now the lengthe will become 18 characters hence no results). But in the table it is having only 3 characters length.
Can any one help me, how can I retrieve the data from T2550 table.
Thanks in advance.
Regards
Ramesh .
2009 Jan 19 8:37 PM
2009 Jan 19 8:46 PM
Hi Ramesh,
My suggestion is to use variable of length 3 with data type NUMC. After you enter your value, your CONVERSION exit which will fill your variable with leading zeros. Use this varaible in your select statement to fetch your results.
Regards
Krishna
2009 Jan 19 8:53 PM
Hi Ramesh,
I didn't found this table in R3X or E6Ssystems.You should specify in which you found this standard table?Then only i can give solution.Even i found a table T255, its structure is different from table you mentioned.
by
Prasad GVK