customized table

[Former Member]

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 .

[faisalatsap]

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

[Former Member]

Razia,

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

Thanks

Bala Duvvuri

[Former Member]

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

[matt]

Presumably T_FiNAL_DISP doesn't contain anything.

[Former Member]

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

[JoffyJohn]

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.

Or

check the status of you current background exection in SM37.