|
|
API AWD3
AWD3 - WTax Codes Details for BP 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 |
|---|---|---|---|---|---|---|---|---|
| LineId | Row Number | Int | 11 | |||||
| WTCode | WTax Code | nVarChar | 4 | |||||
| KeyPart1 | BP Key Part 1 | nVarChar | 15 | |||||
| KeyPart2 | BP Key Part 2 | nVarChar | 15 | |||||
| DateFrom | Effective Date From | Date | 8 | |||||
| DateTo | Effective Date To | Date | 8 | |||||
| Rate | Currency Rate | Num | 20 | |||||
| DetailType | Type of Detailed Information | nVarChar | A) Allowed S) Special Rate E) Exemption | 2 | ||||
| DataSource | Data Source | VarChar | N) Unknown M) Import O) DI API P) Partner Implementation | 1 | N | |||
| UpdateDate | Date of Update | Date | 8 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
SELECT statement
SELECT
AWD3.AbsEntry AS 'Internal Number',
AWD3.LineId AS 'Row Number',
AWD3.WTCode AS 'WTax Code',
AWD3.KeyPart1 AS 'BP Key Part 1',
AWD3.KeyPart2 AS 'BP Key Part 2',
AWD3.DateFrom AS 'Effective Date From',
AWD3.DateTo AS 'Effective Date To',
AWD3.Rate AS 'Currency Rate',
AWD3.DetailType AS 'Type of Detailed Information',
AWD3.DataSource AS 'Data Source',
AWD3.UpdateDate AS 'Date of Update',
AWD3.LogInstanc AS 'Log Instance'
FROM AWD3 AS AWD3
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
