Insert appropriate datasource in field USEROBJ + * (* -> important as this field also includes the source system)stands for the appropriate source system) and will be generated by the system, the technical name has to be checked in each system as the name will be different. The techncial name of the PSA/Changelog table starts with: /BIC/B. BIC/B0020971000 /BIC/B0020971001 -> newest versionĮxamples with data records in the PSA table If a new version has been created an addtionally entry will be created in table RSTSODS.Į.g. Therefore make sure that there is no data remaining in the PSA table of the datasource that has not yet been uploaded to the infoprovider. The old data remains in the old PSA table but ca no longer be extracted using standard methods. If there a data available and the structure or datatype has been changed in a way that is not compatible with the database (abbreviated or type changed, for NUMC also made longer) or a field has been deleted, a new PSA version will be created with the new format. In case there are no data available in the PSA table no new version will be created.
If you change a datasource in the sourcesystem and replicate the changes into BW system or perform changes directly in RSDS a new version of the PSA table can be created. It depends wether the old version of the datasource contains data or not. In the 3.x dataflow, if you activate datasources or transfer rules, the PSA table will be created in 3.x dataflow. However, it is recommend to use the concepts for DataSources and transformations available after SAP NetWeaver 7.X, which includes using the new technology of the PSA.
SAP PES UPDATE
You can still use this technology when your data model is based on the previously available objects and rules (DataSource 3.x, transfer rule 3.x, update rule 3.x). The PSA as a standalone application is managed in an object tree of the Administrator Workbench. The PSA table is generated for an active transfer structure in this case. The design of the PSA table was previously oriented towards transfer structure. When loading flat files, the data does not remain completely unchanged, since it is adjusted by conversion routines if necessary (for example, the date format is converted to 19991231 in order to ensure uniformity of data). The data format remains unchanged, meaning that no summarization or transformations take place, as is the case with InfoCubes. Request data is stored in the transfer structure format in transparent, relational database tables in the Business Information Warehouse.
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.
0 kommentar(er)
