Skip to Content
0
Dec 03, 2021 at 12:07 PM

Sales Order Quantity (converted)

147 Views

Hello there,

I prepared a report on invoices. Here, some groups of goods are sold in both NUMBER and M2 units of measure.

I wrote the following (converted) if condition to differentiate them in the invoice report:

If(MATKL='MG0008',FKLMG,FKIMG) AS INVOICED_AMOUNT

I am preparing an Order Report and I would like to make such a distinction here.

Field related to the order quantity in the order table (VBAP): KWMENG field. I also want to write an IF condition for order quantities, similar to the IF condition I made in the invoice report.

I can't reach the other field name that should be in my if condition (in case of no KWMENG) from the VBAP table.

Will you support?

Thanks in advance.