Is it possible to create database view without foreign key relationship for tables?

· Designed a Smartform for dunning procedure for accounting dunning and form is converted into PDF which is configured as output in T-Code F150 and FBMP and converted into PDF format.

I need to develop an ALV report for calculating consumption of BOM for a material. Please tell me the tables and fields that I need to refer to develop this object.

My requirement is to develop a report to display gross sales, credit return and gross weight for the customer for the current year and comparing the same with that of the previous year for the same period. Please mention what are the tables and field...