ADMM_Snapshot Management_How to add custom logic to a field while extracting from source & How to extract long text tables? How to schedule extractions in snapshot management?

Hello Everyone,

I have a requirement to add a customer field into source table while extracting from source system like below,

While extracting data from MARA table, i need to add a additional custom field called Material Type with a case statement logic.

How can we achieve this in ADMM? In ADM we use to update assemble package to achieve this requirement.

Also how can we extract Long text tables data in ADMM?

And how to schedule extraction jobs in Snapshot Management?