logic for tax data in purchase documents.

[Former Member]

Dear Experts,

As per user requirement,we need to capture the purchase data record like excise ,taxes  ect , we are passing  PO document, invoice and date of invoice(document date),which table i need to use for this J_1IEXCDTL  or BSET table ,is there any link between the tables.please suggest me.

Thanks in advance.

Regards,

Varun

[former_member187965]

Hi Varun,

For purchasing excise related data the tables, J_1IEXCHDR (Excise invoice header detail) and J_1IEXCDTL (Excise invoice line item details) are enough.

Pass, TRNTYP (Excise TT) as GRPO, EXNUM (Official No.) and EXYEAR (Excise year) to table J_1IEXCDTL and you will get all the PO and GR related details with excise duty values itemwise.

Pass, TRNTYP (Excise TT) as GRPO, EXNUM (Official No.) and EXYEAR (Excise year) to table J_1IEXCHDR and you will get the total of excise duty values for that invoice and the vendor excise details, for ex. ECC No, CST No, LST No, etc.

Excise invoice number and year with the excise transaction type (GRPO) is the unique combination for fetching data from both the tables.