R/3 Infoset join question

[jody_chassereau]

I'm not a big SQ02 user, but was hoping someone who has used it more could answer a question posed by one of our analysts. They would like to create an Infoset for some reporting needs where there is a join between VBAK and VEDA. No problem with this since it makes the connection based on the sales document field. However, they only want to bring in rows from VEDA where the item is 000000, not all the individual line items. Is there a way to accomplish this in the join definition (I couldn't see any way to restrict that there)? Or would you have to build in the VEDA item field as a parameter where it can be input as all zeroes?

Any input would be appreciated. Thanks... Jody

[Former Member]

Can you not create a view where the item is one of the selection conditions?

Rob

[Former Member]

after creating the joins in infoset in sq02, goto sq01, create an infoset query, select your infotype from your usergroup.

here, below output button you have a drop down button as 'field group' and 'field catalog', from here make the line number as selection criteria(drag and drop in the right part of screen).

you will have this item in selection screen. pass 000000 here and execute...

i hope task done. any doubt?

[jody_chassereau]

Thanks for your reply... that is pretty much what we had assumed since I couldn't find where you could further restrict the join condition. We'll give it a shot.