WTY_XPRA_002 - Programm WTY_XPRA_002

Vendor Master (General Section)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

XPRA for decoupling from iPPE and moving important iPPE field content to new fields in the warranty tables.

Prerequisites

This XPRA should be executed from release DI 4.6C CRT7 and higher.

Any customer extensions to iPPE tables are not supported by this XPRA . In case such extensions exist, you have to create your own report(s) to convert the data.

DESCRIPTION

This XPRA report moves field values from iPPE tables that are no longer used by the Warranty application to the new fields of the corresponding Warranty tables. Moreover, the report sets up direct links between warranty tables instead of links through iPPE tables.

This XPRA report does not delete any data and can be safely restarted before productive use.

We do not recommend restarting this report after productive use, because older values might overwrite timestamps and administrative data for existing claims that were changed after execution of this XPRA and that still have corresponding entries in the iPPE tables.

The report has the following sections, which are marked with comments in the report source code:

  1. Section 1 Prepare field lists
This section prepares field lists for dynamic SELECT statements later in the program. This improves performance, because these dynamic field lists allow execution of the command UPDATE ... FROM TABLE instead of updating single records. The following field lists are prepared:
  1. PNWTYH
  2. PNWTYV for SELECT/UPDATE of the HEADER_GUID field
  3. PNWTYV for SELECT/UPDATE of the administrative fields
  4. PVWTY
  5. PRWTY for SELECT/UPDATE of the HEADER_GUID field
  6. PRWTY to delete the header guid for the relationship between items in different claims
  • Section 2 Process PNWTYH table
  • In this section, administrative fields from the PNODID table and short texts from PNODTX are transferred to the corresponding new fields in PNWTYH.
    1. Section 3 Process PNWTYV table
    The PNWTYV table is processed in two steps for performance reasons:
    1. The PNWTYV table is joined with PRWTY, and PRWTY is joined with PALTID. The system reads the header GUID from PALTID and writes it to the HEADER_GUID field in PNWTYV.
    2. The PNWTYV table is joined with PNODID and PNODTX, and the administrative data together with the short texts are transferred to the new fields in PNWTYV.
  • Section 4 Process PVWTY table
  • In this section, PVWTY is joined with POSVID, and the administrative fields and version GUID are transferred to the corresponding new fields in PVWTY.
    1. Section 5 Process the Version-Version relationship in the PRWTY table
    This section contains two steps for performance reasons:
    1. Transfer header GUID to the records in PRWTY with a Version-Version relationship
    2. Delete header GUID for all relationships where GUID1 and GUID2 reference the versions from the different claims
  • Section 6 Process the Item-Item relationship in the PRWTY table
  • This section contains two steps for performance reasons:
    1. Transfer header GUID to the records in PRWTY with an Item-Item relationship
    2. Delete header GUID for all relationships where GUID1 and GUID2 reference the items from the different claims
  • Section 7 Save messages in the database
  • Output

    When carrying out the XPRA, the system logs the start and finish of the process. Log entries are made in the following situations:

    • No warranty claims are found in the client. A message will be logged in the clients in which the Warranty application is not used
    • For each processed table, the system logs a message containing the table name and the total number of records

    If the system raises a catchable exception during execution, it writes the exception text to the log as an error and terminates processing.






    BAL Application Log Documentation   CPI1466 during Backup  
    This documentation is copyright by SAP AG.


    Length: 4530 Date: 20140419 Time: 051206     triton ( 153 ms )

    consolut Transport Check

    The consolut Transport Check is a simple and reliable tool that helps you identify dependencies between transport orders.

    consolut Transport Check