Skip to Content

MCTG SOURCE DATA

Hello, can someone please tell me how to reach the source data for the key figure 'Incoming Orders' in MCTG? We use Cognos for our formal reporting software, which is fed daily from SAP, but we are finding a significant difference between SAP's figure and Cognos figure. We know the filters applied in Cognos and can account for some of the discrepancy, but there is still close to $1 million unaccounted for. When I run VA05/VA05N, the figures do not match, and they don't match when I take the data directly from the VBAK table either, even accounting for the returns and credit memos.

Ideally, I would like to see the actual data that is calculating 'incoming orders' and then compare this to the line item data in Cognos to weed out the discprepancies.

Any help or direction will be greatly appreciated. I am 2 days into this now!

Thank you,

Erica Nash

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 02, 2012 at 06:27 AM

    Hello,

    Are Figures that you are getting in MCTG correct in the first place?

    I mean that the MCTG figures may be reported wrong & that is way Cognos is generating wrong figures.

    The settting for MCTG are done here: IMG - Logistics - General - Logistics Information System (LIS) - Information Structures

    Thanks,

    Jignesh Mehta

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 02, 2012 at 01:05 PM

    Thanks for your quick reply.

    I cannot say if the figures in MCTG are correct in the first place. This is what I want to proof out with determining what exactly makes up the key figure 'incoming orders'.

    For the Cognos figure, we take daily extractions of VBAK and VBAP, subtract out certain order types and material groups and come to a figure that makes sense. But with MCTG, I cannot even say what this figure starts with. I cannot reconcile it to VBAK.

    The path IMG - Logistics - General - Logistics Information System (LIS) - Information Structures does not exist for me. I am on ECC 6.0 .

    Thanks for your help. I really appreciate it.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.