Programme SAP RPIADUC0 - HR-CH: Create Batch Input Session for Legacy Data Transfer

Description
This report generates a batch input session for HR infotypes from filesin the work station. It transfers the data from an old system to HRmaster data, specially for the pension fund in Switzerland. It supportsthe flexible field assignment of infotype "Individual Values PF" (0279).
You generate accounts/postings for the component 'Pension FundSwitzerland' with report RPUADUC0.

Significance of the selection parameters
Name of the description file
It is assumed that this file is on the work station. You must specifythe complete path as the name. Also, the file must exist as a text file.
Name of the batch input session to be generated.
Option "Display only file info"
If you select this field, no batch input session is created. Instead, itdisplays which file layouts result from the entries in the descriptionfile.
Country grouping and transaction class
This data is required to evaluate the features (for example, P0002,P0006), that control the country-specific screens for the correspondinginfotypes (0002, 0006).
Check the features for the infotypes that you want to process. If youwant to use more fields to control the features, you must extend theselection screen and the report to include these fields.

Input files
This report reads the following text files from the work station:

  • Description file (parameters on selection screen)

  • The information in this file controls the import of actual data. Itestablishes in particular:
    For which infotypes a BI folder should be generated
    How infotypes are to be processed (BDC_OKCODE)
    From which data files the relevant date is to be read
    Which data (constants, values from data file), is to be assigned towhich infotype fields
    Which data value types (fields from infotype 0279) are to be assigned.
    • One data file per infotype

    • The structure of these files is determined by the description filespecifications.

      Format of description file
      The description file has the following block of lines per infotype:
      PROTECT
      * Commentary lines are ignored
      #INFOTYPE []
      #FIELD #VAL
      #FIELD #COL []
      #VALTY []
      ENDPROTECT
      The individual fields must be separated by one or more empty characters.
      Many user-defined lines with #FIELD or #VALTY (only practical forinfotype 0279) can follow on #INFOTYPE lines.
      You must enter a four-figure infotype number. The first number must be0. Therefore, you must enter '0001', not simply '1'.
      The name of the data file is determined, in which the name in thedescription file is appended to the path of the description file. Thesefiles must lie in the same or in a subordinate directory.
      "INS" (<-> create new) is used as the default BDC_OKCODE. Otheralternatives are "COP" (<-> copy) or "MOD" (<-> change).
      Enter the name of the screen field as the field name. This can bedetermined through F1 help in this field (technical info). You mustenter the structure name (for example, P0278).
      You must enter a constant value (also in the date file) - a manual entryis also possible - (for example, 01011997 instead of 19970101). This isalso valid for character strings in the data files. The settings in theuser parameters (date format, payment format) should also be consideredhere.
      The column numbers refer to columns in the data field of the respectivedata file. The output length of the screen field is selected as thestandard column length, as long as this is not explicitly specified. For#VALTY lines the standard width is 12 characters. If the output lengthof the screen field is not clear, then the explicit specification of thecolumn width is recommended.

      Format of data files
      The data files are made up of columns with the fields

      • Personnel number [NUMC(8)]

      • Subtype [CHAR(4)]

      • For example, the fund for infotypes 0278 or 0279, or the wage type forinfotype "Recurring Payments/Deductions" (0014).
        • Data part [CHAR(1024)]

        • The length of 1024 characters is a maximum value.
          The column specifications in the description file refer to positions inthe data part.

          Precondition
          If fields of the "Individual Values PF" (0279) infotype should be filledper value type, then:

          • Feature CHPKP must be active

          • The setting field assignment for infotype 0279
          • must be correct and
            • An "Organizational Assignment" (0001) infotype record must exist for
            • every employee.
              The last of these records is used for the evaluation of feature CHPKP inthe period SY-DATE up until 12.31.9999.

              Restrictions
              The data part of data files can have a maximum length of 1024characters.

              Output
              A batch input section with the name entered in the selection screen.
              A log

              Example
              The description file contains the following:
              PROTECT
              #INFOTYPE 0278 ADU_DATA_0278
              * Start date in form DDMMYYYY: Specify output length = 8
              #FIELD P0278-STADA #COL 1 8
              * Same validity end date for all records
              #FIELD P0278-ENDDA #VAL 12.31.9999
              * Entrance date with points: Explicit width entry not necessary
              #FIELD P0278-ENTDT #COL 2
              #FIELD ...
              #INFOTYPE 0279 ADU_DATA_0279
              * Standard start and end date
              #FIELD P0279-STADA #VAL 01.01.1998
              #FIELD P0279-ENDDA #VAL 12.31.9999
              #VALTY LN00 1
              #VALTY ...
              #INFOTYPE 0014 ADU_DATA_0014
              #FIELD P0014-STADA #VAL 01.01.1998
              #FIELD P0014-ENDDA #VAL 06.30.1998
              #FIELD Q0014-AMNT #COL 1
              #FIELD ...
              ENDPROTECT
              Data file ADU_DATA_0278 could contain some of the following:
              PROTECT
              Subtype = Fund
              | Column 2
              Perno. | Column 1 | Column 3 ...
              | | | | |
              00100001S0010101199801.04.1987***
              00100001S0020101199801.08.1991***
              ENDPROTECT
              Two records of the "Basic Data PF" (0278) infotype are created with thefollowing dates for personnel number 00100001:
              RESET N1
              Record for fund S001
              Start date: 01.01.1998
              End date: 12.31.9999 (constant in description file)
              Entrance date: 04.01.1987
              Record for fund S002
              Start date: 01.01.1998
              End date: 12.31.9999 (constant in description file)
              Entrance date: 08.01.1991
              It should be noted here that the date can be in a different form in thedata file. The output length of a date field is normally 10 (domainDATS). If a date is in the data file without periods, then an explicitlength entry of 8 is required.
              If in doubt, you can determine field attributes as follows:

              • Call up F1 help in the field to be filled and from there call up
              • "technical info".
                • The field "screen field" in the lowest frame of the popup contains the
                • name to be used for the batch input. If the problem is a steploop field(for example, wage type lines in the "Basic Pay" infotype (0008)), thenfield "FNAME" should be specified in the form "FNAME(INDEX)".
                  • By double clicking on the field "data element", the output length can be
                  • determined. It appears in the data element display in the frame of therelevant domain.
                    File ADU_DATA_0279
                    PROTECT
                    Subtype = Fund
                    PerNo. | Column 1 Column 2 ...
                    | | | |
                    00100001S001 198999,00 ***
                    00100001S002 212000,00 ***
                    ============
                    --- Standard width for values to value types:12 characters
                    ENDPROTECT
                    The field assigned to value type LN00 (relevant to wage) for infotype0279 (Q0279-VAExy) is filled with 198000,00 and 212000,00. It should benoted that the number format is dependent on the settings in the userparameters.
                    File ADU_DATA_0014
                    PROTECT
                    Subtype = Wage type
                    PerNo. | Column 1 Column 2
                    | | | |
                    00100001M80A 1542,25 ***
                    ==============
                    ---Output length of Q0014-AMNT: 13 characters
                    ENDPROTECT
                    For more information on batch input, see the documentation on datatransfer in the SAP Library.