topic Re: Customized reports on ECC in Application Development and Automation Discussions

Customized reports on ECC

Former Member — Fri, 02 Sep 2016 22:18:37 GMT

Hello experts, i'm having a hard time trying to understand how to create customized reports on ECC, using sq01, sq02 and sq03 TX.

By now im trying to create a Purchase Report that shows the following fields:

Document Creation Date.
Document Number.
Vendor Name.
Item number of Purchasing Document.
Short Text
Purchase Order Qty
Net Order Value

So far i have identified EKKO, EKPO and EBAN tables where i'm trying to join them using EBELN (Purchasing Document Number), but once i test my query it shows empty results for EBELN fields and LIFNR (vendor id).

Im very familiar with SQL but i think i'm missing something related to SAP functionalities, would you share some advice?

Thanks!

Re: Customized reports on ECC

Sandra_Rossi — Sat, 03 Sep 2016 08:23:13 GMT

This issue is not specific to SAP but to your join:

Join 1: EKKO --- EKPO, by EBELN

Join 2: EKPO --- EBAN, by EBELN and EBELP

Re: Customized reports on ECC

Clemenss — Sat, 03 Sep 2016 11:04:14 GMT

you may try to create a quickview based on table join (SQVI). Run it, use system->status to get the report name.

Quickview will automatically suggest the join conditions.

No more need for decades-old query hassle.

Regards Clemens

Re: Customized reports on ECC

Former Member — Sat, 03 Sep 2016 11:59:47 GMT

This message was moderated.

Re: Customized reports on ECC

Former Member — Mon, 05 Sep 2016 22:40:57 GMT

Under this context, EKPO would be my fact table right?, let me try this query.

thanks

Re: Customized reports on ECC

Former Member — Mon, 05 Sep 2016 22:43:00 GMT

I didn't know that transaction, guess i'll try to create my query in both ways.

Thank you.