ich bekomme alle IBAN angezigt die im System angelegt wurden..deshalb habe ich recherchiert und folgendes von 2007 umgesetzt..natürlich mit den Kundentabellen...funktioniert aber leider nicht....HIIILFE :)
Try the following plan. The plan is to create a new field to populate with the maximum of the dates and make it compare with the valid from dates. Strike the difference between these two fields. Pull only those records where the valid from date is equal to maximum date.
Go to the infoset. Click on Extras. Create an additional field say MAXDATE LIKE TIBAN-VALID_FROM.
Go to the coding section and give the following coding
DATA: ZMAXDATE LIKE TIBAN-VALID_FROM.
CLEAR:ZMAXDATE, MAXDATE.
SELECT MAX( VALID_FROM ) FROM TIBAN INTO ZMAXDATE WHERE
BANKS = LFBK-BANKS AND
BANKL = LFBK-BANKL AND
BANKN = LFBK-BANKN.
MAXDATE = ZMAXDATE.
Generate, save, assign the additional field to a field group.
Also include VALID_FROM field of TIBAN table into the field group.
Go to query, and create a local field called Difference, by enabling short names on. Give the ZMAXDATE field as MAX and TIBAN-VALID_FROM as VALFROM. Give the formula for the new field as difference between VALFROM - MAX.
Include the new field in the selection parameters. When running the report restrict the DIFFERENCE field = 0.