Skip to Content
avatar image
Former Member

Custom pricing and rebate reports

Hello,

We need to develop a custom ABAP report. This report will pull the pricing and rebate condition typedata from invoices. We need an ABAP report since this reort will be sent to a non sap system through middleware ( this is the requirement )..

the seection criteria to be used is billing doc type/billing date/sales org

dist chnl/div.

My questions are as follows :-

A ) for pricing conditions

-


how will we fetch all the pricing related condition types. Pls if someone can inform the logic to be built to pick pricing condition types(like discount/base price etc) for each line item invoice. Also how can the value which is appearing against " gross price " and subtotals be pickd plus how can the value of a condition type which is determined throug formula be pickd. Pls mention the link from selection criteria above and the link to be formed for all the pricing condition tables in order to access the data relating to all pricing condition types of a invoice line item. I do not think so we can use structures since structures are avaibale at run time.

B) for rebate conditions

-


how will we fetch all the rebate related condition types. Pls if someone can inform the logic to be built to pick rebate condition types for each line item invoice. Pls mention the link from selection criteria above and the link to be formed for all the rebate condition tables in order to access the data relating to all rebate condition types of a invoice line item. I do not think so we can use structures since structures are avaibale at run time.

C) Rebate condition agreement

-


Also pls inform how to extract data(based on selection criteria above like billing type/sales org etc) from rebate agreements relating to partial settlement/full settlement/accruals/sales volume/invoice no/rebatre credit memo/debit memo/accrual reversed

regards

Pamela

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 07, 2011 at 04:34 PM

    For A and B

    1. The net price list allows you to provide your customers with pricing information on materials .

    Path : sales and distributionu2014master datau2014conditionsu2014list

    Transaction code: V_NL

    Program:SDNETPR0

    We can also develop the Zu2019 program with multiple customers range .

    2. The function module CALL FUNCTION 'GN_INVOICE_CREATE' in SDNETPR0 program is critical .

    The above function module simulates billing document with pricing procedure.

    The above program works for materials with item category which are relevant for pricing (item category customization field pricing should not be blank i.e. no pricing.

    3. The link between SD document with KONV

    VBRK-KNUMV = KONV-KNUMV.

    VBRK / VBAK - KNUMV will give you the link to KONV.

    4. For C

    Rebates tables KONA,VBOX will be useful in addition to VBAK,VBRK,KONH tables. RV15C001 program may help you understand rebate tables.

    tables:

    T685A,KONP,T6B1,VBPA,KNVV,S060,VBRP,T683S

    function modules:

    SD_BONUS_READ

    REBATE_INDEX_BUILD

    RV_INVOICE_PRICING_PREPARE

    PRICING_REQUIREMENT_CHECK

    i think the above information is useful for custom reports on pricing and rebate.

    Add comment
    10|10000 characters needed characters exceeded