Thanks for the question and using MS Q&A platform.
I understand that you are facing an issue with the partition condition not being consistently applied in incremental loads after full load execution in Synapse Dataflow when utilizing the SAP CDC source.
check if the SAP CDC connector is configured correctly and if the partition condition is specified correctly in the SAP CDC source dataset.
the SAP CDC connector uses the SAP ODP framework to extract data from SAP source systems. please go through: https://learn.microsoft.com/en-us/azure/data-factory/connector-sap-change-data-capture you can use a manual, limited workaround to extract mostly new or updated records. In a process called watermarking, extraction requires using a timestamp column, monotonically increasing values, and continuously tracking the highest value since the last extraction. However, some tables don’t have a column that you can use for watermarking. please follow the blog https://techcommunity.microsoft.com/t5/fasttrack-for-azure/metadata-driven-data-ingestion-pipeline-using-the-sap-cdc/ba-p/3940416
if the issue persists do let us know. Hope this helps. Do let us know if you any further queries.