How to print Excise values in Purchase Order Smartform

[Former Member]

Hi, Experts,

I am developing the Purchase Order Smartform as per the my client requirment. For this i took the copy of standard Smartform for PO. The name of the standard smartform is 'YBIN_MMPO'. My requirment is to print all the excise values {BED,CESS,ECESS and VAT/CST} of every item. How to get these conditions to print in PO. I serched the table KONV, but the conditions which are under the taxes button are not stored in this table.

For this I found one FM "CALCULATE_TAX_FROM_AMOUNT'. This is also not helpful if client goes to manual excise to create PO.

Is there any other table to get these conditions? or is there any function modules to get these conditions?

Please give me the solution.

Thanks & regards,

Jagadeesh.

[Former Member · Accepted solution]

Hi

Check the Function Modules : CALCULATE_TAX_ITEM,

GET_TAX_PERCENTAGE.

Vishwa.

[Former Member · Accepted solution]

Hi Vishwa,

Thanks for your immediate replay. I have tested this function module CALCULATE_TAX_ITEM . I got all conditions under taxes tab correctly if PO is in not manual excise case. I am not able to get the correct values in Manual Excise case. Can please explain how to use this fuction module if i create a PO with manual excise.

Regards,

Jagadeesh.

[Former Member]

Hi Jaghadesh,

Currently i am also getting that same problems,would u help me to how to get the excise value in smartform.actually i got the Excise value and Sales tax values bt i dont know how to get the Manual excise values.

Regards

murugesh

Edited by: Murugesh P on Feb 11, 2009 6:26 AM

[Former Member]

Hi,

I used this piece of code to get the excise values in PO.

SELECT SINGLE * FROM EKPO INTO

W_EKPO

WHERE EBELN EQ IS_EKKO-EBELN AND

EBELP EQ <FS>-EBELP.

CALL FUNCTION 'J_1I4_COPY_PO_DATA'

EXPORTING

Y_EKPO = W_EKPO

• EXCCOM =

.

CALL FUNCTION 'CALCULATE_TAX_FROM_NET_AMOUNT'

EXPORTING

i_bukrs = <FS>-BUKRS

i_mwskz = <FS>-MWSKZ

• I_TXJCD =

i_waers = IS_EKKO-WAERS

i_wrbtr = <FS>-NETWR

• I_ZBD1P = 0

• I_PRSDT =

• I_PROTOKOLL =

• I_TAXPS =

• I_ACCNT_EXT =

• IMPORTING

• E_FWNAV =

• E_FWNVV =

• E_FWSTE =

• E_FWAST =

tables

t_mwdat = ITAB_TAXDATA

EXCEPTIONS

BUKRS_NOT_FOUND = 1

COUNTRY_NOT_FOUND = 2

MWSKZ_NOT_DEFINED = 3

MWSKZ_NOT_VALID = 4

KTOSL_NOT_FOUND = 5

KALSM_NOT_FOUND = 6

PARAMETER_ERROR = 7

KNUMH_NOT_FOUND = 8

KSCHL_NOT_FOUND = 9

UNKNOWN_ERROR = 10

ACCOUNT_NOT_FOUND = 11

TXJCD_NOT_VALID = 12

OTHERS = 13

.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

ENDIF.

regards,

Jagadeesh T.