cancel
Showing results for 
Search instead for 
Did you mean: 

Custom pricing and rebate reports

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.