|
|
DTW Business Partners / Deduction Tax Hierarchies
API ODDT / / Deduction Tax Hierarchies
ODDT - Withholding Tax Deduction Hierarchy Table
Deduction Tax Hierarchies DeductionTaxHierarchies Object· Table: ODDT
ODDT SQL Table
Business Partner OCRD SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Numerator KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OCRD Business Partner | CARD | Yes | ||
| TrcCode | Hierarchy Code | nVarChar | 10 | |||||
| TrcName | Hierarchy Name | nVarChar | 30 | |||||
| DateFrom | Valid From | Date | 8 | |||||
| DateTo | Valid Until | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LastUpdate | Last Update Date | Date | 8 | |||||
| WHShaamGrp | Withholding Shaam Group | VarChar | 1) Services and Asset 2) Agricultural Products 3) Insurance Commissions 4) Withholding Tax Instructions 5) Interest, Exchange Rate Differences | 1 | 1 | |||
| DdctPrcnt | Deduction % | Num | 20 | |||||
| MaxSum | Maximum Total | Num | 20 |
Table relationship map
SELECT statement
SELECT
ODDT.Numerator AS 'Internal Number',
ODDT.CardCode AS 'BP Code',
ODDT.TrcCode AS 'Hierarchy Code',
ODDT.TrcName AS 'Hierarchy Name',
ODDT.DateFrom AS 'Valid From',
ODDT.DateTo AS 'Valid Until',
ODDT.DataSource AS 'Data Source',
ODDT.UserSign AS 'User Signature',
ODDT.LastUpdate AS 'Last Update Date',
ODDT.WHShaamGrp AS 'Withholding Shaam Group',
ODDT.DdctPrcnt AS 'Deduction %',
ODDT.MaxSum AS 'Maximum Total'
FROM ODDT AS ODDT
Related information
Deduction Tax Hierarchies DeductionTaxHierarchies Object· Table: ODDT
The DeductionTaxHierarchies object enables to define taxation levels to withhold from payments to vendors. This object is part of the Business Partners module.
Source table: ODDT.
ODDT SQL Table
Business Partner OCRD SQL Table
Users OUSR SQL Table
DeductionTaxHierarchies
Method
Object
Property
AbsEntry
DTW DB
BPCode
DTW DB
DeductionPercent
DTW DB
HierarchyCode
DTW DB
HierarchyName
DTW DB
MaximumTotal
DTW DB
ValidFrom
DTW DB
ValidUntil
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates