How can you map two different CDTs (a basic one and another with all the columns

You don't need anything special as long as they have different names and they both use the @Table(name="") annotation to make it point to the same table.

Let's say that CDT A has two fields while CDT B has the 4 fields/columns the table has, for Appian this is transparent if the @Table annotation is telling it to point to this table since CDT A matches the table (because the table contains the two columns mapped to the CDT fields)

I omitted the @Table annotations.
Thank you Eduardo.
By the way...your name sounds very spanish. Where do you come from?
My name sounds French, but my mother languages are spanish and german.

You almost got it right, I am from Mexico. It's good to see we have Spanish speaking people as part of the Appian Forum Community. Bienvenido!

Aprovecho la oportunidad para aplaudir el excelente soporte que das en este foro.
Saludos!