topic Re: Problem with preceding zeros in Application Development and Automation Discussions

Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 06:49:37 GMT

Hi i have a problem with table entries. I have one table with name 'z*' having fields of vbeln ,date, plant.

when i try to display the records it displays all the vbeln records. In that some of them are having vbeln with preceding

zeros like 0009050750 and some are not having zeros like 9081059. When i try to display 0009050750 it executes and display

that record but when i try to display 9081059 it doesnot execute and it displays "no table entries found for specific key".

Plz give any suggesions on that.

Plz solve my issue

Shiva.

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 08:13:58 GMT

Hi Shiva,

are you using standard domain ?

e.g domain for VBELN is VBELN . In definition tab there ALPHA is maintained in Convers. Routine. This converts internally values with actual length.

e.g 0000000098 can be actly found by passing 98.

Please pass this ALPHA conversion routine in your domain.

Thanks,

Rupali

Re: Problem with preceding zeros

SujeetMishra — Mon, 27 Dec 2010 08:40:39 GMT

Hello Shivang,

Can you look at the function given below:

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

above function you can use in your problem.

Regards,

Sujeet

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 09:11:27 GMT

THANKS but i am using domain of vbeln only but since i did not get any output

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 09:18:25 GMT

Thanks for ur reply but in table only it doesnot display... It iss at table level I can't get output when i try to display without preceding zeros even data is present for that particular vbeln

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 09:28:15 GMT

Hi,

Try this out:

Goto SE14 -> Enter your table name -> choose Edit -> Active and Adjust database.

But I think we should erase database contains before check the alpha conversion routine.

Hope it help.

Thanks,

Thien

Re: Problem with preceding zeros

SujeetMishra — Mon, 27 Dec 2010 09:32:38 GMT

Hello Shivang,

Yes, you are right..at the table level its with all leading zeros.

you can do one thing, the local variables in which you are passing the value of VBELN, make that to type VBELN_VA.

Hope it solve your problem.

Regards,

Sujeet

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 09:39:20 GMT

HI,

Change the code in your custom report from where the Z* is getting populated.

Use conversion routines before updating the table.

Regards

Praveen

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 09:46:26 GMT

Hi Shiva,

go to se16n and enter table name and execute ..

double click on the record row and see the Uncoverted record and converted record.

If they tried to save the record in some time with uncoverted format.

so go to se11-->enter ztable and chcek where used list.

and check while updating the table are they usign the converted format ..

if they try to assign the data will be in unconverted.

instead of assign try to use move command at vbeln field the data will be in converted formated and then insert.

then the table data in proper format.

Prabhudas

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 10:30:12 GMT

thanks praveen reddy

actually here data is present for vbeln in both with zeros and without zeros. But if i try to execute with zeros the data fetched from table but when i try to execute the table without zero vbeln values the data is not fetching. But data is present in table.

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 10:33:58 GMT

No sujeet it is having the converstion routine as same as vbeln_vf.

Re: Problem with preceding zeros

anjan_paul — Mon, 27 Dec 2010 10:42:28 GMT

Hi,

Try to search with LIKE statement instead of = .

Ex.

Select * from ztable into ita where vbeln like '9090810'.

Re: Problem with preceding zeros

Former Member — Mon, 27 Dec 2010 12:28:28 GMT

sorry i am not asking in report i want it in table.

Re: Problem with preceding zeros

anjan_paul — Mon, 27 Dec 2010 13:26:51 GMT

Hi,

Then put ' *9090810' in the selection field. You can find the records.

Re: Problem with preceding zeros

Former Member — Tue, 28 Dec 2010 03:49:45 GMT

can u tell me the way how to convert the table data to normal data...

Plz

Re: Problem with preceding zeros

Former Member — Tue, 28 Dec 2010 04:30:59 GMT

Thanks anjan now its working

Re: Problem with preceding zeros

Former Member — Tue, 28 Dec 2010 05:52:57 GMT

Hi anjun i solved on table level with your reply but i have another problem with report how can i get output in the select statement of report....

I have select-options with vbeln so how can i use '*9782546' here.

So i need to append * to s_vbeln value plz give me the code to solve my issue...

Thanks

Siva

Re: Problem with preceding zeros

Former Member — Tue, 28 Dec 2010 06:08:26 GMT

I got a solution at table level but i did not get solution at report level how can i do this

Re: Problem with preceding zeros

Former Member — Tue, 28 Dec 2010 06:10:28 GMT

hi ,

you can use the same code with vbeln = *99080.. it wil work

SELECT-OPTIONS : s_vbeln FOR vbrk-vbeln OBLIGATORY.

SELECT vbeln

fkart

fktyp

vbtyp

waerk FROM vbrk INTO CORRESPONDING FIELDS OF TABLE it_tab WHERE vbeln IN s_vbeln.

Re: Problem with preceding zeros

Former Member — Tue, 28 Dec 2010 06:18:52 GMT

As you created a Z table, just change your domain as VBELN_VA for VBELN, adjust the data base in SE14, then it will work.