BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Best and fastest method to read SAP ECC


 
Search this topic... | Search DI: SAP-specific ERP/BW... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Author Message
aragornII
Senior Member
Senior Member



Joined: 21 Dec 2006

Posts: 55
Location: Belgium


flag
PostPosted: Mon Jun 02, 2014 2:19 am 
Post subject: Best and fastest method to read SAP ECC

All,

I searched all the documentation about connecting to SAP Applications Datastore, but I did not figure out what's the best method to connect:

Our task: read data, preferable only delta data from a set of SAP tables (for instance, VBAP, VBUP, VBPA, JEST, ...)

Untill now we were working with abap dataflows but we encounter a lot of problems transporting our abap from dev to the other environments. (in combination with the shared directory method)

Is the RFC method better and faster (also taken into account the amount of data in the tables?)

Thanks!
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Mon Jun 02, 2014 3:03 am 
Post subject: Re: Best and fastest method to read SAP ECC

RFC read table with RFC streaming will result in not requiring to transport ABAP.

However RFC read table is limited to reading 1 table, with if applicable a where clause.

Joining multiple tables will force you to use ABAP.

We are extracting the full tables to prevent code changes because for example 1 field was missing from a specification. As long as the delta is correctly defined, then you are okay.

_________________
Consultant at Teradata

The opinions expressed in this post are my own views and not those of Teradata. Apply any advise in this post at your own discretion.
Back to top
aragornII
Senior Member
Senior Member



Joined: 21 Dec 2006

Posts: 55
Location: Belgium


flag
PostPosted: Mon Jun 02, 2014 3:27 am 
Post subject: Re: Best and fastest method to read SAP ECC

Thanks for the reply Johannes,

So we are using the correct method after all icon_wink.gif
Even with the abap, you are getting all the data or did you built a delta mechanism for it?

I am also experiencing lots of problems with bods 4.2 / sap ecc 6.0 and netweaver 7.2

At first we needed to upload special transport files (the ones supplied with installation where not correct) but now we are running into
https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3137323334323026

Although the solution provided is not for our version and if we try to manually upload the function described it gives also errors.
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Mon Jun 02, 2014 3:58 am 
Post subject: Re: Best and fastest method to read SAP ECC

Full loads for VBAK etc are not an option here icon_wink.gif

Most delta's are custom build, based on standard SAP and standard indexes. So often a select on the creation date and changes via the change header table.

Do you have the transport files via SAP Note 1919255 - How to obtain transport files for Data Services and SAP Hana Cloud Integration for Data Services
and then have the transport files via SAP Note 1916294?

If so, then please contact SAP. It should work...

And in the SAP datastore the $TMP is defined?

_________________
Consultant at Teradata

The opinions expressed in this post are my own views and not those of Teradata. Apply any advise in this post at your own discretion.
Back to top
aragornII
Senior Member
Senior Member



Joined: 21 Dec 2006

Posts: 55
Location: Belgium


flag
PostPosted: Mon Jun 02, 2014 4:25 am 
Post subject: Re: Best and fastest method to read SAP ECC

I understand icon_smile.gif
We have to make something here as well because these tables are huge and take a lot of time to get all data.

Those notes where indeed implemented, but the issue is with the transport of the abap program itself.

When we keep the default $TMP he is uploading into the system (abap exists, we checked) but the transport is empty. So he is not making the right link between the transport and the function/functions that should exist in it.

When we change the $TMP to the correct development class they are using for the 'normal' ABAP team, it results in the error 1723420 - Unable to load DS generated ABAP into ECC: error code <RS_CORR_INSERT:1>

But the attached aw_upload in that note seems older then the one delivered by SAP in the installation folder of BODS 4.2

We tried first the one of the installation folder but that failed.
Last attempt will be now the attached file and if that fails as well, then we have no other option than to file a new ticket.
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Mon Jun 02, 2014 5:47 am 
Post subject: Re: Best and fastest method to read SAP ECC

Just a thought: could it be an authorization challenge?
Between the documention of 4.0 and 4.1, the 4.1 SAP supplement has an additional entry for package "$TMP".

Not sure though, I've not encountered problems yet as we are still on 4.0...

_________________
Consultant at Teradata

The opinions expressed in this post are my own views and not those of Teradata. Apply any advise in this post at your own discretion.
Back to top
aragornII
Senior Member
Senior Member



Joined: 21 Dec 2006

Posts: 55
Location: Belgium


flag
PostPosted: Mon Jun 02, 2014 6:28 am 
Post subject: Re: Best and fastest method to read SAP ECC

I am afraid not, user has SAP_ALL :p
So that can be excluded.
I searched in the documentation for the $tmp but its not giving more info it seems.
The user has the role S_DEVELOP since he is SAP_ALL.


Code:

Purpose: This authorization allows Data Services to run generated programs on the SAP server.
Use: DEV
Text (Description): ABAP Workbench
Class: Basis - Development Environment
Field Values
Package $TMP
Object type PROG
Object name List of temporary program names that are allowed to
be generated
Authorization group ABAP/4 program Not used
Activity 01 and 02


Hopefully SAP can help me out with this, as soon as I get a reply, I will post the solution in this topic.
Back to top
pavani_yerra
Principal Member
Principal Member



Joined: 28 Apr 2010

Posts: 113



PostPosted: Thu Apr 02, 2015 6:17 am 
Post subject: Re: Best and fastest method to read SAP ECC

HI,

Are you able to extract data from VBAP or VBUP using ABAP dataflow mechanism without seeing much performance issues.

We are also seeing similar issue in our project. With huge volume of data in QA VBUP ran for 43 minutes and we need to run this everyday in PROD.

Please suggest if there is a way to reduce this performance impact and also best way to extract data other than ABAP dataflow.

Thanks in advance!
Pavani
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0350 seconds using 17 queries. (SQL 0.0084 Parse 0.0009 Other 0.0257)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo