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....