Hello Experts,
I am new to Logical Database. I am assigned to change a Report in which Data from BSEG and WITTH_ITEM tables are fetched by using Logical database KDF using FM LDB_PROCESS.
Problem is, this report is not showing any document for one company code but showing all for another.
When I debugged, I found that this FM is fetching all the documents from BKPF table but none from BSEG table. But it should as I checked the BSEG contains all the data.
How can I check this LDB and If anybody has worked on this kind of report please guide.
*** Code for FM LDB_PROCESS is :-
gs_callback-ldbnode = 'BSIK'.
gs_callback-get = 'X'.
gs_callback-cb_prog = sy-repid.
gs_callback-cb_form = 'CALLBACK_BSIK'.
APPEND gs_callback TO gt_callback.
gs_callback-ldbnode = 'BKPF'.
gs_callback-get = 'X'.
gs_callback-cb_prog = sy-repid.
gs_callback-cb_form = 'CALLBACK_BKPF'.
APPEND gs_callback TO gt_callback.
gs_callback-ldbnode = 'BSEG'.
gs_callback-get = 'X'.
gs_callback-cb_prog = sy-repid.
gs_callback-cb_form = 'CALLBACK_BSEG'.
APPEND gs_callback TO gt_callback.
gs_callback-ldbnode = 'WITH_ITEM'.
gs_callback-get = 'X'.
gs_callback-cb_prog = sy-repid.
gs_callback-cb_form = 'CALLBACK_WITH'.
APPEND gs_callback TO gt_callback.
gs_seltab-kind = 'S'.
gs_seltab-selname = 'KD_BUKRS'.
gs_seltab-option = 'EQ'.
gs_seltab-sign = 'I'.
gs_seltab-low = p_bukrs.
APPEND gs_seltab TO gt_seltab.
CLEAR gs_seltab.
gs_seltab-kind = 'S'.
gs_seltab-selname = 'KD_GJAHR'.
gs_seltab-option = 'EQ'.
gs_seltab-sign = 'I'.
gs_seltab-low = gv_year.
APPEND gs_seltab TO gt_seltab.
CLEAR gs_seltab.
gs_seltab-kind = 'S'.
gs_seltab-selname = 'KD_BUDAT'.
gs_seltab-option = 'BT'.
gs_seltab-sign = 'I'.
gs_seltab-low = startdate.
gs_seltab-high = enddate.
APPEND gs_seltab TO gt_seltab.
CLEAR gs_seltab.
gs_seltab-kind = 'S'.
gs_seltab-selname = 'KD_LIFNR'.
LOOP AT s_lifnr.
MOVE-CORRESPONDING s_lifnr TO gs_seltab.
APPEND gs_seltab TO gt_seltab.
ENDLOOP.
*Note 1584640 for filling KD_APOPT to fetch data from BSAK
CLEAR gs_seltab.
gs_seltab-kind = 'P'.
gs_seltab-selname = 'KD_APOPT'.
gs_seltab-sign = 'I'.
gs_seltab-low = 'X'.
gs_seltab-option = 'EQ'.
APPEND gs_seltab TO gt_seltab.
gs_seltab-kind = 'P'.
gs_seltab-selname = 'KD_NOOAP'.
gs_seltab-sign = 'I'.
gs_seltab-low = 'X'.
gs_seltab-option = 'EQ'.
APPEND gs_seltab TO gt_seltab.
CLEAR gs_seltab.
gs_seltab-kind = 'P'.
gs_seltab-selname = 'KD_OPOPT'.
gs_seltab-sign = 'I'.
gs_seltab-low = 'X'.
gs_seltab-option = 'EQ'.
APPEND gs_seltab TO gt_seltab.
CLEAR gs_seltab.
*End OF Note 1584640
CALL FUNCTION 'LDB_PROCESS'
EXPORTING
ldbname = c_kdf
variant = space
TABLES
callback = gt_callback
selections = gt_seltab
EXCEPTIONS
ldb_not_reentrant = 1
ldb_incorrect = 2
ldb_already_running = 3
ldb_error = 4
ldb_selections_error = 5
ldb_selections_not_accepted = 6
variant_not_existent = 7
variant_obsolete = 8
variant_error = 9
free_selections_error = 10
callback_no_event = 11
callback_node_duplicate = 12
OTHERS = 13.
IF sy-subrc <> 0.
WRITE: text-041, sy-subrc. "#EC NOTEXT
ENDIF.
Thanks,
Vibz
Bluesky
