topic Re: SD tables for Tax code in Application Development and Automation Discussions

SD tables for Tax code

former_member445510 — Mon, 21 Oct 2013 08:30:18 GMT

Hello,

knows some one which table(s) from SD should i use, to gave in those input data :

Ship From
Ship To
Material
Customer Country
Billing Country
.......

And receive a tax code as output data ?

thank you in advance for your reply.

Re: SD tables for Tax code

Former Member — Mon, 21 Oct 2013 08:46:20 GMT

For

1 and 2.Ship to and ship from /Sold to party use VBPA table with PARVW = RE and WE as deciding factor for ship to and ship from.

3. matnr (Material) ---> VBAP

4.Take kunnr field (customer no ) from VBPA and pass kunnr no to KNA1 table to get the Land1 field (country ).

For Tax code , Pass knumv value of VBAK into the KONV knumv table get tax details.

Re: SD tables for Tax code

former_member445510 — Mon, 21 Oct 2013 09:12:34 GMT

Thank u very much madhukumar,

It's helpful answer, can you show me:

1 - From where can i get the billing country ?

2 - And how can i create ABAP query from those tables ( VBPA, VBAK, KONV ) to get tax details ?

thank you madhukumar in advance for your reply.

madhukumar lakshmana

Re: SD tables for Tax code

Former Member — Mon, 21 Oct 2013 09:48:56 GMT

Select * from VBAK into wa_vbak where vbeln = p_vbeln.

select * from VBPA into table IT_VBPA where vbeln = wa_vbak-vbeln and parvw in (RE,WE).

write parvw condition based on sold to party or ship to party.

For country :

select * from kna1 into table it_kna1 for all entires in it_vbpa where kunnr = it_vbpa-kunnr .

you ll get kna1-land1 ll give country of sold to party and ship to party.

select * from konv into table it_konv where knumv = wa_vbak-knumv . " Tax details

Re: SD tables for Tax code

former_member212148 — Mon, 21 Oct 2013 09:55:56 GMT

Hi,

You will get billing country from VBRK table (VBRK-LAND1)

Match VBELN filed from VBPA and VBAK table.

after that match knumv field from vbak and konv table.

Regards,

Ranjit K.

Re: SD tables for Tax code

former_member445510 — Mon, 21 Oct 2013 13:19:15 GMT

Thank u madhukumar,

is ship to party equal to sold to party ?

Or what is the difference between ship to party and sold to party ?

Re: SD tables for Tax code

Former Member — Tue, 22 Oct 2013 02:47:56 GMT

Dear roukbi,

If u have manufacturing company then you ll have company situated in one place and warehouse might be in other place then

Ship to Party means Delivery Address ( warehouse address )

Sold to party means Company Address

In some company ship to party and sold to party will be same .

Re: SD tables for Tax code

former_member445510 — Tue, 22 Oct 2013 07:21:48 GMT

Thank u very much madhukumar.

Re: SD tables for Tax code

Former Member — Tue, 22 Oct 2013 08:19:40 GMT

Its ok 🙂 🙂 Former Member