Skip to Content
0

How to take value from database in SAP B1 SDK?

Nov 27, 2017 at 01:38 PM

42

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Johan Hakkesteegt Nov 27, 2017 at 02:37 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded