Skip to Content

How to take value from database in SAP B1 SDK?

Hi all,

I want to get Rate % value from Tax groups - Setup under Administration/ Setup/ Financials/ Tax/ Tax Groups.

Actually I know how to take value from matrix of active form, but here I want to select data from database table OVTG in field of Rate % and Code, where I will have two variables like

rate=Rate % value

code=Code value

In active form I use column number and row number in order to take values from matrix

How can I take them from database?

Please anyone can help me

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 27, 2017 at 02:37 PM

    Hi,

    You can use a query against the OVTG and VTG1 tables or you can use the TaxDefinitions object from the DI API.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded