topic Re: ztable issue in Application Development and Automation Discussions

ztable issue

Former Member — Mon, 27 Nov 2006 18:38:24 GMT

Hi all,

I have created a custom field of type numc and length 4.

Iam uploading data from text file to the ztable.

an again i retrieving data from the same table in other program

if its value is 1 its saving in database as 1 its not saving as 0001.

When i go into selection screen of ztable and give 1 as input it says no records found but when i see data without any input i see data 1 .

So i ahve to convert that field using fm CONVERSION_EXIT_ALPHA_INPUT before saving it to ztable so that i would save as 0001.

is there any alternate way for this which can be done at table itself rather than using the fm at program level.

Thanks

Re: ztable issue

Former Member — Mon, 27 Nov 2006 18:43:37 GMT

Then you will have to declare the field as INTEGER, then you don't have to use the conversion function.

NUMC is meant to be numeric character, so it automatically pads with ZEROE's.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: ztable issue

LucianoBentiveg — Mon, 27 Nov 2006 18:44:14 GMT

You need to create a Z Domain with convertion routine ALPHA and use it in a Z Data element, and use that element in your Z table.

Regards.

Re: ztable issue

Former Member — Mon, 27 Nov 2006 19:17:07 GMT

Hi all,

I have added alpha as conversion routine to my domain.

Even then when i upload a value of 1 to the ztable, it stores as 1 lave 3 spaces blank.

when i try to access that record through selection screen of table it says noi record found.

i tried giving 1 and 0001 in my selection in both the cases it failed and says no entries found though i have a record value 1

when i write as select query to retrieve data with value 1 its returnas sy-subrc of 4 or 8

Please let me know

Thanks

Re: ztable issue

Former Member — Mon, 27 Nov 2006 19:24:02 GMT

Hi,

Check if the data type of the field is really a numc field..Go to the domain of the data element..and check if the data type is NUMC.

Thanks,

Naren

Re: ztable issue

Former Member — Mon, 27 Nov 2006 21:39:55 GMT

The data type is numc and length 4.

In addition to that i have given the conversion routine as alpha.

Now iam uploading a value equal to 1 ,

it uploads as 1 followed by 3 spaces ,so when i try to retrieve it witha select query it returns a sy-subrc ne 0.

i guess it should adjust to a value equal to 0001 but its not doing that .

can anyone explain as to what is happening

Thanks

Re: ztable issue

Former Member — Mon, 27 Nov 2006 21:57:55 GMT

Hi,

For NUMC field you don't require conversion routine..Automatically it will have leading zeroes..

I tried a sample code in my system with a numc field..It is automatically adding the zeroes..

Please give me the following information to analyze further..

1) Show the structure of database table of the numc field..

FIELDNAME - ???

DATA ELEMENT - ???

DOMAIN - ??

DATA TYPE - ??

LENGTH - ??

2) Paste code the of how you are uploading to your table..

Thanks,

Naren

Re: ztable issue

Former Member — Mon, 27 Nov 2006 22:02:42 GMT

Hi narendran,

can i know your email id.

i can send you screen shots

Thanks

preeti

Re: ztable issue

Former Member — Mon, 27 Nov 2006 22:04:40 GMT

Hi,

Please send it to narendranm@hotmail.com

Thanks,

Naren

Re: ztable issue

Former Member — Mon, 27 Nov 2006 22:08:54 GMT

Hi initially the internal table has 0000 but when i use the following code

i has a value equal to 1.

split i_file at con_tab

into idat-id.

append idat.

Now the idat-id has a value eq 1

Thanks

Re: ztable issue

Former Member — Mon, 27 Nov 2006 22:11:22 GMT

Hi,

Did you send the screen shots to my email address.

Thanks,

Naren

Re: ztable issue

Former Member — Mon, 27 Nov 2006 22:14:10 GMT

Hi ,yes i did now

Re: ztable issue

Former Member — Mon, 27 Nov 2006 22:35:27 GMT

Hi,

I think you have to call the FM CONVERSION_EXIT_ALPHA_INPUT..

As when you split the string and move it to the NUMC field..It is not putting the zeroes in front of it..

You manually have to insert zeroes...

split i_file at con_tab

into idat-id.

<b> CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = idat-id

IMPORTING

output = idat-id.</b>

append idat.

Now the idat-id has a value eq 0001

Thanks,

Naren

Re: ztable issue

Former Member — Mon, 27 Nov 2006 22:40:18 GMT

Hi,

Check this example..

DATA: BEGIN OF ITAB,

CHAR(4),

NUMC(4) TYPE N,

END OF ITAB.

DATA: STR TYPE STRING.

STR = '12,12'.

SPLIT STR AT ',' INTO ITAB-CHAR ITAB-NUMC.

WRITE: / ' BEFORE '.

WRITE: / ITAB-CHAR.

WRITE: / ITAB-NUMC.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = ITAB-NUMC

IMPORTING

OUTPUT = ITAB-NUMC

WRITE: / ' AFTER '.

WRITE: / ITAB-CHAR.

WRITE: / ITAB-NUMC.

Thanks,

Naren