topic Re: how to pass data frominternal table to database table in Application Development and Automation Discussions

how to pass data frominternal table to database table

Former Member — Thu, 14 Feb 2008 12:52:28 GMT

hi,

can any one help me to pass data from internal table to database table when duplicates also have to be stored in DB table

Re: how to pass data frominternal table to database table

Former Member — Thu, 14 Feb 2008 12:56:55 GMT

Hi,

Use the modify or update statement to modify the ddic object from the internal table.

Regards,

Himanshu

Re: how to pass data frominternal table to database table

Former Member — Thu, 14 Feb 2008 12:57:24 GMT

Hi,

all the fields are same in the internal table.

Re: how to pass data frominternal table to database table

Former Member — Thu, 14 Feb 2008 13:02:52 GMT

Hi,

use update statement with set and finally commit.

sample code:

UPDATE ZPST_BILL_RATES

SET STATUS = 'A'

ZZCDUID = SY-UNAME

ZZCDDATE = SY-DATUM

ZZCDTIME = SY-UZEIT

ZZFRMDATE = GV_TODATE

WHERE PSPID = GT_ZPST_BILL_RATES-PSPID.

iF SY-SUBRC = 0.

COMMIT WORK.

ENDIF.

Regards,

Ratna

Re: how to pass data frominternal table to database table

Former Member — Thu, 14 Feb 2008 13:52:31 GMT

here the data should be enterd into a ztable(database) which has only mandt as key field ,and the records in internal table has duplicates,plz give me a sample code

Re: how to pass data frominternal table to database table

Former Member — Thu, 14 Feb 2008 13:58:08 GMT

Hi,

No problems is it has duplicates but in that case ur z-table should not have any key fields you can simply use the update statement:

UPDATE dbtab FROM TABLE itab.

Regards,

Himanshu

Re: how to pass data frominternal table to database table

Former Member — Thu, 14 Feb 2008 13:59:23 GMT

Hi,

Refer to the below example code snippet:


INSERT SPFLI FROM TABLE ITAB ACCEPTING DUPLICATE KEYS.

Thanks,

Sriram Ponna.