on 01-04-2023 4:30 AM
Dear Experts,
We tried to fetch the withholding tax details by joining OCRD and OWHT tables for individual business partners and returning with no data.
Can anyone be of any help as to how can we retrieve or fetch the data?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Greetings of the day Sir,
Thanks for your help.
Would not fetch any data.
What we want is the linked Type/group of the Withholding tax from (OWHT/WHT1) table to the respective BP Code or Name, which are not being linked.
Business Partner's 'withholding tax %' is a column of the OCRD table. Try :
SELECT
Cardcode,
CardName,
DdctPrcnt
FROM OCRD
If you need 'Withholding Tax Deduction Group', that is DdgKey which is link to ODDG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.