Banner
Banner

Attention: open in a new window. PDFPrintE-mail

2009
10
Feb

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.

Last Updated (Tuesday, 30 November 1999 00:00)
Banner
Free software downloads