-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- tax calculation.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tax calculation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2007 Jun 04 12:33 PM
- SAP Managed Tags
- ABAP Development
Dear firends
I am having one problem is with Tax calculation, I am calculating 2 types of tax one is with education cess and another without it. my problem is i found the amount which i have calculated which is not proper,
please look at my code and tell me where i am making mistakes.
regards
Naeem
loop at t_komv .
IF ( t_komv-waers = '%' OR
t_komv-kschl = 'JSRE' OR
t_komv-kschl = 'JSRF' OR
t_komv-kschl = 'JES8' ).
IF t_komv-kschl = 'JSRE' .
g_percentage = t_komv-kbetr / 10.
ELSEIF t_komv-kschl = 'JSRF'.
g_percentage1 = t_komv-kbetr / 10.
ELSEif t_komv-kschl = 'JES8'.
g_percentage2 = t_komv-kbetr / 10.
ENDIF.
ADD t_komv-kwert TO l_stax1-amt. <---- here i am not receiving the correct amount. ( on 20000 @12.36 it should be 2472 but i am receiving @12.24% 2448)
ENDIF.
IF ( t_komv-waers = '%' OR
t_komv-kschl = 'JSER' OR
t_komv-kschl = 'JSVD' ).
IF t_komv-kschl = 'JSER' .
g_percentage = t_komv-kbetr / 10.
ELSEif t_komv-kschl = 'JSVD'.
g_percentage1 = t_komv-kbetr / 10.
ENDIF.
ADD t_komv-kwert TO l_stax1-amt. (here i receive correct result 10000 @ 12.24% 1224).
ENDIF.
IF ( t_komv-waers = '%' OR
t_komv-kschl = 'JSRC' OR
t_komv-kschl = 'JSRD' OR
t_komv-kschl = 'JES3' ).
IF t_komv-kschl = 'JSRC' .
g_percentage = t_komv-kbetr / 10.
ELSEIF t_komv-kschl = 'JSRD'.
g_percentage1 = t_komv-kbetr / 10.
ELSEif t_komv-kschl = 'JES3'.
g_percentage2 = t_komv-kbetr / 10.
ENDIF.
ADD t_komv-kwert TO l_stax1-amt.
*add t_komv-kwert to l_stax-amt.
ENDIF.
IF ( ( g_percentage IS NOT INITIAL AND
g_percentage1 IS NOT INITIAL AND
g_percentage2 IS NOT INITIAL ) AND
( t_komv-kschl = 'JSRE' OR
t_komv-kschl = 'JSRF' OR
t_komv-kschl = 'JSER' OR
t_komv-kschl = 'JSVD' OR
t_komv-kschl = 'JSRC' OR
t_komv-kschl = 'JSRD' OR
t_komv-kschl = 'JES8' OR
t_komv-kschl = 'JES3') ).
g_mul = g_percentage * ( g_percentage1 + g_percentage2 ).
g_percentage3 = g_percentage + ( g_mul / 100 ).
l_stax1-per = g_percentage3.
COLLECT l_stax1 INTO it_stax.
wa_sitem-item = <fs>-ebelp.
wa_sitem-per = l_stax1-per.
SHIFT wa_sitem-item LEFT DELETING LEADING '0'.
APPEND wa_sitem TO it_sitem.
CLEAR wa_sitem.
*append l_stax1 to it_stax.
CLEAR : g_percentage, g_percentage1 ,g_percentage2 .
ENDIF.
elseif
( ( g_percentage IS NOT INITIAL AND
g_percentage1 IS NOT INITIAL AND
g_percentage2 IS INITIAL ) AND
( t_komv-kschl = 'JSRE' OR
t_komv-kschl = 'JSRF' OR
t_komv-kschl = 'JSER' OR
t_komv-kschl = 'JSVD' OR
t_komv-kschl = 'JSRC' OR
t_komv-kschl = 'JSRD' ) ).
g_mul = g_percentage * g_percentage1 .
g_percentage3 = g_percentage + ( g_mul / 100 ).
l_stax1-per = g_percentage3.
COLLECT l_stax1 INTO it_stax.
wa_sitem-item = <fs>-ebelp.
wa_sitem-per = l_stax1-per.
SHIFT wa_sitem-item LEFT DELETING LEADING '0'.
APPEND wa_sitem TO it_sitem.
CLEAR wa_sitem.
*append l_stax1 to it_stax.
CLEAR : g_percentage, g_percentage1 .
ENDIF.
*comment ends here
ENDLOOP.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2007 Jun 04 12:50 PM
- SAP Managed Tags
- ABAP Development
HI naim,
i have done the same check my code,
SELECT VBELN FKART FKDAT KNUMV
FROM VBRK
INTO CORRESPONDING FIELDS OF TABLE IT_VBRK
WHERE FKDAT IN S_DATE.
IF IT_VBRK[] IS NOT INITIAL.
SELECT VBELN POSNR MATNR FKIMG NETWR WERKS VKORG_AUFT PRCTR
FROM VBRP
INTO CORRESPONDING FIELDS OF TABLE IT_VBRP
FOR ALL ENTRIES IN IT_VBRK
WHERE VBELN = IT_VBRK-VBELN
AND WERKS IN S_WERKS
AND VKORG_AUFT IN S_VKORG.
ENDIF.
IF IT_VBRK[] IS NOT INITIAL.
SELECT KNUMV KPOSN KWERT KBETR
FROM KONV
INTO CORRESPONDING FIELDS OF TABLE IT_KONV
FOR ALL ENTRIES IN IT_VBRK
WHERE KNUMV = IT_VBRK-KNUMV.
ENDIF.
IF IT_VBRK[] IS NOT INITIAL.
SELECT KNUMV KPOSN KSCHL
KWERT KBETR
INTO CORRESPONDING FIELDS OF TABLE IT_COND
FROM KONV
FOR ALL ENTRIES IN IT_VBRK
WHERE KNUMV = IT_VBRK-KNUMV.
ENDIF.
SORT IT_COND BY KWERT DESCENDING.
LOOP AT IT_VBRP.
READ TABLE IT_VBRK WITH KEY VBELN = IT_VBRP-VBELN.
READ TABLE IT_COND WITH KEY KNUMV = IT_VBRK-KNUMV KPOSN = IT_VBRP-POSNR KSCHL = 'MWST'.
*here u can check for other condition
IF SY-SUBRC = 0.
IT_FINAL-VBELN = IT_VBRK-VBELN.
IT_FINAL-FKART = IT_VBRK-FKART.
IT_FINAL-FKDAT = IT_VBRK-FKDAT.
IT_FINAL-MATNR = IT_VBRP-MATNR.
IT_FINAL-FKIMG = IT_VBRP-FKIMG.
IT_FINAL-NETWR = IT_VBRP-NETWR.
IT_FINAL-WERKS = IT_VBRP-WERKS.
IT_FINAL-VKORG_AUFT = IT_VBRP-VKORG_AUFT.
IT_FINAL-PRCTR = IT_VBRP-PRCTR.
IT_FINAL-KWERT = IT_COND-KWERT.
IT_FINAL-KBETR = IT_COND-KBETR.
APPEND IT_FINAL.
ENDIF.
ENDLOOP.
LOOP AT IT_FINAL.
IT_FINAL-KBETR = IT_FINAL-KBETR / 10.
MODIFY IT_FINAL TRANSPORTING KBETR.
ENDLOOP.
dont forget to reward points,
Regards,
Imran
Dear firends
I am having one problem is with Tax calculation, I am calculating 2 types of tax one is with education cess and another without it. my problem is i found the amount which i have calculated which is not proper,
please look at my code and tell me where i am making mistakes.
regards
Naeem
loop at t_komv .
IF ( t_komv-waers = '%' OR
t_komv-kschl = 'JSRE' OR
t_komv-kschl = 'JSRF' OR
t_komv-kschl = 'JES8' ).
IF t_komv-kschl = 'JSRE' .
g_percentage = t_komv-kbetr / 10.
ELSEIF t_komv-kschl = 'JSRF'.
g_percentage1 = t_komv-kbetr / 10.
ELSEif t_komv-kschl = 'JES8'.
g_percentage2 = t_komv-kbetr / 10.
ENDIF.
ADD t_komv-kwert TO l_stax1-amt. <---- here i am not receiving the correct amount. ( on 20000 @12.36 it should be 2472 but i am receiving @12.24% 2448)
ENDIF.
IF ( t_komv-waers = '%' OR
t_komv-kschl = 'JSER' OR
t_komv-kschl = 'JSVD' ).
IF t_komv-kschl = 'JSER' .
g_percentage = t_komv-kbetr / 10.
ELSEif t_komv-kschl = 'JSVD'.
g_percentage1 = t_komv-kbetr / 10.
ENDIF.
ADD t_komv-kwert TO l_stax1-amt. (here i receive correct result 10000 @ 12.24% 1224).
ENDIF.
IF ( t_komv-waers = '%' OR
t_komv-kschl = 'JSRC' OR
t_komv-kschl = 'JSRD' OR
t_komv-kschl = 'JES3' ).
IF t_komv-kschl = 'JSRC' .
g_percentage = t_komv-kbetr / 10.
ELSEIF t_komv-kschl = 'JSRD'.
g_percentage1 = t_komv-kbetr / 10.
ELSEif t_komv-kschl = 'JES3'.
g_percentage2 = t_komv-kbetr / 10.
ENDIF.
ADD t_komv-kwert TO l_stax1-amt.
*add t_komv-kwert to l_stax-amt.
ENDIF.
IF ( ( g_percentage IS NOT INITIAL AND
g_percentage1 IS NOT INITIAL AND
g_percentage2 IS NOT INITIAL ) AND
( t_komv-kschl = 'JSRE' OR
t_komv-kschl = 'JSRF' OR
t_komv-kschl = 'JSER' OR
t_komv-kschl = 'JSVD' OR
t_komv-kschl = 'JSRC' OR
t_komv-kschl = 'JSRD' OR
t_komv-kschl = 'JES8' OR
t_komv-kschl = 'JES3') ).
g_mul = g_percentage * ( g_percentage1 + g_percentage2 ).
g_percentage3 = g_percentage + ( g_mul / 100 ).
l_stax1-per = g_percentage3.
COLLECT l_stax1 INTO it_stax.
wa_sitem-item = <fs>-ebelp.
wa_sitem-per = l_stax1-per.
SHIFT wa_sitem-item LEFT DELETING LEADING '0'.
APPEND wa_sitem TO it_sitem.
CLEAR wa_sitem.
*append l_stax1 to it_stax.
CLEAR : g_percentage, g_percentage1 ,g_percentage2 .
ENDIF.
elseif
( ( g_percentage IS NOT INITIAL AND
g_percentage1 IS NOT INITIAL AND
g_percentage2 IS INITIAL ) AND
( t_komv-kschl = 'JSRE' OR
t_komv-kschl = 'JSRF' OR
t_komv-kschl = 'JSER' OR
t_komv-kschl = 'JSVD' OR
t_komv-kschl = 'JSRC' OR
t_komv-kschl = 'JSRD' ) ).
g_mul = g_percentage * g_percentage1 .
g_percentage3 = g_percentage + ( g_mul / 100 ).
l_stax1-per = g_percentage3.
COLLECT l_stax1 INTO it_stax.
wa_sitem-item = <fs>-ebelp.
wa_sitem-per = l_stax1-per.
SHIFT wa_sitem-item LEFT DELETING LEADING '0'.
APPEND wa_sitem TO it_sitem.
CLEAR wa_sitem.
*append l_stax1 to it_stax.
CLEAR : g_percentage, g_percentage1 .
ENDIF.
*comment ends here
ENDLOOP.
Bluesky
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2007 Jun 04 12:50 PM
- SAP Managed Tags
- ABAP Development
HI naim,
i have done the same check my code,
SELECT VBELN FKART FKDAT KNUMV
FROM VBRK
INTO CORRESPONDING FIELDS OF TABLE IT_VBRK
WHERE FKDAT IN S_DATE.
IF IT_VBRK[] IS NOT INITIAL.
SELECT VBELN POSNR MATNR FKIMG NETWR WERKS VKORG_AUFT PRCTR
FROM VBRP
INTO CORRESPONDING FIELDS OF TABLE IT_VBRP
FOR ALL ENTRIES IN IT_VBRK
WHERE VBELN = IT_VBRK-VBELN
AND WERKS IN S_WERKS
AND VKORG_AUFT IN S_VKORG.
ENDIF.
IF IT_VBRK[] IS NOT INITIAL.
SELECT KNUMV KPOSN KWERT KBETR
FROM KONV
INTO CORRESPONDING FIELDS OF TABLE IT_KONV
FOR ALL ENTRIES IN IT_VBRK
WHERE KNUMV = IT_VBRK-KNUMV.
ENDIF.
IF IT_VBRK[] IS NOT INITIAL.
SELECT KNUMV KPOSN KSCHL
KWERT KBETR
INTO CORRESPONDING FIELDS OF TABLE IT_COND
FROM KONV
FOR ALL ENTRIES IN IT_VBRK
WHERE KNUMV = IT_VBRK-KNUMV.
ENDIF.
SORT IT_COND BY KWERT DESCENDING.
LOOP AT IT_VBRP.
READ TABLE IT_VBRK WITH KEY VBELN = IT_VBRP-VBELN.
READ TABLE IT_COND WITH KEY KNUMV = IT_VBRK-KNUMV KPOSN = IT_VBRP-POSNR KSCHL = 'MWST'.
*here u can check for other condition
IF SY-SUBRC = 0.
IT_FINAL-VBELN = IT_VBRK-VBELN.
IT_FINAL-FKART = IT_VBRK-FKART.
IT_FINAL-FKDAT = IT_VBRK-FKDAT.
IT_FINAL-MATNR = IT_VBRP-MATNR.
IT_FINAL-FKIMG = IT_VBRP-FKIMG.
IT_FINAL-NETWR = IT_VBRP-NETWR.
IT_FINAL-WERKS = IT_VBRP-WERKS.
IT_FINAL-VKORG_AUFT = IT_VBRP-VKORG_AUFT.
IT_FINAL-PRCTR = IT_VBRP-PRCTR.
IT_FINAL-KWERT = IT_COND-KWERT.
IT_FINAL-KBETR = IT_COND-KBETR.
APPEND IT_FINAL.
ENDIF.
ENDLOOP.
LOOP AT IT_FINAL.
IT_FINAL-KBETR = IT_FINAL-KBETR / 10.
MODIFY IT_FINAL TRANSPORTING KBETR.
ENDLOOP.
dont forget to reward points,
Regards,
Imran
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2007 Jun 04 1:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2007 Jun 04 1:16 PM
- SAP Managed Tags
- ABAP Development
No , Only in frist case.. where calculation is at 12.36% but i am having result at 12.24%
regards
naeem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2007 Jun 04 1:31 PM
- SAP Managed Tags
- ABAP Development
I hope u are doing for P.O. or INVOICE, please debug it find, ihope u r missing some condition types or rounding off problem.
regards
prabhu
reward if helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2007 Jun 13 6:32 AM
- SAP Managed Tags
- ABAP Development
I have used At end of kposn
endat.
and use flag to refresh this thing
it workes
regards
naeem
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
