|
|
SQL Finance / Budget Scenario
DTW Financials / Budget Setup / Budget Scenarios
API OBGS / / Budget Scenarios
OBGS - Budget Scenario Table
Budget Scenarios BudgetScenarios Object· Table: OBGS
OBGS SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Name | nVarChar | 100 | SECOND | Yes | |||
| BaseId KEY | Basic Budget | Int | 11 | INTER_KEY | No | |||
| InitRate | Initial Ratio Percentage | Num | 20 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| FinancYear | Start of Fiscal Year | Date | 8 | |||||
| IsMain | Main | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | 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 | |||
| RoundSys | Rounding Method | Int | 0 1) Round to Full Decimal Amount 2) Round to Full Amount 3) Round to Full Tens Amount | 6 | 0 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| OcrCode | Dimension 1 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Dimension 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Dimension 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Dimension 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Dimension 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrjCode | Project Code | nVarChar | 20 | OPRJ 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
BudgetScenarios
Method
Property
BasicBudget
DTW DB
InitialRatioPercentage
DTW DB
Name
DTW DB
Numerator
DTW DB
RoundingMethod
DTW DB
StartofFiscalYear
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
