Issue:
When clicking the Create Source Table button in AutoGen, the source's Schema Columns page in Map is updated to mark a field "inactive", which causes the field to not be included in the autogenerated source table. No matter how many times the field is forced back to "active" (or even set as a "lock field"), the Create Source Table operation flips it back to "inactive".
Cause(s):
This is a bug in all versions of SST/DSP prior to 6.3.1 ([DSP-5981]). If a target field is set "inactive" in Design, then any source fields with the same name that are mapped to the same target will be forced "inactive" during the autogeneration of the source table. This happens commonly when migrating between identical systems (e.g. SAP to SAP).
Resolution:
Set the target field "active" in Design and set the Action value for that field's mappings to 'Not Used'.
Similar Issue:
[ADM] Error: “Cannot insert the value NULL into column 'zSource', table ttBUT000"