Skip to Content
0
Former Member
Mar 22, 2009 at 11:16 AM

insert the records with other id

21 Views

Hi,

is there a way to do following.

relating to a header_id in a table I have to replicate all the records which have the same id.

Suppose: There are four different tables. You have records related to the this headerid.

And now the requirement is find out all the records in those tables which belong

to the hederid. And finally replicate them by pasisng a new id

Table 1

HeaderID = 12345

LVORM = any value

STOFF = any value

SPART = any value

Table 2

HeaderID = 12345

BLANZ = any value

Table 3

HeaderID = 12345

ERSDA = any value

ERNAM = any value

LAEDA = any value

Table 4

HeaderID = 12345

GEWEI = any value

VOLUM = any value

VOLEH = any value

BEHVO = any value

RAUBE = any value

Regards

sas erdem