Need help for finding Field
In Business Partner master data i need information from Accounting tab->tax information-> Tin No. For this which table we need to take, when i searched with System Information its shows only 'TIN NO', It not shown any table, Please do needful.
Try the below query
SELECT T0.[CardCode], T0.[CardName], T1.[TaxId11] FROM OCRD T0 INNER JOIN CRD7 T1 ON T0.[CardCode] = T1.[CardCode]