Reg:Tax Table In Purchase Order

[former_member585865]

Hi All,

In the Purchase Order Line Item Level We will Give Tax I.e In the Invoice tab We have our required tax codes the the taxes button will enable when we click taxes all the taxes will come my question is coils anybody say in which table all the tax details for a Purchase Order is Stored? i have checked the table KONV

only the Header Conditions is Stored in that table.could you please help me?

[Former Member]

Chcek table KONM...

Rgds,

Pavan

[Former Member]

use Function Module CALCULATE_TAX_ITEM for getting taxes under invoicing tab in PO.

[former_member585865]

Hi Vijetasap,

i have tried that function module it doesn't return the values thats y i asked the table name, i have attached the code for my reference just correct me where am wrong?

LOOP AT I_EKPO.

clear taxcom.

CLEAR : I_KOMV.

REFRESH : I_KOMV.

SELECT SINGLE *

INTO t001

FROM t001

WHERE bukrs = ekko-bukrs .

taxcom-bukrs = i_ekpo-bukrs.

taxcom-budat = ekko-bedat.

taxcom-waers = ekko-waers.

taxcom-kposn = i_ekpo-ebelp.

taxcom-mwskz = i_ekpo-mwskz.

taxcom-txjcd = i_ekpo-txjcd.

taxcom-shkzg = 'H'.

taxcom-xmwst = 'X'.

IF I_EKPO-MTART = 'HAWA'.

taxcom-wrbtr = i_ekpo-kzwi6.

ELSEIF I_EKPO-MTART = 'ROH'.

taxcom-wrbtr = i_ekpo-kzwi4.

ENDIF.

ELSE.

taxcom-wrbtr = i_ekpo-zwert.

ENDIF.

taxcom-lifnr = ekko-lifnr.

taxcom-land1 = ekko-lands.

taxcom-ekorg = ekko-ekorg.

taxcom-hwaer = t001-waers.

taxcom-llief = ekko-llief.

taxcom-bldat = ekko-bedat.

taxcom-matnr = i_ekpo-ematn.

taxcom-werks = i_ekpo-werks.

taxcom-bwtar = i_ekpo-bwtar.

taxcom-matkl = i_ekpo-matkl.

taxcom-meins = i_ekpo-meins.

taxcom-ebeln = i_ekpo-ebeln.

taxcom-ebelp = i_ekpo-ebelp.

IF ekko-bstyp EQ bstyp-best.

taxcom-mglme = i_ekpo-menge.

ELSE.

IF ekko-bstyp EQ bstyp-kont AND i_ekpo-abmng GT 0.

taxcom-mglme = i_ekpo-abmng.

ELSE.

taxcom-mglme = i_ekpo-ktmng.

ENDIF.

ENDIF.

IF taxcom-mglme EQ 0.

taxcom-mglme = 1000.

ENDIF.

taxcom-mtart = i_ekpo-mtart.

IF NOT TAXCOM-mwskz IS INITIAL.

CALL FUNCTION 'CALCULATE_TAX_ITEM'

EXPORTING

• ANZAHLUNG = ' '

• DIALOG = ' '

• DISPLAY_ONLY = ' '

• INKLUSIVE = ' '

• I_ANWTYP = ' '

• I_DMBTR = '0'

• I_MWSTS = '0'

I_TAXCOM = taxcom

• PRUEFEN = ' '

• RESET = ' '

IMPORTING

• E_NAVFW =

E_TAXCOM = taxcom

• E_XSTVR =

• NAV_ANTEIL =

TABLES

T_XKOMV = i_komv

EXCEPTIONS

MWSKZ_NOT_DEFINED = 1

MWSKZ_NOT_FOUND = 2

MWSKZ_NOT_VALID = 3

STEUERBETRAG_FALSCH = 4

COUNTRY_NOT_FOUND = 5

OTHERS = 6

.

.Note: Am not given Full Code but this is the part where am getting the tax values.

[Former Member]

Did u try this FM in SE37 . Just test it there what is it returning???? It worked for me thats y i m asking may be u r missing some varable or may be tax code.

[GauthamV]

Did you check these tables ?

KONH,KONP.

[former_member585865]

Hi Gautham,

I have Checked It That Tables Doesn't Contain The Values.

[GauthamV]

Try EKPO.

[Former Member]

table name : konv

c_lv_knumv = wa_ekko-knumv.

select * from konv appending table itab_lt_konv where knumv EQ

c_lv_knumv and

kposn EQ wa_ekpo-ebelp.

hope this helps u

[former_member585865]

Hi Monica,

According To Your Query the Header Condition Table Values Only come i just need the taxing values

i.e when you click the invoice tab a tax button will appear i need that taxing values.

[GauthamV]

Table : T007A