biuan SAP® BUSINESS ONE SDK
SQL Finance / Budget Cost Assess. Mthd
DTW Financials / Budget Setup / Budget Distribution
API OBGD / Budget Distribution
OBGD - Budget Cost Assess. Mthd Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BgdCode KEY UNIQUEDivision CodeInt
11
PRIMARYYes
BgdName KEYDescriptionnVarChar
30
NAMENo
BgdTotalBudget AmountNum
20
Month1JanuaryNum
20
Month2FebruaryNum
20
Month3MarchNum
20
Month4AprilNum
20
Month5MayNum
20
Month6JuneNum
20
Month7JulyNum
20
Month8AugustNum
20
Month9SeptemberNum
20
Month10OctoberNum
20
Month11NovemberNum
20
Month12DecemberNum
20
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
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OBGD.BgdCode AS 'Division Code', OBGD.BgdName AS 'Description', OBGD.BgdTotal AS 'Budget Amount', OBGD.Month1 AS 'January', OBGD.Month2 AS 'February', OBGD.Month3 AS 'March', OBGD.Month4 AS 'April', OBGD.Month5 AS 'May', OBGD.Month6 AS 'June', OBGD.Month7 AS 'July', OBGD.Month8 AS 'August', OBGD.Month9 AS 'September', OBGD.Month10 AS 'October', OBGD.Month11 AS 'November', OBGD.Month12 AS 'December', OBGD.DataSource AS 'Data Source', OBGD.UserSign AS 'User Signature' FROM OBGD AS OBGD

Related information


Budget Distribution BudgetDistribution Object· Table: OBGD
BudgetDistribution is a business object that represents the budget distribution methods used by the budget management in the Finance module. This object enables you to: Add a budget distribution method. Retrieve a budget distribution method...

OBGD 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