topic Re: Regarding storing each row value into one variable in Application Development and Automation Discussions

Regarding storing each row value into one variable

former_member242166 — Wed, 22 Aug 2012 09:20:04 GMT

Hi experts,

I have 5 line items for the same billing document ( Table: VBRP, Vbeln is primary key) , I want store each row in different variables, because i want to send that line items to external id. I Know the concepts of mail sending from sap. When i try my concepts the last line item only stored into that variables. I want all line items in different variables. Please Help me.

My code:

parameters : docno type vbrk-vbeln.

select fkimg arktx kzwi1 from vbrp into (fkimg1,arktx1,kzwi11) where vbeln = docno.

t1 = arktx1.

t2 = fkimg1.

t3 = kzwi11.

endselect.

Hints: How can i get the table value in different variables?

Thanks and Regards,

Linganathan.K

Re: Regarding storing each row value into one variable

schneidertho — Wed, 22 Aug 2012 14:48:41 GMT

Hi Linganathan,

I would put the result of the select into an internal table. Then you have one line in the table for each of the line items. Best regards

Thorsten

Re: Regarding storing each row value into one variable

former_member242166 — Thu, 23 Aug 2012 08:26:55 GMT

Hi Thorsten,

Can You explain me somewhat briefly.

Thanks and Regards,

Linganathan.K

Re: Regarding storing each row value into one variable

former_member209818 — Thu, 23 Aug 2012 08:39:32 GMT

HI Linganathan,

Take all the selection data in an internal table.

Then loop to this internal table and keep on concatenating the details which you need and at end of the VBELN, move whereever you need..

Hope this helps

Re: Regarding storing each row value into one variable

former_member242166 — Thu, 23 Aug 2012 08:43:37 GMT

Dear Harshad Bhingarkar, Thanks for your reply.

If possible can you send some sample coding for the same example. I will be very thankful to u.

Thanks,

Linganathan.K

Re: Regarding storing each row value into one variable

schneidertho — Thu, 23 Aug 2012 16:55:07 GMT

Hi Linganathan,

pseudo code looks like this:

select field1, field2, field 3 from... into table itab where...

loop at itab into wa.

send_eMail(wa-field1, wa-field2, wa-field3).

endloop.

But please also spend some time and take a look at the standard documentation for Open SQL and internal tables.

Best regards

Thorsten

Re: Regarding storing each row value into one variable

former_member242166 — Fri, 24 Aug 2012 04:47:38 GMT

Dear Thorsten,

Thanks for your reply,

I know fetching the data from table and also loop,

See: the first row of data from table is fetching using select statement, after 2nd row will fetch, after 3rd. etc..

My query is: for each time i want to move the data into some different variables(like t1,t2,t3, etc ), Can you getting my points?

Thanks and Regards,

Linganathan.K

Re: Regarding storing each row value into one variable

schneidertho — Fri, 24 Aug 2012 20:17:51 GMT

Hi Linganathan,

not sure, if I completely understand what you want to do. Here how you could do it.

But how do you know how many variables do you need? You can see in my example code that I exit the loop after 3 times, because I only have three variables. But can you rely on that?

REPORT zts_fieldsymbols.

DATA: gt_t005 TYPE STANDARD TABLE OF t005,
      gs_t005 TYPE t005.
DATA: gv_land1_01 TYPE land1,
      gv_land1_02 TYPE land1,
      gv_land1_03 TYPE land1.
DATA: gv_counter(2) TYPE n,
      gv_varname(11) TYPE c.

FIELD-SYMBOLS: <gv_land1> TYPE land1.

SELECT * FROM t005 INTO CORRESPONDING FIELDS OF TABLE gt_t005.

LOOP AT gt_t005 INTO gs_t005.
gv_counter = sy-tabix.
IF gv_counter <= 3.
    CONCATENATE 'GV_LAND1_' gv_counter INTO gv_varname.
    ASSIGN (gv_varname) TO <gv_land1>.
    <gv_land1> = gs_t005-land1.
    UNASSIGN <gv_land1>.
ELSE.
    EXIT.
ENDIF.
ENDLOOP.

WRITE: gv_land1_01, space, gv_land1_02, space, gv_land1_03.

Best regards

Thorsten