cancel
Showing results for 
Search instead for 
Did you mean: 

report

Former Member
0 Kudos

Is there any report available in purchasing to know the purchase value in combination with VENDOR & GL ACCOUNT?

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

ans

Former Member
0 Kudos

Now requirement is to have report for GR values in combination with Vendor, Material, and GL account number.

Can anyone guide pls?

Edited by: sapsarang on Apr 28, 2009 1:30 PM

Former Member
0 Kudos

Hi check it in ME2K.

Regards,

Raman

Former Member
0 Kudos

But in ME2K, it doesnt ask for specific GL account number. It asks for cost center. I hav created query, but it is not showing any result. Is it sufficient to take tables MSEG & EKKN in my case or shud i consider all tables EKKO, EKPO, EKKN & MSEG?

Pls guide

Former Member
0 Kudos

pls guide

JL23
Active Contributor
0 Kudos

there is no report that fulfills your requirement, you have either to create query or quickview as already described, or you need to create an ABAP report.

Former Member
0 Kudos

HI,

For GR Values,

It is MSEG, it self Gives all the GR values .for the combination of (GL ,VEndor,and material.)

it has the in the selction screen GL and Material and Vendor .

Just execute the same,so that you get all the details

Like the Material Docment number ,plant ,storage Location ,Amount in Local Current ( GRN value)

Delivery Cost if any, PO NUmber .

HOpe so it helps

Regards

Anjanna

Former Member
0 Kudos

thanks

Former Member
0 Kudos

HI,

There is no Standard Report that could give this report,we can write a Query by Linking the Tables

EKKO - For PO Header detais( vendor PO NUmber ,Total PO value)

EKPO- For PO Item details ( MAterial /services ,text,plant ,per unit value ,qty etc.)

EKKN- For PO accounting Details ( GL accounts ,Cost element etc

Quick viewer reporting tool will be used for this report SQVI

This link will be useful in understanding the SQVI

http://www.sapdb.info/sqvi-quick-viewe/

hope so it helps

Regards

Anjanna

Former Member
0 Kudos

Hi,

u can make a query report by joining the tables ekko, ekpo,mseg,ekbe. or else u can make a buyers negotiation sheet.

regards

jash

Former Member
0 Kudos

check ME2L, ME2M, ME2N.