Solved: sd reports

Former Member · ‎02-12-2007

hi friends,

please explain about sd reports.

thanks,

rao.

Former Member · ‎02-12-2007

hi

this sd standard reports

Customer - Incoming Orders SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Incoming Orders MC(A

Customer - Returns SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Returns MC+A

Customer - Invoiced Sales SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Invoiced sales MC+E

Customer - Credit Memo SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Credit Memo MC+I

Material - Incoming Orders SAP menu - Information Systems - Logistics - Sales and distribution - Material - Incoming Orders MC(E

Material - Returns SAP menu - Information Systems - Logistics - Sales and distribution - Material - Returns MC+M

Material - Sales SAP menu - Information Systems - Logistics - Sales and distribution - Material - Sales MC+Q

Sales Organization - Incoming Orders SAP menu - Information Systems - Logistics - Sales and distribution - Sales Organization - Incoming Orders MC(I

Sales Organization - Sales SAP menu - Information Systems - Logistics - Sales and distribution - Sales Organization - Sales MC+2

Shipping Point - Deliveries SAP menu - Information Systems - Logistics - Sales and distribution - Shipping Point - Deliveries MC(U

Shipping Point - Returns SAP menu - Information Systems - Logistics - Sales and distribution - Shipping Point - Returns MC-0

Customer SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Customer MCTA

Material SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Material MCTC

Sales Organization SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Sales Organization MCTE

Shipping Point SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Shipping Point MCTK

worked by two this tranactions

1.OVRP

2.OVRO

Former Member · ‎02-13-2007

Hi,

Please look at these links for more information :

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/8e/c5853488601e33e10000009b38f83b/frameset.htm">SD Reports</a>

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/8e/c5853488601e33e10000009b38f83b/frameset.htm">List of various documents : Reports 2</a>

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/8e/c5853488601e33e10000009b38f83b/frameset.htm">Functional Analysis</a>

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/8e/c5853488601e33e10000009b38f83b/frameset.htm">Sales Information System</a>

Hope this would give more information regarding reports.

Thanks & Regards

Sadhu Kishore

Former Member · ‎02-12-2007

Dear Rao,

Send me your email id so that I can send you an extensive document on SD Reporting.

Regards,

Rakesh

Former Member · ‎02-12-2007

Hi,

Reports are basically what the client uses to run his business to understand what is happening. In sap all the data is stored in the form tables. So, when we want a report say to show the sales happened over the last 3 months or an year over some division for a product can be fetched from the database through these tables. We have a primary key- foreign key relationship used by RDBMS ( Oracle the underlying database) used to fetch the data from various tables.

Like for data required on sales delivery and billing documents we use.

VBAK - sales document header

VBAP- Item data

VBEP - Schedule line data

LIKP - Delivery Header

LIPS - Delivery Item data

VBRK - Billing Header

VBRP- Billing Item data

VBFA - Sales document flow

VBKD- Sales document Business data

<a href="http://www.sap-img.com/ab024.htm">Sales Order Changed History Display</a>

Hope this gives some idea. Please reward if helpful.

Thanks & Regards

Sadhu Kishore

Former Member · ‎02-12-2007