Hi
I am quite new to use SAP stages inside data stage.
I need to select two data structures (tables) from SAP R/3 using ABAP extract
I am not able to understand how to browse the tables available in SAP from DataStage and select its meta data their after.
Note: I could not find any button available to browse the tables in SAP in ABAP Extract stage.
Can you pls help me in this issue.
Thanks
Sai
Need help on SAP ABAP Extract stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 10
- Joined: Sun Oct 08, 2006 8:01 am
Let's say you want to add two most common tables in SAP MARA and MARC (these are the two material master tables). Start by clikcing on the build button under 'ABAP program' tab in the ABAP stage. Once in there, easiest way to add tables is to 'Search for Table' and typing in 'MARA' in "find in name" option. Once you have tables in the list, move it to the right by clickin on the '>' button andbring it under select table list. Next go to 'Select' tab and you will see all columns. You can select 'columns' and then go to 'Where' tab to put your where clause and so on. Once done here, close this window and click on 'Generate Program' which will generate abap program and you are ready to run your job that will extract table data from SAP and put it into a file or a database table etc.
good luck!!!
Regards,
Arun
good luck!!!
Regards,
Arun
The real danger is not that computers will begin to think like men, but that men will begin to think like computers. ~Sydney J. Harris
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom