• JDELIST is celebrating its 20 year anniversary today!
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

How to identify Clone Object

puppy

Active Member
Hi,

Is there way to identify the clone objects list in JDE?

I mean copy of standard objects.

Thanks & Regards,
Puppy.
 

puppy

Active Member
I mean if we copied P554218 from P4210 and do the customization on P554218.

How to identify this P554218 is a copy of P4218.
 

ybuffetaud

Active Member
Hi a way to find that is to make an SQL over F9860 :
Let's sayt that I know I've copied R42565 into R5742565 :
select * from ol812.f9860 where siobnm in ('R42565','R5742565'); =S Look at the fiel APPLID : this is the same so now by doing this request :

select * from ol812.f9860 where siapplid=96523 => you'll have all the copied ones.

Regards
 

ybuffetaud

Active Member
Hi a way to find that is to make an SQL over F9860 :
Let's sayt that I know I've copied R42565 into R5742565 :
select * from ol812.f9860 where siobnm in ('R42565','R5742565'); =S Look at the fiel APPLID : this is the same so now by doing this request :

select * from ol812.f9860 where siapplid=96523 => you'll have all the copied ones.

Regards
You'll also have this one :
select * from ol812.f9860 where sicato='COP' => all new APPL or other objetcs whiche were copied from standard one
 

puppy

Active Member
Thanks Yann Buffetaud.

I tried the query select * from ol812.f9860 where siapplid=96523 with some modification.

Somehow I am able to get.

But this select * from ol812.f9860 where sicato='COP' not selecting any records.

Thanks & Regards,
Puppy.
 

DBohner-(db)

Legendary Poster
You could, always, review OMW Logging for Action type 06, then drill into the details.

You could create a BSVW linking F98210 to F98211 by LOGKEY. Then QBE on the F98210.LHOMWAC=06, this would give you the "What was Copied" from the F98210.LHOMWOBJID and the "Copied To" from the F98211.LDOMWLDATA.

The query might look something like:

SELECT T0.LHLOGKEY, T0.LHOMWPRJID, T0.LHOMWOBJID, T0.LHOMWOT, T0.LHOMWAC, T1.LDLOGKEY, T1.LDLOGSEQ, T1.LDOMWLDTAI, T1.LDOMWLDATA, T1.LDPID, T1.LDMKEY, T1.LDUSER, T1.LDUPMT
FROM SY900/F98210 T0,SY900/F98211 T1
WHERE ( T0.LHOMWOT IN ( 'APPL','UBE','BSVW' )
AND T0.LHOMWAC = '06' )
AND ( T0.LHLOGKEY=T1.LDLOGKEY )
ORDER BY T0.LHLOGKEY ASC;

(db)
 

johndanter

Legendary Poster
I've done this and Daniels code is right. I think he may have helped me :)

Here are my notes:

ALL objects mods in E1 are stored in several back end tables in E1. All these tables live in the OL900 and SY900 data sources and are shared over ALL environments

F9860 is the OMW master table (OL900)
F9861 is the OMW Status Detail (OL900)
F98210 is the OMW Log Header (SY900)
F98211 is the OMW Log Detail (SY900)

Within these tables we can work out all manner of object movement within E1. Cloned objects, changed objects, which project the objects were in etc.

It is important to NOTE C++ and NER BSFNS will not be in this list.

F98210 where LHOMWAC = 06 (copy)
F98210 and F98211 are linked by field LHLOGKEY and LDLOGKEY (create a join BSVW)

Goto F98211 and type in your R55* in LDOMWLDATA
Get the LOGKEY and use that to select in F98210 where LHOMWAC = 06.
LHOMWOBJID is the base object it came from
(F982111.OMWLDTAI = 135J)
 
Top