Adding a column to the view which shows the date in format YYYYMM
(Assuming DB2 for Linux/Unix/Windows here, since you don't specify, but this will probably also work on the other platforms.)

You don't have to do funky date math, there is a built-in function VARCHAR_FORMAT that will do it for you:

SELECT VARCHAR_FORMAT(CURRENT DATE, 'YYYYMM')
FROM SYSIBM.SYSDUMMY1