Skip to Content
0
Jul 19, 2018 at 03:36 AM

SAP B1 Used budget information

169 Views Last edit Jul 19, 2018 at 03:37 AM 2 rev

HI All,

We are trying to query out the 'budget used for the GL account and cost centre' using SQL. Found out that if you dont specify the distribution rule in Budget scenario, we can get the values from the BGT1 table, columns like DebRLTotal, DebRLTotal.. keeps the value.

How ever, if there is a dimention specified, these columns are not getting updated. Anyone knows where SAP stores this information? or is it a running calculation?