topic Re: Interactive Report in Application Development and Automation Discussions

Interactive Report

Former Member — Tue, 13 May 2008 20:41:31 GMT

Hi Experts,

I am new in ABAP field.....How to create a interactive report for sales order and purchase order...what r the tables needs to create the report???plz reply me as soon as possible.....

Thanks and Regards,

Arun

Re: Interactive Report

Former Member — Tue, 13 May 2008 20:51:50 GMT

Hi Arun,

The top table is VBAK. "Subtables" are VBUK and VBAP only to mention a few.

There are a couple of Logical Databases available like VAV. Take a look at these and you can find a lot more transparent tables including their links.

Hope this helps,

Heinz

Re: Interactive Report

Former Member — Tue, 13 May 2008 20:58:46 GMT

Hi Ankit,

For sales order you can fetch the data from following tables:

VBAK - sales order header

VBAP - sales order item

VBEP - sales order schedule line

You can also use BAPI_SALESORDER_GETLIST to get the sales order information.

For purcahse order use tables:

EKKO - PO header

EKPO - PO item

Try using BAPI_PO_GETDETAIL bapi to get the PO information.

Hope this helps

Re: Interactive Report

Former Member — Wed, 14 May 2008 06:35:55 GMT

Thanks Heinz....

Now am doing this project...i dont know how to create a classical report for these requirements...

How to create a classical report for this requirements,

1) purchase documents and vendor.

2) vendor performance report that lists vendor name, materials

Supplied and actual delivery times, payments terms and prices

Purchase.

3) Requisitions with details like MRP controller, release date, unit

to Measure along with the standard details

4) list of customer number, Credit limit To the given Customer.

Thanks and Regards,

Sivaguru.

Re: Interactive Report

Former Member — Wed, 14 May 2008 06:37:55 GMT

Thanks Heinz....

Now am doing this project...i dont know how to create a classical report for these requirements...

How to create a classical report for this requirements,

1) purchase documents and vendor.

2) vendor performance report that lists vendor name, materials

Supplied and actual delivery times, payments terms and prices

Purchase.

3) Requisitions with details like MRP controller, release date, unit

to Measure along with the standard details

4) list of customer number, Credit limit To the given Customer.

Thanks and Regards,

Sivaguru.

Edited by: arun kumar on May 14, 2008 9:00 AM

Re: Interactive Report

Former Member — Wed, 14 May 2008 06:41:28 GMT

Thanks Heinz....

Now am doing this project...i dont know how to create a classical report for these requirements...

How to create a classical report for this requirements,

1) purchase documents and vendor.

2) vendor performance report that lists vendor name, materials

Supplied and actual delivery times, payments terms and prices

Purchase.

3) Requisitions with details like MRP controller, release date, unit

to Measure along with the standard details

4) list of customer number, Credit limit To the given Customer.

Thanks and Regards,

Sivaguru.

Re: Interactive Report

Former Member — Wed, 14 May 2008 16:26:57 GMT

Hello Arun,

Generally spoken for creating a classical report, you have to design your output structure, then retrieve the data from the relevant database(s), populate your output fields and display the data via

LOOP 
... 
WRITE 
.... 
ENDLOOP.

In your case you have to retrieve data from the DB tables, structured in the .JPG attachment I e-mail you soon.

Have success,

Heinz