/IAM/D_I_ROOT

Root node DB table | #transactional | Component: Generic Issue and Activity Management
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Currency Key (RM_CURRENCY):
EST_COST_IMPACT Estimated Cost Impact
RISK_MIT_COST Estimated Cost Impact
💲 Currency Key (CURRENCY):
EST_COST Estimated Cost
Column Name Description
Column Name Description
Column Name Description
EMERGENCY Emergency Indicator Show values
ARCHIVING_OF_ACT Activities of Issue Are Archived Show values
LCYCLE_CD Issue Lifecycle Status Code Show values
CONSIST_CD Consistency Status of an Object Show values
DEFERRAL_CD Deferral Status of an Object Show values
ARCHIVING_CD Archiving Status of an Object Show values
VALIDATION_CD Validation Status of an Object Show values
EFFECTIVENESS_CD Effectiveness Check Status of an Object Show values
APPROVAL_CD Approval Status of an Object Show values
ISSUE_TYPE_CD Issue Type Status of an Object Show values
DIGSIGN_CD Digital Signature Status Code Show values
ARCHIVING Archiving Status Show values
RISK_OPPT Risk / Opportunity Show values
EST_DELAY_TYPE Estimated Delay Type Show values
CRCAT Change Request Category (Single, Collective, Blank) Show values
PICM_LCYCLE_CD Issue Lifecycle Status Code Show values
ARCHIVING_STATUS Archiving Status Show values
Column Name Description Domain name
NODE_CAT_KEY NodeID /BOBF/CONF_KEY
ISSUE_ID Issue ID /IAM/ID
ISSUE_TYPE Issue Type /IAM/ISSUE_TYPE
ISSUE_CATEGORY Issue Category /IAM/ISS_CATEGORY
PAR_ISSUE_UUID NodeID /BOBF/CONF_KEY
ROOT_ISSUE_UUID NodeID /BOBF/CONF_KEY
SORTNO Sort Number /IAM/SORTNO
AUTH_GROUP Authorization Group /IAM/AUTH_GROUP
CRITICALITY Criticality /IAM/CRITICALITY
PRIORITY Priority /IAM/PRIORITY
REPORTED_BY Business Partner Name BU_TEXT50
DURATION_CD Duration /IAM/DURATION
TERM_REDEF_ID Redefinition of Semantics /IAM/REDEFINITION
ACT_DET_COUNT Counter for Activity Determination
STATUS_PROFILE Status Profile
DATE_SCHEMA Date Schema
MASTER_LANGUAGE Master Language for Texts SPRAS
DIGSIGN_ACTION Action /BOBF/CONF_KEY
USER_STATUS_01 User Status Code 1 /IAM/USER_STATUS
USER_STATUS_02 User Status Code 2 /IAM/USER_STATUS
USER_STATUS_03 User Status Code 3 /IAM/USER_STATUS
USER_STATUS_04 User Status Code 4 /IAM/USER_STATUS
USER_STATUS_05 User Status Code 5 /IAM/USER_STATUS
CREATED_BY Created By XUBNAME
CREATED_ON Created on /BOFU/TSTMP
CHANGED_BY Changed By XUBNAME
CHANGED_ON Changed On /BOFU/TSTMP
I_ROOT Dummy function in length 1 DUMMY
/CPD/MC_MP_GUID NodeID /BOBF/CONF_KEY
OBJECT_GUID NodeID /BOBF/CONF_KEY
IDENTIFY_STAGE Commercial Project: Stage /CPD/PWS_WS_MP_STG
RISK_ID Risk ID /CPD/RM_RISK_ID
CAT_ID Category ID /CPD/RM_CAT_ID
SUB_CAT_ID Subcategory ID for Risk Management /CPD/RM_SUB_CAT_ID
RISK_TXT Short Description /CPD/RM_DESCRIPTION
PROBABILITY_ID Probability /CPD/RM_PROBABILITY
SEVERITY_ID Severity /CPD/RM_SEVERITY
RISK_LEVEL_ID Risk Management: Risk Level ID /CPD/RM_RISK_LEVEL_ID
RISK_STATUS Risk Status ID /CPD/RM_STATUS_ID
EST_SHDL_DELAY Estimated Schedule Delay /CPD/RM_EST_DELAY
RESP_TYPE Risk Response Type /CPD/RM_RESPONSE_TYPE
RESP_STATUS Response Status /CPD/RM_RESP_STATUS
COST Cost /CPD/RM_IMPACTS
SCHEDULE Schedule /CPD/RM_IMPACTS
QUALITY Quality /CPD/RM_IMPACTS
SCOPE Scope /CPD/RM_IMPACTS
VERSION_GUID NodeID /BOBF/CONF_KEY
MIGRATION_SOURCE Migration Source CHAR60
EST_DELAY Estimated Delay /PICM/EST_DELAY
SEND_NOTI E-mail notification sent
STAT_CD Status Code /PICM/STATUS_CD
REFCR Reference Change Request Number /PICM/REFCR
PLAN_ID Plan /PICM/PLAN_ID
PLAN_VERSION Plan Version /PICM/PLAN_VERSION
PLAN_VERSION_ID Plan Version /PICM/VERSION_ID
PLAN_VERSION_TYPE Version Type /PICM/VER_TYPE_ID
MASTER_PROJ Master Project /PICM/MASTER_PROJ_ID
PROBABILITY Probability DEC03_2
PLAN_KEY NodeID /BOBF/CONF_KEY
CHANGE_NO Change Number AENNR
Master Data Relations Join Conditions
Client and Application
  • Application in Issue and Activity Engine
  • Client
System client and country
  • Country/Region Key
  • Client
  • /IAM/D_I_ROOT.COUNTRY == T005.LAND1
  • /IAM/D_I_ROOT.MANDT == T005.MANDT
Currency Key
  • /IAM/D_I_ROOT.MANDT == TCURC.MANDT
  • /IAM/D_I_ROOT.CURRENCY == TCURC.WAERS
Default Quantity Unit
  • /IAM/D_I_ROOT.MANDT == T006.MANDT
  • /IAM/D_I_ROOT.DEF_QUANT_UNIT == T006.MSEHI