I need to find Discount/ QST /GST/ detenstion/ logistics adder/ fuel surcharge/vendor commision of a sales order how to do it.
This is what i have thought of let me know if i am going in correct way.
- I have condition types for all the above
| Condition type(kschl) |
|---|
Discount | RB00 |
| QST | ZQST |
| GST | ZQST |
| detenstion | Zk09 / Zfh1 |
| logistics adder | Ze03 |
| fuel surcharge | Zrc45 |
| vendor commision | Zcar / Zdrt |
|
|
- Now i fill a select options(so_type)with the above kschl in (low/I/EQ)
- Now i write a query
select knumv kwert
from konv
into table lt_cond
for all entries of lt_vbak
where knumv = lt_vbak-knumv and kschl in so_type
- Now i loop the the lt_cond table
loopat lt_cond into ls_cond.
"GST canada tax
if ls_condition-Kschl = 'ZQST'.
Ls_GST-konv=ls_condition-konv.
Ls_GST-kwert=ls_condition-kwert.
append Ls_GST to LT_GST.
endif.
"detension
if ls_condition-Kschl = 'Zk09' or s_condition-Kschl = 'Zfh1'
.
Ls_detension-konv=ls_condition-konv.
Ls_detension-kwert=ls_condition-kwert.
append Ls_detension to LT_detension.
endif.
endloop.
so Ls_detension-kwert will have the detension value of respective knumv..is it possible..please help meout
