$GV_Batch_No = 0 # will be assigned in next flows $GV_Curr_Batch_No = 0 # will be assigned in next flows $GV_UpdateQuery = ” # will be assigned in next flows $GV_Query = null # will be assigned in next flows
$GV_STATUSFLAG = ” # will be assigned in next flows $FLAG = 0 # will be assigned in next flows $KEY = 0 # will be assigned in next flows $GV_FolderName = ” # will be assigned in next flows. $GV_FILENAME_KEY = 0 # will be assigned in next flows. $GV_FILENAME = ” # will be assigned in next flows. $TargetFileName = ” # will be assigned in next flows. $TargetFilePath = ” # will be assigned in next flows. $SourceFileName = ” # will be assigned in next flows.
$SourceFilePath = ‘\\\ xyz.com\shared\CA002\IT\GTS\HTS-ECCN_Watch_Folder’ $SRC_HeaderFilePath = ‘\\\ xyz.com\shared\CA002\IT\GTS\HTS-ECCN_Watch_Folder\HTS-ECCN_Header_Formats’ $ECCNMANDT = ‘110 ‘ # Always keep 2 blank spaces after the 3 digit number. $HTSWERKS = ‘0102 ‘ # Always keep 2 blank spaces after the 4 digit number. $HTSMANDT = ‘200 ‘ # Always keep 2 blank spaces after the 3 digit number. $G_Email_Header = ” # will be assigned in next flows. $G_Email_Message = ” # will be assigned in next flows. # Variables Declaration Required inside the Job as per requirement to satisfy the Logic.# Which is used by BODS to read the STATIC HEADER into a Input File with DELETE before Load & then, this Input File is again used a TARGET file in next flow to load the actual source input excel file data as an append mechanism without Enabling DELETE Option. Maintained Header Format Folder, where STATIC HEADER format files are stored in TEXT file format. It will also move the input file to this directory for confirmation that it was processed.īefore generating Files, separate folder has to be created via BODS & generate files inside the folder as below. In the directory, the job will place all non-blank HTS and ECCN files that can be generated from the input file. Note: The job checks every 5 minutes for new data. Upon finding one, it will process the file and create an output directory with the following format: A Data Services job will be scheduled to scan for these files.Note: Don’t use SPACES or PERIODS in the input filename. Place file using GTS_HTS_ECCN_LOAD_TEMPLATE.xlsx format with a filename that BEGINS with “HTSECCN_RTP_”.Maintained a READ-ME Document for USERS to follow the INPUT files placing: –-ĭisplayed Fields: 4 of 4 Fixed Columns:3 List Width 0500 | |MANDT|MATNR |ALAND|GEGRU|ALNUM |EMBGR |PMAST|SECGK | Already processed files should be ignored & job has to be terminated.Įxample: Each Output file should have below HEADER Starting Lines under which data has be loaded with proper line-spacing.ĭisplayed Fields: 8 of 8 Fixed Columns: 4 List Width 0250.There might be multiple Input files, So, need to create a BATCH wise load mechanism.BODS Job has to be running every 12 Min & search for the File in Input Folder, if not found wait spooning for few minutes & abort the job.Output Text file has a specified format, into which data has to be generated on the basis of country.Before Generating Multiple Country wise files, BODS has to create a FOLDER with file-name format on run-time.Generate Multiple Output Text files separately for Each Country from a single Input file. SAP BODS – Multiple Files Generation with STATIC pre-defined Format in Text File.
0 kommentar(er)
