Using the transaction code CTBW_META we can easily create rquired infoobjects, transfer rules, infosources all in one go for a given datasource. This is usefull while creating custom generic extractors on with not common fields. It saves us time and effort to be spent on creating each indivitual infoobject manually. Below are step by step instructions with screenshots on using this transaction code.
We have following datasource with 9 fields for wich we are trying to automatically generate corresponding infoobjects using the trasnsaction code CTBW_META
After creating above datasource replicate it in BW. When your replicate make sure that you select "import as a 3.X datasource" when in prompts. It looks like CTBW_META does not work for 7.X datasources. You can migrate it back to 7.X later. This transaction only supports 3.X flow and does not support 7.X flow.
1. Go to transaction code CTBW_META
2. Enter the source system and datasource and then select the second radio button "Create InfoObject/Source"
3. Press enter. This will generate some more input fileds enter in the infosource name and application component and presse enter. If you get below warning ignore it and press enter one more time.
4. In the next screen specify Infoobject Catelogs for characterstics and key figures.
5. Some of the fields might have blank in the incobject column, you can fill these with existing incoobjects. You can also change generated infoobject names from C_ to Z_ as shown below.
6. Click on execute button at the top.
7. This will create and activate all the infoobjects and take you through the screens for all the infoobjects that has problems with the default settings. For example below infoobject has a lenght of 100 but the maximum lenght supported by BW is 60, so change the lenght to 60 and then click on activate button.
8. You will get a message "All InfoObjects" activated if everything goes fine.
9. Click back button and say yes to the messages, it will create text infosources for alls the indibidual infoobjects.
10. After all the activations are complete it will take you to th elog screen.
11.Go to the datasources screen and verify that transfer rules with all the required infoobjects are generated correctly.
12. .We are done. It is has created all the required infoobjects, created the infosource and finally created transfer rules mapping the infoobjects in the infosource to the fields in the datasource.
