topic Re: select query on table returned by bapi in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-query-on-table-returned-by-bapi/m-p/6272549#M1386845 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P></BODY></HTML> Tue, 03 Nov 2009 11:34:00 GMT Former Member 2009-11-03T11:34:00Z select query on table returned by bapi https://community.sap.com/t5/application-development-and-automation-discussions/select-query-on-table-returned-by-bapi/m-p/6272547#M1386843 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P> I m facing a problem in using bapi , i m using bapi 'BAPI_GL_GETGLACCPERIODBALANCES' as like this </P><P> CALL FUNCTION 'BAPI_GL_GETGLACCPERIODBALANCES'</P><P> EXPORTING</P><P> companycode = '1000'</P><P> glacct = itab-hkont</P><P> fiscalyear = itab-gjahr</P><P> currencytype = '10'</P><UL><LI level="1" type="ul"><P> IMPORTING</P></LI><LI level="1" type="ul"><P> BALANCE_CARRIED_FORWARD =</P></LI><LI level="1" type="ul"><P> RETURN =</P></LI></UL><P> tables</P><P> account_balances = itab1.</P><P></P><P>it is returning 16 value in itab1 but i just want to pick a single line for e.g bal in period = 4. </P><P>how to go ahead </P><P> kindly suggest</P><P></P><P>thanks </P><P>reagrds </P><P>sarabjit</P></BODY></HTML> Tue, 03 Nov 2009 10:17:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-query-on-table-returned-by-bapi/m-p/6272547#M1386843 Former Member 2009-11-03T10:17:14Z Re: select query on table returned by bapi https://community.sap.com/t5/application-development-and-automation-discussions/select-query-on-table-returned-by-bapi/m-p/6272548#M1386844 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Read the table itab1 with the key fields according to your requirement and delete all other entries from the table if that condtion is not satisied.</P><P></P><P></P><P>Regards,</P><P>Srilatha</P></BODY></HTML> Tue, 03 Nov 2009 10:26:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-query-on-table-returned-by-bapi/m-p/6272548#M1386844 Former Member 2009-11-03T10:26:43Z Re: select query on table returned by bapi https://community.sap.com/t5/application-development-and-automation-discussions/select-query-on-table-returned-by-bapi/m-p/6272549#M1386845 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P></BODY></HTML> Tue, 03 Nov 2009 11:34:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-query-on-table-returned-by-bapi/m-p/6272549#M1386845 Former Member 2009-11-03T11:34:00Z