Infoset Additional Table needs to return multiple lines

[Former Member]

I have searched throughout and cannot find a good answer to this question, I hope you can help provide guidance.

I am trying to create an enhanced infoset / query where the number of records returned needs to be more than what is being returned from the joined tables.

A simple example (which i know can work through joined tables, but pretend it needs to be handled using additional tables and extra code within the infoset, the actual tables I am working with are custom).

VBAK-KNVV are joined on KUNNR/VKORG/VTWEG/SPART to show further customer detail. I would put in a check box selection into extras that would allow the users to choose if they want their results to include the line items of the sales order (VBAP). So if the user does not check the, it would only return one record and have the item fields empty. If the box is checked, it would return the results in multiple lines for each item from VBAP where VBELN = VBAK-VBELN.

Hopefully this is enough explanation.

Thanks in advance!

Jonathon

[Former Member]

Any help would be greatly appreciated.