Dynamic names to target tables - SAP BODS

[former_member310495]

Hi Experts,

Can I add dynamic names(using variable) to target tables. Actually my requirement is we have 5 districts data in one table. In target need to create 5 separate tables with district name.

Thanks,

Pavan Sharma Aurora.

[former_member187605 · Accepted solution]

No, you cannot.

But there's a workaround. When using a DS template table, you can rename the target table in a script. Put the RENAME command as 2nd parameter in a call to the sql built-in function.