topic Re: Loop through header and item internal table in Application Development and Automation Discussions

Loop through header and item internal table

Former Member — Tue, 07 Aug 2007 16:37:36 GMT

Hi,

My scenario will be like this, i have two internal tables which is populated based on certain conditions, now i have to call one bapi to update values that am going to store values in a tree structure say for eg mat01 is header and mat02 and mat03 are item values.

What is the efficient method to call that bapi one time for header creation and consequte times for item creation respectively.

shall i have to loop thro two internal tables i.e header and item?

suggestions are welcomed from the experts...

Thanks in advance...

Regards,

Babu

Re: Loop through header and item internal table

Former Member — Tue, 07 Aug 2007 16:42:44 GMT

u need to loop first through header item and internally loop through the item level data which would be a efficient way of posting data into SAP.

Re: Loop through header and item internal table

Former Member — Tue, 07 Aug 2007 16:46:50 GMT

HI,

Ensure that you have some relation between header and item..

sort it_vbap by vbeln.

loop at it_vbap.

at new vbeln.

read table it_vbak with key vbeln = it_vbap-vbeln.

endif.

at end of vbeln.

call bapi..

endat.

endloop.

Thanks

mahesh

Re: Loop through header and item internal table

Former Member — Tue, 07 Aug 2007 16:49:18 GMT

Hi Babu

you can do something like that.


loop it_header.
*Call bapi to create header
  loop it_item where field_key = it_header-field_key.
*  Call bapi to create item   
  endloop.
endloop.

The important part is the where sentence in the second loop.

Regards

David N.