cancel
Showing results for 
Search instead for 
Did you mean: 

HR-ABAP data extraction with Decoupled framework

former_member343446
Discoverer
0 Kudos

Hi All,

I try to implement a simple data extraction app. using DCIF.
I know the basic usage of classes to read specific PA / OM infotypes (CL_HRPA_MASTERDATA_FACTORY, CL_HRBAS_DISPATCH_BL).

The main constraint is that you always need to enter PERNR or OBJID for the method READ.

Is there a way to read all records of a single infotype for all employees / objects using DCIF?

The purpose is simple. Consider data extractor, working in two modes (initial upload, delta changes). In delta changes you can use standard API to read change pointers, change documents whatever to get data scope (list of changed PERNRs, OBJID). But in initial upload mode you simply need to extract all data. I can put a simple SELECT PERNR FROM PA0000 INTO TABLE LT_PERNRS and then use a loop over LT_PERNRS to read infotypes, but I'd rather expect to have a standard OO "data provider".

Thanks in advance for any suggestions

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member226519
Active Contributor
0 Kudos

The "standard data provider" in HR for PA data is logical database PNPCE, for OM PCH.

Documentation for both can be found at reports SAPDBPNPCE and SAPDBPCH.

But the simplies way for your purpose is indeed SELECT * FROM dbtab INTO TABLE inftytab without any WHERE condition.

The DBTAB for all infotypes is in table T777D so you can write your report dynamically:

SELECT SINGEL dbtab INTO gv_dbtab WHERE infty = my_infty.

CREATE DATA ref_itab TYPE STANDARD TABLE OF (gv_dbtab).

ASSIGN ref_itab->* to <ref_tab>.

SELECT * FROM (gv_dbtab) INTO TABLE <ref_tab>.

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

Don't know if it helps, but for processing these crazy HR infotypes, ABAP offers that fairly ununderstandable (at least for normal people) PROVIDE statement. I myself got exactly one abstract example running and quickly forgot about it ...