Hi Vineet S ,
Thankyou for using Microsoft Q&A platform and thanks for posting your query here .
Based on the your query, it seems like you are looking for a way to load incremental data (to avoid full load everytime) in SAP using ADF or databricks.
There could be multiple ways to achieve this requirement , either creating datapipelines, or write databricks code , or using mapping dataflow, or else by using CDC capabilities within ADF, which seems to be the most efficient approach.
Change data capture (CDC) allows you to track changes to a table and capture only the modified data, which can help to reduce the amount of data that needs to be processed and loaded.
For implementation, kindly check the below relevant resources:
Overview and architecture of the SAP CDC capabilities
Hope it helps. Thankyou