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

Register | Login 

 
Lead By Knowing (Opens a new window)  

General Notice: No events within the next 45 days.

Loading to SAP BW Tables Directly


 
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
softsys
Senior Member
Senior Member



Joined: 13 May 2005

Posts: 50
Location: US


flag
PostPosted: Wed Feb 08, 2012 2:50 pm 
Post subject: Loading to SAP BW Tables Directly

I have been requested to find out if non-SAP flat file data can be loaded directly into SAP BW tables using data services and avoiding use of process chain on BW side ?

DS 4.0
BW 7.0

Thank you
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Fri Feb 10, 2012 8:40 am 
Post subject: Re: Loading to SAP BW Tables Directly

Yes and No. Yes we can load all data into an InfoSource or a DataSource (BW 7.3 required for the latter). And as these are nothing else than tables, the answer is yes.
But your question sounds more like "Can I load the data directly into a cube model?" No, BW does not allow that. Would love to but I am forbidden.

_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
aposullivan
Principal Member
Principal Member



Joined: 22 Jul 2004
ASUG Icon
Posts: 176
Location: Australia


flag
PostPosted: Sun Feb 12, 2012 7:01 pm 
Post subject: Re: Loading to SAP BW Tables Directly

Ok, here is my scenario. I am trying to load some data from SQL Server 2008 database through a source in BW that is Data Services source.

I have the RFC configuration working between Data Services 4.0 and BW 7.3.

In RSA1, under Modelling, I have created a Data Source to load Customer data. The source system is Data Services. In the Extraction tab the Adapter is set automatically to Load using RFC from Data Services and I have selected the source object of DBO.ODS_CUSTOMER.

In the Proposal tab, I have only selected 3 columns. In the Fields tab those same 3 columns are selected and they are:
CUST_ID, CUST_CLASSF and NAME1.

I have mapped these 3 columns to 3 infoobjects that I defined previously.

Data Type and Length all match.

What do I do next to load the SQL Server customer data into BW from this data source?

When right-clicking on the data source I can 'Create Transformation', 'Create Data Transfer Package' or 'Create InfoPackage'.

If I select Create InfoPackage, I give it a name and then it automatically fills in all the required tabs for me. I can then execute a Data Services job from this InfoPackage. In Data Services Management Console, I can see that the InfoPackage has been executed, but it doesn't finish successfully and fails with the following error message, which I do not understand:

(14.0) 02-13-12 10:42:20 (E) (8740:3504) RES-020104: |SESSION ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200|DATAFLOW ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200|STATEMENT <GUID::'dae4a319-f7ec-47b4-9b93-e8f841c346ab' LOAD TABLE "DS_SOURCE@NBICLNT200".""."ZDSCUSTOMER_TRAN@DS_SOURCE" INPUT("ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200")>
Cannot read from a file. Specify columns for file format <DS_SOURCE@NBICLNT200>. Notify Customer Support.


All i want to do is load some data into BW, using Data Services 4.0 and where the source is a sql server database table. I am not sure what I am missing. I cannot find any straight forward documentation on how you load data from Data Services into BW.

Many thanks to anyone who can put me onto the right steps of setting this up.

icon_mrgreen.gif
Back to top
softsys
Senior Member
Senior Member



Joined: 13 May 2005

Posts: 50
Location: US


flag
PostPosted: Mon Feb 13, 2012 8:37 pm 
Post subject: Re: Loading to SAP BW Tables Directly

Thanks Werner.
My next question is load to BW 7.0 using DS 4.0 can be done only thru either master or transaction structures ? There is no other way to load like flat file target ?

Thanks
Back to top
rodrigocpz
Senior Member
Senior Member



Joined: 26 Mar 2008

Posts: 54
Location: Brazil



PostPosted: Mon Jun 04, 2012 2:30 pm 
Post subject: Re: Loading to SAP BW Tables Directly

Hi, just for future queries, I faced the same issue here and solved, in my case, the Data Services job that BW create automatically is missing the target object, I create then a new BW target Data Store and import this target object manually, after that works running the job directly from BW

Best Regards,

Rodrigo.
Back to top
anup_kumar_n
Forum Member
Forum Member



Joined: 29 Apr 2008

Posts: 22


flag
PostPosted: Mon Jun 11, 2012 6:10 pm 
Post subject: Re: Loading to SAP BW Tables Directly

I have a custom DSO in SAP BW. I have data in an external sql server which needs to be loaded into this DSO. I created a SAP BW as Target Data source in data services and imported this DSO as a transaction source.

I created a data flow which reads data from the sql server and loads into this target table. The job fails giving error message

<Error 694 (RSM): Request REQU_1OPG0DSJHFQ64LJT5S86E5SAW properly ended; no further processing allowed from method BAPI_ISOURCE_TD_T_SEND.>

1) Can I load directly to the DSO table ? If so, why the error.

2) If not , does it always have to be a data source ?

SAP BW : 7.3
SAP DS: 4.0 (14.0.2)

Anup
Back to top
rodrigocpz
Senior Member
Senior Member



Joined: 26 Mar 2008

Posts: 54
Location: Brazil



PostPosted: Mon Jun 11, 2012 6:19 pm 
Post subject: Re: Loading to SAP BW Tables Directly

Anup, based on my experience, you can load just a PSA as it's considered a Data Source on BW
Back to top
anup_kumar_n
Forum Member
Forum Member



Joined: 29 Apr 2008

Posts: 22


flag
PostPosted: Mon Jun 11, 2012 7:38 pm 
Post subject: Re: Loading to SAP BW Tables Directly

rodrigo, figured that out now. But for some reason, data services job is giving error as mentioned earlier. Anybody get that ? I am not able to get a single record inserted into the PSA.
Back to top
Siva.dwh
Senior Member
Senior Member



Joined: 13 Nov 2008

Posts: 47



PostPosted: Tue Apr 30, 2013 4:34 am 
Post subject: Re: Loading to SAP BW Tables Directly

Dear aposullivan,

Have you got any solution for your scenario, because i got same issue .

Could you please provide steps to resolve the issue.

Issue #
|SESSION ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200|DATAFLOW ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200|STATEMENT <GUID::'acca2fd9-443f-4617-b92d-8c4db33f1b28' LOAD TABLE "REPO@BPDCLNT200".""."DS_TRAN@REPO" INPUT("ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200")>
Cannot read from a file. Specify columns for file format <REPO@BPDCLNT200>. Notify Customer Support.

Thanks,
Back to top
Siva.dwh
Senior Member
Senior Member



Joined: 13 Nov 2008

Posts: 47



PostPosted: Thu May 02, 2013 6:05 am 
Post subject: Re: Loading to SAP BW Tables Directly

Hi aposullivan,

In your scenraio

1. Data types are not mismatch - BODS & BW
2. Quality of data is not loading
3. File format is not specified properly
4. Ex BODS - 2012.MON
But BW will not support above format.
It will support 2012.MM only.

like that same columns from both sides and relavant data type is required.

Thanks,
Back to top
bmvrus
Principal Member
Principal Member



Joined: 08 May 2011

Posts: 213
Location: Moscow



PostPosted: Sun Jun 09, 2013 5:47 am 
Post subject: Re: Loading to SAP BW Tables Directly

DS - Ability to direct write to ABAP tables.

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=34503CB9-F213-4EF9-8603-E500CB16D712&idea_id=2F931BA4-3B5D-472E-BDDF-7689E33B47C8
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.0461 seconds using 17 queries. (SQL 0.0031 Parse 0.0337 Other 0.0093)
CCBot/2.0 (http://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