on 01-18-2013 3:06 PM
Hi,
In Billing document at item level conditions, we can see all the condition types, CondType Names, Amount, Currency, Condition value etc like
CondType | Name | Amount | Crcy | Per | Unit | Condition Value |
---|---|---|---|---|---|---|
PR00 | Price | 1315 | EUR | 100 | KS | 1972.50 |
Gross | 1315 | EUR | 100 | KS | 1972.50 | |
K007 | Discount | 30- | % | 591.75- | ||
Discount Amount | 394.50- | EUR | 100 | KS | 591.75- | |
Total | 920.50 | EUR | 100 | KS | 1380.75 | |
My question is from which table/field we can get the value of Total as "920.50"? In technical information it is showing as structure KOMV-KBETR.
In KONV only PR00 and K007 are present.
In Pricing Procedure, Subtotal A (Carry over price to KOMP-CMPRE (credit price)) is present.
Please help. Points will be rewarded.
Thanks
VK
Hi,
Check NETWE field in VBRK or VBRP itself. It will give you the total value.
Regards
Leo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Leo,
There is no such fields in VBAK or VBAP
Check NETWE field in VBRK or VBRP itself. It will give you the total value.
I think you are talking about NETWR but this fields stores the total values of combinations of all the Condition types excluding of Condition types of condition class Taxes.
Plz let me know if you are telling something new.
Thanks,
Suman
Hi Vaibhav,
Basically all Condition types with values are stored in KONV table.And the SubTotal A (Carry over price to KOMP-CMPRE (credit price)) is calculated at the Run Time. This Sub Total value does not store the values in any table.
Now the Questions are ;
1. Can this Description Total be stored in a Table?
Ans : Yes, for that you have to assign the SubTotal values of Pricing Control data in V/08 and use the fields from SubTotal 1 to Subtotal 6 (KOMP-KZWI1 to KOMP-KZWI6).
Now save a sales document after these configuration and check the Table VBAP fields from VBAP-KZWI1 to VBAP-KZWI6. You will find the values are permanently stored in VBAP table.
2. Is there any other ways-out ?
Ans : Yes, for that you have incorporate the calculation formula in the ABAP codes with the help of ABAPers.
So, take your opportunity and do whatever you like.
Thanks,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.