biuan SAP® BUSINESS ONE SDK
DTW Financials / Budget Setup / Budget Scenarios
API OBGS / / Budget Scenarios
OBGS - Budget Scenario Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Name KEY UNIQUENamenVarChar
100
SECONDYes
BaseId KEYBasic BudgetInt
11
INTER_KEYNo
InitRateInitial Ratio PercentageNum
20
LockedLockedVarChar
Y) Yes
N) No
1
N
FinancYearStart of Fiscal YearDate
8
IsMainMainVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
RoundSysRounding MethodInt
0
1) Round to Full Decimal Amount
2) Round to Full Amount
3) Round to Full Tens Amount
6
0
UserSignUser SignatureInt
6OUSR
Users
OcrCodeDimension 1nVarChar
8OOCR
Distribution Rule
OcrCode2Dimension 2nVarChar
8OOCR
Distribution Rule
OcrCode3Dimension 3nVarChar
8OOCR
Distribution Rule
OcrCode4Dimension 4nVarChar
8OOCR
Distribution Rule
OcrCode5Dimension 5nVarChar
8OOCR
Distribution Rule
PrjCodeProject CodenVarChar
20OPRJ
Project Codes

Table relationship map

SELECT statement

SELECT OBGS.AbsId AS 'Internal Number', OBGS.Name AS 'Name', OBGS.BaseId AS 'Basic Budget', OBGS.InitRate AS 'Initial Ratio Percentage', OBGS.Locked AS 'Locked', OBGS.FinancYear AS 'Start of Fiscal Year', OBGS.IsMain AS 'Main', OBGS.DataSource AS 'Data Source', OBGS.RoundSys AS 'Rounding Method', OBGS.UserSign AS 'User Signature', OBGS.OcrCode AS 'Dimension 1', OBGS.OcrCode2 AS 'Dimension 2', OBGS.OcrCode3 AS 'Dimension 3', OBGS.OcrCode4 AS 'Dimension 4', OBGS.OcrCode5 AS 'Dimension 5', OBGS.PrjCode AS 'Project Code' FROM OBGS AS OBGS

Related information


Budget Scenarios BudgetScenarios Object· Table: OBGS
BudgetScenarios is a business object that represents the budget scenarios used by the budget management in the Finance module. This object enables you to: Add a budget scenario. Remove a budget scenario. Retrieve a budget scenario by its...

OBGS SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ 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