biuan SAP® BUSINESS ONE SDK
SQL Finance / Withholding Tax Deduction Groups
DTW Administration / System Initialization / Deduction Tax Groups
API ODDG / Deduction Tax Groups
ODDG - Withholding Tax Deduction Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Numerator KEY UNIQUEGroup KeyInt
11
PRIMARYYes
DdgCode KEY UNIQUEGroup CodenVarChar
2ODGL
Deduction Group List		NAMEYes
DdgNameGroup NamenVarChar
30
DdctPrcntMax. Red. in %Num
20
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT ODDG.Numerator AS 'Group Key', ODDG.DdgCode AS 'Group Code', ODDG.DdgName AS 'Group Name', ODDG.DdctPrcnt AS 'Max. Red. in %', ODDG.DataSource AS 'Data Source', ODDG.UserSign AS 'User Signature' FROM ODDG AS ODDG

Related information


Deduction Tax Groups DeductionTaxGroups Object· Table: ODDG
Represents withholding tax groups. These groups can be assigned to business partners to determine . Source table: ODDG.

ODDG SQL Table

Deduction Group List ODGL SQL Table

Users OUSR SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates