topic Re: Select constant from Transp. Table in Application Development and Automation Discussions

Select constant from Transp. Table

Former Member — Tue, 08 Dec 2009 08:26:51 GMT

Hello

I would like to make the following select from Transp. Table :

Select F1 F2 'ABC' AS SOURCE

FROM Transp. Table

F1, F2 - fields of the table , 'ABC' is a char constant , the same for all records of the table

I dont want to run Loop-End loop and populate the constant there.

Re: Select constant from Transp. Table

Former Member — Tue, 08 Dec 2009 08:38:25 GMT

Hi,

Select F1 F2 'ABC' AS SOURCE

FROM Transp. Table

Your saying that ABC is same for all records of the table.So it must be one of the field of the table.

SELECT F1 F2 <your field>

From TABLE

WHERE <your field> = 'ABC'.

Regards,

Subhashini

Re: Select constant from Transp. Table

SuhaSaha — Tue, 08 Dec 2009 09:06:44 GMT

Hello,

You can use MODIFY ... TRANSPORTING statement for this. No need to use LOOP...ENDLOOP.

TYPES:
BEGIN OF ty,
  bukrs TYPE bukrs,
  text  TYPE string,
END OF ty.

DATA:
      itab TYPE STANDARD TABLE OF ty,
      wa   TYPE ty.

SELECT bukrs FROM t001 INTO TABLE itab.
IF sy-subrc = 0.
  wa-text = 'Test Modify'.
  MODIFY itab FROM wa TRANSPORTING text WHERE bukrs IS NOT INITIAL.
ENDIF.

LOOP AT itab INTO wa.
  WRITE : / wa-bukrs, 10 wa-text.
ENDLOOP.

Hope i am clear.

BR,

Suhas

Re: Select constant from Transp. Table

Former Member — Tue, 08 Dec 2009 09:20:33 GMT

thanks

constant ABC isnt a part of the table. Its not a field of the table.

I need it to know where the data was derived from.

Re: Select constant from Transp. Table

SuhaSaha — Tue, 08 Dec 2009 09:26:11 GMT

Hello,

If i understand correctly ABC is an identifier of the data source. You want this identifier to be able to identify from which table the data has come.

I donot think you can do this w/o defining it as a table field.

BR,

Suhas

Re: Select constant from Transp. Table

Former Member — Tue, 08 Dec 2009 09:51:12 GMT

Hi,

I will suggest you to fill the dummy column right after the query through MODIFY statement as descirbed above.

And then if you get more data into the same tab using SELECT.. APPENDING... then again u can fill your dummy column through MODIFY.

Only additional processing time will be the MODIFY statements, and that wont be too much and your purpose will be served of identifying the source too..

Revert if I havent been able to clarify myself.