3769769 - Invalid Column Name Errors Occur When Source Columns Contain Unsupported Special Characters in prophecy for SAP Incentive Management Admin

• An error occurs when mapping from the input file to the target table using reformat: a column named "account (BAN)" is automatically taken as "account _AN_".
• Error message: "invalid column name account _AN_".
• After adding a format/reformat step, target column names with parentheses are changed to use underscores (for example, Account Number(AN) becomes Account Number_AN_).

SAP Sales Performance Management

• Incentive Management
• Incentive Management on Hyperscalers

reformat, invalid column name, parentheses, brackets, underscore, column name sanitation, naming convention, mapping error, pipeline, schema validation, temporary table, bigquery, transformation, target table, column rename , KBA , CEC-SAL-COM-INT , Application Integration , CEC-SAL-COM-TITAN , SPM Titan Ref Architecture and Migration Incentive Mgmt , Problem