Ask t-code for PO list

[Former Member]

Hi, All,

Is there a t-code that will show a PO by lines, goods receipts and invoice receipts?

Thanks

[Former Member · Accepted solution]

SQVI is SAP Query. It's reasonably straight forward, especially for lists and you can link tables according to your own needs (in my experience it can be a bit flakey on sub totals and totalling).

EKBE is the PO history table. Use tx SE11 to view fields and tx SE16 to see examples.

See also tables EKKO, EKPO.

Regards,

Nick

[former_member187989]

Develop a report using SQVI from table EKBE.

[Former Member]

Could you tell me what's functional for SQVI?

And what's table for EKBE?

Thanks

[Former Member]

He is referring to make a report through SAP QUERY by using table EKBE which is table used for PO. You can check EKKO and EKPO as well. These tables are used for PO Header and items.

[former_member187989]

There a lot of reports for po list,

T.codes are ME2N,ME2M,ME2L,ME2S,ME2W,ME2K,MB5S,MR11...

[Former Member]

Hi,

For goods receipts exists

In tcode ME2N enter the purchasing org,plant or your reqyuired data .In selection parameter enter the parameter you want for example WE102 -Goods receipt exist .This will provide you the list of goods receipts for seleected period.

I am not sure about the invoice receipt

Reagdrs,

Nitin Amritkar