|
|
DTW Financials / Budget Setup / Budget / Budget - Rows
API Budget / Budget Lines
BGT1 - Budget - Rows Table
Budget Lines Budget_Lines Object· Table: BGT1
Parent: Budget Budget Object· Table: OBGT
Budget OBGT 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 | BudgId KEY UNIQUE | Budget Key | Int | 11 | OBGT Budget | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Line_ID | Row Number | Int | 11 | 0 | ||||
| DebLTotal | Monthly Budget - Deb. | Num | 20 | |||||
| CredLTotal | Monthly Budget - Cr. | Num | 20 | |||||
| DebSTotal | Monthly Budget - SC Deb. | Num | 20 | |||||
| CredSTotal | Monthly Budget - SC Cr. | Num | 20 | |||||
| DebRLTotal | Monthly Bal. - Deb. | Num | 20 | |||||
| CrdRLTotal | Monthly Bal. - Cr. | Num | 20 | |||||
| DebRSTotal | Monthly Bal. - SC Deb. | Num | 20 | |||||
| CrdRSTotal | Monthly Bal. - SC Cred. | Num | 20 | |||||
| FtrIDRLSum | Fut. Monthly Incomes SC Cr. | Num | 20 | |||||
| FtrIDRSSum | Fut. Monthly Incomes SC Deb. | Num | 20 | |||||
| FtrICRLSum | Fut. Incomes - Cr. | Num | 20 | |||||
| FtrICRSSum | Fut. Incomes - Sys. Cr. | Num | 20 | |||||
| FtrODRLSum | Fut. Expen - Local Deb. | Num | 20 | |||||
| FtrODRSSum | Fut.Expen - SC Deb. | Num | 20 | |||||
| FtrOCRLSum | Fut.Expen - Local Cr. | Num | 20 | |||||
| FtrOCRSSum | Fut.Expen - Sys. Cr. | Num | 20 | |||||
| MonthPrcnt | % of annual budget amount | Num | 20 | |||||
| LineMemo | Row Details | nVarChar | 50 | |||||
| Instance | Instance | Int | 11 | OBGS Budget Scenario | 1 | |||
| AcctCode | Account Code | nVarChar | 15 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
BGT1.BudgId AS 'Budget Key',
BGT1.Line_ID AS 'Row Number',
BGT1.DebLTotal AS 'Monthly Budget - Deb.',
BGT1.CredLTotal AS 'Monthly Budget - Cr.',
BGT1.DebSTotal AS 'Monthly Budget - SC Deb.',
BGT1.CredSTotal AS 'Monthly Budget - SC Cr.',
BGT1.DebRLTotal AS 'Monthly Bal. - Deb.',
BGT1.CrdRLTotal AS 'Monthly Bal. - Cr.',
BGT1.DebRSTotal AS 'Monthly Bal. - SC Deb.',
BGT1.CrdRSTotal AS 'Monthly Bal. - SC Cred.',
BGT1.FtrIDRLSum AS 'Fut. Monthly Incomes SC Cr.',
BGT1.FtrIDRSSum AS 'Fut. Monthly Incomes SC Deb.',
BGT1.FtrICRLSum AS 'Fut. Incomes - Cr.',
BGT1.FtrICRSSum AS 'Fut. Incomes - Sys. Cr.',
BGT1.FtrODRLSum AS 'Fut. Expen - Local Deb.',
BGT1.FtrODRSSum AS 'Fut.Expen - SC Deb.',
BGT1.FtrOCRLSum AS 'Fut.Expen - Local Cr.',
BGT1.FtrOCRSSum AS 'Fut.Expen - Sys. Cr.',
BGT1.MonthPrcnt AS '% of annual budget amount',
BGT1.LineMemo AS 'Row Details',
BGT1.Instance AS 'Instance',
BGT1.AcctCode AS 'Account Code',
BGT1.UserSign AS 'User Signature'
FROM BGT1 AS BGT1
Related information
Budget Lines Budget_Lines Object· Table: BGT1
Budget_Lines is a child object of Budget object and represents the budget item details of an account.
Source table: BGT1.
Parent: Budget Budget Object· Table: OBGT Budget OBGT SQL Table
Budget Scenario OBGS SQL Table
Users OUSR SQL Table
Budget
Object
Budget_Lines
Method
Property
AccountCode
DB
BalTotCredit
DB
BalTotDebit
DB
BudgetKey
DB
BudgetSysTotCredit
DTW DB
BudgetSysTotDebit
DTW DB
BudgetTotCredit
DTW DB
BudgetTotDebit
DTW DB
RowDetails
DTW DB
RowNumber
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
