Customer Master Report needed for jurisdiction, tax code, and district

[Former Member]

I am trying to pull a customer master report and need to include the following fields:

Name (NAME1)

Account (KUNNR)

Jurisdiction ( TAXJURCODE)

Tax Code (TAXKD)

District, which is County for US addresses (CITY2)

I haven't seen a report with CITY2 and have tried S_ALR_87012180 or opening KNA1, KNVI, etc.

Any ideas?

Thanks,

Michelle

[Former Member · Accepted solution]

No there is not such report or transaction.

You may look at tables KNA1 + ADRC.

In table KNA1 there are fields ORT01, ORT02, COUNC and CITYC that could help

Otherwise you must link KNA1 and ADRC with field KNA1-ADRNR = ADRC-ADDRNUMBER

Sorry

BR

Alain