Tax amount in PO output

[sandeep_pv]

Hi

In PO smartform which table field we can pick for tax value printing. I am working in ECC 5.0 version.

While PO print tax value need to be printed.

How we can do this?

If anybody done this please tell me the logic.

Kindly advise.

Thanks

[Former Member · Accepted solution]

First read table EKPO for a PO and get condition no from this table. For this condition no KNUMV read table KONV for different tax conditions types.

anya

[sandeep_pv · Accepted solution]

Hi Anya,

Thanks. But in EKPO which is the field where we can see the condition record?

regards

[Former Member]

Hi,

I am on 4.6c.

In our Print Program ( Z opied from original ) we are calling the FM CALCULATE_TAX_ITEM. Just copy the following code, which is populating TAXCOM & calling the above FM which rerurns all 'TAX' conditions in TKOMV which you can use while printing PO.

REPORT ZMM_TEST_PRICING .

TABLES: EKKO, EKPO.

PARAMETERS: w_ebeln like ekko-ebeln,

w_ebelp like ekpo-ebelp.

data : begin of tkomv occurs 50.

include structure komv.

data : end of tkomv.

data : begin of taxcom occurs 50.

include structure taxcom.

data : end of taxcom.

data : begin of komk occurs 50.

include structure komk.

data : end of komk.

data : begin of komp occurs 50.

include structure komp.

data : end of komp.

DATA: calculation_type VALUE 'A'.

data: hwert like tkomv-kwert.

data : KALSM like t683s-kalsm value 'TAXINJ'.

select single * from ekko

where ebeln eq w_ebeln.

if sy-subrc eq 0.

select single * from ekpo

where ebeln eq w_ebeln

and ebelp eq w_ebelp.

if sy-subrc eq 0.

IF EKPO-MWSKZ NE SPACE.

CLEAR TAXCOM.

TAXCOM-BUKRS = EKPO-BUKRS.

TAXCOM-BUDAT = EKKO-BEDAT.

TAXCOM-WAERS = EKKO-WAERS.

TAXCOM-KPOSN = EKPO-EBELP.

TAXCOM-MWSKZ = EKPO-MWSKZ.

TAXCOM-TXJCD = EKPO-TXJCD.

TAXCOM-SHKZG = 'H'.

TAXCOM-XMWST = 'X'.

• IF EKKO-BSTYP EQ BSTYP-BEST.

TAXCOM-WRBTR = EKPO-NETWR.

• ELSE.

• TAXCOM-WRBTR = EKPO-ZWERT.

• ENDIF.

*- Beginn neue Felder zu 3.0C für internationale Steuermodule

TAXCOM-LIFNR = EKKO-LIFNR.

• taxcom-land1 = t001-land1.

TAXCOM-LAND1 = EKKO-LANDS. "WIA

TAXCOM-EKORG = EKKO-EKORG.

*? TAXCOM-GSBER = EKPO-KO_GSBER. "noch nicht versorgt bei uns

TAXCOM-HWAER = EKKO-WAERS.

TAXCOM-LLIEF = EKKO-LLIEF.

TAXCOM-BLDAT = EKKO-BEDAT.

• taxcom-matnr = ekpo-ematn.

TAXCOM-MATNR = EKPO-MATNR. "HTN-Abwicklung

TAXCOM-WERKS = EKPO-WERKS.

TAXCOM-BWTAR = EKPO-BWTAR.

TAXCOM-MATKL = EKPO-MATKL.

TAXCOM-MEINS = EKPO-MEINS.

*- Mengen richtig fuellen -

---

*

TAXCOM-MGLME = EKPO-MENGE.

IF TAXCOM-MGLME EQ 0. "falls keine Menge gesetzt --> auf 1 setzen

TAXCOM-MGLME = 1000. "z.B. bestellte Banf nochmal bestellt

ENDIF.

TAXCOM-MTART = EKPO-MTART.

CALL FUNCTION 'CALCULATE_TAX_ITEM'

EXPORTING

I_TAXCOM = TAXCOM

DISPLAY_ONLY = 'X'

• DIALOG = DIAKZ

DIALOG = '

'

IMPORTING

E_TAXCOM = TAXCOM

NAV_ANTEIL = HWERT

TABLES

t_xkomv = tkomv

EXCEPTIONS

OTHERS = 01.

• IF SY-SUBRC NE 0. "keine Reaktion, Exception eingebaut wegen

• ENDIF. "Problemen in Calculate_tax_item

ENDIF.

I Hope this helps,

Regards

Raju Chitale

[Former Member]

EKKO-KNUMV

[sandeep_pv]

Hi Anya,

If I am having a condition type in MM pricing schema where it display tax value , then I can pick value from your suggested table.

But I dont' have such condition type , in other words in ME21N screen I cannot see tax value in 'Conditions' tab. I can only see tax value in 'Invoice' tab.

How I can pick this value from here?

Please advise.

Thanks

[former_member196280]

I guess you tax percentage and rest will be picked from your condition table. If I am not wrong goto pricing condition table(condition records) see the tax percentage maintained for that PO and build a logic for calculating tax on amount inside your program.

Regards,

SaiRam

[sandeep_pv]

Hi,

Are you saying to calculate tax inside print program?

There are two pricing procedures, one is tax pricing proceudre which is FI settings, seconfd is MM pricing settings.

In my MM pricing , it will not display tax amount anywhere, means in PO'conditions' tab , it will not come.

But tax will calculate according to tax pricing proceudre and will be displayed in 'invoice' tab.

I cannot change MM pricing so that to adopt tax amount in this, because this is a roll out project and its the global template.

Tax is calculating in PO, normally in these types of situation how tax amount is getting printed in PO output.

If you don't mind ,please explain bit elaborately .

Thanks in advance.