Symptom
Uncertainty as to applying SAP transports relating to BSI TUBs.
Other Terms
BSI TUB, Tax Update Bulletin, Transports.
Reason and Prerequisites
Confusion over how to apply tax updates.
Solution
This is to be used for informational purposes when applying an SAP transport relating to the release of BSI TUBS (Tax Update Bulletins). Each transport has a related note that gives the transport numbers and which tables they are updating. We deliver the tables in both cumulative and incremental forms; cumulative being all the objects in a particular table are delivered, whereas incremental is the delta between the previous TUB and the current TUB.
BSI Tax Update Bulletin (TUB) is the incremental data file entitled ‘TFU07{xxx}.arq’ where xxx is the TUB number. It only contains the delta change. These TUBs should be applied in a sequential order without any skipping.
As BSI releases their tax bulletins, SAP provides updates via transports delivered through sapserv4 to update the related SAP tables. The following is the list of the tables delivered through the SAP TUB transports:
BTXAUTH – BSI: Tax Authority (S)
BTXFORM – BSI: Tax Formula Description (S)
T5UTN – BSI Authority Numbers with Sequential Number per State (S)
T5UTT – Tax Types (US) (S)
BTXTAXC – BSI: Grouping BSI Tax Authorities to SAP Tax Authorities (E)
T5UTA – Resident Tax Areas (C)
T5UTB – Work Tax Areas (C)
T5UTX – Tax Ceilings and rates (S)
T5UTR – Tax Authorities per Resident Tax Area (C)
T5UTW – Tax Authorities per Work Tax Area (C)
T5UTD – Default Tax Type (US) (C)
T5UTZ – Tax Authorities (C)
T512W – Wage Type Valuation (E)
T5UTO – Assignment of technical wage types to tax types (S)
T512T – Wage Type Texts (E)
T5US0 – Priority for tax wage types (C)
The tables that have a delivery class of ‘S’ are system tables, which means that SAP maintains them. The transport containing these tables MUST be applied by all customers to client 000. Included in the transport are the following tables:
T5UTN, T5UTT, BTXAUTH, and BTXFORM
These tables are client-INDEPENDENT, all clients can read them from client 000. The transport is cumulative, all objects delivered. It is located under the directory:
/specific/bsi/bsi70/data/tubxxx
Another transport that must be applied by all customers is the one containing the BTXTAXC table, which has a delivery class of ‘E’. Due to a table structure change with BSI 70, the BTXTAXC table is client-dependent. You need to apply this transport to all of your clients respectively. The transport is also located under the directory:
/specific/bsi/bsi70/data/tubxxx
Please also read the note for the TUB to see if there is any new tax authorities delivered with this table. If there are any, you will have to manually update your BSI GUI with this tax mapping code for all your clients.
The following describes the transports that are delivered in the cumulative and incremental subdirectories.
The tables T5UTA, B, D, R, W and Z all have the delivery class of ‘C’ which means that these tables are customizing tables and maintenance is only done by the customer, not SAP imports. After the transports containing the T5UTN, T5UTT, BTXAUTH, BTXFORM, and BTXTAXC have been completed, you have a decision. Depending upon the needs of your enterprise, you may apply the cumulative tax data update or the incremental tax data update to your system. The cumulative updates deliver all the objects in the table, whereas the incremental only delivers the new changes or the deltas for tables T5UTA, B, D, R and W.
Also delivered are updates for table T5UTZ, but you must choose the transport for T5UTZ that corresponds with your release; 4.5 and below or 4.6 and above. The reason for this is the table structure change that occurred in the 4.6 release. If you wish to apply the incremental transports which is only the delta, please go to the following transport:
/specific/bsi/bsi70/data/tubxxx/incremental
or for the cumulative transports, the following:
/specific/bsi/bsi70/data/tub0xx/cumlative
If you have customized changes to these tables and DO NOT want to overwrite any of those changes, you should apply either the cumulative or the incremental transport to your client 000. This will prevent you from losing your customized entries. You will then have to follow the below directions using transaction SM31 and compare and adjust your customized entries.
However, if you DO NOT have any customized entries in these tables you can then at the Operating System level execute the command TP IMPORT and specify the client number you wish to apply the transports to. Please be sure this is what you want since you will lose your customized entries.
Regarding the physical cascading/import of data to non-zero clients, there are several ways. The first way is to use the client copy function via transaction SCC1, which uses the CUST transport template to copy the data to non-zero clients. Another way is to use TPIMPORT to directly import the transport to each client. Note 13719 has some general information about TPIMPORT and references to related notes. In addition, executing the help command on the TPIMPORT command is another good source of information.
If you DO care about the customizing entries then you need to compare and adjust the entries under transaction SM31 or SM30.
The steps are as follows:
1. Go to transaction SM31 or SM30 -> enter table name or table view -> select ‘Maintain’
2. From the menu, choose ‘Utility’ -> ‘Adjust’ -> Enter the connection ‘DVBCLNT000’ (DVB = System, 000 = Client number) -> choose green check mark -> click green check mark on ‘Notes on performance’ dialog box
3. The screen will show all the entries. The one which is different from client 000 are shown with colors. You may select ‘Change Filter’ from the toolbar and turn off the check mark beside ‘Identical’ and choose the green check mark.
4. Now the screen will only show the difference. From the menu bar, choose ‘Edit’ -> Select -> Select All (if you want adjust all the differences).
5. From the toolbar, choose ‘Adjust’ -> ‘copy all’
6. At this moment, you will still pink entries. These entries exist in client 150 but NOT in client 000. If you want to delete them, select ‘delete all’.
7. Once you are finished, select enter and choose the green arrow (Back) and save your changes.