How to get tax amount from BSEG based on an invoice

[Former Member]

Hi All,

We're preparing a Z report for which we need to capture a) tax amount and b) Whether the accounting document is cleared or not  from BSEG table with reference to an Invoice number.

Now how to fetch the above mentioned two values. we have noticed that there is no value in tax amount field of BSEG table , though we charged tax in invoices.

And also in BSEG table there is a field called Debit / Credit . For SD transaction what would be field value , Is it going to be Debit or Credit  ?

Kindly advise .

regards,

Kumar

[former_member204407 · Accepted solution]

Dear

Have you tried with "BSID" and "BSAD" tables,

which suits to your requirement.

Regards,

Krishna.

[former_member209909]

This message was moderated.

[former_member209909]

This message was moderated.

[former_member184065]

Do not use BSEG table for Z reports since there will be a performance issue after development.

Use BSAD / BSID

Check the table BSET

Thanks