Skip to Content
0
Former Member
Sep 29, 2008 at 10:55 AM

Modifying DBTAB

41 Views

Dear Guru's,

I have a Ztable with the following Fields:

OBJECT_ID

BEGDA

ENDDA

SEQNR

WERKS

BTRTL

of which OBJECT_ID, BEGDA, ENDDA, SEQNR are keyfields.

Consider I have a data with OBJECT_ID = 9400, BEGDA = '20080929', ENDDA = '99991231', SEQN = '001'.

now I am gonna save a new record to the table OBJECT_ID = 9400, BEGDA = '20081029', ENDDA = '99991231', SEQN = '001' through a program.

What I want to do in my program is I want the first data to be delimited to the new datas begda.

i.e., first data must change to OBJECT_ID = 9400, BEGDA = '20080929', ENDDA = '20081029', SEQN = '001'.

how to do it....

I cant use modify because the key fields are different so it will add a new record. Please tell me how to go about it???

Regards

VIjay