biuan SAP® BUSINESS ONE SDK
SQL Finance / Budget / Budget - Cost Accounting
DTW Financials / Budget Setup / Budget / Budget - Cost Accounting
API Budget / Budget Cost Accounting Lines
BGT2 - Budget - Cost Accounting Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BudgId KEY UNIQUEBudget KeyInt
11OBGT
Budget		PRIMARYYes
OcrCodeFactor CodenVarChar
8OOCR
Distribution Rule
DimCodeIn Which DimensionInt
6ODIM
Cost Accounting Dimension
InstanceInstanceInt
11OBGS
Budget Scenario		1
DebLTotalTot. Annu. Budgt Debit (LC)Num
20
CredLTotalTot. Annu. Budgt Credit (LC)Num
20
DebSTotalTot. Annu. Budgt Debit (SC)Num
20
CredSTotalTot. Annu. Budgt Credit (SC)Num
20
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT BGT2.BudgId AS 'Budget Key', BGT2.OcrCode AS 'Factor Code', BGT2.DimCode AS 'In Which Dimension', BGT2.Instance AS 'Instance', BGT2.DebLTotal AS 'Tot. Annu. Budgt Debit (LC)', BGT2.CredLTotal AS 'Tot. Annu. Budgt Credit (LC)', BGT2.DebSTotal AS 'Tot. Annu. Budgt Debit (SC)', BGT2.CredSTotal AS 'Tot. Annu. Budgt Credit (SC)', BGT2.UserSign AS 'User Signature' FROM BGT2 AS BGT2

Related information


Budget Cost Accounting Lines BudgetCostAccounting_Lines Object· Table: BGT2
BudgetCostAccounting_Lines Class
   Parent: Budget Budget Object· Table: OBGT
Budget OBGT SQL Table

Cost Accounting Dimension ODIM SQL Table

Budget Scenario OBGS SQL Table

Distribution Rule OOCR 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates