Quickly Find Specific PSA Entries Among Thousands of Records

  • by David Eady, Reporting Team Lead, SI Corporation
  • March 1, 2006
Learn how to easily find the specific Persistent Staging Area (PSA) entry you’re looking for with these simple steps.
Key Concept

A BW system stores raw source system data in Persistent Staging Area (PSA). Behind the scenes, PSA is simply a transparent table that has the same fields as the source system’s transfer structure. When you load data from the source system and store it in PSA, the system writes it to this transparent table in BW. The system stores all PSA data from the same DataSource together in the same transparent table. The system-generated request identifier, which uniquely identifies each data load to BW, is a key for this table to keep each load’s data separate.

Understanding how BW stores Persistent Staging Area (PSA) data so that you can locate specific PSA records is helpful when you are debugging sophisticated transfer rules or update rules using simulation. It’s also useful when you are verifying InfoCube data against the original source system data that PSA stores.

You might need to examine PSA data during your BW development. Debugging update rules using simulation or verifying the raw data received from your source systems are two situations in which you might work directly with PSA data. You can see this PSA data using Administrator Workbench Monitor, shown in Figure 1

David Eady

David Eady is the reporting team lead of the SI Corporation MIS team headquartered in Chattanooga, TN. The reporting team is responsible for all aspects of SAP information delivery. David has been with SI Corporation for six years and has been involved with BW for the last four years. He has a BS degree in industrial engineering from Mercer University and lives with his wife and two daughters in the foothills of northwest Georgia.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.