Skip to Content
author's profile photo Former Member
Former Member

Customized reports on ECC

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!

join.PNG (48.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Sep 03, 2016 at 08:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 03, 2016 at 11:04 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2016 at 11:59 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.