queryviz
tables/relationship path
open in builder
T002
SPRAS
T001
BUKRS
PA0001
PLANS → SOBID, PERNR → OBJID
HRP1001

HRP1001

om - relationships (organizational management)
hr17f · 12k · 2r
Unchanged in S/4
Unchanged in S/4HANA on-premise. All org management relationships including reporting lines, matrix relationships, and position-to-person assignments are stored here. Cloud strategic direction: SuccessFactors Employee Central.

fields (17)

fieldtypelengthkeydescription
BEGDAdats8pkstart date
ENDDAdats8pkend date
ISTATnumc1pkplanning status
MANDTclnt3pkclient
OBJIDnumc8pkobject id
OTYPEchar2pkobject type
PLVARchar2pkplan version
PRIOXnumc2pkpriority
RELATchar3pkrelationship type
RSIGNchar1pka/b direction of relationship
SEQNRnumc3pksequence number
VARYFchar40pkcontent-dependent additional value
AEDTMdats8changed on
PROZTdec5percentage
SCLASchar2object type of related object
SOBIDchar40id of related object
UNAMEchar12changed by

relationships (2)

master lookup

reference to master data

referenced by
HRP1000
PLVARPLVAR
OTYPEOTYPE
OBJIDOBJID
1:N
PA0001
SOBIDPLANS
OBJIDPERNR
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms