Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

(BDC) downloading .....

Former Member

‎10-18-2007 4:23 AM

0 Kudos

Hi Experts,

here am writing a bdc program inthat am uploading one text file, it contains heading and data, after that am doing some calclations on that data. based on that source data am getting some data from standard tables and adding into target file.

now my target file contains source data and extracted data, but my problem is here is i want 2 provide headings for that extracted data, here my my source data having headings.

how to add headings to my extracted data into my target file.

my source data is like.

BRANCH|XRE_TTY|ORIG_CURR|ORIG_AMT|BASE_AMT|QTR_END_DATE|COB|MAIN_CLASS|FI_YEAR|TTY_TYPE|FI_DATE|FI_MONTH|UWYEAR|FACESLIP

S|S-CCG-P-96-0064-99|HKD|152552.74|33981.00|20010630|CCG|C|2001|P|20010601|06|1999|S-ASS-OSLR-15527

S|S-EEG-P-96-0065-00|HKD|73572.44|17271.00|20010930|EEG|E|2001|P|20010901|09|2000|S-ASS-OSLR-15528

S|S-EEG-P-96-0065-01|HKD|3384.68|795.00|20010930|EEG|E|2001|P|20010901|09|2001|S-ASS-OSLR-15529

S|S-EEG-P-96-0065-96|HKD|109890.55|25797.00|20010930|EEG|E|2001|P|20010901|09|1996|S-ASS-OSLR-15530

S|S-EEG-P-96-0065-97|HKD|210870.95|49502.00|20010930|EEG|E|2001|P|20010901|09|1997|S-ASS-OSLR-15531

and my target file is

B XRE_TTY ORI ORIG_AMT BASE_AMT QTR_END_ COB M FI_Y T FI_DATE FI UWYE FACESLIP 00.00.0000

S S-CCG-P-96-0064-99 HKD 152552.7433981.00 20010630 CCG C 2001 P 20010601 06 1999 S-ASS-OSLR-15527 01.01.199900000000000000203413 0001 0000000583 CCG

S S-EEG-P-96-0065-00 HKD 73572.44 17271.00 20010930 EEG E 2001 P 20010901 09 2000 S-ASS-OSLR-15528 01.01.200000000000000000203414 0001 0000000583 EEG

S S-EEG-P-96-0065-01 HKD 3384.68 795.00 20010930 EEG E 2001 P 20010901 09 2001 S-ASS-OSLR-15529 01.01.200100000000000000203414 0001 0000000583 EEG

S S-EEG-P-96-0065-96 HKD 109890.5525797.00 20010930 EEG E 2001 P 20010901 09 1996 S-ASS-OSLR-15530 01.01.199600000000000000203414 0001 0000000583 EEG

S S-EEG-P-96-0065-97 HKD 210870.9549502.00 20010930 EEG E 2001 P 20010901 09 1997 S-ASS-OSLR-15531 01.01.199700000000000000203414 0001 0000000583 EEG

in my target file am adding extra 5 fields. i want 2 provide haedings to that 5 fields.

Thanks in advance,

murali.

1 REPLY 1

Former Member

‎10-18-2007 4:32 AM

0 Kudos

When you are populating target file, are you appending data to existing source file?

In any case while populating final internal table, you need to add declaration for extra 5 fields also.

First you populate source data to this final table. In this case, those 5 fields will contain space / blanks.

Then you add / append heading of target data to the final table. After this append all data lines to final table.

Once source and target data is added to the final table, download this as a new file.

Hope this helps.

ashish