biuan SAP® BUSINESS ONE SDK
API BGT3
BGT3 - Budget - Cost Accounting Rows 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
Line_IDRow NumberInt
11
DebLTotalMonthly Budget - Deb.Num
20
CredLTotalMonthly Budget - Cr.Num
20
DebSTotalMonthly Budget - SC Deb.Num
20
CredSTotalMonthly Budget - SC Cr.Num
20
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT BGT3.BudgId AS 'Budget Key', BGT3.OcrCode AS 'Factor Code', BGT3.DimCode AS 'In Which Dimension', BGT3.Instance AS 'Instance', BGT3.Line_ID AS 'Row Number', BGT3.DebLTotal AS 'Monthly Budget - Deb.', BGT3.CredLTotal AS 'Monthly Budget - Cr.', BGT3.DebSTotal AS 'Monthly Budget - SC Deb.', BGT3.CredSTotal AS 'Monthly Budget - SC Cr.', BGT3.UserSign AS 'User Signature' FROM BGT3 AS BGT3

Related information


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