Is the consolidated transcript required and should it include all semesters or only the major subject courses in Germany for a Master's?

Yes, a consolidated transcript is typically required for master's applications in Germany, and it should include all semesters and all courses you have completed - not just your major subject courses.

German universities expect a comprehensive academic record to assess your overall performance and eligibility. Make sure your transcript lists all modules, courses, credit points, and grades from your entire academic program.