|
|
SQL Finance / Value Ranges
API AWD2
AWD2 - 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
AWD2.AbsEntry AS 'Internal Number',
AWD2.EfctFrom AS 'Effective From',
AWD2.ValueFrom AS 'Value From',
AWD2.Rate AS 'Rate',
AWD2.WTCur AS 'Currency',
AWD2.LogInstanc AS 'Log Instance',
AWD2.LineNum AS 'Row Number',
AWD2.SeqNum AS 'Sequence Number'
FROM AWD2 AS AWD2
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
