|
|
API BGT3
BGT3 - Budget - Cost Accounting Rows Table
Budget OBGT SQL Table
Cost Accounting Dimension ODIM SQL Table
Budget Scenario OBGS SQL Table
Distribution Rule OOCR 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 |
|---|---|---|---|---|---|---|---|---|
| OcrCode | Factor Code | nVarChar | 8 | OOCR Distribution Rule | ||||
| DimCode | In Which Dimension | Int | 6 | ODIM Cost Accounting Dimension | ||||
| Instance | Instance | Int | 11 | OBGS Budget Scenario | 1 | |||
| Line_ID | Row Number | Int | 11 | |||||
| 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 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
BGT3.BudgId AS 'Budget Key',
BGT3.OcrCode AS 'Factor Code',
BGT3.DimCode AS 'In Which Dimension',
BGT3.Instance AS 'Instance',
BGT3.Line_ID AS 'Row Number',
BGT3.DebLTotal AS 'Monthly Budget - Deb.',
BGT3.CredLTotal AS 'Monthly Budget - Cr.',
BGT3.DebSTotal AS 'Monthly Budget - SC Deb.',
BGT3.CredSTotal AS 'Monthly Budget - SC Cr.',
BGT3.UserSign AS 'User Signature'
FROM BGT3 AS BGT3
Related information
Budget OBGT SQL Table
Cost Accounting Dimension ODIM SQL Table
Budget Scenario OBGS SQL Table
Distribution Rule OOCR SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
