Search found 10 matches

by arunsardana
Tue Aug 04, 2009 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help on SAP ABAP Extract stage
Replies: 2
Views: 2516

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 ...
by arunsardana
Mon Aug 03, 2009 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to install SAP PACK R/3 Client and Server
Replies: 7
Views: 4721

You will have to install client component, server component, couple of SAP transports in SAP that are shipped with the PACK and download a dll from SAP service marketplace. It's not for the weak hearted :) especially if you have not done it before and do not have general SAP knowledge like tranports...
by arunsardana
Wed Jul 22, 2009 7:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SAPBW - Reject Handling
Replies: 3
Views: 2002

I believe you can find the underlying table for PSA where reject rows are stored in BW and then use SAP ABAP extract PACK stage (yeah it works with BW as well) to pull that data from the table and bring it over in your staging area.

Regards,
Arun
by arunsardana
Tue Jul 21, 2009 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Return file from BAPI stage
Replies: 5
Views: 3688

So I guess you can simply ignore that character as it indicates end of text (kind of end of file). Let me know if still issues and I should be able to assist.

Regards,
Arun
by arunsardana
Tue Jul 21, 2009 2:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SAP BAPI Posting
Replies: 1
Views: 1831

Hello Jonnala, Sorry for the late response - didnt' login for some time. In any case, for BAPI stage with an output link (to extract data), there's an option in the stage under 'Read Logs' tab where you can specify 'Input File for Import Parameters'. All you have to do is provide your input values i...
by arunsardana
Tue Jul 21, 2009 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SAPBW - Reject Handling
Replies: 3
Views: 2002

Hi Rajesh, I am not sure if I understood your question completely but let me try to answer anyways. I am assuming you are using BW Load pack stage to load data into SAP BW (now referred to as SAP BI). Basically, there's not an ooption for reject data in the BW load stage. Anything that gets dropped ...
by arunsardana
Tue Jul 21, 2009 11:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using ABAP stage is not usefull for me
Replies: 5
Views: 5585

Hello, You will have to work closely with SAP basis team to get around this time limit issue. Basically, you will have to negotiate with SAP BASIS team (this is the team that controls SAP administration and is a different team from SAP SECURITY) if they are willing to increase the SAP runtime limit ...
by arunsardana
Tue Jul 21, 2009 11:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: month extraction in where clause of The ABAP Stage
Replies: 3
Views: 3168

Hello Saraswati, You can use following WHERE CLAUSE to extract data for any particular or previous month: SalesDate >= '20090601 and SalesData <= '20090630' ---this is an example for month of june. If you want to change the month dynamically, you can parameterize WHERE clause and then pass the previ...
by arunsardana
Fri Apr 17, 2009 7:21 am
Forum: Data Integration
Topic: CPIC Mode not supported
Replies: 2
Views: 16795

You need to have your SAP user id of type 'Communication' for CPIC to work. Ask your SAP security team to change your SAP userid from 'Dailog' type to 'communication' tyep and you should be able to extract data from SAP using ABAP Pack pretty easily. We do it all the time.
by arunsardana
Sun Oct 08, 2006 8:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ABAP extract stage with Parameter don't work
Replies: 2
Views: 3285

Re: ABAP extract stage with Parameter don't work

This comes from the developer of ABAP Stage :). You can use parameters in abap stage by simply defining the job parameter for a job and then selecting it from a drop down for "value" field in SQL condition screen. Instead of #param#, you will see values like "DS_JOB_PARAM@param"....