|
|
DTW Inventory / Price Lists / Price Lists
API OLTB
OLTB - Location-based Tax Bal Table Table
Location OLCT SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Numerator | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LocCode KEY | Location Code | Int | 11 | OLCT Location | index | No | ||
| STAType | Tax Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| STACode | STA Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| BalaType | Balance Type | VarChar | P) R) C) F) | 1 | ||||
| Balance | Balance | Num | 20 |
Table relationship map
SELECT statement
SELECT
OLTB.AbsId AS 'Numerator',
OLTB.LocCode AS 'Location Code',
OLTB.STAType AS 'Tax Type',
OLTB.STACode AS 'STA Code',
OLTB.BalaType AS 'Balance Type',
OLTB.Balance AS 'Balance'
FROM OLTB AS OLTB
Related information
Location OLCT SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
