Hi,
By using the a table like for MSEG if i want to retrieve data for the movement type 101 (receipts from vendor), i can build a query using this table and retrieve data - my problem starts when the system shows individual line items instead of cumulated result as mentioned in the following example.
Example :-
for the date 01.07.2007 - i have 10 entries (101 movement) of quantity 1,2,3,4,5,6,7,8,9,10 against a vendor V1. - the query lists all the 10 entries.
But what is required is the cumulated entry against the vendor like shown below
vendor receipt
V1 55.
What abap coding should be written (provide the sample code) and the where should it be written in the query transaction SQ01
Regards,
M.M