topic Re: Select column with default value in Application Development and Automation Discussions

Select column with default value

Former Member — Tue, 12 Mar 2013 06:18:51 GMT

Hi,

I can write query like this i SQL.

SELECT VBELN, '1' AS Flag FROM VBAK WHERE.......

How can i do this in ABAP?

Re: Select column with default value

adam_krawczyk1 — Tue, 12 Mar 2013 08:39:09 GMT

Hi Sathya,

I doubt if there is a syntax that allows to put default value in column from select statement.

Anyhow you can get same results by few ABAP commands, like example below:

DATA ls_vbak type vbak.
DATA lt_vbak type table of vbak.
ls_vbak-vbtyp = '1'.  " Constant defined
SELECT VBELN FROM VBAK INTO TABLE lt_vbak WHERE ...
MODIFY lt_vbak from ls_vbak transporting vbtyp WHERE vbtyp IS INITIAL.

Regards,

Adam

Re: Select column with default value

Former Member — Tue, 12 Mar 2013 09:16:38 GMT

Hi Satya,

You can write in abap as follows:

SELECT VBELN

from vbak

into table t_vbak

where vbeln eq '1'.

Regards,

Vineesh.

Re: Select column with default value

jascha_meiswinkel — Tue, 12 Mar 2013 09:29:43 GMT

Hi Sathya,

this is not possible by only using the SELECT statement. This is what you can do:

1) Use the approach mentioned by Adam

2) Define a loop after you executed the SELECT which may look like this:

FIELD-SYMBOL <f_s_yourTable> TYPE <yourTable>.

LOOP AT <yourTable> ASSIGNING <f_s_yourTable>.

<f_s_yourTable>-yourStaticField = '1'.

ENDLOOP.

This is very fast and therefore should not lead to any performance issues. This is also discussed here: http://scn.sap.com/thread/3229304

BR, Jascha

Re: Select column with default value

Former Member — Tue, 12 Mar 2013 09:45:36 GMT

Hi Sathya,

You can write the query like that when the case occured as your internal table or work area structure field is different and your dictionary table field is differnt but with the same data type.

please find the delow example code.

TYPES : BEGIN OF TY_MARA,

MAT TYPE MATNR,

END OF TY_MARA.

DATA : WA_MARA TYPE TY_MARA.

SELECT SINGLE MAT AS MATNR

FROM MARA

INTO WA_MARA

WHERE ...................

Thanks

Mani

Re: Select column with default value

vigneshyeram — Tue, 12 Mar 2013 10:44:41 GMT

Dear Satya,

Do you want to fetch from VBAK where VBELN = 1?

OR
After fectching you want change the value of VBELN to 1?
If yes to 2nd question then you can follow or .

Hope it helps you.

Please let me know in case of any issues.

Thanks & Regards,

Vignesh Yeram

Re: Select column with default value

Former Member — Fri, 22 Mar 2013 13:03:34 GMT

Hi Sathya,

I think you are new in SAP ABAP (i think so ) its a basic question any way please refer the below link it explain's how to use the SELECT statement in abap.

http://help.sap.com/erp2005_ehp_04/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/content.htm

Please search in scn before posting (Otherwise Moderator will lock the Discussion ).

Regards

Mahesh .

Re: Select column with default value

guilherme_frisoni — Fri, 22 Mar 2013 13:17:23 GMT

Hi Sathya,

you can do this with ABAP Open SQL.

But you can use the following solution:

Keep FLAG column in our IT_VBAK as the last column.

Do your selection normally, without using this flag.

Right after select, update your IT_VBAK.

wa_vbak-flag = '1'.

modify it_vbak from wa_vbak transporting flg

where flag is initial.

Regards,

Frisoni

Re: Select column with default value

Former Member — Thu, 30 Jun 2016 11:18:43 GMT

This message was moderated.