|
|
API BTC1
BTC1 - Internal Bank Operation Codes - Accounts Table
G/L Accounts OACT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row | Int | 6 | |||||
| GLAct | G/L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Project | Project | nVarChar | 20 | OPRJ Project Codes | ||||
| PrftCenter | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| VatCode | VAT Code | nVarChar | 8 | OVTG Tax Definition | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| PrftCent2 | Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCent3 | Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCent4 | Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCent5 | Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule |
Table relationship map
SELECT statement
SELECT
BTC1.AbsEntry AS 'Internal Number',
BTC1.LineId AS 'Row',
BTC1.GLAct AS 'G/L Account',
BTC1.Project AS 'Project',
BTC1.PrftCenter AS 'Distribution Rule',
BTC1.VatCode AS 'VAT Code',
BTC1.LogInstanc AS 'Log Instance',
BTC1.PrftCent2 AS 'Distribution Rule2',
BTC1.PrftCent3 AS 'Distribution Rule3',
BTC1.PrftCent4 AS 'Distribution Rule4',
BTC1.PrftCent5 AS 'Distribution Rule5'
FROM BTC1 AS BTC1
Related information
G/L Accounts OACT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
