Customized reports on ECC

[Former Member]

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!

[Sandra_Rossi]

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

[Former Member]

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

thanks

[Clemenss]

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

[Former Member]

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

Thank you.

[Former Member]

This message was moderated.