Need help for finding Field

[Former Member]

Hi experts,

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.

Thanks,

Vigneshwaran

[former_member205766 · Accepted solution]

Hi Vignesh

Tin No. is stored as Tax Id 11 in CRD7 Table.

With Regards

Balaji Sampath

[Former Member · Accepted solution]

Hi sir,

Its Not showing any table like CRD7, Instead of CRD7 its taking CRD1 and showing U_TIN no, but our users type TIN no , Tax information's only.

[former_member205766 · Accepted solution]

Hi Vignesh

Tax Information back end table is CRD7  it is not showing in System Information and tell what purpose you need that field?

With Regards

Balaji Sampath

[Former Member · Accepted solution]

Hi sir,

I need to take query report for vendors with bpcode, bpname and Tin no, for that only i need that Table.

Regards,

Vigneshwaran

[former_member205766 · Accepted solution]

Hi Vignesh

Try the below query

SELECT T0.[CardCode], T0.[CardName], T1.[TaxId11] FROM OCRD T0  INNER JOIN CRD7 T1 ON T0.[CardCode] = T1.[CardCode]

With Regards

Balaji Sampath

[Former Member · Accepted solution]

Thank You sir.