Excise Invoice Quantity

[Former Member]

Dear all,

I have a requirement to fetch excise invoice qty against a sales order for a report. I am thinking of fetching it from VBFA where I am giving the follow on doc as the excise invoice (JEX) number. Is this the right way please let me know.

Thanks & Regards,

AK

[Former Member]

Hi,

Check this logic.

J_1IEXCHDR-RDOC (Invoice Number) for each J_1IEXCHDR-DOCNO (excise invoice number) from J_1IEXCHDR table.

J_1IEXCHDR-RDOC = VBRP- VBELN then get VBRP- AUBEL (Sale Order number)

VBRP-AUBEL = VBAP-VBLEN

VBRP-FKIMG (Excise invoice quantity)

Get

VBAP- KWMENG (Order quantity)

Regards,

Sharan