766 B
Fix the CDS view entity {{P}}I_FILM_REVENUE in package $TMP. It must show one row for each film that has at least one ticket. Do not show films without tickets. TICKET_COUNT is the number of tickets sold for the film. REVENUE is the sum of the prices of all tickets for the film. The view elements are FILM (key), TICKET_COUNT, and REVENUE. The view has no authorization check (#NOT_REQUIRED). All other behavior stays the same. Do not change {{P}}SCREEN, {{P}}TICKET, or {{P}}SEED_CINEMA. Do not create other objects. The target release is SAP_BASIS 816. Use Clean ABAP and have no ATC priority 1 or 2 findings. The view must be active and have no syntax error. The hidden tests must pass. Write ABAP Unit tests with CL_CDS_TEST_ENVIRONMENT in a global test class.