topic Re: update internal table in Application Development and Automation Discussions

update internal table

Former Member — Thu, 18 Feb 2010 08:28:50 GMT

Hi,

I have an internal table with structure as follows

MANDT

KDMAT

VBELN

POSNR

VBTYP

CHARG

ERDAT

Now I need to fill this table from 2 different database tables:

VBAK: VBELN, VBTYP, ERDAT

VBAP: KDMAT, POSNR, CHARG.

Should I have 2 itabs for VBAK and VBAP. And fill the final itab looping thru VBAK and VBAP itabs?

What would be the best way to do this?

Regards,

Sriram.

Re: update internal table

RaymondGiuseppi — Thu, 18 Feb 2010 08:40:40 GMT

You can use a [SELECT - join|http://help.sap.com/abapdocu_70/en/ABAPSELECT_JOIN.htm], the choice between JOIN or two SELECT (second via [FOR ALL ENTRIES|http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm] or[ WHERE|http://help.sap.com/abapdocu_70/en/ABAPWHERE.htm] option) depends on factor like volume of data and selection criteria.

Regards,

Raymond

Re: update internal table

Former Member — Thu, 18 Feb 2010 10:05:44 GMT

Hi,

You can use Join statement to fetch data from different DB table at once.

Select A_{VBELN A}VBTYP A_{ERDAT B}KDMAT B_{POSNR B}CHARG

into corresponding fields of table itab

from VBAK as A inner join VBAP as B

ON A_{vbeln = B}vbeln

Where <condition>.

Regards,