on 03-29-2006 1:36 PM
Hello,
i'm new in BW - i try to load data from a flat file. How can I define in InfoSource / communication structure to irgnore some column's.
I.e. to igrnore the first, 4., 6..
The 2., 3., 5. and 7. are values to import.
Best regards,
Alexander
Hi Alexander Kutz,
Simple way is just define the data source same as your flat file(dont ignore any fields). Define communication structure only the required fields and map it accordingly in transfer rules.
or define all the fields in communication structure and map only required fields in update rules from thsis communication structure, dont map for other fields..
Hope this helps.
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alexander,
While loading the data, the funda is you can load the data from a file to a structure is both are identical. So, if both your flat file and the communication structure are not in sync, you can not load the data.
As per your issue, if you want to avoid these odd 50 columns, better create a new flat file which does not contain them and as per the new file's structure and load the data.
Hope it helps!!!!
Do not forget to assign points, if helpful.
Amit
As stated before, deleting the unwanted fields is the most straightforward and cleanest solution.
However, if, for whatever reason, you are unable to remove them from the flatfile, you should also be able to omit the unwanted columns by positioning them to the rightmost position(s) of the file layout. For example, if costcenter and glaccount are included within your flatfile, but are not to be loaded into BW, position them as the last columns within your flatfile. Be sure NOT to include them within your comm/trans structure.
Rod
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
Also Go through this help documents.
Maintaining Communications Structures with Flexible Updating
http://help.sap.com/saphelp_bw31/helpdata/en/80/1a62a5e07211d2acb80000e829fbfe/content.htm
Maintaining Communication Structures with Direct Updating
http://help.sap.com/saphelp_bw31/helpdata/en/65/2cde3776061051e10000009b38f842/content.htm
Assign Points if this helps
Cheers,
Aravindhan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.