Insert into database table

Former Member — Wed, 04 Jun 2008 09:12:39 GMT

Hi Guy's,

Please help me, trying to insert the records into database table. when i debug the program work area contain data records but not insert into databse table. Here pasted my code pls suggest me where i did mistake.

FUNCTION ZEXM_PHOTOCOPYDTLS_EP.

*"----

""Local Interface:

*" IMPORTING

*" VALUE(EXMCODE) TYPE ZEXMCODE OPTIONAL

*" VALUE(EXMMONTH) TYPE ZEXMMONTH OPTIONAL

*" VALUE(SEATNO) TYPE ZSEATNO OPTIONAL

*" VALUE(STDFIRSTNAME) TYPE ZSTDFIRSTNAME OPTIONAL

*" VALUE(STDMIDDLENAME) TYPE ZSTDMIDDLENAME OPTIONAL

*" VALUE(STDLASTNAME) TYPE ZSTDLASTNAME OPTIONAL

*" VALUE(ADDLINE1) TYPE ZADDLINE1 OPTIONAL

*" VALUE(CITY) TYPE ZCITY OPTIONAL

*" VALUE(COUNTRY) TYPE ZCOUNTRY OPTIONAL

*" VALUE(PIN) TYPE ZPIN OPTIONAL

*" VALUE(TELEPHONENO) TYPE ZTELEPHONENO OPTIONAL

*" VALUE(MOBNO) TYPE ZMOBNO OPTIONAL

*" VALUE(EMAIL) TYPE ZEMAIL OPTIONAL

*" VALUE(DDNO) TYPE ZDDNO OPTIONAL

*" VALUE(DDAMT) TYPE ZDDAMOUNT OPTIONAL

*" VALUE(DDDATE) TYPE ZDDDATE OPTIONAL

*" VALUE(BANKNAME) TYPE ZBANKNAME OPTIONAL

*" VALUE(COLNAME) TYPE ZCOLNAME OPTIONAL

*" VALUE(COLADDRESS) TYPE ZCOLADDRESS OPTIONAL

*" VALUE(COURSECODE) TYPE ZCOURSECODE OPTIONAL

*" VALUE(EXMYEAR) TYPE ZEXMYEAR OPTIONAL

*" VALUE(PAPERCODE) TYPE ZPAPERCODE OPTIONAL

*" VALUE(PAPERNO) TYPE ZPAPERNO OPTIONAL

*" VALUE(MARKSOBT) TYPE ZMARKSOBT OPTIONAL

*" VALUE(EXMDATE) TYPE ZEXMDATE OPTIONAL

*" VALUE(EXMTIME) TYPE ZEXMTIME OPTIONAL

*" VALUE(SUBCODE) TYPE ZSUBCODE OPTIONAL

*" EXCEPTIONS

*" SELECTION_ERROR

*"----

DATA : WA_OUTPUT TYPE ZEXM_PHOTOCOPYDT,

WA_COLL TYPE ZEXM_COLLEGEMST,

WA_COURSE TYPE ZEXM_COURSEMST,

WA_EXMCODE TYPE ZEXM_EXMCODEMST,

WA_PAPER TYPE ZEXM_PHOPAPERMAP,

WA_SUBJECT TYPE ZEXM_SUBJECTMST.

STUDENT DETAILS

MOVE : EXMCODE TO WA_OUTPUT-ZEXMCODE,

EXMMONTH TO WA_OUTPUT-ZEXMMONTH,

SEATNO TO WA_OUTPUT-ZSEATNO,

STDFIRSTNAME TO WA_OUTPUT-ZSTDFIRSTNAME,

STDMIDDLENAME TO WA_OUTPUT-ZSTDMIDDLENAME,

STDLASTNAME TO WA_OUTPUT-ZSTDLASTNAME,

ADDLINE1 TO WA_OUTPUT-ZADDLINE1,

CITY TO WA_OUTPUT-ZCITY,

COUNTRY TO WA_OUTPUT-ZCOUNTRY,

PIN TO WA_OUTPUT-ZPIN,

TELEPHONENO TO WA_OUTPUT-ZTELEPHONENO,

MOBNO TO WA_OUTPUT-ZMOBNO,

EMAIL TO WA_OUTPUT-ZEMAIL,

DDNO TO WA_OUTPUT-ZDDNO,

DDAMT TO WA_OUTPUT-ZDDAMT,

DDDATE TO WA_OUTPUT-ZDDDATE,

BANKNAME TO WA_OUTPUT-ZBANKNAME.

insert into ZEXM_PHOTOCOPYDT values wa_output.

if sy-subrc = 0.

commit work.

endif.

Thanks and Regards,

Sai.

Edited by: sai shanhu on Jun 4, 2008 11:13 AM

Re: Insert into database table

Former Member — Wed, 04 Jun 2008 09:17:38 GMT

Hi,

Instead of using insert, try this

modify ZEXM_PHOTOCOPYDT from wa_output.

Thanks

Nayan

Re: Insert into database table

Former Member — Wed, 04 Jun 2008 09:17:41 GMT

Hi,

Try using

INSERT wa_output into table ZEXM_PHOTOCOPYDT

Regards

Sayee

Re: Insert into database table

Former Member — Wed, 04 Jun 2008 09:17:48 GMT

Hai,

move wa_output into ZEXM_PHOTOCOPYDT.

insert ZEXM_PHOTOCOPYDT.

Thanks,

Durai.V

topic Insert into database table in Application Development and Automation Discussions

Insert into database table

Re: Insert into database table

Re: Insert into database table

Re: Insert into database table