I_DFS_OrglMeasureForArea

Org Measure for Area (for User) | view: IORGMFAREA | Extraction: Not supported | Component: Common Functionality for Defense and Security
Tables used: SCMG_T_CASE_ATTR, /ISDFPS/ORGM, SWWWIHEAD, SWPSTEPLOG, SCMGSTATPROFS, SCMGSTATPROFST, /ISDFPS/CORGM1, /ISDFPS/CORGM1T, SWW_WI2OBJ, SWWWICOMMENT, SCMGPDIR_CLNT, SCMGPREL_CLNT
Column Name Description
DfsOrglMeasureUUID Technical Case Key (Case GUID)
Column Name Description
Column Name Description
Column Name Description
DfsOrglMsrEffectivenessDate Effectiveness of the Organizational Measure
Column Name Description
Column Name Description Domain name
CaseID Case ID SCMG_EXT_KEY
DfsOrglMeasureCategoryText null
CaseExternalReference External Reference CHAR30
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CloseDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
DfsOrglMeasureDescription Case Title TEXT80
CaseStatusName Case: Status Description SCMGSTAT_DESCR
StatusCriticality null
CaseStatusObjectNumber Case: Status Object Number (GUID), (Central Status Managmnt) SYSUUID_C
CaseSystemStatusName Case: System Status Description (Central Status Management) SCMGSTATLINE
CaseUserStatusName Case: User Status Description (Central Status Management) SCMGSTATLINE
DfsOrglMeasureHeaderType Object Type OTYPE
DfsOrglMeasureHeaderID Header Element of the Organizational Measure HROBJID
DfsOrglMeasureTypeText Description of Measure Type TEXT40
DfsOrglMeasureType Measure Type CHAR4
Master Data Relations Join Conditions
Authorization level
  • Client
  • Authorization level
Closed by User
  • Client
  • Closed by User
  • I_DFS_ORGLMEASUREFORAREA.MANDT == USR02.MANDT
  • I_DFS_ORGLMEASUREFORAREA.CASECLOSEDBY == USR02.BNAME
Created By
  • Created By
  • Client
  • I_DFS_ORGLMEASUREFORAREA.CASECREATEDBY == USR02.BNAME
  • I_DFS_ORGLMEASUREFORAREA.MANDT == USR02.MANDT
Last Changed By
  • Client
  • Last Changed By
  • I_DFS_ORGLMEASUREFORAREA.MANDT == USR02.MANDT
  • I_DFS_ORGLMEASUREFORAREA.CASELASTCHANGEDBY == USR02.BNAME
Processor
  • Client
  • Processor
  • I_DFS_ORGLMEASUREFORAREA.MANDT == USR02.MANDT
  • I_DFS_ORGLMEASUREFORAREA.CASEPROCESSOR == USR02.BNAME
Reason for Case
  • Client
  • Reason for Case
  • Case Type
Case: Status
  • Client
  • Case: Status
  • ?
  • I_DFS_ORGLMEASUREFORAREA.MANDT == SCMGSTATPROFS.CLIENT
  • I_DFS_ORGLMEASUREFORAREA.CASESTATUS == SCMGSTATPROFS.STAT_ORDERNO
  • I_DFS_ORGLMEASUREFORAREA.[column in domain "SCMGSTATUSPROFID"] == SCMGSTATPROFS.PROFILE_ID
Case: System Status I_DFS_ORGLMEASUREFORAREA.CASESYSTEMSTATUS == SCMGSTAT.STAT_PARA
Case Type
  • Client
  • Case Type
Person Responsible
  • Client
  • Person Responsible
  • I_DFS_ORGLMEASUREFORAREA.MANDT == USR02.MANDT
  • I_DFS_ORGLMEASUREFORAREA.DFSORGLMEASURERESPONSIBLE == USR02.BNAME