Skip to Content
0
Former Member
Aug 23, 2007 at 12:05 PM

Abap coding in SAP query (SQ01)

445 Views

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