Read Data from Logical Database

 

 

1. Declare table

 

Tables: pernr.

 

2. Create data structures for infotypes.

INFOTYPES: 0001, "ORG ASSIGNMENT
                 0002, "PERSONAL DATA
                 0008. "BASIC PAY

3. Fill data structures with the infotype records.

Start-of-selection.
  GET PERNR.

 

End-0f-selection.

Read Master Data

·        Infotype structures (after GET PERNR) are internal tables loaded with data.

·        The infotype records (selected within the period) are processed sequentially by the PROVIDE - ENDPROVIDE loop.

GET PERNR.

PROVIDE * FROM Pnnnn BETWEEN PN/BEGDA AND PN/ENDDA
  If Pnnnn-XXXX = ' '. write:/ Pnnnn-XXXX. endif.
ENDPROVIDE.

 

·        Period-Related Data All infotype records are time stamped - IT0006 (Address infotype)
01/01/1990 12/31/9999 present

Which record to be read depends on the date selection period specified on the selection screen. PN/BEGDA PN/ENDDA.

·        Current Data IT0006 Address - 01/01/1990 12/31/9999 present

RP-PROVIDE-FROM-LAST retrieves the record which is valid in the data selection period.

For example, pn/begda = '19990931' pn/endda = '99991231' - IT0006 subtype 1 is resident address
RP-PROVIDE-FROM-LAST P0006 1 PN/BEGDA PN/ENDDA.

Converted from CHM to HTML with chm2web Standard 2.7 (unicode)