Skip to Content
-1

Extract open contracts to BW

I know when raising a delivery, it is made against a sales order and an invoice is made against a delivery. From BW perspective the delivery has a reference number of the sales order and invoice has a reference to the delivery. is there a reference to the contract other than filtering by document category ? I am trying to extract open contracts to BW

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 15, 2017 at 07:35 PM

    I would recommend to ask a local SD expert about this since they are the only ones who would be able to advise on the specific configuration in your system. In addition to the delivery-related billing, there is also order-related billing, which has a different document flow. And your definition of "open" could differ from the SAP definition (VBUK/VBUP table). So any replies from a global forum would need to be taken with caution.

    You can also simply use SQL Trace (ST05) to find tables used in any report or transaction. And there is a PDF with all major tables available online if you just google "SAP tables".

    There is even a question about sales orders for a contract in BW already posted 2 years ago and it can be easily found in Google as well.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 04:11 PM

    Standard transaction to check the Open Contracts is VA45 and table is VBBE where OMENG shows the open quantity

    Add comment
    10|10000 characters needed characters exceeded