topic Re: 00 before fields in Application Development and Automation Discussions

00 before fields

Former Member — Mon, 18 Dec 2006 08:57:32 GMT

Hallow I doing a program that write to file and I wont one field that bring me a 3 numbers like 456 when he less then 3 numbers bring 0 before like 78 bring 078 or 1 bring 001 how can I do that this is my program

SELECT SINGLE name1

FROM hrp1032

INTO wa_itab-num_mmka

WHERE otype = 'D '

AND objid = wa_itab-objid_course_num

AND subty = '9001'

AND istat = '1'.

CONCATENATE wa_itab-objid_oved_num wa_itab-num_mmka

wa_itab-begda wa_itab-endda

INTO v_tab SEPARATED BY ';'.

TRANSFER v_tab TO file_ser.

Name1 is char 12 and num_mmka is same type.

Regards.

SELECT SINGLE name1

FROM hrp1032

INTO wa_itab-num_mmka

WHERE otype = 'D '

AND objid = wa_itab-objid_course_num

AND subty = '9001'

AND istat = '1'.

CONCATENATE wa_itab-objid_oved_num wa_itab-num_mmka

wa_itab-begda wa_itab-endda

INTO v_tab SEPARATED BY ';'.

TRANSFER v_tab TO file_ser.

Name1 is char 12 and num_mmka is same type.

Regards.

Re: 00 before fields

former_member225631 — Mon, 18 Dec 2006 08:58:55 GMT

use the function module conversion_exit_alpha_input

Re: 00 before fields

former_member225631 — Mon, 18 Dec 2006 09:01:18 GMT

conversion_exit_alpha_input will add '0' before the values ie input format and conversion_exit_alpha_output will removes the leading zeroes ie output format

Re: 00 before fields

Former Member — Mon, 18 Dec 2006 09:02:42 GMT

declare the field as numeric (3).

data : v(3) type n.

or use FM CONVERSION_EXIT_ALPHA_INPUT.

regards

shiba dutta

Re: 00 before fields

amit_khare — Mon, 18 Dec 2006 09:04:48 GMT

Use UNMASK.

UNMASK C2 to C2.

Where C1 is the resultant field.

Regards,

Amit

Re: 00 before fields

anversha_s — Mon, 18 Dec 2006 09:08:49 GMT

hi,

converts any number into a string fill with zeroes

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = wf_version

IMPORTING

output = wf_version.

Example:

input = 123

output = 0000000000000...000000000000123

Rgds

Anver