Skip to Content
0
Former Member
Sep 11, 2009 at 04:36 AM

text datasource enhancement

32 Views

hello guys

I am trying to enhance text datasourcein R3 and got this problem.

I am trying to load texts for infoobject 'material number' fromR3 table MAKT.....I created view on fields MANDT,MATNR,MAKTX (client,material number,material description) and then created generic datasource onthis.now I replicated and loaded texts to Infoobject 'Material Number' in BW.

Now I want to enhance text datasource in R3 so that I will add field MAKTG (material description in capital letters) from MAKT table...I added append structure in extract structure...then I want to write code in CMOD....Here I choose RSAP0001 enhancement...then EXIT_SAPLRSAP003 for enhancing text datasource...here there is no code provided by SAP...so wrote my own code..and activated and then unchecked 'hide field' ....saved the datasource....nowcame to Extractor Checker RSA3 to check if code is working....I am able to see the new field MAKTG but its not populated..it means my code or my way of doing enhancement is wrong...Can anyone please suggest any solution....

here is my code:

data: l_s_ZOXID30088 like ZOXID30088 ,

L_TABIX LIKE SY-TABIX.

case I_CHABASNM.

when 'MATNR'.

LOOP AT C_T_TEXTS INTO L_S_ZOXID30088.

L_TABIX = SY-TABIX.

SELECT SINGLE MAKTG FROM MAKT INTO L_S_ZOXID30088-ZZMAKTG WHERE MATNR =

L_S_ZOXID30088-MATNR..

MODIFY C_T_TEXTS FROM L_S_ZOXID30088 INDEX L_TABIX .

ENDLOOP.

ENDCASE.

Thanx,

S

Edited by: SChandx200 on Sep 11, 2009 6:37 AM