|
|
API WHT2
WHT2 - Withholding Tax Definition - Rows2 Table
Withholding Tax OWHT SQL Table
Currency Codes OCRN SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry | Numerator | Int | 11 |
|---|---|---|---|---|---|---|---|---|
| Code KEY UNIQUE | Tax Code | nVarChar | 4 | OWHT Withholding Tax | PRIMARY | Yes | ||
| EffectDate | Date Effective | Date | 8 | |||||
| Rate | Tax Rate | Num | 20 | |||||
| MinAmount | Min. Amount | Num | 20 | |||||
| MaxAmount | Max. Amount | Num | 20 | |||||
| WTCUR | Progressive Tax Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| LineNum | Row Number | Int | 11 | |||||
| SeqNum | Sequence Number | Int | 11 |
Table relationship map
SELECT statement
SELECT
WHT2.AbsEntry AS 'Numerator',
WHT2.Code AS 'Tax Code',
WHT2.EffectDate AS 'Date Effective',
WHT2.Rate AS 'Tax Rate',
WHT2.MinAmount AS 'Min. Amount',
WHT2.MaxAmount AS 'Max. Amount',
WHT2.WTCUR AS 'Progressive Tax Currency',
WHT2.LogInstanc AS 'Log Instance',
WHT2.LineNum AS 'Row Number',
WHT2.SeqNum AS 'Sequence Number'
FROM WHT2 AS WHT2
Related information
Withholding Tax OWHT SQL Table
Currency Codes OCRN SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates