/ISDFPS/TRNGQUAL

Training - Qualification Mapping | #other | Component: Organizational Flexibility
Column Name Description
MANDT FK Client
TPROG_ID FK Training Program ID
FUNCT_ID FK Function ID
STATUS_ID FK Training Status ID
TRAIN_ID FK Training ID
OTYPE FK Object Type
OBJID FK Object ID
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Function ID
  • Function ID
  • Client
  • Training Program ID
  • ?
Client /ISDFPS/TRNGQUAL.MANDT == T000.MANDT
Object ID
  • Object ID
  • Client
  • ?
  • Object Type
  • ?
  • ?
  • ?
  • ?
  • ?
  • /ISDFPS/TRNGQUAL.OBJID == HRP1000.OBJID
  • /ISDFPS/TRNGQUAL.MANDT == HRP1000.MANDT
  • /ISDFPS/TRNGQUAL.[column in domain "PLVAR"] == HRP1000.PLVAR
  • /ISDFPS/TRNGQUAL.OTYPE == HRP1000.OTYPE
  • /ISDFPS/TRNGQUAL.[column in domain "ISTAT_D"] == HRP1000.ISTAT
  • /ISDFPS/TRNGQUAL.[column in domain "BEGDATUM"] == HRP1000.BEGDA
  • /ISDFPS/TRNGQUAL.[column in domain "ENDDATUM"] == HRP1000.ENDDA
  • /ISDFPS/TRNGQUAL.[column in domain "SEQNR"] == HRP1000.SEQNR
  • /ISDFPS/TRNGQUAL.[column in domain "LANGU"] == HRP1000.LANGU
Object Type
  • /ISDFPS/TRNGQUAL.MANDT == T778O.MANDT
  • /ISDFPS/TRNGQUAL.OTYPE == T778O.OTYPE
Training Status ID
  • Training Program ID
  • Function ID
  • Training Status ID
  • Client
  • ?
  • /ISDFPS/TRNGQUAL.TPROG_ID == TRAIN_STAT.TPROG_ID
  • /ISDFPS/TRNGQUAL.FUNCT_ID == TRAIN_STAT.FUNCT_ID
  • /ISDFPS/TRNGQUAL.STATUS_ID == TRAIN_STAT.STATUS_ID
  • /ISDFPS/TRNGQUAL.MANDT == TRAIN_STAT.MANDT
  • /ISDFPS/TRNGQUAL.[column in domain "ENDDA"] == TRAIN_STAT.ENDDA
Training Program ID
  • Training Program ID
  • Client
  • ?
  • /ISDFPS/TRNGQUAL.TPROG_ID == TRAIN_PROG.TPROG_ID
  • /ISDFPS/TRNGQUAL.MANDT == TRAIN_PROG.MANDT
  • /ISDFPS/TRNGQUAL.[column in domain "ENDDA"] == TRAIN_PROG.ENDDA
Training ID
  • Training Program ID
  • Training ID
  • Client
  • End Date