I have two tables. In table A i have Equipment and Posting Date.
In table B i have [Sales Document],
Now for [Sales Document],Item , and MaterialEntered the condition is i need to get only records based on the below condition i.e.
if both the table equipments matches and Posting Date>=Start_DT_New and Posting <=End_DT_New.
Can you please tell me how to achieve this and let me know if you need anything more.
Are you saying Equipment is not the most granular data and something else is?
You need to filter the date condition right? If you need the data that is present in table 1 you can definitely do a left join , apply map will give you the flexibility to enter default value for the non matching rows. At the end you need to see what is feasible for the data set you are using.