Link between Withholding Tax Table and Accounting Doc. Table

[analistia16]

Hi Experts,

Has any of you have experience with using table WITH_ITEM (for withholding tax journal).

Currently I am facing a problem where I couldnt find any visible link between the line item in table WITH_ITEM with accounting document in table BSEG/BSIS/BSAS.

- Please refer to below screen cap, document number 1900015254 has two item for tax, line item 4 and 5

- In WITH_ITEM, the respective tax line items, have different line item number compared to the one in BSIS table (line item number 2 and 3)

Entries in BSIS:

Entries in WITH_ITEM:

How do I link those records in WITH_ITEM and BSIS table? I cannot use BUZEI (line item) because they are not the same in both tables.

Kindly advise,

Regards,

Analistia

[Former Member]

Hi Analistia,

The table WITH_ITEM is displayed all line Withholding tax item.

You can link record between WITH_ITEM and BSEG/BSIS/BSAS via field WHT type.

In table BSEG, it is field WHT code (BSEG-QSSKZ)

In table BSIS, it is field WHT code (BSIS-QSSKZ)

In table BSAS, it is field WHT code (BSAS-QSSKZ)

In table WITH_ITEM, it is field WHT type (WITH_ITEM-WITHT)

This field is the same between these tables.

Note: Be careful in case the line item has so many WHT type.

Julie

[Former Member]

Hi  Astry,

   As far as i know  line items in BSEG table  links to the the  "J_1IBUZEI" line item field in the table      WITH_TABLE.

try to this....