/IAM/C_ACTIVTYP
Activity Template
/IAM/C_ACTIVTYP is an SAP database table in S/4HANA. Activity Template. It contains 17 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ChgMgmtActivityTemplate | view | from | BASIC | Change Management Activity Template |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | application | /IAM/APPLICATION | Application | |||
| KEY | activity_type | /IAM/ACT_TEMPLATE | Acty Template | |||
| auth_group | /IAM/AUTH_GROUP | Authoriz. Group | ||||
| code | /IAM/CAT_CODE | Templ. Code | ||||
| acttype | /IAM/ACTTYPE | Activity Type | ||||
| duration | /IAM/ACT_DURATION | Acty Duration | ||||
| duration_unit | /IAM/ACT_DURATION_UNIT | Unit of Durat. | ||||
| response_type | /IAM/ACT_RESPONSE_TYPE | Resp. Type | ||||
| response_unit | /IAM/ACT_RESPONSE_UNIT | Response Unit | ||||
| act_long_term | /IAM/ACT_LONG_TERM_IND | Long-Term Acty | ||||
| act_mandatory | /IAM/ACT_MANDATORY | Mandatory | ||||
| auto_rule_execut | /IAM/AUTO_RULE_EXECUTION | Auto. Rule Exe. | ||||
| act_follow_up | /IAM/ACT_FOLLOW_UP | Follow-Up Act. | ||||
| follow_up_mode | /IAM/FOLLOWUP_MODE | Proc. Mode | ||||
| inactive | /IAM/INACTIVE | Inactive | ||||
| cmnt_mandatory | /IAM/CMNT_MANDATORY | Cmnt Mandatory |
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.
-- Activity Template
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /IAM/C_ACTIVTYP (
CLIENT, -- Client [MANDT]
APPLICATION, -- Application [/IAM/APPLICATION]
ACTIVITY_TYPE, -- Acty Template [/IAM/ACT_TEMPLATE]
AUTH_GROUP, -- Authoriz. Group [/IAM/AUTH_GROUP]
CODE, -- Templ. Code [/IAM/CAT_CODE]
ACTTYPE, -- Activity Type [/IAM/ACTTYPE]
DURATION, -- Acty Duration [/IAM/ACT_DURATION]
DURATION_UNIT, -- Unit of Durat. [/IAM/ACT_DURATION_UNIT]
RESPONSE_TYPE, -- Resp. Type [/IAM/ACT_RESPONSE_TYPE]
RESPONSE_UNIT, -- Response Unit [/IAM/ACT_RESPONSE_UNIT]
ACT_LONG_TERM, -- Long-Term Acty [/IAM/ACT_LONG_TERM_IND]
ACT_MANDATORY, -- Mandatory [/IAM/ACT_MANDATORY]
AUTO_RULE_EXECUT, -- Auto. Rule Exe. [/IAM/AUTO_RULE_EXECUTION]
ACT_FOLLOW_UP, -- Follow-Up Act. [/IAM/ACT_FOLLOW_UP]
FOLLOW_UP_MODE, -- Proc. Mode [/IAM/FOLLOWUP_MODE]
INACTIVE, -- Inactive [/IAM/INACTIVE]
CMNT_MANDATORY, -- Cmnt Mandatory [/IAM/CMNT_MANDATORY]
PRIMARY KEY (CLIENT, APPLICATION, ACTIVITY_TYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA