topic Select with default value in Application Development and Automation Discussions

Select with default value

Former Member — Wed, 29 Aug 2012 14:47:22 GMT

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

Re: Select with default value

Former Member — Wed, 29 Aug 2012 15:08:56 GMT

Hi eric,

please explain the question in detail?

Re: Select with default value

Former Member — Wed, 29 Aug 2012 15:20:27 GMT

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

Re: Select with default value

yuri_ziryukin — Wed, 29 Aug 2012 15:49:36 GMT

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.

Re: Select with default value

Former Member — Wed, 29 Aug 2012 16:46:16 GMT

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

Re: Select with default value

Former Member — Wed, 29 Aug 2012 20:23:10 GMT

Tks a Lot Yuri,

The solution was use a Loop...

Regards

Eric

Re: Select with default value

yuri_ziryukin — Thu, 30 Aug 2012 11:53:49 GMT

Hello Eric,

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

Yuri

Re: Select with default value

Former Member — Thu, 30 Aug 2012 13:42:59 GMT

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

Regards

Eric