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