topic Re: Query in Application Development and Automation Discussions

Query

former_member225891 — Fri, 11 Mar 2011 07:17:14 GMT

Dear Experts,

I am PP functional consultant, i am trying to make query both from SQVI and SQ01, my requirement is like, i need to give BOM header as input parameter and from that i need to view components and alternatives of that BOM with qty and UOM, i got the tables which are follows,

MAST - Material to BOM Link

STKO - BOM Header

STAS - BOMs - Item Selection

STPO - BOM item

when i try to execute my query it says no data was selected, the link for MAST STKO and STAS is STLAL field and the link between STAS and STPO is STLKN, but when i am executing query it says NO data was selected, what i am missing and what should i do, please explain in more detail, thanks

Re: Query

Former Member — Fri, 11 Mar 2011 07:25:46 GMT

Hi Devidas,

Please write your select query here.

Thanks

lalit Gupta

Re: Query

former_member225891 — Fri, 11 Mar 2011 08:02:54 GMT

Dear Lalit,

What to write actually, please tell me, i will write

Re: Query

Former Member — Fri, 11 Mar 2011 08:32:03 GMT

Write your select statements what your are using in your code to fetch data.

Thanks

Re: Query

former_member225891 — Fri, 11 Mar 2011 08:39:05 GMT

Dear,

My requirement is to give BOM header, alternative and plant as input and the output should contain components of bom, with qty and UOM, so in MAST i am selecting MATNR, WERKS and STLAL, and in STKO i am selecting STLAL and STLNR, while from STAS table i am selecting STLNR STLAL and STLKN fields and lastly from STPO table i am selecting STLKN, IDNRK, MEINS, MENGE fields

Re: Query

Former Member — Fri, 11 Mar 2011 08:41:52 GMT

Hi Devidas

I meants that your complete select query

whether you are using for all entries or joins for selecting data from the mentioned tables.

Please paste your complete query as you have written in your ABAP Program.

Thanks

Re: Query

former_member225891 — Fri, 11 Mar 2011 08:50:53 GMT

Dear,

I am doing by empty fields method and also tried with key fields while doing query, but no data was selected was the error, and which ABAP program you are talking about, i am not getting, where to find that

Re: Query

Former Member — Fri, 11 Mar 2011 08:56:55 GMT

Hi Devidas,

To display you can use satndard BAPIS/FM for BOM and alternative BOMs.

Why cant you do in this way?

refer:

Thanks

Re: Query

former_member225891 — Fri, 11 Mar 2011 09:00:50 GMT

Dear,

Yes it can be done by other ways, but if i have to do from query only so what i am missing what should be the logical flow behind these table joining, pls give me inputs