SD tables for Tax code

[former_member445510]

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.

[Former Member]

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.

[former_member445510]

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

[Former Member]

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 

[former_member212148]

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.

[former_member445510]

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 ?

[Former Member]

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 .

[former_member445510]

Thank u very much madhukumar.

[Former Member]

Its ok 🙂 🙂 Former Member