topic GET statement in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/get-statement/m-p/3313424#M793622 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question about the restriction after GET TABLE statement. Please help</P><P></P><P>I use <STRONG>GET</STRONG> statement to get the data from a database table bsid.</P><P></P><P>In the table bsid.</P><P>kunnr zuonr belnr xblnr</P><P>aaa space 10291 21986</P><P>aaa space 23321 97165</P><P>aaa Q1 36353 38363</P><P>bbb t2 38763 373662</P><P>bbb t2 286648 264829</P><P> </P><P>1, when the zuonr is initial, the records belongs to kunnr (aaa)include the following should be deleted.</P><P>kunnr zuonr belnr xblnr</P><P>aaa space 10291 21986</P><P>aaa space 23321 97165</P><P>aaa Q1 36353 38363 <STRONG>(even zuonr=Q1, the other records which belong to the same aaa have initial zuonr, this should be deleted too)</STRONG></P><P></P><P>2, Only the bbb which zuonr has value can be seleted.</P><P></P><P><STRONG>Question</STRONG>:</P><P>How to write the coding after <STRONG>GET bsid</STRONG> to restrit the condition?</P><P></P><P>Please help!</P><P>Thank you!</P></BODY></HTML> Mon, 21 Jan 2008 15:19:30 GMT Former Member 2008-01-21T15:19:30Z GET statement https://community.sap.com/t5/application-development-and-automation-discussions/get-statement/m-p/3313424#M793622 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question about the restriction after GET TABLE statement. Please help</P><P></P><P>I use <STRONG>GET</STRONG> statement to get the data from a database table bsid.</P><P></P><P>In the table bsid.</P><P>kunnr zuonr belnr xblnr</P><P>aaa space 10291 21986</P><P>aaa space 23321 97165</P><P>aaa Q1 36353 38363</P><P>bbb t2 38763 373662</P><P>bbb t2 286648 264829</P><P> </P><P>1, when the zuonr is initial, the records belongs to kunnr (aaa)include the following should be deleted.</P><P>kunnr zuonr belnr xblnr</P><P>aaa space 10291 21986</P><P>aaa space 23321 97165</P><P>aaa Q1 36353 38363 <STRONG>(even zuonr=Q1, the other records which belong to the same aaa have initial zuonr, this should be deleted too)</STRONG></P><P></P><P>2, Only the bbb which zuonr has value can be seleted.</P><P></P><P><STRONG>Question</STRONG>:</P><P>How to write the coding after <STRONG>GET bsid</STRONG> to restrit the condition?</P><P></P><P>Please help!</P><P>Thank you!</P></BODY></HTML> Mon, 21 Jan 2008 15:19:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-statement/m-p/3313424#M793622 Former Member 2008-01-21T15:19:30Z Re: GET statement https://community.sap.com/t5/application-development-and-automation-discussions/get-statement/m-p/3313425#M793623 <HTML><HEAD></HEAD><BODY><P>Why not use SELECT instead of GET?</P><P></P><P>Rob</P></BODY></HTML> Mon, 21 Jan 2008 15:52:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-statement/m-p/3313425#M793623 Former Member 2008-01-21T15:52:48Z Re: GET statement https://community.sap.com/t5/application-development-and-automation-discussions/get-statement/m-p/3313426#M793624 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The original program is using Get, so I am just thinking where there is anyway to restrite it.</P><P></P><P>thank you</P></BODY></HTML> Mon, 21 Jan 2008 15:56:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-statement/m-p/3313426#M793624 Former Member 2008-01-21T15:56:06Z