Problem with VAT

[Former Member]

Dear All,

I have to show both Sales Price and VAT in same ALV grid, i, e using tcode VK13, I have to show this. Users use VK13

condition type(KSCHL)- VKP0 to see the sales price(KBETR) values and
                       ZVT1 to see VAT(KBETR) values.

But they dont want to use radio buttons now, they need to see both the Sales Price and VAT in same grid. I tried several ways. But the problem here i found is Sales Price uses table A073 for getting Condition record no(KNUMH), where VAT uses table A004 for getting Condition record no(KNUMH). But the table KONP holds both Sales Price and VAT in KBETR,based on KNUMH. I am unable to marge this two tables. The selection parameters will be - Sales Org(VKORG), Distribution Channel(VTWEG), Material no(MATNR), Valid on(DATAM). Plz give me some idea.

With regards,

Roslaine.

[Former Member]

Please help me with any suggestion or idea.

With regards,

Rosaline

[eduardo_hinojosa]

Hi Rosaline,

I copy a coding to get the data of percentage of VAT (in my case for Spain, check in tcode FTXP the parameters for your country) as a sample for your coding.

  data: clasif_mt like mlan-taxm1,
        clasif_cl like knvi-taxkd,
        percentage like konp-kbetr.


  select single taxm1 into clasif_mt from mlan
      where matnr = p_matnr
      and   aland = 'ES'.

  select single taxkd into clasif_cl from knvi
      where kunnr = p_kunnr
      and   aland = 'ES'
      and   tatyp = 'MWST'.        "your SD condition (VK13)

  select * from a002
    into table i_a002
      where kappl = 'V'
      and   kschl = 'MWST'
      and   aland = 'ES'
      and   taxk1 = clasif_cl
      and   taxm1 = clasif_mt.

  delete i_a002 where datbi < pp_fecha.

  read table i_a002 index 1.   "??? debug it and see the data

  select single * from konp
     where knumh = i_a002-knumh.

  percentage = konp-kbetr / 10.

I hope this helps you

Regards

Eduardo

[Former Member]

Thanks E_Hinojosa for your reply. But these tables contain no value here. Need any other idea.

With regards,

Rosaline.

[eduardo_hinojosa]

Hi

Check in VK13 (or in customizing sequence access, V/07) for the VAT condition in which table you store this data (in my case, table A002). After, with field KNUMH search the value condition in KONP. Tcode FTXP will tell you the info related with VAT scheme.

Regards

Eduardo