Sample code to create a Select ... Into a variable from a custom table?

[Former Member]

We've got a custom table called z1 which contain fields of EBELN, EBELP, and f1. Now we know the field f1 value and we would like to use this f1 value to get EBELN and EBELP values and put these values in two corresponding variables.

We would like to use the following code:

Data: vEBELN string,
  vEBELP string.

Select EBELN EBELP from z1 where f1 = 'xx' INTO vEBELN vEBELP.

We know that the above code doesn't work. Would be appreciated if some ABAP experts here to correct/complete the above code and we will give you reward points!

[b_deterd2]

Your datadeclaration is not correct.

data: lv_ebeln type ebeln.

data: lv_ebelp type ebelp.

[Former Member]

hi,

Check out in this way ..

Data: VEBELN LIKE z1-EBELN,
         VEBELP LIKE z1-EBELP.

Select EBELN EBELP from z1 INTO (vEBELN, vEBELP) where f1 = 'XX' .
endselect.

[Sm1tje]

try this.

Select (EBELN, EBELP) INTO vEBELN vEBELP from z1 where f1 = 'xx' .

Make sure value from f1 is 'xx' and not 'Xx' or 'XX'. Case sensitive.

[former_member194669]

Try this way

Select single EBELN EBELP from z1 
        into vebeln vebelp
        where f1 = 'xx'.

a®

[Former Member]

Data: V_EBELN type EKPO-EBELN,,

V_EBELP type EKPO-EBELP.

Select single EBELN EBELP

from z1

into (V_EBELN , V_EBELP )

where f1 = 'xx'.

Thanks,

Srinivas

[Former Member]

select single kunnr into wa_final-kunnr2 from vbpa where parvw = 'SP' and vbeln = 'wa_vbak-vbeln'.

temp = wa_final-kunnr2

select single name1 into wa_final-name2 from  kna1 where kunnr = temp .

select single land1 into wa_final-land1 from  kna1 where kunnr =  temp .

can i do like this