/IAM/D_ACT_ROOT

Transparent Table Application Table
55 Fields 8 CDS Views

Root

/IAM/D_ACT_ROOT is an SAP database table in S/4HANA. Root. It contains 55 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
E_MasterProjectActivityRoot view from EXTENSION Extension view for Activity Root
I_ChgMgmtActivity view from BASIC Change Management Activity
I_MasterProjectActivityRoot view from BASIC Master Project Activity Root
I_MstrProjActivities view from BASIC Master Project Activities
I_MstrProjActyAttchs view from BASIC Master Project Activity Attachment
I_MstrProjActyTeamMbrBasic view from BASIC Master Project Activity Team Member Basic
P_Activitylist view inner BASIC
P_MstrProjAlertMSC view inner BASIC

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
node_cat_key /BOBF/CONF_KEY NodeID
activity_id /IAM/ACTIVITY_ID Activity ID
application /IAM/APPLICATION Application
act_template /IAM/ACT_TEMPLATE Acty Template
act_type /IAM/ACTTYPE Activity Type
act_category /IAM/ACT_CATEGORY Activity Cat.
par_issue_uuid /IAM/CONF_KEY Node ID
par_act_uuid /IAM/CONF_KEY Node ID
sortno /IAM/SORTNO Sort No.
auth_group /IAM/AUTH_GROUP Authoriz. Group
mandatory /IAM/ACT_MANDATORY Mandatory
cont_incomplete /IAM/CONT_INCOMPLETE Cont. Incompl.
origin_cd /IAM/ACT_ORIGIN_CODE Activity Origin
proposal_ind /IAM/PROPOSAL_IND Proposal
sel_crit_cd /IAM/CAT_CODE Templ. Code
resp_val_bool /IAM/ACT_RESPONSE_VALUE_BOOL Response
long_term /IAM/ACT_LONG_TERM_IND Long-Term Acty
obligatory /IAM/ACT_OBLIGATORY Obligatory
act_master_uuid /IAM/ACT_MASTER_UUID Source Activity
phase /IAM/PHASE Step
status_profile /IAM/USER_STATUS_PROFILE Status Profile
master_language /IAM/MASTER_LANGUAGE Master Language
lcycle_cd /IAM/ACT_LCYCLE_STAT_CD Acty Lifecycle
deferral_cd /IAM/DEFERRAL_STATUS_CD Deferral Status
approval_cd /IAM/APPROVAL_STATUS_CD Approval Status
archiving_cd /IAM/ARCHIVING_STATUS_CD Arch. Status
consist_cd /IAM/CONSISTENCY_STATUS_CD Consistency
followup_cd /IAM/FOLLOWUP_STATUS_CD Follow-Up Actn
validation_cd /IAM/VALIDATION_STATUS_CD Valid. Status
processing_cd /IAM/PROCESSING_STATUS_CD Processing Status
digsign_cd /IAM/DIGIT_SIGN_CD Digit.Sign.
digsign_action /BOBF/ACT_KEY Action
user_status_01 /IAM/USER_STATUS1 User Status 1
user_status_02 /IAM/USER_STATUS2 User Status 2
user_status_03 /IAM/USER_STATUS3 User Status 3
user_status_04 /IAM/USER_STATUS4 User Status 4
user_status_05 /IAM/USER_STATUS5 User Status 5
created_by /BOFU/USER_ID_CREATED_BY Created By
created_on /BOFU/TSTMP_CREATION_TIME Created On
changed_by /BOFU/USER_ID_CHANGED_BY Changed By
changed_on /BOFU/TSTMP_CHANGED_TIME Changed On
act_root DUMMY Dummy function in length 1
archiving /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
act_item_stat_cd /CPD/RM_ACT_STAUS Status
admin_info BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
version_guid /BOBF/CONF_KEY NodeID
migration_source /MOC/MIGRATION_SOURCE Migration Source
alternative_id /IAM/ACTIVITY_ID Activity ID
alternative_key /BOBF/CONF_KEY NodeID
archiving_status /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
cea_status /PICM/ICM_STATUS_ACT Activity Status
cea_status_img /PICM/ICM_STATUS_ACT_IMG Activity Status
cea_active BOOLE_D TRUE

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /IAM/D_ACT_ROOT (
    MANDT,             -- Client [MANDT]
    DB_KEY,            -- NodeID [/BOBF/CONF_KEY]
    NODE_CAT_KEY,      -- NodeID [/BOBF/CONF_KEY]
    ACTIVITY_ID,       -- Activity ID [/IAM/ACTIVITY_ID]
    APPLICATION,       -- Application [/IAM/APPLICATION]
    ACT_TEMPLATE,      -- Acty Template [/IAM/ACT_TEMPLATE]
    ACT_TYPE,          -- Activity Type [/IAM/ACTTYPE]
    ACT_CATEGORY,      -- Activity Cat. [/IAM/ACT_CATEGORY]
    PAR_ISSUE_UUID,    -- Node ID [/IAM/CONF_KEY]
    PAR_ACT_UUID,      -- Node ID [/IAM/CONF_KEY]
    SORTNO,            -- Sort No. [/IAM/SORTNO]
    AUTH_GROUP,        -- Authoriz. Group [/IAM/AUTH_GROUP]
    MANDATORY,         -- Mandatory [/IAM/ACT_MANDATORY]
    CONT_INCOMPLETE,   -- Cont. Incompl. [/IAM/CONT_INCOMPLETE]
    ORIGIN_CD,         -- Activity Origin [/IAM/ACT_ORIGIN_CODE]
    PROPOSAL_IND,      -- Proposal [/IAM/PROPOSAL_IND]
    SEL_CRIT_CD,       -- Templ. Code [/IAM/CAT_CODE]
    RESP_VAL_BOOL,     -- Response [/IAM/ACT_RESPONSE_VALUE_BOOL]
    LONG_TERM,         -- Long-Term Acty [/IAM/ACT_LONG_TERM_IND]
    OBLIGATORY,        -- Obligatory [/IAM/ACT_OBLIGATORY]
    ACT_MASTER_UUID,   -- Source Activity [/IAM/ACT_MASTER_UUID]
    PHASE,             -- Step [/IAM/PHASE]
    STATUS_PROFILE,    -- Status Profile [/IAM/USER_STATUS_PROFILE]
    MASTER_LANGUAGE,   -- Master Language [/IAM/MASTER_LANGUAGE]
    LCYCLE_CD,         -- Acty Lifecycle [/IAM/ACT_LCYCLE_STAT_CD]
    DEFERRAL_CD,       -- Deferral Status [/IAM/DEFERRAL_STATUS_CD]
    APPROVAL_CD,       -- Approval Status [/IAM/APPROVAL_STATUS_CD]
    ARCHIVING_CD,      -- Arch. Status [/IAM/ARCHIVING_STATUS_CD]
    CONSIST_CD,        -- Consistency [/IAM/CONSISTENCY_STATUS_CD]
    FOLLOWUP_CD,       -- Follow-Up Actn [/IAM/FOLLOWUP_STATUS_CD]
    VALIDATION_CD,     -- Valid. Status [/IAM/VALIDATION_STATUS_CD]
    PROCESSING_CD,     -- Processing Status [/IAM/PROCESSING_STATUS_CD]
    DIGSIGN_CD,        -- Digit.Sign. [/IAM/DIGIT_SIGN_CD]
    DIGSIGN_ACTION,    -- Action [/BOBF/ACT_KEY]
    USER_STATUS_01,    -- User Status 1 [/IAM/USER_STATUS1]
    USER_STATUS_02,    -- User Status 2 [/IAM/USER_STATUS2]
    USER_STATUS_03,    -- User Status 3 [/IAM/USER_STATUS3]
    USER_STATUS_04,    -- User Status 4 [/IAM/USER_STATUS4]
    USER_STATUS_05,    -- User Status 5 [/IAM/USER_STATUS5]
    CREATED_BY,        -- Created By [/BOFU/USER_ID_CREATED_BY]
    CREATED_ON,        -- Created On [/BOFU/TSTMP_CREATION_TIME]
    CHANGED_BY,        -- Changed By [/BOFU/USER_ID_CHANGED_BY]
    CHANGED_ON,        -- Changed On [/BOFU/TSTMP_CHANGED_TIME]
    ACT_ROOT,          -- Dummy function in length 1 [DUMMY]
    ARCHIVING,         -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    ACT_ITEM_STAT_CD,  -- Status [/CPD/RM_ACT_STAUS]
    ADMIN_INFO,        -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    VERSION_GUID,      -- NodeID [/BOBF/CONF_KEY]
    MIGRATION_SOURCE,  -- Migration Source [/MOC/MIGRATION_SOURCE]
    ALTERNATIVE_ID,    -- Activity ID [/IAM/ACTIVITY_ID]
    ALTERNATIVE_KEY,   -- NodeID [/BOBF/CONF_KEY]
    ARCHIVING_STATUS,  -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    CEA_STATUS,        -- Activity Status [/PICM/ICM_STATUS_ACT]
    CEA_STATUS_IMG,    -- Activity Status [/PICM/ICM_STATUS_ACT_IMG]
    CEA_ACTIVE,        -- TRUE [BOOLE_D]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More