Skip to Content
Author's profile photo Raman Korrapati

Loading data to info provider without PSA #SAP BW 7.X

DTP settings to load data directly to targets without PSA:


Recently I came across this situation to load data directly to target without psa.

Before that we need to consider the below steps.

  1. Always full load
  2. Data volume is less
  3. No wrong data, if not sure then need taken care thru error stack concept.

How to find whether data source support direct access or not:

Two ways we can find:

1. By using ECC table SE11 – ROOSOURCE, try to see the table data with selection on your data source.

after that you can see the field VIRTCUBE – 1 (direct access allowed/supported).


2. at BW side, RSA1–> Data source–> double click –> Extraction tab also we can see the same information.

  /wp-content/uploads/2013/12/dc_339457.jpg


Advantages: No PSA maintenance/Info pack load.


BW 7.x  DTP screen shot where we don’t have setting to bypass psa for transaction data sources.

/wp-content/uploads/2013/12/33_338207.jpg


Below one is BW 7.x we can see the new settings as shown below for master data sources only.

/wp-content/uploads/2013/12/dtp_338208.jpg


Once we select above options we will get default adapter settings to access directly from source.


/wp-content/uploads/2013/12/dtp_338208.jpg

Save and activate your dtp. while saving we  will get pop up messages

/wp-content/uploads/2013/12/dtp_338208.jpg

As said above, if needed then we need introduce symantic groups to filter the erroneous records.

Once we set above setting at dtp, without creation of info pack, we can load data directly into targets.


Simple steps:

1. Replicate your data source from source to bw system

2. Activate your data source

3. Create your target

4. Create transformations(between data source and target)

5. Create dtp , do settings as said above.

6. Trigger the dtp and check the logs.


At process chains without info pack step, we can add dtp step directly after the start variant.


Thanks for reading.

Raman



Assigned Tags

      43 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi Raman,

      Interesting feature...(only in data target in 3.5 infopackage setting)..Good one.Thanks for sharing... 🙂 .I will check this feature.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Thank You Ganesh.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Thank you Raman for introducing this new feature to me in BW 7.3 🙂 🙂

      Author's profile photo Former Member
      Former Member

      Thanks Raman...

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Hi Raman,

      This functionality is also available with 7.0. and use for only small amount of data.

      But still its a good document.

      Regards,

      SM

      Author's profile photo Former Member
      Former Member

      Good one Raman... Thanks for sharing... 🙂

      Regards,

      Poorna

      Author's profile photo Former Member
      Former Member

      Good to know,

      Thanks for sharing Raman

      Author's profile photo Former Member
      Former Member

      Hi Raman,

      Good One.... I learned one new feature 🙂

      Thanks,

      Purushotham.

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Hi Raman,

      I can see this setting in BW 7.0  as well and it is available if we are loading the data to master data object.

      Can you please check and confirm same is the case in BW 7.31 or is it available if we load data to cube and DSO as well.

      Regards,

      AL

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Sure anshu, i will check and rename the doc. Thanks for pointing out on bw version Satendra Mishra

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Hi Anshu,

      yes this feature is available from BW7.0.

      This feature is only apply for the data loads with data source supporting "direct access' and with less volumes of data. this can't be used for DSO and IC data loads.

      For ex: this can be used for Text data sources or master data sources whose data volumes are less.

      Limitations:

      - Data not is not displayed in the query.

      - SAP Customer Enhancements are not processed.

      -  If errors occur during processing in BI, you have to extract the data again since the PSA is not available as a buffer. This means that deltas are not possible.

      FYI:

      http://help.sap.com/saphelp_nw70ehp1/helpdata/en/44/7e3af696b96fb5e10000000a155369/content.htm?frameset=/en/80/1a6365e07211d2acb80000e829fbfe/frameset.htm

      Regards

      KP

      Author's profile photo Former Member
      Former Member

      Useful Information.

      Thanks,

      Hari

      Author's profile photo GANAPATHI .
      GANAPATHI .

      Hi Raman,

      Neatly Presented ,Keep blogging ,,,,

      -GANAPATHI

      Author's profile photo Former Member
      Former Member

      Hi Raman,

      Thanks for sharing! Useful info. And thanks others for adding up more info 🙂

      Regards,

      Mohammed.

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Good one.

      You can add the below screen shot as well in the beginning so that the document will be full.

      This is mandatory, all the data sources won't support loading without PSA.

      Data source must support "Direct Access"

      If the data source support direct access then only you can get the option in DTP.

      Regards

      KP

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Thank You Prasanth, along with above screen i added table and field name also which indicates direct access. by seeing at table itself we can check whether it allows direct access or not.

      Thanks for adding information.

      Author's profile photo Shyamala Kalluri
      Shyamala Kalluri

      Nice document Raman....

      Regards,

      Shyamala

      Author's profile photo Former Member
      Former Member

      Nice one.

      Author's profile photo Former Member
      Former Member

      Useful information.

      Thanks sharing the new information.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Your welcome Raghav.

      Author's profile photo Former Member
      Former Member

      i think we will use this process when we are loading master data. Nice document Raman thanks for sharing.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Yes, for master data loads and that less volume data.

      Author's profile photo abilash n
      abilash n

      Nice try Raman. Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      wow Raman. Its awesome. Prashanth also thanks.

      Author's profile photo Former Member
      Former Member

      Good document Raman.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Thank You kumar

      Author's profile photo Phani KV
      Phani KV

      Hi raman,

      Very good document and i impressed.

      Thanks,

      Phani.

      Author's profile photo Former Member
      Former Member

      Hi Raman,

      Good document..thanks for sharing it.. 🙂

      Regards,

      Lalit

      Author's profile photo Former Member
      Former Member

      Good blog, nice 🙂

      Author's profile photo Avinash Verma
      Avinash Verma

      Thanks Raman for sharing it..!

      Just to add some generic point: This option will be enabled only in full extraction mode.

      This feature is available BW 7.0 onward.

      Regards,

      Avinash

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      May be you missed that. i mentioned the same as full load only. Thank you Avinash.

      Author's profile photo Avinash Verma
      Avinash Verma

      Thanks for correcting me, yes it was a miss 😛 .

      Author's profile photo Former Member
      Former Member

      Thanks for sharing the information. Nice feature.

      Author's profile photo vinod bokade
      vinod bokade

      Thank-You Raman 🙂

      Author's profile photo Former Member
      Former Member

      Hi Ram,

      Your Document is very useful,I tried in my project.

      It helps me lot.

      Keep posting and keep rocking..

      Regards,

      J.Sakthikumar

      Author's profile photo Devendra Talele
      Devendra Talele
      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Might be you seen about Direct access option only. Both documents discuss direct access but targets are different here.  He is taking about virtual info provider mine is master data load.

      Author's profile photo Devendra Talele
      Devendra Talele

      Thanks for my correction

      Author's profile photo Former Member
      Former Member

      Good One

      Author's profile photo Sakthi S
      Sakthi S

      Good Blog Ramanjaneyulu.

      Author's profile photo Former Member
      Former Member

      wow this is an interesting feature , will try to use it .Thanks for sharing 🙂

      Author's profile photo Former Member
      Former Member

      Informative.. 🙂

      Author's profile photo Rajesh Ramakrishnan
      Rajesh Ramakrishnan

      Good One.Thanks Raman!