Report

[Former Member]

Hi All,

What are the standard reports are there in sales and distribution?

What are the transaction codes for these?

Kindly help me out on this.

Reward points for helpful answer.

Regards

Ashis

[Former Member · Accepted solution]

For your information, some of the useful standard reports are:

RGUGBR00 Substitution/Validation utility

RHGENZ0/HRGRENZ2 Notes RHGRENZ0/2 will abend if there are any inconsistencies between PD and PA (i.e. people in a different controlling area than the position they belong to).

RHGRENZ0 Delimit IT1000 and related 1001s. Program will delete any 1001 infotypes whose start date is after the delimit date.

RHGRENZ1 Extend the end date on delimited records. Very useful when you delimit a bunch of records incorrectly, and need to change the end date.

RHGRENZ2 Delimit IT1001 only.

RKCTSEAR Search source code for up to two strings. Also see RSRSCAN1 and RPR_ABAP_SOURCE_SCAN.

RPDTRA00 List all HR transactions.

RPR_ABAP_SOURCE_SCAN Search ABAP code for a string. Has many more options for selecting the ABAPs to search than RSRSCAN1 or RKCTSEAR.

RPUAUD00 HR Report to list all logged changes for an employee. Uses the PCL4 Audit Cluster.

RPUAUDDL HR Report to delete audit data from the PCL4 Audit Cluster.

RPUDELPN Delete all info for an employee number, including cluster data and infotypes

RPUP1D00/10 View/Delete data from PCL1 Cluster

RPUP2D00/10 View/Delete data from PCL2 Cluster

RPUP3D00/10 View/Delete data from PCL3 Cluster

RPUP4D00/10 View/Delete data from PCL4 Cluster

RSABAPIV Mass print/display of ABAP/4 help text

RSAVGL00 Table adjustment across clients

RSBDCBTC Submit a BDC job with an internal batch number and wait for the end of the batch input session.

RSBDCDRU Prints the contents of a Batch Input session. No options for error transactions only.

RSBDCOS0 Execute UNIX commands. Looks similar to the old SAPMSOS0 program that disappeared in 3.0

RSBDCSUB Release batch input sessions automatically

RSBTCDEL Clean the old background job records

RSCLTCOP Copy tables across clients

RSDBCREO Clean batch input session log

RSINCL00 Extended program list

RSORAREL Get the Oracle Release

RSPARAM Display all instance parameters

RSPO0041 Removing old spooling objects

RSRSCAN1 Search source code for a given string. Will also search includes. Also see RKCTSEAR and RPR_ABAP_SOURCE_SCAN.

RSSNAPDL Clean the old ABAP error dumps

RSTBSERV Compare a contents of a table between clients

RSTXFCON Converts SAPScript page formats

RSTXSCRP Save a SAPScript layout set to disk, and load it back into SAP.

RSTXSCRP Transport SAPscript files across systems

RSTXSCRP Upload and download SAPScript layout sets

RSTXTRAN Add standard texts to a transport so they can be moved between systems.

RSUSR003 Check the passwords of users SAP* and DDIC in all clients

RSUSR006 List users last login

RSWBO052 Change development class of a sapscript (provided by Alan Cecchini)

RSWBO060 put objects into a request and transport it to any other system

RFSKPL00 Global chart of accounts(General data)+B106

RFSKVZ00 Local chart of accounts(Ccode specific)

RFBELJ00 transaction journal

RFSLD00 Trial balance

RFBILA00 balance sheet /P&L

RFHABU00 balance audit trail

RFSKTH00 Financial policy manual

RFBUSU00 Postings totla

RFSABL00 Changes to g/l account

RFEPOJ00 Line item journal

SAPMV45A Sales Order Processing

SAPMM06E Purchase Order Processing

SAPMF02K Vendor master

SAPMM03M Material master

SAPLF0180 Balance sheet readjustment

RSWBO052 Change Development Class

RSTXLDMC

RSTXFCON Converts page format

RSTXSCRP pload/Download layout sets

RSTXCHKO To Correct Inconsistencies in Copying Script

RAALTD11 Asset master upload

Reward points if useful.

[Former Member · Accepted solution]

Hi Sravan,

How to get these all things like:

RGUGBR00 Substitution/Validation utility

RHGENZ0/HRGRENZ2 Notes RHGRENZ0/2 will abend if there are any inconsistencies between PD and PA (i.e. people in a different controlling area than the position they belong to).

RHGRENZ0 Delimit IT1000 and related 1001s. Program will

etc etc..........

From where u got all these things.

And I can not understand how to process on these.

Plz help me out on these.

Regards

'Ashis

[Former Member · Accepted solution]

Hi Ashis,

For Standard SAP SD reports, use transaction code SD01.

For Standard SAP reports, use transaction code SAP1.

Do let me know in case of any queries.

Hope this helps you.

Do award points if you found them useful.

Regards,

Rakesh

[Former Member · Accepted solution]

Hi Rakesh,

when i execute sd01 transaction code...it is telling sd01 transaction code doesnt exist..Can u plz tell me once again??

Regards

Ashis

[Former Member]

HI,

Please find teh some Sd std reports

Sales summary VC/2

Display Customer Hirarchy VDH2

Disply 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

Outbond Delivery Monitor VL06o

IncompleteSD documents 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

Customer Analysis-Incoming orders MC(A

Sales org analysis-Invoiced sales MC+2

Material Analysis-Incoming ordersMC(E

General- List of Outbond deliveriesVL06f

Material Returns-Analysis MC+M

Material Analysis- Invoiced Sales MC+Q

Variant congiruration Analysis MC(B

Sales org analysis-Incoming ordersMC(I

Sales org analysis-Returns MC+Y

Sales office Analysis- Invoiced SalesMC-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

Release sale order for billing V.23

Hope this helps u

regards,

Arun prasad

[Former Member]

SD REPORTS

Reports: Reports consist of data, which is expected to be reveiwed or checked the transaction taken in said period. Reports are useful for analysis of decision taking for future activities.

Some of the standard reports for SD & its configuration guide is as under:

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

Shipment List Planning - VT11

List of Incomplete Shipments -Try VT04/VT11/VT32

Delivery without Shipments -Use VL06O

Reward points if useful.