biuan SAP® BUSINESS ONE SDK
DTW Financials / Budget Setup / Budget
API OBGT / Budget
OBGT - Budget Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
AcctCode KEY UNIQUEAccount CodenVarChar
15
ACCNT_CODEYes
BgdCodeDivision CodeInt
11OBGD
Budget Cost Assess. Mthd
FatherCode KEYParent Account KeynVarChar
15
INTER_KEYNo
FthrPrcntParent Acct %Num
20
DebLTotalTotal Annual Budget - Debit (LC)Num
20
CredLTotalTotal Annual Budget - Credit (LC)Num
20
DebSTotalTotal Annual Budget - Debit (SC)Num
20
CredSTotalTotal Annual Budget - Credit (SC)Num
20
DebRLTotalBudget Balance - Debit (LC)Num
20
CrdRLTotalBudget Balance - Credit (LC)Num
20
DebRSTotalBudget Balance - Debit (SC)Num
20
CrdRSTotalBudget Balance - Credit (SC)Num
20
FtrIDRLSumFuture Annual Revenues - Debit (LC)Num
20
FtrIDRSSumFuture Annual Revenues - Credit (SC)Num
20
FtrICRLSumFuture Revenues - Debit (LC)Num
20
FtrICRSSumFuture Revenues - Debit (SC)Num
20
FtrODRLSumFuture Annual Expenses - Credit (LC)Num
20
FtrOCRLSumFuture Annual Expenses - Debit (LC)Num
20
FtrODRSSumFuture Annual Expenses - Credit (SC)Num
20
FtrOCRSSumFuture Annual Expenses - Debit (SC)Num
20
FinancYearStart of Fiscal YearDate
8
InstanceInstanceInt
11OBGS
Budget Scenario
1
UserSignUser SignatureInt
6OUSR
Users
SCNCounterSCN CounterInt
6

Table relationship map

SELECT statement

SELECT OBGT.AbsId AS 'Internal Number', OBGT.AcctCode AS 'Account Code', OBGT.BgdCode AS 'Division Code', OBGT.FatherCode AS 'Parent Account Key', OBGT.FthrPrcnt AS 'Parent Acct %', OBGT.DebLTotal AS 'Total Annual Budget - Debit (LC)', OBGT.CredLTotal AS 'Total Annual Budget - Credit (LC)', OBGT.DebSTotal AS 'Total Annual Budget - Debit (SC)', OBGT.CredSTotal AS 'Total Annual Budget - Credit (SC)', OBGT.DebRLTotal AS 'Budget Balance - Debit (LC)', OBGT.CrdRLTotal AS 'Budget Balance - Credit (LC)', OBGT.DebRSTotal AS 'Budget Balance - Debit (SC)', OBGT.CrdRSTotal AS 'Budget Balance - Credit (SC)', OBGT.FtrIDRLSum AS 'Future Annual Revenues - Debit (LC)', OBGT.FtrIDRSSum AS 'Future Annual Revenues - Credit (SC)', OBGT.FtrICRLSum AS 'Future Revenues - Debit (LC)', OBGT.FtrICRSSum AS 'Future Revenues - Debit (SC)', OBGT.FtrODRLSum AS 'Future Annual Expenses - Credit (LC)', OBGT.FtrOCRLSum AS 'Future Annual Expenses - Debit (LC)', OBGT.FtrODRSSum AS 'Future Annual Expenses - Credit (SC)', OBGT.FtrOCRSSum AS 'Future Annual Expenses - Debit (SC)', OBGT.FinancYear AS 'Start of Fiscal Year', OBGT.Instance AS 'Instance', OBGT.UserSign AS 'User Signature', OBGT.SCNCounter AS 'SCN Counter' FROM OBGT AS OBGT

Related information


Budget Budget Object· Table: OBGT
Budget is a business object that represents the budget management in the Finance module. The budget management tracks company expenses and allows to block transactions when the budget exceeds. This object enables you to: Add a budget object....

OBGT SQL Table

Budget Cost Assess. Mthd OBGD SQL Table

Budget Scenario OBGS SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates