sd reports

[Former Member]

hi friends,

i am new to this community

what is customised Reports???

can i get some example...

is that we can practise on IDES???

thanks

raj

[Former Member · Accepted solution]

Hi Raj,

Custom Reports are like which are not in standard system.

As per the Client Requirement have to desing that with the help of Abaper.

From functional side have to prepare the Functional Spec and should send the same to Technical Person for which he add the Technical aspect.

Finally getting the client Approval.Abaper will develop the report.

As a functional consultant have to check the same.

Apart from this please find below the SD Standard Reports:

SD Reports

Standard SAP SD Reports:=

Statistic Group:

Purpose – To capture data for Standard Reports, we require to activate Statistic Group as under:

--> Item category (Configuration)

--> Sales document type (Configuration)

--> Customer (Maintain in Master data)

--> Material (Maintain in Master data)

When you generate statistics in the logistics information system, the system uses the combination of specified statistics groups to determine the appropriate update sequence. The update sequence in turn determines for exactly which fields the statistics are generated.

Configuration:

IMG --> Logistics Information System (LIS) --> Logistics Data Warehouse --> Updating --> Updating Control --> Settings: Sales --> Statistics Groups -->

1. Maintain Statistics Groups for Customers

2. Maintain Statistics Groups for Material

3. Maintain Statistics Groups for Sales Documents

4. Assign Statistics Groups for Each Sales Document Type

5. Assign Statistics Groups for each Sales Document Item Type .....

All Standard Reports which are available are as under:

SAP Easy Access: Information Systems -> Logistics -> Sales and distribution ->

1. Customer -> Incoming orders / Returns / Sales / Credit memos / Sales activities / Customer master / Conditions / Credit Master Sheet

2. Material -> Incoming orders / Returns / Sales / Credit memos / Material master / ...

3. Sales organization -> Sales organization / Sales office / Sales employee

4. Shipping point -> Deliveries / Returns

5. SD documents -> Orders / Deliveries / Billing documents ...

& so on.

Some of the Standard reports in SD are:

Sales summary - VC/2

Display Customer Hierarchy - VDH2

Display Condition record report - V/I6

Pricing Report - V/LD

Create Net Price List - V_NL

List customer material info - VD59

List of sales order - VA05

List of Billing documents - VF05

Inquiries list - VA15

Quotation List - VA25

Incomplete Sales orders - V.02

Backorders - V.15

Outbound Delivery Monitor - VL06o

Incomplete delivery - V_UC

Customer Returns-Analysis - MC+A

Customer Analysis- Sales - MC+E

Customer Analysis- Cr. Memo - MC+I

Deliveries-Due list - VL04

Billing due list - VF04

Incomplete Billing documents - MCV9

Customer Analysis-Basic List - MCTA

Material Analysis(SIS) - MCTC

Sales org analysis - MCTE

Sales org analysis-Invoiced sales - MC+2

Material Analysis-Incoming orders - MC(E

General- List of Outbound deliveries - VL06f

Material Returns-Analysis - MC+M

Material Analysis- Invoiced Sales - MC+Q

Variant configuration Analysis - MC(B

Sales org analysis-Incoming orders - MC(I

Sales org analysis-Returns - MC+Y

Sales office Analysis- Invoiced Sales - MC-E

Sales office Analysis- Returns - MC-A

Shipping point Analysis - MC(U

Shipping point Analysis-Returns - MC-O

Blocked orders - V.14

Order Within time period - SD01

Duplicate Sales orders in period - SDD1

Display Delivery Changes - VL22

There are hundreds of standard reports provided by SAP. You can access them by using the Tcodes

SAP1 and SARP

Go to SARP, input sd01 in "Report Tree" and press F5. You will get all standard SD Reports.

Hope this clarifies your doubt and Please Reward If Really Helpful.

Thanks and Regards,

Sateesh.Kandula

[Former Member · Accepted solution]

hi friends,

can somebody share your experience on customise reports( means scenarios).

it will very helpful for new comers like me

thanks

[Former Member · Accepted solution]

Hello,

We had a requirement for a report which should show all the open contracts, in which it should exclude the line item, if it is fully referenced. This was not available in standard SAP, we went for a Z report.

Prase

[Former Member · Accepted solution]

hi prasanth,

can u tell me the configuration steps of above report???

thanks

[Former Member · Accepted solution]

Rajan,

As you asked about a customized report (Z report) I have explained you a Zreport which we have developed. The reports are generally created by coding and no customisation required.

Prase

[Former Member]

hi.

IDES is learning and practicing server. We practice lots of thinmgs and modules here.

Custome rep[orts are also known as Z Reports for list of Z reports go to SE38 and Put Z* and Press F4 u can view all Z reports.

Thanks,

Raja

[jignesh_mehta3]

Customised are reports are the ones those are created by your ABAPers...

Say for example your requirement are not fulfilled by SAP standard reports, then you can get Customised reports Developed by your ABAPers. These reports are prepared by picking dta from relevant tables & feilds...

You can also have Customised reports for LIS / SIS...

Hope this helps...

Reward if Useful...

Thanks,

Jignesh Mehta

98700 10230

[Former Member]

Hi,

Custom Reports (Z-Reports) are newly-designed reports apart from Standard SAP Reports.

example:

ZSTATUS

Say, u wanna single report to list out all Sales Orders (with criterias) with Delivery Status and Billing Status (item-wise) for a specific period.

Purpose of custom reports to fullfill the en-user reporting requirements, which are not possible with Standard SAp reports.