Skip to Content

R/3 Infoset join question

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2009 at 06:04 PM

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

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2009 at 06:21 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.