|
|
DTW Financials / Budget Setup / Budget
API OBGT / Budget
OBGT - Budget Table
Budget Budget Object· Table: OBGT
OBGT SQL Table
Budget Cost Assess. Mthd OBGD SQL Table
Budget Scenario OBGS 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 |
|---|---|---|---|---|---|---|---|---|
| AcctCode KEY UNIQUE | Account Code | nVarChar | 15 | ACCNT_CODE | Yes | |||
| BgdCode | Division Code | Int | 11 | OBGD Budget Cost Assess. Mthd | ||||
| FatherCode KEY | Parent Account Key | nVarChar | 15 | INTER_KEY | No | |||
| FthrPrcnt | Parent Acct % | Num | 20 | |||||
| DebLTotal | Total Annual Budget - Debit (LC) | Num | 20 | |||||
| CredLTotal | Total Annual Budget - Credit (LC) | Num | 20 | |||||
| DebSTotal | Total Annual Budget - Debit (SC) | Num | 20 | |||||
| CredSTotal | Total Annual Budget - Credit (SC) | Num | 20 | |||||
| DebRLTotal | Budget Balance - Debit (LC) | Num | 20 | |||||
| CrdRLTotal | Budget Balance - Credit (LC) | Num | 20 | |||||
| DebRSTotal | Budget Balance - Debit (SC) | Num | 20 | |||||
| CrdRSTotal | Budget Balance - Credit (SC) | Num | 20 | |||||
| FtrIDRLSum | Future Annual Revenues - Debit (LC) | Num | 20 | |||||
| FtrIDRSSum | Future Annual Revenues - Credit (SC) | Num | 20 | |||||
| FtrICRLSum | Future Revenues - Debit (LC) | Num | 20 | |||||
| FtrICRSSum | Future Revenues - Debit (SC) | Num | 20 | |||||
| FtrODRLSum | Future Annual Expenses - Credit (LC) | Num | 20 | |||||
| FtrOCRLSum | Future Annual Expenses - Debit (LC) | Num | 20 | |||||
| FtrODRSSum | Future Annual Expenses - Credit (SC) | Num | 20 | |||||
| FtrOCRSSum | Future Annual Expenses - Debit (SC) | Num | 20 | |||||
| FinancYear | Start of Fiscal Year | Date | 8 | |||||
| Instance | Instance | Int | 11 | OBGS Budget Scenario | 1 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| SCNCounter | SCN Counter | Int | 6 |
Table relationship map
SELECT statement
SELECT
OBGT.AbsId AS 'Internal Number',
OBGT.AcctCode AS 'Account Code',
OBGT.BgdCode AS 'Division Code',
OBGT.FatherCode AS 'Parent Account Key',
OBGT.FthrPrcnt AS 'Parent Acct %',
OBGT.DebLTotal AS 'Total Annual Budget - Debit (LC)',
OBGT.CredLTotal AS 'Total Annual Budget - Credit (LC)',
OBGT.DebSTotal AS 'Total Annual Budget - Debit (SC)',
OBGT.CredSTotal AS 'Total Annual Budget - Credit (SC)',
OBGT.DebRLTotal AS 'Budget Balance - Debit (LC)',
OBGT.CrdRLTotal AS 'Budget Balance - Credit (LC)',
OBGT.DebRSTotal AS 'Budget Balance - Debit (SC)',
OBGT.CrdRSTotal AS 'Budget Balance - Credit (SC)',
OBGT.FtrIDRLSum AS 'Future Annual Revenues - Debit (LC)',
OBGT.FtrIDRSSum AS 'Future Annual Revenues - Credit (SC)',
OBGT.FtrICRLSum AS 'Future Revenues - Debit (LC)',
OBGT.FtrICRSSum AS 'Future Revenues - Debit (SC)',
OBGT.FtrODRLSum AS 'Future Annual Expenses - Credit (LC)',
OBGT.FtrOCRLSum AS 'Future Annual Expenses - Debit (LC)',
OBGT.FtrODRSSum AS 'Future Annual Expenses - Credit (SC)',
OBGT.FtrOCRSSum AS 'Future Annual Expenses - Debit (SC)',
OBGT.FinancYear AS 'Start of Fiscal Year',
OBGT.Instance AS 'Instance',
OBGT.UserSign AS 'User Signature',
OBGT.SCNCounter AS 'SCN Counter'
FROM OBGT AS OBGT
Related information
Budget Budget Object· Table: OBGT
Budget is a business object that represents the budget management in the Finance module. The budget management tracks company expenses and allows to block transactions when the budget exceeds.
This object enables you to:
Add a budget object....
OBGT SQL Table
Budget Cost Assess. Mthd OBGD SQL Table
Budget Scenario OBGS SQL Table
Users OUSR SQL Table
Budget
Method
Object
Budget_Lines BGT1
Property
AccountCode
DTW DB
BudgetScenario
DTW DB
DivisionCode
DTW DB
Numerator
DTW DB
ParentAccountKey
DTW DB
ParentAccPercent
DTW DB
TotalAnnualBudgetCreditLoc
DTW DB
TotalAnnualBudgetCreditSys
DTW DB
TotalAnnualBudgetDebitLoc
DTW DB
TotalAnnualBudgetDebitSys
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
