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.