topic Re: Conversion external data type to internal data type in Application Development and Automation Discussions

Conversion external data type to internal data type

Former Member — Wed, 18 Jun 2008 08:51:04 GMT

Hi freinds,

Problem:

I would like to convert the fields in my ITABs with conversion routines such as '==CUNIT', '==ISOLA', '==MATN1' etc from the user external format to SAP internal format.

I have the feelings that my code is too complicated, so I would like to simplify it. My intension is this:

Aim:

ITAB (in ext. format) -->FM or Bapi (converts all neccessary fields with conversion routines) --> ITAB (intern. format)

Does some know a FM or how I can achieve this aim as simple as possible?

Blacky.

Re: Conversion external data type to internal data type

Former Member — Wed, 18 Jun 2008 08:57:54 GMT

Hi,

Are you trying to upload some thing from external flat file in your program.

If yes,then the internal table in which you are trying to upload the data just put the fields of those internal table as standard sap tables field for e.g.

data:begin of itab occurs 0,

matnr type mara-matnr,

...... ..

end of itab.

I hope you got my point.

then use any of the Fm available for upload and pass the internal table to those Fm.

I hope this will help you.

Re: Conversion external data type to internal data type

Former Member — Wed, 18 Jun 2008 09:03:32 GMT

Hi,

First read the records from your flat file.Convert them to the proper format by CONVERSION ROUTINES then pass them to FM /BAPI.After that if you further require them convert them to internal format.

Re: Conversion external data type to internal data type

Former Member — Wed, 18 Jun 2008 09:04:27 GMT

Hi,

First you need to list out the list of fields and their conversion exist, if exist. Assume that your internal table has three field as below for example..

field1 -> no conversion exist

field2 -> has ALPHA conversion

field3 -> has MATN1 conversion

Then write a separate subroutine for each converion exit. I am taking ALPHA as one example.

form z_conversion_exit_cunit changing p_input.

clearL: p_input.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = p_input

IMPORTING

OUTPUT = p_input

endform.

Similarly write for other conversion exits also.

Then loop at the table and call each conversion exits.

loop at itab.

call ALPHA converion routine for itab-field2.

call MATN1 converion routine for itab-field3.

modify itab. "Modify itab

endloop.

After the loop your internal table will have internal format data.

Regards,

Yellappa.

Re: Conversion external data type to internal data type

Former Member — Wed, 18 Jun 2008 09:19:38 GMT

Hi Yellapa,

Thanks for this tip. However this is exactly what I did. I am just thinking there could be a simpler way to do this.

However I will give some points for tghe tip.

My logic was:

- Upload text data into ext_ITAB

- Describe ext_ITAB into desc_ITAB

- loop desc_ITAB

- case routine

- When conversion routine (e.g. '==CUNIT') found

- then loop ext_ITAB

- use FM CONVERSION_EXIT_CUNIT_INPUT

- Modify ITAB

Blacky,

Re: Conversion external data type to internal data type

Former Member — Wed, 21 Sep 2011 21:53:49 GMT

Hi Blacky,

Just wondering, whether did you find any simple way without having to use the loop statement while doing the conversion routine in internal table?

Appreciate if you could share your trick.

Thank you.