cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding PSA real time scenarios and things

cvp
Participant
0 Kudos

Hai

I knew abour PSA therotically . But i want in detail real time scenarios concering about PSA . Like , if data laoding is failed then how to look at PSA and after identifying how to update to corresponding datatarget like this ......

So please tell in detail some real time scenarios about PSA and also send some documents or weblogd or old forums to am.mohammed@tcs.com now

I ll assign the points for thanks

bye

mohammed

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi chakri

regarding PSA theoratically, then it will not be that much difficult in practical.

coming to ur query, if data loading is failed and if it is success full upto PSA then in RSA1->psa u can select ur PSA there u can see ur request under ur application component. there on double click ur request u can see the psa data and if it is not loaded in data targets u can edit the records. depending on error message if there is any problem in data u can edit data in psa.

after editing on right click on psa u will get option for update.

Hope this helps .....

Regards

Nr

Assign points if it is helpfull

Answers (6)

Answers (6)

Former Member
0 Kudos

hi

i sent to your id

Former Member
0 Kudos

Hi,

Rsa1> modelling>psa> select the appiacation component>infosource > psa> request. In the context menu of psa request select update the data target.

shylaja.

Former Member
0 Kudos

Hi Chakri,

The key to look at the data in the PSA is to first look at the "details" tab of the monitor of the request. In that tab you would find the reasons why your load has failed and in most of the cases it would point to the record number and the field of the datapackage where the error has occured.

Now you can go to the PSA and find out the records - they would have the status in "red" and make the corresponding changes. Save the changes and then schedule the update. The Path is RSA1 -> PSA -> PSA request -> right click and select "update immediately". The data would then get updated in the Data target.

Hope this helps.

Bye

Dinesh

Former Member
0 Kudos

hi chakri, go through this.

1.The Persistent Staging Area (PSA) is the inbound storage area for data from the source systems in the SAP Business Information Warehouse. The requested data is saved, unchanged from the source system. Request data is stored in the transfer structure format in transparent, relational database tables in the Business Information Warehouse. The data format remains unchanged, meaning that no summarization or transformations take place, as is the case with Info Cubes.

2. The data records in BW are transferred to the transfer structure when you load data with the transfer method PSA. One TRFC is carried out per data package. Data is written to the PSA table from the transfer structure, and stored there. A transparent PSA table is created for every transfer structure that is activated. The PSA tables each have the same structure as their respective transfer structures.

3. The number of fields is limited to a maximum of 255 when using TRFCs to transfer data. The length of the data record is limited to 1962 bytes when you use TRFCs.

4. Four types of updates a) psa and data targets parallel b)psa and data targets serially c) only psa with subsequent updates to data targets d) only data targets

5.Since the data is stored in transparent tables in database we can edit the data in psa using ABAP routines using PSA-API’s.

6. u can delete the requests from the PSA for the incorrect data provided that the concerned request data is not populated into data targets.

7. table for PSA:There is only one table for all psa requests.One way to know the psa table name is by right click the psa node and 'maintain export datasource', you will see the table name is /BIC/B0000xxxx (System generated psa table name ) ('ExtractStru.') with se16 you can see the contents, each request no. displayed in field REQUEST.

8. reporting: We can not report directly on psa as the same data is coming form the source system we can see a report from the source sytem. How ever technically speaking we can have a report on that. You are creating an export datasource on it and report using a Remotecube. you could even create an ODS with the same structure of the PSA and push the PSA data into it with no data transformation and then report. When u create an export data soruce on psa it will start with 7 followed by ur PSA name. The below link gives the reporting on psa document.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/968dab90-0201-0010-c093-9d2...

9.Changelog and PSA: If we delete data in changelog the data in psa will not be deleted. You have to delete the data in the PSA exclusively.The change log acts as the PSA for the data target if the ODS acts as a datasource. What I mean is if the ODS supplies to another cube/ODS then the source ODS's Changelog is the PSA for the target ODS/Cube.

10.PSA as a data source: create an export data source. The export data source starts with 7 followed by psa name. Go to data marts in the info sources tab and replicate that data source. Create an info source and assign this data source. Activate transfer rules and communication structure Then create a data package and schedule the load to the data target.

11.PSA deletion:

12. PSA data in EP:

13.Deleting PSA data source:

To delete the export data source

Just go to RSA6 and find the your datasource in the node 'DM', click once (highlight it) and there is a delete icon on the standard icon bar, click on that you should be able to delete the datasource.

14.Debug load inpsa:

to load data manually from psa to the data targets.

1. go to rsal .ie administrator work bench

2. under modelling tab choose psa option

3.select your application component

4. choose ur info soruce and expand the tree to see the requests

5. double click on the psa icon

6. a new screen will appear which asks for the no of records to enter give the number and press enter u can see the data in the psa

7. to update psa data manually go to the context menu of that request and select the optio "update date immeditatley" it will be loaded to the data target/

cheers

ravi

dont forget to assign points that is the way of saying thanks in sdn

Former Member
0 Kudos

Hello Chakri,

There are many advantages for using PSA.

As you rightly pointed out, you can rectify records in PSA and upload them to the data targets in case of failed loads. for this you need to go to PSA section in rsa1. you can go in the respective psa and change/rectify the incorrect records.

then right click on the psa and update data-targets from there.

Hierarchies dont use PSA methods.

check out the following links:

Hope this helps..

thanks,

Former Member
0 Kudos

Friend check in Search in this forum you will find lot of material. if we send some documents again you will theoritical. check the PSA view in AWB. you could see lot of options(right click on PSA).

My Opiion is search in the forum for real time errors.

all the best.

Nagesh.