|
|
SQL Finance / Value Range
API AWH3
AWH3 - Value Range Table
Withholding Tax OWHT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId | Internal Number | Int | 11 |
|---|---|---|---|---|---|---|---|---|
| WTCode KEY UNIQUE | WTax Code | nVarChar | 4 | OWHT Withholding Tax | PRIMARY | Yes | ||
| EfctFrom | Effective from | Date | 8 | |||||
| ValueFrom | Value From | Num | 20 | |||||
| Deduct | WTax to Be Deductible | Num | 20 | |||||
| Rate | Rate | Num | 20 | |||||
| WTCur | Currency | nVarChar | 3 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| LineNum | Row Number | Int | 11 | |||||
| SeqNum | Sequence Number | Int | 11 |
SELECT statement
SELECT
AWH3.AbsId AS 'Internal Number',
AWH3.WTCode AS 'WTax Code',
AWH3.EfctFrom AS 'Effective from',
AWH3.ValueFrom AS 'Value From',
AWH3.Deduct AS 'WTax to Be Deductible',
AWH3.Rate AS 'Rate',
AWH3.WTCur AS 'Currency',
AWH3.LogInstanc AS 'Log Instance',
AWH3.LineNum AS 'Row Number',
AWH3.SeqNum AS 'Sequence Number'
FROM AWH3 AS AWH3
Related information
Withholding Tax OWHT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates