Skip to Content
avatar image
Former Member

Sales report

Hi:

How can I run a report to include all the sales column specified to one/mutilply sold tos?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 11, 2009 at 01:48 PM

    HI,

    What do you mean by "to include all the sales column"?

    Assuming that's to see all data in sales order, you can try below transactions.

    VA05

    Can be execute to single Sold to Party only.

    Cannot run for multiple Sold to Parties.

    Can view most of the data in your sales order.

    If you can see only few columns, go to Menu Option Settings -> Layouts -> Current. There you can add columns from "Hidden Columns" to "Display Columns"

    VA05N

    Can execute for multiple Sold to Parties.

    Can view only few data columns, Not like in VA05

    Else Check these

    To see Sales Document Header data

    Tx: SE11

    Enter "Database table" as "VBAK" Then press "Contents" button (CTRLSHIFTF10)

    There you can execute for data

    To see Sales Document Item data

    Tx: SE11

    Enter "Database table" as "VBAP" Then press "Contents" button (CTRLSHIFTF10)

    There you can execute for data

    Best regards,

    Anupa

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2009 at 07:02 AM

    Dear Friend,

    You can use :

    Standard Report -

    1. VF05N

    LIS Report -

    2. MC+E

    Alternatively you can also develop a sinple ABAP report by joining VBRK & VBRP tables.

    Hope this Helps.. .

    Thanks,

    Jignesh Mehta

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2009 at 05:55 PM

    Hi

    As per you query , if you want to include all sales column specified to Sold to party (KUNNR) then you can run the standard reports VA05 , VA05N , MCTA . But if still the standard reports are not meeting your requirement then you have to create your own report using the fields which are in the sales column and then you can run the report

    Regards

    Srinath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2009 at 01:17 PM

    Hi

    Using trx SARP (with SD01) you can select any available report.

    This is a full standard report tree.

    Regards

    Gabriel

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2009 at 12:07 PM

    Hi..

    Tcode-SARP

    Use Report tree-SD01

    You will get all reports in SD

    Regds

    MM

    Add comment
    10|10000 characters needed characters exceeded