Select with default value

[Former Member]

Hi guys,

      I'm trying to do a Select in a ABAP program, this select has values from SAP tables, but I have to put a default value like in SQL.

In SQL:

     Select 'VALUE' , TableField  from TABLE

But in my ABAP program it doesn't works.

does anyone knows a way to do it?

TKs

Eric Fioraso

[Former Member]

Hi eric,

         please explain the question in detail?

[Former Member]

Hi prasanna,

  SELECT

    LQUA~WERKS

    LGORT

    LQUA~LGNUM

    LQUA~LGTYP

    LQUA~LGPLA

    LAGP~VERIF

    BESTQ

    LQUA~MATNR

    LENUM

    LQUA~CHARG

    MCHA~ZUSTD

    GESME

    MEINS

FROM LQUA INTO MYCUSTOM TABLE

This is my select, so I need to put a static field in this select like below

SELECT

     "DATA"      * Static field but doesn't works in this way

    LQUA~WERKS

    LGORT

    LQUA~LGNUM

    LQUA~LGTYP

    LQUA~LGPLA

    LAGP~VERIF

    BESTQ

    LQUA~MATNR

    LENUM

    LQUA~CHARG

    MCHA~ZUSTD

    GESME

    MEINS

    LQUA~LQNUM

    MEINS

    LQUA~VFDAT

    MCH1~HSDAT

    SOBKZ

    SONUM

FROM LQUA MYCUSTOMTABLE

regards,

Eric

[yuri_ziryukin]

Not sure if this works with SAP Open SQL. Probably not.

What will certainly work is to loop over the result table and set the required field.

loop at mycustomtable assigning <fs_customtable>.

  <fs_customtable>-field1 = 'DATA'.

endloop.

This will be relatively fast.

[Former Member]

Thanks Yuri,

   The main question is this program will be a Job and will be executed every 5 minutes, for about 1000 records. I don't if I'll have performance issues with this approach.

Regards

Eric

[Former Member]

Tks a Lot Yuri,

       The solution was use a Loop...

Regards

Eric

[yuri_ziryukin]

Hello Eric,

don't worry. "Loop assigning" is very fast. For your 1000 records it will take maybe a few milliseconds, not more.

Yuri

[Former Member]

Tks Yuri, In fact it's very fast and I don't have performance issues.

Regards

Eric