Skip to Content
avatar image
Former Member

Material details

Dear Friends,

My client has an requirement to see the list of material which is got invoiced for a month with distribution channel wise also he wants to see the qty and value

please help me on this

i have tried thru MCTC it was not working

Regards

Shakthi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2008 at 10:47 AM

    Dear,

    There is standard report: MC+Q, as also replied by me in response to your earlier thread.

    In this report, key-in:

    1. Distribution Channel (Range: From and To)

    and

    2. Period (Range: From and To)

    And F8.

    This report lists out all the Materials, invoiced within period-range for all the Distribution Channels (as ranged), along with Billed Qty and Gross Sale.

    If you need to include more inputs, just press F6.

    Now, as you are saying that none of your Standard reports (MCTC, MC+Q etc...) are not fetching any data; Please check whether LIS-Update has been maintained or not.

    To Check LIS-Update:

    SPRO --> IMG --> Logistics-General --> Logistics Information System --> Logistics Datawarehouse --> Updating --> Updating Control --> Assign Update Group at Item Level

    Entries must be maintained for the Combination:

    A. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()Material Statistic Group (1)Statistics group for sales document type (1)+Statistics group for the item category (1)

    B. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()Material Statistic Group (1)Statistics group for sales document type (2)+Statistics group for the item category (2)

    Similarly for:

    SPRO --> IMG --> Logistics-General --> Logistics Information System --> Logistics Datawarehouse --> Updating --> Updating Control --> Assign Update Group at Header Level

    A. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()+Statistics group for sales document type (1)

    B. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()+Statistics group for sales document type (2)

    I am confident that you will get the desired result.

    Best Regards,

    Amit

    Note: I have writen such a long response as the same is working at my end.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 10:19 AM

    hello, friend.

    VF05 should work for you.

    regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hello part 3.

      actually, you can do SQVI and choose VBRP. select documents with dates within your desired range. this should fit your requirements.

      regards.

  • avatar image
    Former Member
    Oct 15, 2008 at 10:24 AM

    hi

    for this you need to develope a Report with ABAPer, it is related to more than 2-3 tables and in one table you cannot get these all values. infact you will get invoice list in VF05.

    regards

    srini

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2008 at 10:41 AM

    Dear Shakthi

    Have you tried with VF05N ??

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded