error in getting common records from two internal tables

20 Views

Hello Friends,

I am getting about 34000 records in tvenmap (Internal table) and 48 records in it_search table. There are about 10 records common between both the tables that I want to extract and move it into 3rd internal table namely, it_vend_search. By reading the table I am getting dump error. Can anybody help me to update/modify it_vend_search.

CONCATENATE ' ' '' name1 '' '' INTO objid1.

REPLACE ALL OCCURRENCES OF '*' IN objid1 WITH '%'.

SELECT NAME_ORG1 PARTNER_GUID from but000 INTO TABLE it_search WHERE name_org1 LIKE objid1.

SELECT PARTNER_GUID VENDOR_NO FROM venmap INTO TABLE tvenmap WHERE LOG_SYS = p_logsys.

Below code gives me error ********

LOOP AT tvenmap.

READ TABLE tvenmap WITH KEY ZPARTNER_GUID = it_search-PARTNER_GUID.

IF it_search-PARTNER_GUID = tvenmap-ZPARTNER_GUID.

it_vendsearch-ZPARTNER_GUID = it_search-partner_guid.

APPEND it_vendsrch.

ENDIF.

MODIFY it_vendsrch[] FROM it_vendsrch.

ENDLOOP.

*****************************************************************************************

Thks & Rgds,

Hemal

Edited by: hemalgandhi on May 4, 2009 7:43 PM