Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

formatted search query for displaying invoice items details

hi all,

i need to display all the items in AP invoice.kindly suggest me a query for that.

in AP invoice

Ex. row items

code--


desc
qty

price
--


total

I0001--


XXXXXXX
5
--


100 -


500

-


query should display this row as

code--


desc--


price

I0001--


XXXXXXX--


100

I0001--


XXXXXXX--


100

I0001--


XXXXXXX--


100

I0001--


XXXXXXX--


100

I0001--


XXXXXXX--


100

=================================

the query should display as the qty is 5 so it will display the same item 5 times

kindly suggest me some query for formatted search

its very urgent

regards

sandip

Former Member
Not what you were looking for? View more on this topic or Ask a question