Mass update Postal Code and Tax Jurisdiction (TJXCD)

[former_member184342]

I'm trying to mass update some customers both Postal Code and Tax Jurisdiction data using t-code XD99, but I'm getting error. I've noted that the field it's part of the structure ADDR1_DATA, with the field TAXJURCODE.

Configuring the XD99 i've found that that's a field called KNA1-TXJCD.

Using this field, while I'm at the t-code SE16N return to me the Tax Jurisdiction codes, but at the XD99, returns me other data:

Any thoughts of how to mass change?

[JL23 · Accepted solution]

You missed to tell what error you get.

KNA1 address fields are old, from ancient times prior to 4.5 release, got replaced by central address management, the ADRx tables.

Nevertheless the data is stored redundant  in corresponding fields of KNA1 table too.

This is the usual approach, otherwise thousands of SAP customers had to be forced to change their Z-programs too when this central address management was introduced.

[former_member184342 · Accepted solution]

When I choose this field (KNA1-TXJCD) in the XD99 it shows the Jurisdiction Codes from the customers that I've selected, but when I try to insert the correct value, I've got this message:

The value CE 2306901 does not exist in foreign key table TTXJ

Message no. M&150

Looking the image that I've attached you can see that when I've clicked at the match code, other values showed up, different from the jurisdiction codes that we use.

[JL23 · Accepted solution]

The easiest way to get around would be a LSMW recording  for XD02 address and control data view.

The root cause is that you have only the jurisdiction code itself, but the check table TTXJ needs another key field KALSM from the country table T005.

To make the update happen in XD99 you would need to remove the flag for check required

in the ABAP dictionary (SE11)

[former_member184342 · Accepted solution]

I see. In this case, will be better to make the changes using LSMW, changing at the same time Postal Code and the TaxJud.

These fields would do the job?

KUNNR

PSTLZ

TXJCD

[JL23 · Accepted solution]

It should be sufficient. Don't forget to tick the little box for central address management in the first screen of the recording

[former_member184342 · Accepted solution]

Do you recommend use the Recording method beside the Direct Input one?

Looking at the structure I've another field that might be useful to update:

TAXJURCODE

This is located at the structure BIADDR2.

[JL23 · Accepted solution]

I usually do not recommend recording methods if other methods are given, however, to update just one or two fields which are at the general level, it is quicker to do a recording (most people know the recording method well, while they are not really used to any other. I have to admit that I never used the batch input, I do it usually with IDOC method, and in this case I had to do 2 LSMWs: DEBMAS for KNA1 update and ADRMAS for ADRC update.