SAP ABAP IMG Activity OHPSUSCPDF120 (Configure Table Access Methods)
Hierarchy
☛ EA-HRCUS (Software Component) Sub component EA-HRCUS of EA-HR
   ⤷ PA-PA-US (Application Component) USA
     ⤷ PAOC_PAD_US_FD (Package) US Federal Public Sector
IMG Activity
ID OHPSUSCPDF120 Configure Table Access Methods  
Transaction Code S_AEN_10000437   (empty) 
Created on 20050225    
Customizing Attributes OHPSUSCPDF120   Configure Table Access Methods 
Customizing Activity OHPSUSCPDF120   Configure Table Access Methods 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name OHPSUSCPDF120    

Use

This configuration step is optional.

To allow configurable access to Central Personnel Data File (CPDF) validation data that is held in an SAP database table, several methods have been implemented in class CL_HRPBSUSPA_VT.

In this step, you configure these methods to return the values from the CPDF validation tables.

Requirements

Prior to configuring the access methods, determine the following:

  1. The CPDF validation table that is technically being accessed.
  2. The method in CL_HRPBSUSPA_VT that has the correct interface for the CPDF validation table.
  3. Determine the SAP database table that holds the data for the CPDF table.
    1. Determine the field of the database table that needs to be returned to get the correct value.
    2. Determine the selection criteria that will access the correct record of the SAP table.

Activities

  1. Configure the method-level information for the access method:
    1. Enter the name for the CPDF table name, e.g. TABLE_1 for CPDF validation table 1.
    2. Enter the name of the method in class CL_HRPBSUSPA_VT that is being configured to access the values for this CPDF table.
    3. Enter the name of the SAP database table that has the information for the CPDF table.
    4. Enter the field name of the SAP table that should be returned for the check.
  2. Enter the selection criteria for the table access:
    1. Enter a new sequence number for ever new line.
    2. Enter the conditions required to select the correct record of the SAP table.

Additional information

The selection is defined by the statement:
SELECT SINGLE * FROM (T5UPBSPA22-DBTAB)
INTO (DBTAB_STRUCTURE) WHERE
(FIELD_1) IN (SELECTION_TABLE_1) AND
(FIELD_2) IN (SELECTION_TABLE_2) AND
#
(FIELD_N) IN (SELECTION_TABLE_N).

In the above statement, the table (T5UPBSPA22-DBTAB) is the table defined in table T5UPBSPA22 that uses the selection rule defined in this view. This is read into a structure of the appropriate type that we call (DBTAB_STRUCTURE).

(FIELD_1), (FIELD_2), # (FIELD_N) are fields of the table (T5UPBSPA22-DBTAB). For each field, a selection table is created. See the ABAP help for the SELECT statement for detailed information on the selection table.

The selection table for (FIELD_N) has the following structure:
SIGN: 'I' for inclusive, 'E' for exclusive.
OPTION: 'EQ' for equal, 'NE' for not equal, 'BT' for between, etc.
LOW: A field of type (FIELD_N). For OPTION choices that refer to one field such as 'EQ', this is the field used for comparison. For OPTION choices that refer to ranges such as 'BT', then both LOW and HIGH fields are used.
HIGH: A field of type (FIELD_N). As noted above, this is used only for OPTION choices that refer to a range.

Example

Business Attributes
ASAP Roadmap ID 203   Establish Master Data 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency I   Valid for countries specified 
Customizing Attributes Country Key Country Name
OHPSUSCPDF120 US USA
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG OHPSUSCPDF120 0 ALN0000203 Functions for U.S. Federal Government 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
VC_T5UPBSPA22 C - View cluster SM34  
History
Last changed by/on SAP  20050225 
SAP Release Created in 600