Reading Notes maintained in Freight Order

[shasan]

Hi All,

I have a requirement to extract the text maintained in Notes tab of Freight Order and load it into BW.

I tried checking for multiple options and seems there is no direct way of using READ_TEXT Function module to achieve this.

Kindly let me know how should I go ahead with the solution.

[shasan]

Hi All,

Any inputs will be highly appreciated.

[shasan · Accepted solution]

Hi All,

In case someone needs it someday, below are the base tables and join condition to reach to the desired solution.

Note- I was not able to use for all entries while selecting from /bobf/d_txccon because field "text" is of type STRING.

SELECT a~db_key AS dbkeytor,

               b~host_key,

               b~db_key AS dbkeyroot,

               b~text_schema_id,

               a~tor_id,

               a~tor_cat,

               c~parent_key AS parenttxt,

               c~db_key AS dbkeytxt,

               c~text_type,

               c~language_code

               FROM /scmtms/d_torrot AS a

               LEFT OUTER JOIN /bobf/d_txcroot AS b ON a~db_key = b~host_key

               LEFT OUTER JOIN /bobf/d_txctxt AS c ON b~db_key = c~parent_key

                INTO TABLE @DATA(lt_text)

                FOR ALL ENTRIES IN @lt_temp

                WHERE a~db_key = @lt_temp-parent_key.

lt_temp is populated from /bobf/d_torite.

And finally a select on core text table-

SELECT parent_key AS parentcon, text FROM /bobf/d_txccon INTO TABLE @DATA(lt_text2).

[former_member738238 · Accepted solution]

Thanks Shadab. Good information!!