topic Re: Modify Table in Application Development and Automation Discussions

Modify Table

Former Member — Thu, 26 Jul 2007 20:52:04 GMT

Hi,

I have to update the table gt_zprice with created CreditMemo. I tried the following two ways, but nothing is working. Please guide me if I am doing something wrong here.

Thanks,

Neelu.

READ TABLE gt_zprice INTO gs_zprice.

IF sy-subrc EQ 0.

gs_zprice-crmemo = salesdocument.

MODIFY TABLE gt_zprice FROM gs_zprice

TRANSPORTING crmemo.

ENDIF.

READ TABLE gt_zprice INTO gs_zprice.

IF sy-subrc EQ 0.

gs_zprice-crmemo = salesdocument.

MODIFY TABLE gt_zprice FROM gs_zprice

TRANSPORTING mandt vkorg vtweg spart kunnr matnr crdate efdate

sprice eprice eohqty aohqty auart bstkd werks augru

xblnr crmemo.

ENDIF.

Re: Modify Table

Former Member — Thu, 26 Jul 2007 20:55:26 GMT

check this

READ TABLE gt_zprice INTO gs_zprice.

IF sy-subrc EQ 0.

gs_zprice-crmemo = salesdocument.

MODIFY gt_zprice FROM gs_zprice

TRANSPORTING crmemo index sy-tabix.

ENDIF.

Mahesh

Message was edited by:

I Can Solve It

Re: Modify Table

Former Member — Thu, 26 Jul 2007 20:56:34 GMT

Try this way.

DATA: v_index TYPE i.

READ TABLE gt_zprice INTO gs_zprice.

IF sy-subrc EQ 0.

v_index = sy-tabix.

gs_zprice-crmemo = salesdocument.

MODIFY TABLE gt_zprice FROM gs_zprice

TRANSPORTING crmemo INDEX v_index.

ENDIF.

Re: Modify Table

former_member194669 — Thu, 26 Jul 2007 20:56:54 GMT

Hi,

While reading gt_zprice wht will be key?


READ TABLE gt_zprice INTO gs_zprice with key <<< you need to mention>>.
IF sy-subrc EQ 0.
gs_zprice-crmemo = salesdocument.
MODIFY TABLE gt_zprice FROM gs_zprice 
  TRANSPORTING crmemo index sy-tabix. 
ENDIF.

aRs

Message was edited by:

a®

Re: Modify Table

Former Member — Thu, 26 Jul 2007 20:58:04 GMT

sorry small change

READ TABLE gt_zprice INTO gs_zprice.

IF sy-subrc EQ 0.

gs_zprice-crmemo = salesdocument.

MODIFY gt_zprice FROM gs_zprice index sy-tabix

TRANSPORTING crmemo .

ENDIF.

Re: Modify Table

Former Member — Thu, 26 Jul 2007 21:50:34 GMT

Hi,

I tried all the ways but I am getting error saying 'No Component exists with name INDEX.' Please correct me if I am doing something wrong.

FORM update_pricetable.

DATA: ls_zprice TYPE ty_zprice.

LOOP AT gt3_zprice INTO ls_zprice.

READ TABLE gt_zprice INTO gs_zprice INDEX ls_zprice-index.

IF sy-subrc EQ 0.

gs_zprice-crmemo = salesdocument.

MODIFY TABLE gt_zprice FROM gs_zprice

transporting crmemo.

ENDIF.

ENDLOOP.

REFRESH:gt3_zprice.

ENDFORM. " update_pricetable

gt3_zprice contains few records of the table where CRMEMO has to be placed.

TYPES: BEGIN OF ty_zprice,

mandt TYPE mandt,

vkorg TYPE vkorg,

vtweg TYPE vtweg,

spart TYPE spart,

kunnr TYPE kunnr,

matnr TYPE matnr,

crdate TYPE zcrdate,

efdate TYPE zefdate,

sprice TYPE zprice3,

eprice TYPE zprice4,

eohqty TYPE zquantity1,

aohqty TYPE zquantity2,

auart TYPE auart,

bstkd TYPE bstkd,

werks TYPE werks_d,

augru TYPE augru,

xblnr TYPE xblnr,

crmemo TYPE vbeln,

index TYPE sy-index,

END OF ty_zprice.

Thanks,

Neelu.

Re: Modify Table

Former Member — Thu, 26 Jul 2007 23:04:54 GMT

Hi,

Try this..


.................
DATA: v_tabix TYPE sytabix.

LOOP AT gt3_zprice INTO ls_zprice.
READ TABLE gt_zprice INTO gs_zprice INDEX ls_zprice-index.
IF sy-subrc EQ 0.

v_tabix = sy-tabix.

gs_zprice-crmemo = salesdocument.
MODIFY gt_zprice FROM gs_zprice INDEX v_tabix TRANSPORTING crmemo.

Thanks

Naren

Re: Modify Table

Former Member — Thu, 26 Jul 2007 23:22:04 GMT

Thank you Naren. It is displaying the CreditMemo number now.

I really appriciate your help.

Regards,

Neelu.