Skip to Content
0
Former Member
Jan 15, 2008 at 10:20 AM

Transport data from R/3 to APO via RFC: Issue with quantity fields

64 Views

Hi all,

I have a problem:

I want to get entries from R/3 tables into APO via RFC. Now the problem is, that I get entries which have the data type "quantity" only as packed information which will be displayed only as "#######" (for example). Now have a look at what the program is doing:

I use a function model in APO which will create an RFC and start a SQL selection in R/3. The output is a table in APO in which contains the selected entries from R/3 but as a large string. That means on R/3 side the table looks like this:

Client ¦ Material ¦ Location ¦ Orderquantity ¦ ...

010 ¦ 004711 ¦ 0001 ¦ 500.000 ¦ ...

The table I could use in APO looks like this:

Field01 ¦

010 004711 0001 ####### ... ¦

You see, that I have a large string with all the information in it. That is no problem, because I could use table "dd03l" to create the structure I need and get all the information I need in the string and move it into the new createt structure except the quantity!

How could I convert the packed quantity in something that I could use to fill the quantity field in APO?

Additional information:

I get all fields from the R/3 table, so I could not select special fields. I could call the RFC by importing a structure and the function modul will compare the fields directly into this structure, but I do not want to create a single structure for everything I need from R/3 (in this example case we talk about the table "PLAF", but I will have to do this again also for table "MARA"). I am doing this all in an ABAP include so, if possible, send me source codes which will fix my problem 😉

Question again... How could I get the entries in quantity fields from R/3 into APO?

Thanks and best regards

Andy

p.s.

Answer in english or german. Spell checker does not work so I hope my question is clear. Otherwise, let me know.