topic Re: Select problem in BKPF in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826610#M1315900 <HTML><HEAD></HEAD><BODY><P>check the declaration for that internal table. it should match with ur select query field order</P></BODY></HTML> Tue, 16 Jun 2009 13:12:06 GMT Former Member 2009-06-16T13:12:06Z Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826606#M1315896 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have written the following Select Query .I got one record in IT_BKPF1 but the awkey field in Internal Table IT_BKPF1 is Blank. can u help me.</P><P></P><P> SELECT bukrs</P><P> belnr</P><P> gjahr</P><P> blart</P><P> bldat</P><P> budat</P><P> cpudt</P><P> usnam</P><P> bvorg</P><P> xblnr</P><P> bstat</P><P> awtyp</P><P> awkey</P><P> INTO TABLE it_bkpf1</P><P> FROM bkpf</P><P> WHERE awkey = '51056012492007 '.</P><P></P><P>Regards,</P><P>Deepthi.</P></BODY></HTML> Tue, 16 Jun 2009 12:56:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826606#M1315896 Former Member 2009-06-16T12:56:14Z Re: Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826607#M1315897 <HTML><HEAD></HEAD><BODY><P>make sure that Internal Table BKPF has the same structure.</P><P>bukrs</P><P>belnr</P><P>gjahr</P><P>blart</P><P>bldat</P><P>budat</P><P>cpudt</P><P>usnam</P><P>bvorg</P><P>xblnr</P><P>bstat</P><P>awtyp</P><P>awkey</P><P></P><P>the way you are selecting.</P></BODY></HTML> Tue, 16 Jun 2009 13:08:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826607#M1315897 Former Member 2009-06-16T13:08:11Z Re: Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826608#M1315898 <HTML><HEAD></HEAD><BODY><P>Yes, it has got the same structure...</P></BODY></HTML> Tue, 16 Jun 2009 13:11:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826608#M1315898 Former Member 2009-06-16T13:11:22Z Re: Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826609#M1315899 <HTML><HEAD></HEAD><BODY><P>use <STRONG>INTO CORRESPONDING FIELDS</STRONG> OF TABLE it_bkpf1</P></BODY></HTML> Tue, 16 Jun 2009 13:11:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826609#M1315899 Former Member 2009-06-16T13:11:32Z Re: Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826610#M1315900 <HTML><HEAD></HEAD><BODY><P>check the declaration for that internal table. it should match with ur select query field order</P></BODY></HTML> Tue, 16 Jun 2009 13:12:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826610#M1315900 Former Member 2009-06-16T13:12:06Z Re: Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826611#M1315901 <HTML><HEAD></HEAD><BODY><P>The field in the internal table should be in the same ORDER and of same TYPE.</P><P></P><P>Please verify.</P><P></P><P>Thanks,</P><P>Amol</P></BODY></HTML> Tue, 16 Jun 2009 13:14:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826611#M1315901 Former Member 2009-06-16T13:14:13Z Re: Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826612#M1315902 <HTML><HEAD></HEAD><BODY><P>I have commented bstat field from selection as it has got some deep strcture.</P><P> SELECT bukrs</P><P> belnr</P><P> gjahr</P><P> blart</P><P> bldat</P><P> budat</P><P> cpudt</P><P> usnam</P><P> bvorg</P><P> xblnr</P><UL><LI level="1" type="ul"><P> bstat</P></LI></UL><P> awtyp</P><P> awkey</P><P> INTO TABLE it_bkpf1</P><P> FROM bkpf</P><P> FOR ALL ENTRIES IN it_ekbe</P><P> WHERE</P><P> awkey = it_ekbe-awkey.</P></BODY></HTML> Tue, 16 Jun 2009 13:18:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826612#M1315902 Former Member 2009-06-16T13:18:53Z Re: Select problem in BKPF https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826613#M1315903 <HTML><HEAD></HEAD><BODY><P>BSTAT a deep structure?</P><P>Better include AWTYP in the where-condition, or we will see you in the performance forum soon.</P><P>Thomas</P></BODY></HTML> Tue, 16 Jun 2009 13:36:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-problem-in-bkpf/m-p/5826613#M1315903 ThomasZloch 2009-06-16T13:36:35Z