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.

SAP Datastore components


 
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
Shazin
Principal Member
Principal Member



Joined: 19 Jul 2011

Posts: 284
Location: India


flag
PostPosted: Thu May 25, 2017 5:20 am 
Post subject: SAP Datastore components

Hi Guys.

Please can anyone share the documentation as to what are the different use cases of different options to fetch data from SAP DS e.g using Open Hub or Using Tables etc.

Regards.
Shaz
Back to top
ErikR
Forum Enthusiast
Forum Enthusiast



Joined: 10 Jan 2007

Posts: 1111
Location: Wellington, NZ


flag
PostPosted: Mon May 29, 2017 6:14 pm 
Post subject: Re: SAP Datastore components

Open Hub is a BW component and could be used to source data from BW but not directly from Business Suite systems such as ECC, S/4, CRM and SRM/APO.

For sourcing data from ECC 6.0, you can use RFC Streaming for simple table downloads (but no joins or complex logic on the SAP-end).

You can also use ABAP Data Flows using RFC Streaming and/or file-based transfer (I typically recommend RFC Streaming here) in which Data Services generates ABAP programs that can contain joins and SAP function calls to pre-filter the data for extraction. However, this is a more involved process and will also require you to create the ABAP Data Flows in your ECC development environment and have them transported through to QA and PROD.

For other scenario's you may need to make BAPI function calls to get the data you require.

For near-real-time processing, you can receive IDocs as well but these can be more complex to work with due to their nested structures, much like XML.

Note that extracting directly from the database is typically frowned upon. The database itself is very complex, can change with any ECC Service Pack or Enhancement Pack and certain types of data is stored in a binary format which you cannot access directly at the database level (e.g. HR data).

Best practice is always to interface with any SAP environment through the Application Server and the proper APIs.

For data loading, direct database writes are a complete no-no. Again, you have multiple interfaces available such as generating IDocs or using BAPI function calls. Alternatively, you can generate upload files and load the data manually through LSMW although SAP recommends the use of Data Services for SAP S/4 data migrations/uploads as some of the legacy LSMW structures have not been maintained for the structure changes in S/4 (e.g. the removal of customer and vendor masters in favour of the business partner structures).

I strongly suggest going to the SAP Help site for Data Services and download the complete Technical Manuals (which is a bundle of all reference documentation) or download the Supplement for SAP individually if you only need details on how to interface with SAP ERP environments.

https://help.sap.com/viewer/p/SAP_DATA_SERVICES
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.0269 seconds using 17 queries. (SQL 0.0030 Parse 0.0008 Other 0.0231)
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