Skip to Content
0

Lookup statement in SLT transformation

Mar 02, 2017 at 06:31 AM

49

avatar image

Hi,

I want to write the Lookup Statement in the SLT transformation.

Example : Let's say i want to replicate the MARA table, for which i have added one field called MAKTX(Description of the material) and populated the data for the appended field by refering to the MAKT table.

The following piece of code has been written.

1.Select statement:

2.Want to populate the appended field by writing the read statement in the loop statement.

1.select statement :

I want to extract the MAKTX and MATNR field data and want to load the data to one internal table(itab1). I think these piece of code needs to be written in the START OF BEGINING.

If this is the case, then can we access this table data(itab1) in BEGIN OF RECORD and END OF RECORD.

2. For performance improvement i want to write for all entries in the select statement by referring to the internal table. Here in this case, in which internal table, the result package data will be stored so that i can use that table in the select statement.

Hope you got my question.

Please let me know if needs further clarification.

Many thanks,

Regards,

RaviChandra.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tanka Ravi Chandra Mar 04, 2017 at 02:34 AM
0

Any idea please.

Thanks,

Regards,

RaviChandra.

Share
10 |10000 characters needed characters left characters exceeded