topic Re: customized table in Application Development and Automation Discussions

customized table

Former Member — Tue, 05 Oct 2010 04:46:01 GMT

I have created a customized table and inserted records via ABAP report. Its working fine at development server but at Production server, neither table is filled nor its giving any error. I have executed it in Background processing as it gives timeout error on foreground .

Re: customized table

faisalatsap — Tue, 05 Oct 2010 04:53:23 GMT

Hi,

Welcome to SCN

Please USE Meaningful Subject Line for next time

Check may you have created index for table and the index field is going empty.

Regards,

Faisal

Re: customized table

Former Member — Tue, 05 Oct 2010 05:17:32 GMT

Razia,

Any authorisation issue.put the code of the report here for filling the table

Thanks

Bala Duvvuri

Re: customized table

Former Member — Tue, 05 Oct 2010 05:28:00 GMT

No authorization issue.

DATA OBJNR LIKE ZCOST-OBJNR.
OBJNR = 0 .
SELECT COUNT(*)  INTO OBJNR FROM ZCOST.

LOOP AT T_FiNAL_DISP INTO wa.
   IF wa IS NOT  INITIAL.
    OBJNR = OBJNR + 1.
    wa-OBJNR = OBJNR.
    wa-GJAHR = p_GJAHR.
    wa-MONAT = p_PERIO.
    INSERT into ZCOST values wa.
  ENDIF.

ENDLOOP.

if sy-subrc = 0.
    MESSAGE 'Successfully Completed .' TYPE 'S'.
endif.

Edited by: Matt on Oct 5, 2010 7:36 AM - added tags

Re: customized table

matt — Tue, 05 Oct 2010 05:37:54 GMT

Presumably T_FiNAL_DISP doesn't contain anything.

Re: customized table

JoffyJohn — Tue, 05 Oct 2010 06:01:18 GMT

you change the message with a simple write statment and then execute in background mode.

If insertion fails, you can see the write message output in the log in SM37 tcode.

check the status of you current background exection in SM37.

Re: customized table

Former Member — Tue, 05 Oct 2010 06:05:38 GMT

Hi Razia,

Code seems fine but please try modyfying it as below and check whether it works or not.

Declare one internal table (itab) of linetype wa.

DATA OBJNR LIKE ZCOST-OBJNR.
OBJNR = 0 .
SELECT COUNT(*)  INTO OBJNR FROM ZCOST.
 
LOOP AT T_FiNAL_DISP INTO wa.
   IF wa IS NOT  INITIAL.
    OBJNR = OBJNR + 1.
    wa-OBJNR = OBJNR.
    wa-GJAHR = p_GJAHR.
    wa-MONAT = p_PERIO.
    append wa to itab.
     ENDIF. 
ENDLOOP.
 
if not itab is initial.
INSERT ZCOST FROM TABLE itab.
commit work.
if sy-subrc = 0.
    MESSAGE 'Successfully Completed .' TYPE 'S'.
endif.
endif.

Regards,

Pawan