Skip to Content

Reconciliation report for sale orders

Hi Gurus,

I have a requirement of creating BW reconciliation report for sales orders. I am planning to proceed by creating a custom reconciliation data source and a virtual cube. Then planning to put this virtual cube and the standard cube containing sale order in a multiprovider. Can anybody help me with the steps? Do we have any standard reconciliation data sources available for this? If i need to create one custom direct access data source, what should be the tables ?

Thanks a lot

Rakesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jan 16, 2014 at 09:57 AM

    Hi,

    there is no standard reconciliation data sources.

    if needed then create generic one on sd table - VBAK for sales orders

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 16, 2014 at 09:58 AM

    Dear Rakesh,

    Your approach to reconcile sales data is wise.

    If you want to reconcile Sales order/delivery/billing data then create 3 separate generic data-sources of direct access and replicate /connect to IC . Then include this IC to Multi-provider as you stated.

    Sales order - VBAK/VBAP

    Delivery - LIKP/LIPS

    Billing - VBRK/VBRP

    Best wishes, Vijay

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Rakesh,

      Here 0SD_C03 sales overview cube holds data from sales/Delivery and Billing datasources.

      Data get segregates according to 0DOC_CLASS and 0DEB_CRED.

      If you are taking about Shipment specifically you get get help from 2LIS_12_VCHDR/VCITM and 2LIS_12_VCSCL .

      - If you can provide the requirement specifically regarding shipment like fields at Report level , then we can come closer to requirement easily.

      best wishes, Vijay

  • Posted on Jan 16, 2014 at 11:49 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 22, 2014 at 10:11 AM

    Hello Gurus,

    For sales order reconciliation, my plan is to create a reconciliation data source and load to a virtual cube, and to put the virtual cube and standard cube in a MP, and create report with variance. So, now I have created a recon data source with view and replicated to BW. Now what should I do? Do i need to create infopackage and manually trigger it to PSA? And which option do i need to select while creating a virtual cube?

    Thanks

    Rakesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Rakesh,

      Can you pls tell us what is the defination of Sale Order Reconcilation...what is Reconciliation?

      Once we have calrity on this we can suggest you what you can pick up and how you can go about it.

      There are standard Datasource avaliable for Sale Orders /Delivery and Billing.

      For Example :-

      2LIS_11* -> Sales Order

      2LIS_12* ->Delivery

      2LIS_13* ->Billing

      We will have to club them and use it for reporting.

      rgds

      SVU

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.