Skip to Content
author's profile photo Former Member
Former Member

How to find related billing document of a rebate settlement

Hi Experts,

i am facing an issue. I need to start from a rebate settlement document which in an invoice with type Rebate partial settlement. to find out all related invoices . I mean from the sap tables. Based on the threads i found I can only start from VBRK


obtain the document condition number (VBRK-KNUMV), pass it to KONV-KNUMV to fetch KONV-KNUMH (Condition Record Number), pass this inturn to KONP-KNUMH. The field KNUMA_BO in table KONP gives the rebate agreement number


But the rebate settlement ( Credit Memo automatically created ) was generated by calling transaction VB(7, and all invoices fit the criterien would be considered. Is there a way to find all these invoices?


I am waiting online , thanks!!!


Regards



Message was edited by: G Lakshmipathi

Avoid using "Urgent", "Waiting Online" etc., You have to wait till you get some feedback from members




Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jul 07, 2016 at 04:02 PM

    Recke,

    Let me give a non-SAP example:

    There are two big buckets which are empty, placed on a table.

    You pour mugs of water into either of the two buckets. The more mugs you pour, the water level rises in those buckets.

    Then, you want to take out some mugs of water from the buckets because you want to give water away.

    The table is the rebate agreement.

    The buckets are the rebate condition records.

    The mugs of water to fill the bucket are the sales invoices.

    The water is the accrual.

    The mugs of water to give away (and reduce the level of water in the bucket) are the settlements to customers.

    Accumulation of accruals happen at bucket or condition record level. These are labelled with condition type + variable key combination.

    If you want to link mugs of water to fill and the mugs of water to empty at bucket (condition record) level, then you need to filter based on cond type + variable key combination level, in both processes.

    But if you have only one bucket (one condition record) you cannot find out for which mugs of water which raised the level of water in the bucket are linked with which mugs of water which emptied the level of water.

    TW

    Add a comment
    10|10000 characters needed characters exceeded

    • one more question , can we addup accurals manually without creating documents, because we are facing the problem of how to migrate the old accurals into the sap system.

      Recke,

      When finance/invoicing department creates a back dated rebate agreement, agreement created today, but valid from date is 01.Jan.2016. Then business uses VBOF transaction to build up the accruals.

      When you want to transition from a legacy system to SAP, sales billing documents not in SAP, then things become more complicated and a migration/cut over plan needs to be in place, with validations of figures before go live.

      There are two ways to build manual accrual - one with documents (accrual credit notes) and the other is changes at table level. I would strongly oppose changes at table level. I don't know what could be the impact of this.

      Maybe create a few accrual document cycle with aggregated accruals.

      TW

  • Posted on Jul 07, 2016 at 10:57 AM

    Recke,

    VBRK-KNUMA gives you the rebate agreement no. is all the settlement (partial, final and accrual) billing documents. This is because the respective CMR are created from the agreement and not from VA01.

    The logic you have sited is for billing documents related to the sales cycle, where accruals are created, cumulated in a rebate agreement.

    TW

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Typewriter TW

      Hi TW,

      sorry to confuse you. I mean , linkage is a method I try to use, the purpose is to bring some information from sales document to the rebate credit memo/ invoice.

      If it is as you said, there is no way to bring info from sales document. Do you know, if this information can be found in the agreement ? maybe there is a way to find e.g. the calculate base on which the accural will be calculated ???

      I know Vistex is a product to provide enhanced solutions regarding this, but it would be not possible to persuade customer to use this ....

      regards

  • Posted on Jul 07, 2016 at 02:02 PM

    Have a look at this thread

    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi G Lakshmipathi

      thanks, I have already checked the thread, but it does not really help to solve the linkage from sales billing to settlement ( CMR ), please kindly check the example above.

      what in that thread provide is how to find all invoices related to one agreement.

      but thanks anyway

  • Posted on Jul 22, 2016 at 05:30 AM

    via VA01 - VF01 : - order 1- invoice1; order2 - invoice 2; order 3- invoice 3

    via VB(7 : one CMR1 ( Rebate Credit Memo ) is created for these 3 invoices above.

    via VF01 : create invoice100 for this CMR

    via VA01 - VF01 : - order 4- invoice4; order5 - invoice 5; order 6- invoice 6

    via VB(7 : one CMR2 ( Rebate Credit Memo ) is created for these 3 invoices above.

    via VF01 : create invoice200 for this CMR

    Now, my question is, from the last invoice100 , how can I find invoices 1, 2, 3

    Recke,

    The same question is asked in https://scn.sap.com/thread/560920

    Step 1: Create rebate agreement number-100 for customer X.

    Step 2: Create two invoices 90000001 and 90000002 for the customer.

    Step 3: Create final settlement for the agreement and raise a credit memo number 60000001.

    Now i need a way of finding for the CM (60000001) the list of invoices . I.e. by giving the input as CM (60000001) the list of invoices (90000001 and 90000002) needs to be displayed.

    I think the OP has not designed the solution correctly. None the less, it might give you an idea that this is a business need from many customers of SAP and is unresolved.

    TW

    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.