on 08-02-2011 6:39 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.