Query

[former_member225891]

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

[Former Member]

Hi Devidas,

Please write your select query here.

Thanks

lalit Gupta

[former_member225891]

Dear Lalit,

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

[Former Member]

Hi

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

Thanks

LG

[former_member225891]

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

[Former Member]

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

LG

[former_member225891]

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

[Former Member]

Hi Devidas,

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

Why cant you do in this way?

refer:

Thanks

[former_member225891]

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