|
|
API AFML
AFML - Tax Formula Master Table Table
Sales Tax Authorities Type OSTT 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 |
|---|---|---|---|---|---|---|---|---|
| Code | Code | nVarChar | 20 | |||||
| Descr | Description | nVarChar | 100 | |||||
| SttId | Tax Type ID | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| FmlLang | Formula Language Free Text | Text | 16 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| FmlType KEY UNIQUE | Formula Type | VarChar | T) Tax W) WTax | 1 | T | CODE | Yes | |
| IsOrigFml | Original/Edited Formula | VarChar | Y) Yes N) No | 1 | Y |
Table relationship map
SELECT statement
SELECT
AFML.AbsId AS 'Internal Number',
AFML.Code AS 'Code',
AFML.Descr AS 'Description',
AFML.SttId AS 'Tax Type ID',
AFML.FmlLang AS 'Formula Language Free Text',
AFML.LogInstanc AS 'Log Instance',
AFML.UserSign2 AS 'Updating User',
AFML.UpdateDate AS 'Update Date',
AFML.FmlType AS 'Formula Type',
AFML.IsOrigFml AS 'Original/Edited Formula'
FROM AFML AS AFML
Related information
Sales Tax Authorities Type OSTT 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
