topic Re: Get data from temp table in Application Development and Automation Discussions

Get data from temp table

aneel_munawar — Mon, 19 May 2014 06:30:57 GMT

Dear All ABAP Exeprts,

I have written a query but it gives error on

t_vbak-KNUMV as KNUMV line

I want to get KNUMV from the t_vbak table. How can I write this query.?

Regards,

Aneel

SELECT vbeln " Sales Document

posnr " Sales Document Item

matnr " Material Number

arktx " Short text for sales order

" item

kwmeng " Cumulative Order Quantity

vrkme " Sales unit

t_vbak-KNUMV as KNUMV

FROM vbap

INTO TABLE t_vbap

FOR ALL ENTRIES IN t_vbak

WHERE vbeln EQ t_vbak-vbeln.

Re: Get data from temp table

philipdavy — Mon, 19 May 2014 06:40:07 GMT

Hi Aneel,

You may have to do it in two steps.
I guess your T_VBAK internal table is already filled.
Now you are going to join this internal table with the values of database table VBAP comparing the VBELN.

Pseudo Code.

SELECT * from vbak where ""some condition

SELECT

vbeln " Sales Document

posnr " Sales Document Item

matnr " Material Number

arktx " Short text for sales order

" item

kwmeng " Cumulative Order Quantity

vrkme

FROM vbap

INTO TABLE t_vbap

FOR ALL ENTRIES IN t_vbak

WHERE vbeln EQ t_vbak-vbeln.

LOOP AT IT_VBAP ITO WA_VBAP.

READ TABLE IT_VBAK INTO WA_VBAK WHERE VBELN = WA_VBELN.

WA_FINAL-KNUMV = WA_VBAK-KNUMV.

******

some codes

append wa_final to it_final.

*******

ENDLOOP.

Regards,

Philip.

Re: Get data from temp table

RaymondGiuseppi — Mon, 19 May 2014 13:29:48 GMT

Not possible in a single SELECT statement, every field of the result must come from the database : single columns and aggregates. So execute your SELECT and then merge the two internal table into a final table.

You could (should) also consider building a JOIN with the first SELECT which built T_VBAK, as a single JOIN between VBAK and VBAK should give (much) better performance in a single SELECT statement.

Regards,

Raymond

Re: Get data from temp table

sriharsha_parayatham — Tue, 20 May 2014 11:23:35 GMT

Do join instead of for all entries ,