|
|
SQL Finance / Value Ranges
DTW Administration / Setup / Financials / Tax / Withholding Tax Definition
API WTD2
WTD2 - Value Ranges Table
Withholding Tax OWHT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OWHT Withholding Tax | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| EfctFrom | Effective From | Date | 8 | |||||
| ValueFrom | Value From | 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
WTD2.AbsEntry AS 'Internal Number',
WTD2.EfctFrom AS 'Effective From',
WTD2.ValueFrom AS 'Value From',
WTD2.Rate AS 'Rate',
WTD2.WTCur AS 'Currency',
WTD2.LogInstanc AS 'Log Instance',
WTD2.LineNum AS 'Row Number',
WTD2.SeqNum AS 'Sequence Number'
FROM WTD2 AS WTD2
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
