PERI5 Conversion Routine BI InfoObject

Use

The PERI5 conversion serves to convert a five-figure calendar quarter in an external format (Q.YYYY, for example) into the internal format (YYYYQ). Y stands for year (here four digits) and Q for quarter (single digit: 1,2,3, or 4). The separator (‘.’ or ‘/’) has to correspond to the date format in the user settings.

Features

Permitted entries for the date format DD.MM.YYYY are QYY (two digits for year without separator), Q.YY (two digits for year with separator), QYYYY (four digits for year without separator), and Q.YYYY (four digits for year with separator). Permitted entries for the date format YYYY/MM/DD would be YYQ, YY/Q, YYYYQ, YYYY/Q.

Example

Examples where the date format in the user settings is DD.MM.YYYY. A conversion from the external to the internal format takes place:

...

1. '2.02' ® '20022'

2. '31999' ® '19993'

3. '4.2001' ® '20014'

PERI6 Conversion Routine

Use

Conversion routine PERI6 is used with six-digit entries for (fiscal year) periods.

Features

The internal format for six-digit periods is YYYYPP (200206, for example, for period 06 of fiscal year 2002). When the external format is converted to the internal format, this checks whether the entries in the INPUT parameter with external date format (separators, order) comply with user settings. The separator (‘.’ or ‘/’) has to correspond to the date format in the user settings.

Different abbreviated entries are possible and these are converted correctly into the internal format.

Example

For the external date format DD.MM.YYYY in the user settings, the following conversion takes place from external to internal formats:

...

1. '12.1999' ®'199912'

2. '1.1999' ®'199901'

3. '12.99' ®'199912'

4. '1.99' ®'199901'

PERI7 Conversion Routine BI InfoObject

Use

Conversion routine PERI7 is used with seven-digit entries for (fiscal year) periods.
Features

The internal format for seven-digit periods is YYYYPPP (2002006, for example, for period 006 of fiscal year 2002). When the external format is converted to the internal format, this checks whether the entries in the INPUT parameter with external date format (separators, order) comply with user settings. The separator (‘.’ or ‘/’) has to correspond to the date format in the user settings.

Different abbreviated entries are possible and these are converted correctly into the internal format.
Example

For the external date format DD.MM.YYYY in the user settings, the following conversion takes place from external to internal formats:

...

1. '012.1999' ®'1999012'

2. '12.1999' ®'1999012'

3. '1.1999' ®'1999001'

4. '012.99' ®'1999012'

5. '12.99' ®'1999012'

6. '1.99' ®'1999001'

POSID Conversion Routine BI InfoObject

Use

The POSID conversion routine converts the external presentation of the program position (0PROG_PO_EX) into the internal presentation (0PROG_POS), using the active master data table entries for the program position InfoObject (0PROG_POS).

Example

Conversion from the external into the internal format:

P-2411 ® P24110000

PROJ Conversion Routine BI InfoObject

Use

There are extensive possibilities in the ERP system project system for editing the external presentation of the project and PSP elements (project coding, editing mask). These features are included in the ERP conversion routine. This comprehensive logic cannot be mapped in the BI system. For this reason, the characteristic 0PROJECT_EX exists in the attributes of InfoObject 0PROJECT and the external description is stored there. As the external description is entered on the screen, conversion routine 'CONVERSION_EXIT_PROJ_INPUT' reads the corresponding internal description 0PROJECT and uses this for internal processing.

If no master data has been loaded into the BI system (master data generated by uploading transaction data), then the internal description has to be input in order to execute a query.

Example

Internal format: 0PROJECT: ‘A0001’

External format: 0PROJECT_EX: 'A / 0001'

REQID Conversion Routine BI InfoObject

Use

The REQID conversion routine converts the external presentation of the appropriation request (0APPR_REQU) into the internal presentation (0APPR_RE_ED), using the active entries in the master data table for the appropriation request InfoObject (0APPR_RE_ED).

Example

Conversion from the external into the internal format:

P-2411-2 ® P24110002

REQID Conversion Routine BI InfoObject

Use

The REQID conversion routine converts the external presentation of the appropriation request (0APPR_REQU) into the internal presentation (0APPR_RE_ED), using the active entries in the master data table for the appropriation request InfoObject (0APPR_RE_ED).

Example

Conversion from the external into the internal format:

P-2411-2 ® P24110002

IDATE Conversion Routine BI InfoObject

Use

This conversion routine assigns the appropriate internal date presentation (YYYYMMDD) to an external date (01JAN1994, for example).

Call up the test report RSSCA1T0 to be able to better visualize the functionality of this routine. This test report contains the complete date conversion with external as well as internal presentations.

Example

Conversion from the external into the internal format:

'02JAN1994' ® '19940102'

Conversion Routine RSDAT BI InfoObject

Use

Converts a date in an external format into the internal format.

Features

First, the system tries to convert the date in accordance with the user settings (System ® User Profile ® Own Data ® Fixed Values ® Date Format). If the system cannot perform the conversion in this way, it automatically tries to identify the format.

Valid formats:

DD.MM:YYYY

MM/DD/YYYY

MM-DD-YYYY

YYYY.MM.DD

YYYY/MM/DD

YYYY-MM-DD

For automatic recognition, the year has to be in four-digit format. If the date is specified as 14.4.72, this is not unique and can cause errors.

Note: If the system can sensibly specify a date from the format in the user settings, this conversion is performed.

In this example, if the format in the user settings is DD.MM.YYYY, the date is converted to 19720414, since the system conversion recognizes the date.

Example

Conversion from an external format into an internal format:

4/14/1972 ® 19710414

NUMCV Conversion Routine BI InfoObject

Functions

When converting from an external into an internal format this checks whether the entry in the INPUT field is wholly numerical, whether it consists of digits only, possibly with blank spaces before and/or after. If yes, the sequence of digits is copied to the OUTPUT field, right-aligned, and the space on the left is filled with zeros (‘0’). Otherwise the blank characters are removed from the sequence of digits, the result is transferred, left-aligned, into the output field, and this is then filled from the right with blank characters.

Converting from the internal format into the external format (conversion routine CONVERSION_EXIT_NUMCV_OUTPUT) does not produce any changes. The output field is set the same as the input field.

Example

Input and output fields are each 8 characters long. A conversion from an external to an internal format takes place:

...

1. '1234 ' ®'00001234'

2. 'ABCD ' ® 'ABCD '

3. ' 1234 ' ® '00001234'

4. ’ AB CD’ ®’ABCD ’

SDATE Conversion Routine BI InfoObject

Use

This conversion routine assigns the appropriate internal date presentation (YYYYMMDD) to an external date (01.JAN.1994, for example).

Call up the test report RSSCA1T0 to be able to better visualize the functionality of this routine. This test report contains the complete date conversion with external as well as internal presentations.

Example

Date formatting definition in the user master record: DD.MM.YYYY

Conversion from the external into the internal format:

'02.JAN.1994' ® '19940102'