Logic for fetching Quantity Delivered and Invoiced

[former_member216345]

I am creating a Sales Order report in which I need to Fetch the delivered Quantity and Invoiced Quantity fields.

I am currently going to VBFA table and pass SO and line item number and fetch all data. Then I perform addition/ subtraction to remove cancelled quantities. this is making the logic complicated.

Is there any standard Function module/ or table or BAPI which can fetch the Delivered and Invoiced quantities directly?

Regards,

Onkar Borkar

[former_member216345]

Hi Experts,

There is a requirement where in it is required to track changes in the field 'Batch' in the deliveries. This change log report should have the option of checking the log for multiple deliveires at a time. It can be similar to the delivery change log report that we have but shoul run for multiple deliveries at a time.

Please let me know if such a reporet is available in standard SAP or in LIS repporting.

Thanks/ Regards,

Onkar

[Former Member]

Hi,

connect your logic like this

After passing SO and line item number, refer table LIPSD filed G_LFIMG for delivered qyt and then to to table VBRP field FKIMG for actual billed qty.

The report with these tables may get performance issues, to ease out and improve efficiency you can refer structure DOCUMENT_FLOW_ALV_STRUC where all these datas are available.

Hope this solves your issues.

Thanks &regards

Hameed Parvez