Checking Data Consistency 

Use

For Brazilian condition-based tax calculation to function correctly, each tax entry in the Brazilian tax tables (J_1B* tables) must have exactly one corresponding entry in the condition database, and vice versa, meaning there must be a 1:1 relationship.

However, for a number of reasons, the corresponding tax entry or condition record may be missing. You can use the migration function to check for missing condition records. The other case would be for condition records to exist without corresponding tax entries – if, for example, you have deactivated automatic generation of condition records and subsequently deleted tax data, or if you have manually created condition records. To ensure consistency of data in the tax tables, follow the procedure below.  

Procedure

...

       1.      From the SAP Easy Access menu, choose Tools  ® ABAP Workbench  ® Development  ® ABAP Editor (Transaction SE38).

       2.      Run program J_1B_CBT_CONSIST, and the system displays a list of condition tables.

       3.      Double-click a table, and the system displays all condition records used for Brazilian tax calculation.

¡        The traffic light indicates the status of the condition record: red means there is no corresponding record in the tax table; yellow means a record exists in the tax table, but the data differs (for example, the tax rate); and green means a correct corresponding entry exists.

¡        At the far right, you see the corresponding Brazilian tax table as well as the index in the table (for condition records with yellow and green status only; for red entries, this field is blank).

       4.      Select all condition records with red and yellow status, and delete them by choosing the Delete condition records pushbutton.

       5.      Repeat steps 3 and 4 for each of the condition tables. For the tax calculation to function properly, all condition tables must contain green entries only.

Once you have viewed a condition table, the icon next to it changes to include a pair of eyeglasses, ; if you have made at least one change to a table, the icon includes a diskette, .