Questions about address fields in SAP

[Former Member]

Hello All,

We have certain regions in SAP that are setup incorrectly. E.g. Region Texas was setup as TXU rather than TX. I want to correct this to TX, but If I delete TXU from the configuration table, it will affect all the cost centers, WBES etc that had TXU in it's master data. I did a where used on field regio and found 551 tables having this field. Only the master data table should matter to me as the transaction data won't be affected if I change this field.

How do I go about finding out all the master data objects that I will need to update, once I change this region field?

Thanks so much for looking into this.

[Former Member]

HI

First, if you delete TXU in configuration table that is going to make programs fail and inconsistencies in previous registers, So the only thing you can do is set the TXU obsolete and set new TX in the configuration table then change it in the master data.

As you don't specify any SAP modules you are using i just can say look over the master data like bp, creditor, debtor, cost centers, employees and all that works with address.

I hope that helps you.

[Former Member]

Hi,

Master and transaction data tables have delivery type A. You can generally tell master and transaction data tables apart by their key fields. For instance, a table with document number (e.g. BELNR), fiscal year (e.g. GJAHR), period (e.g. POPER) fields must be a transaction data table. Once you know you are dealing with a master data table, the short description is usually obvious.

Whether or not there is an easy way to list the delivery types and key fields of hundreds of tables, best to ask an ABAP developer or basis consultant.

I hope this helps.

Regards.