SAP Table TCACS_ACT
Activity Types
TCACS_ACT (Activity Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TCACS_ACT to other SAP tables.
TCACS_ACT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| APPL | Commission Application (ICM) | CACSAPPL | TCACS_APPLDEF | CHAR | 6 | 0 | ||||||||||||||||||
| ACTIVITY | Activity Type | CACSACT | CHAR | 4 | 0 | |||||||||||||||||||
| VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC | 6 | 0 | |||||||||||||||||||
| ACTGRP | Role | CACSACTGRP | TCACS_ACTGRP | CHAR | 4 | 0 | ||||||||||||||||||
| ACT_PRIORITY | Priority of an Offsetting Type/Activity Type | CACSOFFSETPRIOR | NUMC | 2 | 0 | |||||||||||||||||||
| BUSI_BEGIN | Effective from | CACS_BUSITIME_B | NUMC | 14 | 0 | |||||||||||||||||||
| BUSI_END | Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) | CACS_BUSITIME_E | NUMC | 14 | 0 | |||||||||||||||||||
| TECH_BEGIN | Technically Valid From | CACS_TECHTIME_B | NUMC | 14 | 0 | |||||||||||||||||||
| TECH_END | Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) | CACS_TECHTIME_E | NUMC | 14 | 0 | |||||||||||||||||||
| FLG_CANCEL_OBJ | Indicator: Object is Invalid | CACSCANCOBJ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| FLG_CANCEL_VERS | Indicator: Version is Invalid | CACSCANCVERS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| CHG_TCODE | Transaction in Which the Change Was Made | CACSCDTC | CHAR | 20 | 0 | |||||||||||||||||||
| CHG_USR | Last user to change object | CACSCHUSR | CHAR | 12 | 0 | |||||||||||||||||||
| TRI_METH_TYP | Triggering Method | CACSTRIMETHTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| TRI_METH_TARGET | Processing Target of Triggering Method | CACSTRIMETHTAR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| STATUS_VERSION | Object Version Status | CACSSTATUSVERS | TCACS_VALSTAT1 | CHAR | 1 | 0 | ||||||||||||||||||
| STATUS_WORK | Object Version Processing Status | CACSSTATUSWORK | TCACS_VALSTAT1 | CHAR | 1 | 0 | ||||||||||||||||||
TCACS_ACT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TCACS_ACT | ACTGRP | TCACS_ACT | APPL | TCACS_ACTGRP | Roles | APPL |
| TCACS_ACT | ACTGRP | TCACS_ACT | ACTGRP | TCACS_ACTGRP | Roles | ACTGRP |
| TCACS_ACT | ACTGRP | * | TCACS_ACTGRP | Roles | VERSION | |
| TCACS_ACT | ACTGRP | TCACS_ACT | MANDT | TCACS_ACTGRP | Roles | MANDT |
| TCACS_ACT | APPL | TCACS_ACT | APPL | TCACS_APPLDEF | All Commission Applications | APPL |
| TCACS_ACT | MANDT | TCACS_ACT | MANDT | T000 | Clients | MANDT |
| TCACS_ACT | STATUS_VERSION | TCACS_ACT | STATUS_VERSION | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_VERSION |
| TCACS_ACT | STATUS_VERSION | TCACS_ACT | STATUS_WORK | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_WORK |
| TCACS_ACT | STATUS_VERSION | '0' | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUSCLASS | |
| TCACS_ACT | STATUS_WORK | '0' | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUSCLASS | |
| TCACS_ACT | STATUS_WORK | TCACS_ACT | STATUS_VERSION | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_VERSION |
| TCACS_ACT | STATUS_WORK | TCACS_ACT | STATUS_WORK | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_WORK |
