hi
table T777E contains all possible relations....
so u have to frame ur select query based on what u want from what....and using this table find the relat between them or if there is no direct relationship... then try to find out in what indirect way are they related..... then ur select query will look like....
select single sobid from hrp1001 into v_eventtype where
plvar = '01' and otype = 'L' and sclas = 'D' and relat = '003' and objid = p_eventgrp.
if sy-subrc = 0.
*-- business event type related to business event group
endif.
select single sobid from hrp1001 into v_event where
plvar = '01' and otype = 'D' and sclas = 'E' and relat = '020' and objid = v_eventtype.
if sy-subrc = 0.
*-- business event related to business event type
endif.
select single sobid from hrp1001 into v_persid where
plvar = '01' and otype = 'E' and sclas = 'P' and relat = '025' and objid = v_event.
if sy-subrc = 0.
*-- pernr related to business event
endif.
also relat depends on ur requirement.....
check T777E table to find all possible relations between these object types and find out the one which suits ur requirement.....
here are few relationships
L--> 003 ---> D
D--> 020 ---> E
E---> 023/025/040/050/052 --->P
D-> 026/027/034/049/090>P
L and P are not related directly.
So check what these relationships represent using T777E and use right one. Also u can modify ur selects accoringly.
Regards
Vasu
Code Formatted by: Alvaro Tejada Galindo on Jan 23, 2008 6:13 PM
Bluesky
