<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Query in bdc data transfer for multiple line items FF67 transaction in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/query-in-bdc-data-transfer-for-multiple-line-items-ff67-transaction/m-p/369692#M8204</link>
    <description>&lt;P&gt;Hi all &lt;/P&gt;&lt;P&gt;I have made an bdc using call transaction, i am getting data on first screen ,but when next screen comes , i am getting only single line item data.But when i press back then again enter then next index comes on screen, in this way i get  all data one by one  but i want data once at a time for example multiple line items at a one click.please check below code .&lt;/P&gt;&lt;P&gt;loop at it_ff67 into wa_ff67.&lt;BR /&gt;
 wa_header-bukrs = wa_ff67-bukrs.&lt;BR /&gt;
 wa_header-hbkid = wa_ff67-hbkid.&lt;BR /&gt;
 wa_header-hktid = wa_ff67-hktid.&lt;BR /&gt;
 wa_header-aznum = wa_ff67-aznum.&lt;BR /&gt;
 wa_header-azdat = wa_ff67-azdat.&lt;BR /&gt;
 wa_header-ssald = wa_ff67-ssald.&lt;BR /&gt;
 wa_header-esald = wa_ff67-esald.&lt;BR /&gt;
 wa_header-austg_ds = wa_ff67-austg_ds.&lt;BR /&gt;
 wa_header-budtm = wa_ff67-budtm.&lt;BR /&gt;
 wa_header-vgman = wa_ff67-vgman.&lt;BR /&gt;
 wa_header-kwbtr = wa_ff67-kwbtr.&lt;BR /&gt;
 wa_header-valut = wa_ff67-valut.&lt;BR /&gt;
 wa_header-zuonr = wa_ff67-zuonr.&lt;BR /&gt;
 wa_header-index = wa_ff67-index.&lt;BR /&gt;
&lt;BR /&gt;
 append wa_header to it_header.&lt;BR /&gt;
&lt;BR /&gt;
 endloop.&lt;BR /&gt;
&lt;BR /&gt;
 loop at it_ff67 into wa_ff67.&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-index = wa_ff67-index.&lt;BR /&gt;
 wa_ff67a-vgman = wa_ff67-vgman.&lt;BR /&gt;
 wa_ff67a-valut = wa_ff67-valut.&lt;BR /&gt;
 wa_ff67a-kwbtr = wa_ff67-kwbtr.&lt;BR /&gt;
 wa_ff67a-zuonr = wa_ff67-zuonr .&lt;BR /&gt;
&lt;BR /&gt;
 append wa_ff67a to it_ff67a.&lt;BR /&gt;
&lt;BR /&gt;
endloop.&lt;BR /&gt;&lt;BR /&gt;
 sort it_header by index.&lt;BR /&gt;
&lt;BR /&gt;
 delete adjacent duplicates from it_header comparing index.&lt;BR /&gt;
&lt;BR /&gt;
 loop at it_header into wa_header.&lt;BR /&gt;
&lt;BR /&gt;
 refresh it_bdcdata.&lt;BR /&gt;&lt;BR /&gt;
perform bdc_dynpro using 'SAPMF40K' '0101'.&lt;BR /&gt;
perform bdc_field using 'BDC_CURSOR'&lt;BR /&gt;
 'FEBMKA-AUSTG_DS'.&lt;BR /&gt;
* wa_header-austg_ds.&lt;BR /&gt;
perform bdc_field using 'BDC_OKCODE'&lt;BR /&gt;
 '/00'.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-BUKRS'&lt;BR /&gt;
* record-BUKRS_001&lt;BR /&gt;
 wa_header-bukrs.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-HBKID'&lt;BR /&gt;
* record-HBKID_002.&lt;BR /&gt;
 wa_header-hbkid.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-HKTID'&lt;BR /&gt;
* record-HKTID_003.&lt;BR /&gt;
 wa_header-hktid.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-AZNUM'&lt;BR /&gt;
* record-AZNUM_004.&lt;BR /&gt;
 wa_header-aznum.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-AZDAT'&lt;BR /&gt;
* record-AZDAT_005.&lt;BR /&gt;
 wa_header-azdat.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-SSALD'&lt;BR /&gt;
* record-SSALD_006.&lt;BR /&gt;
 wa_header-ssald.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-ESALD'&lt;BR /&gt;
* record-ESALD_007.&lt;BR /&gt;
 wa_header-esald.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-BUDTM'&lt;BR /&gt;
* record-BUDTM_008.&lt;BR /&gt;
 wa_header-budtm.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-AUSTG_DS'&lt;BR /&gt;
* record-AUSTG_DS_009.&lt;BR /&gt;
 wa_header-austg_ds.&lt;BR /&gt;
perform bdc_dynpro using 'SAPMF40K' '8000'.&lt;BR /&gt;
*&lt;BR /&gt;
data : fnam(20) type c,&lt;BR /&gt;
&lt;BR /&gt;
 idx type c.&lt;BR /&gt;
&lt;BR /&gt;
move 1 to idx.&lt;BR /&gt;
BREAK-POINT.&lt;BR /&gt;
loop at it_ff67a into wa_ff67a where index = wa_header-index.&lt;BR /&gt;&lt;BR /&gt;
&lt;BR /&gt;
concatenate 'febmka-vgman(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;&lt;BR /&gt;
 wa_ff67a-vgman.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;&lt;BR /&gt;
concatenate 'FEBEP-VALUT(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-valut.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;******************************************&lt;BR /&gt;
concatenate 'FEBMKA-KWBTR(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-kwbtr.&lt;BR /&gt;
&lt;BR /&gt;&lt;BR /&gt;
concatenate 'FEBMKK-ZUONR(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-zuonr.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;
*************************************************************&lt;BR /&gt;&lt;BR /&gt;
idx = idx + 1.&lt;BR /&gt;
endloop.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_dynpro using 'SAPMF40K' '8000'.&lt;BR /&gt;
perform bdc_field using 'BDC_CURSOR'&lt;BR /&gt;
 'FEBMKK-ZUONR(09)'.&lt;BR /&gt;
perform bdc_field using 'BDC_OKCODE'&lt;BR /&gt;
 '=SICH'.&lt;BR /&gt;&lt;BR /&gt;
call transaction 'FF67' using it_bdcdata&lt;BR /&gt;
&lt;BR /&gt;
 mode 'A'&lt;BR /&gt;
&lt;BR /&gt;
 update 'S'&lt;BR /&gt;
&lt;BR /&gt;
 messages into it_messtab.&lt;BR /&gt;
&lt;BR /&gt;
 perform fill_message.&lt;BR /&gt;
&lt;BR /&gt;
 refresh it_bdcdata[].&lt;BR /&gt;
&lt;BR /&gt;
endloop.&lt;/P&gt;</description>
    <pubDate>Fri, 10 Feb 2017 13:51:30 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2017-02-10T13:51:30Z</dc:date>
    <item>
      <title>Query in bdc data transfer for multiple line items FF67 transaction</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/query-in-bdc-data-transfer-for-multiple-line-items-ff67-transaction/m-p/369692#M8204</link>
      <description>&lt;P&gt;Hi all &lt;/P&gt;&lt;P&gt;I have made an bdc using call transaction, i am getting data on first screen ,but when next screen comes , i am getting only single line item data.But when i press back then again enter then next index comes on screen, in this way i get  all data one by one  but i want data once at a time for example multiple line items at a one click.please check below code .&lt;/P&gt;&lt;P&gt;loop at it_ff67 into wa_ff67.&lt;BR /&gt;
 wa_header-bukrs = wa_ff67-bukrs.&lt;BR /&gt;
 wa_header-hbkid = wa_ff67-hbkid.&lt;BR /&gt;
 wa_header-hktid = wa_ff67-hktid.&lt;BR /&gt;
 wa_header-aznum = wa_ff67-aznum.&lt;BR /&gt;
 wa_header-azdat = wa_ff67-azdat.&lt;BR /&gt;
 wa_header-ssald = wa_ff67-ssald.&lt;BR /&gt;
 wa_header-esald = wa_ff67-esald.&lt;BR /&gt;
 wa_header-austg_ds = wa_ff67-austg_ds.&lt;BR /&gt;
 wa_header-budtm = wa_ff67-budtm.&lt;BR /&gt;
 wa_header-vgman = wa_ff67-vgman.&lt;BR /&gt;
 wa_header-kwbtr = wa_ff67-kwbtr.&lt;BR /&gt;
 wa_header-valut = wa_ff67-valut.&lt;BR /&gt;
 wa_header-zuonr = wa_ff67-zuonr.&lt;BR /&gt;
 wa_header-index = wa_ff67-index.&lt;BR /&gt;
&lt;BR /&gt;
 append wa_header to it_header.&lt;BR /&gt;
&lt;BR /&gt;
 endloop.&lt;BR /&gt;
&lt;BR /&gt;
 loop at it_ff67 into wa_ff67.&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-index = wa_ff67-index.&lt;BR /&gt;
 wa_ff67a-vgman = wa_ff67-vgman.&lt;BR /&gt;
 wa_ff67a-valut = wa_ff67-valut.&lt;BR /&gt;
 wa_ff67a-kwbtr = wa_ff67-kwbtr.&lt;BR /&gt;
 wa_ff67a-zuonr = wa_ff67-zuonr .&lt;BR /&gt;
&lt;BR /&gt;
 append wa_ff67a to it_ff67a.&lt;BR /&gt;
&lt;BR /&gt;
endloop.&lt;BR /&gt;&lt;BR /&gt;
 sort it_header by index.&lt;BR /&gt;
&lt;BR /&gt;
 delete adjacent duplicates from it_header comparing index.&lt;BR /&gt;
&lt;BR /&gt;
 loop at it_header into wa_header.&lt;BR /&gt;
&lt;BR /&gt;
 refresh it_bdcdata.&lt;BR /&gt;&lt;BR /&gt;
perform bdc_dynpro using 'SAPMF40K' '0101'.&lt;BR /&gt;
perform bdc_field using 'BDC_CURSOR'&lt;BR /&gt;
 'FEBMKA-AUSTG_DS'.&lt;BR /&gt;
* wa_header-austg_ds.&lt;BR /&gt;
perform bdc_field using 'BDC_OKCODE'&lt;BR /&gt;
 '/00'.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-BUKRS'&lt;BR /&gt;
* record-BUKRS_001&lt;BR /&gt;
 wa_header-bukrs.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-HBKID'&lt;BR /&gt;
* record-HBKID_002.&lt;BR /&gt;
 wa_header-hbkid.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-HKTID'&lt;BR /&gt;
* record-HKTID_003.&lt;BR /&gt;
 wa_header-hktid.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-AZNUM'&lt;BR /&gt;
* record-AZNUM_004.&lt;BR /&gt;
 wa_header-aznum.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-AZDAT'&lt;BR /&gt;
* record-AZDAT_005.&lt;BR /&gt;
 wa_header-azdat.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-SSALD'&lt;BR /&gt;
* record-SSALD_006.&lt;BR /&gt;
 wa_header-ssald.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-ESALD'&lt;BR /&gt;
* record-ESALD_007.&lt;BR /&gt;
 wa_header-esald.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-BUDTM'&lt;BR /&gt;
* record-BUDTM_008.&lt;BR /&gt;
 wa_header-budtm.&lt;BR /&gt;
perform bdc_field using 'FEBMKA-AUSTG_DS'&lt;BR /&gt;
* record-AUSTG_DS_009.&lt;BR /&gt;
 wa_header-austg_ds.&lt;BR /&gt;
perform bdc_dynpro using 'SAPMF40K' '8000'.&lt;BR /&gt;
*&lt;BR /&gt;
data : fnam(20) type c,&lt;BR /&gt;
&lt;BR /&gt;
 idx type c.&lt;BR /&gt;
&lt;BR /&gt;
move 1 to idx.&lt;BR /&gt;
BREAK-POINT.&lt;BR /&gt;
loop at it_ff67a into wa_ff67a where index = wa_header-index.&lt;BR /&gt;&lt;BR /&gt;
&lt;BR /&gt;
concatenate 'febmka-vgman(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;&lt;BR /&gt;
 wa_ff67a-vgman.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;&lt;BR /&gt;
concatenate 'FEBEP-VALUT(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-valut.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;******************************************&lt;BR /&gt;
concatenate 'FEBMKA-KWBTR(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-kwbtr.&lt;BR /&gt;
&lt;BR /&gt;&lt;BR /&gt;
concatenate 'FEBMKK-ZUONR(' idx ')' into fnam.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_field using fnam&lt;BR /&gt;
&lt;BR /&gt;
 wa_ff67a-zuonr.&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;
*************************************************************&lt;BR /&gt;&lt;BR /&gt;
idx = idx + 1.&lt;BR /&gt;
endloop.&lt;BR /&gt;
&lt;BR /&gt;
perform bdc_dynpro using 'SAPMF40K' '8000'.&lt;BR /&gt;
perform bdc_field using 'BDC_CURSOR'&lt;BR /&gt;
 'FEBMKK-ZUONR(09)'.&lt;BR /&gt;
perform bdc_field using 'BDC_OKCODE'&lt;BR /&gt;
 '=SICH'.&lt;BR /&gt;&lt;BR /&gt;
call transaction 'FF67' using it_bdcdata&lt;BR /&gt;
&lt;BR /&gt;
 mode 'A'&lt;BR /&gt;
&lt;BR /&gt;
 update 'S'&lt;BR /&gt;
&lt;BR /&gt;
 messages into it_messtab.&lt;BR /&gt;
&lt;BR /&gt;
 perform fill_message.&lt;BR /&gt;
&lt;BR /&gt;
 refresh it_bdcdata[].&lt;BR /&gt;
&lt;BR /&gt;
endloop.&lt;/P&gt;</description>
      <pubDate>Fri, 10 Feb 2017 13:51:30 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/query-in-bdc-data-transfer-for-multiple-line-items-ff67-transaction/m-p/369692#M8204</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2017-02-10T13:51:30Z</dc:date>
    </item>
  </channel>
</rss>

