Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member208363
Active Participant

We can create the destination file names like CSV,TXT,XML with dynamic date names in SAP BODS.

Create a job with Script > Data flow

Script Code:

$G_CurrentDate= sysdate();

print($G_CurrentDate);

$G_Filename = 'Dynamic_File_Name_'||substr(sysdate(),0,10)||'.csv';

print($G_Filename);

Declare the variable $G_CurrentDate as date and $G_Filename as varchar.

Place this variable $G_Filename in the File name of the File Format Editor

Create the Global Variables:

Create the data flow with the following:

Create a file format Editor

Choose the directories for destination file path.

Labels in this area