|
Find the personnel number from a work centre P = Personnel number that we need to find from work centre.
Select HROID into X from CRHD where ARBPL = UE102001 and OBJTY = 'A'.
Select SOBID into Y from HRP1001 where OBJID = X and SCLAS = 'S'.
Select SOBID into P from HRP1001 where OBJID = Y and OTYPE = 'S' AND SCLAS = 'P'.
|
