topic Re: abap -reports in Application Development and Automation Discussions

abap -reports

Former Member — Thu, 23 Mar 2006 03:42:23 GMT

Please suggest me the tables and fields necessary and if possible the code to design the following reports.please can also briefly explain how these reports are useful for an enterprise:

1.breakage/expiry material:to list materials returned due to breakage or expiry or any other reason.

2.dispatch details:to list dispatch details occured during a given period and for the given plant and division.

3.pending po:to list pending purchase orders of all vendors base on purchase organisation,group,purchase document number,item delivery date.

4.email id's: interactive report to list all the mail id's of contact persons for a given customer.

5.plant specific expired material.:to list plant specific expired material.

6.stock transfer:to list stocks transferred from various plants to the main plant.

7.goods receipt document:to list purchase order wise goods receipt document and invoice receipt details line item wise.

8.sales journal::sales journal to dispaly monthwise sales journal based on sales organisation,material number and billing date.

9.mm details report::to list material master details inputing material and plant as select options and material type as parameter.outptut list has total quantity by material group and quantity.

10. vendor analysis report::listing material,material number,storage location,measure unit,material description,group totals.

11. sales doc. details: list displaying all the sales orders along with delivery and billing document details as per user defined date range and/or order ttypes.

12. sales analysis:: sales occured during a user selected month and compare it with the sales occured in first 20 days of the month.

Re: abap -reports

Former Member — Thu, 23 Mar 2006 04:33:39 GMT

GO THROUGH THE FOLLOWING LINKS TO FIND OUT THE REQUIRED TABLES.

<a href="http://www.sapgenie.com/abap/tables_sd.htm">SD TABLES</a>

<a href="http://www.sapgenie.com/abap/tables_mm.htm#Purchasing%20Tables">Purchasing Tables</a>

<a href="http://www.sapgenie.com/abap/tables_mm.htm">MM Tables</a>

IF THESE FINDS USEFUL PLEASE REWARD POINTS

REGARDS,

ANOOP

Re: abap -reports

Former Member — Thu, 23 Mar 2006 04:41:18 GMT

hi,

SD Tables

KONV Conditions for Transaction Data

KONP Conditions for Items

LIKP Delivery Header Data

LIPS Delivery Item Data

VBAK Sales Document Header Data

VBAP Sales Document Item Data

VBRK Billing Header Data

VBRP Billing Item Data

MM Tables

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKKO Purchase Document Header

EKPO Purchase Document Item

Purchase Tables

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

LFA1 Vendor Master(General Section)

LFB1 Vendor Master(Company Code)

Regards,

Santosh

Re: abap -reports

Former Member — Thu, 23 Mar 2006 05:02:07 GMT

hi..

For all the SAP tables wanted and their relationships..the following link will provide you with the PDF file to help you..

www.geocities.com/sapcircle/Relations.pdf

try out whether it is useful to you..

regards..

Ananaya.S

Re: abap -reports

Former Member — Thu, 23 Mar 2006 05:10:23 GMT

Hi Kinthali,

Please check this link for SAP Application tables.

http://www.sapgenie.com/abap/tables.htm

Hope this will help.

Regards,

Ferry Lianto