topic Is it possible to write an abap code be SAP SQL query.(ECC 6) in Application Development and Automation Discussions

Is it possible to write an abap code be SAP SQL query.(ECC 6)

Former Member — Fri, 08 Feb 2008 08:00:55 GMT

hello guys,

Is it possible to write an abap code be SAP SQL query.

Scenario : table A has a field say f1 of length 10 and table B has a field say s1 of lenght 20. in sap sql i am able to link all the other tables but i am not able to link

table A^{f1 --->Table B}s1. as the length doesnot match. so is it possibel that using abap code I can pick 10 characters from table A field f1 adjust it to 20 characters using abap and map it to field s1 of table B.

Please let me know how to accomplish this if possible.

thanks in advance!!

Re: Is it possible to write an abap code be SAP SQL query.(ECC 6)

josgabriel_martnez — Fri, 08 Feb 2008 08:21:45 GMT

Hello hemaraaja,

For optimal results, the fields should be the same lenght/type. Even, some times the ABAP compiler do not let you use different field type to extract data from db tables to internal tables.

Please, type the code you are trying to use (specifying db tables, internal tables, etc).

Regards,

José Gabriel Martínez.

Re: Is it possible to write an abap code be SAP SQL query.(ECC 6)

Former Member — Fri, 08 Feb 2008 08:27:04 GMT

Thanks for your prompt reply,

Just to clarify i am using SAP SQL Query (sq01 sq02) to generate a list. tables/fields are LIPS-MATNR and AUSP-OBJEK.

Regards,

Sai.

Re: Is it possible to write an abap code be SAP SQL query.(ECC 6)

Former Member — Fri, 08 Feb 2008 08:28:15 GMT

Hello Hemaraaja,

You can easily do so. But you need to keep in mind that while mapping the field of table A to table B the length should be same.

This you can do by just transferring the field from table A say field 1 (10 char) to another variable say Var 1 (20 char)

and then map Var 1 (20 char) to field of table 2 say field 2 (20 char).

Jayant Sahu

Re: Is it possible to write an abap code be SAP SQL query.(ECC 6)

Former Member — Fri, 08 Feb 2008 08:32:25 GMT

Jayant,

thanks for your reply.....

how do i do this using SAP Sql query( tcode :sq01/sq02). can you please explain me in details.

Thanks!

Hem

Re: Is it possible to write an abap code be SAP SQL query.(ECC 6)

Former Member — Mon, 25 Aug 2008 12:32:21 GMT

Herm,

Adding code is done in the infoset.

Please do following:

> Goto SQ02

> Type in the infoset that the basis for your query, <change>

> Press <code> OR <shift><f8>

> Tou'll see 4 tabs: Extras, Selections, Code, Enhancements.

> GoTo tab Code

> Choose the coding section (<f4> gives you an overview)

> Enter the code.

You may set a breakpoint to see what the query in SQ01 will do with it.

Succes!

Frank