Skip to Content
0
Jun 20, 2020 at 04:10 PM

Calculated field MAX([PLPO-ZAEHL])

165 Views

I have a table Join Query that has this field in the report, what I need to do is create a calculated column that will give me a 1 if the internal counter for each material number is the highest and a 0 if it's not the highest... My Table joins are:

CRHD-OBJID left outjoin PLPO-ARBID

PLPO-[PLNTY-PLNNR-WERKS] inner join MAPL-[PLNTY-PLNNR-WERKS]

MAPL-[MATNR-WERKS] inner join MARC-[MATNR-WERKS]

MARC-[MATNR-WERKS] inner join MBEW-[MATNR-BWKEY]

The reason why I want them to have the 0's and 1's is because I want to use this calculation in the selecction screen to avoid having multiple results in the report...

Can this be achieve?

I can't handle ABAP and I want to avoid going to an ABAPer....