Skip to Content
author's profile photo
Former Member

Reports in SD

Hi,

I'm very new to this group will anybody plz let me

know about the reports asked by the client in SD

Thanks,

sowji

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 08:29 AM

    Hi,

    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

    Sam

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2007 at 08:34 AM

    Sowji,

    Reports in Sales and Distribution modules (LIS-SIS):

    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

    REWARD IF U FINDS THIS AS USEFUL....

    Regds

    MM

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 08:35 AM

    hi,

    u needed not remeber all SD reports. use tcode:SARP-> enter SD01-> enter inside it will give u all report in sd topic wise

    hope this helps u

    regards,

    Arunprasad

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:31 AM

    hi,

    a lot of your requirements may nt be satisfied using std. reports for which u will need to develop custom reports using ABAP for which u shud knw wat data is to picekd in the report and from where. u can also explore SAP queries for this purpose. some of such reports cud be sales registers, tax registers, excise registers, pricing reports etc.

    saurabh

    Message was edited by:

    saurabh diwakar

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:48 AM

    Hi Sowjanya,

    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.

    Apart from above above Reports Please Find some more reports below:

    Shipment List Planning - VT11

    List of Incomplete Shipments -Try VT04/VT11/VT32

    Delivery without Shipments -Use VL06O

    List of Rebate Agreements - VB(8

    Please Reward If Really Helpful,

    Thanks and Regards,

    Sateesh.Kandula

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 06:45 AM

    Hi sowjanya sri garu

    did u get the good material r u ok

    and I have to say one thing here u have to give feed back

    at least u have to say thanks to all sorry I am telling this thing here

    I dont have ur mail id don't take to heart and this is our group

    we have to encourage one to other that is good for all

    ok all the best

    Add comment
    10|10000 characters needed characters exceeded