Extracting SAP ECC VBAP table using Dataflow instead of ABAP

dataservices sap-erp-bw
1

Hi all,

Iam trying to extract VBAP table from ECC into DS using dataflow instead of ABAP dataflow. I can’t use ABAP as we have some issues with it.

So the only option is to use dataflow. This is a stop gap solution. We troubleshooted by checking trace log in ECC what actually is happening at source level and found below issues.

  1. I need only 5 fields from VBAP table and iam pulling these fields only into query transform. when i see optimized sql in Data services its showing me these 5 fields but when i check the query in ECC side it is selecting all the fields in VBAP table.

  2. Iam using filter conditions in where clause but ECC is not picking those filter conditions instead reading whole table. One more interesting thing was when i use one condition using ‘AND’ operator it works but when i use ‘OR’ it is not selecting any of the conditions.

I appreciate your help.

Thanks,
Arun.
:hb:

arunnura17 (BOB member since 2007-03-30)

2

That is the RFC Read Table method of getting data from SAP.

Definitely not suited for large SAP Tables. It will read the entire table no matter what columns you specify or what filter conditions you specify. All it can do is bring the entire table to Data Services and then apply whatever filters you specified/whatever columns you have chosen in the DS Job Server memory and give the results to you

http://wiki.sdn.sap.com/wiki/display/EIM/Reading+via+RFC+Read+Table

ganeshxp :us: (BOB member since 2008-07-17)