SAP Activity Management Tables
Are you looking for the right table related to SAP Activity Management Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Activity Management (CRM-BTX-ACT) module.
Top 10 tables in Activity Management
| Table | Description |
|---|---|
| CRMC_ACT_PRPRI_T | Activity Journal: Product Priority Text Table |
| CRMC_ACT_CAT_ASS | Activity Category Assignment |
| CRMC_ACT_POSQL | Activity Journal:Qualification of the shelf position |
| CRMC_ACT_POSHR_T | Activity Journal:horizontal position in shelf Text Table |
| CRMC_ACTON_ARC | Transaction Type - Activity Archiving Control |
| CRMC_ACT_SDPMT_T | Activity Journal:Second Placement Available Text Table |
| CRMC_CODEMAPMSA | MSA Activity: Assign Codes to Reason, Result,... |
| CRMC_SAMPLES | Activity: Reporting No of Samples in a year |
| CRMC_ACT_ATTACHM | Customising table to check assignment block addition |
| CRMC_ACT_SBJTB | Activity Journal:Free Text Subject B |
List of tables in Activity Management
| Table | Description |
|---|---|
| CRMC_ACT_PRPRI_T | Activity Journal: Product Priority Text Table |
| CRMC_ACT_CAT_ASS | Activity Category Assignment |
| CRMC_ACT_POSQL | Activity Journal:Qualification of the shelf position |
| CRMC_ACT_POSHR_T | Activity Journal:horizontal position in shelf Text Table |
| CRMC_ACTON_ARC | Transaction Type - Activity Archiving Control |
| CRMC_ACT_SDPMT_T | Activity Journal:Second Placement Available Text Table |
| CRMC_CODEMAPMSA | MSA Activity: Assign Codes to Reason, Result,... |
| CRMC_SAMPLES | Activity: Reporting No of Samples in a year |
| CRMC_ACT_ATTACHM | Customising table to check assignment block addition |
| CRMC_ACT_SBJTB | Activity Journal:Free Text Subject B |
| CRMC_ACT_RSLT | Activity Journal: Result |
| CRMC_ACT_PRSTAT | Activity Journal : Product Status |
| CRMC_APPT_OD | Customizing for Appointments in OData services |
| CRMC_ACT_MPLCT | Activity Journal: Main location of placement |
| CRMC_ACT_PRAVA_T | Activity Journal:Product available after visit Text Table |
| CRMC_ACT_SBJTA | Activity Journal:Free Text Subject A |
| CRMC_ACT_DECOM | Decoration Material |
| CRMC_ACT_ACC_ID | customising table to check account id is used or not |
| CRM_ACT_CUSTNO | Mapping Table: Business Partner - Customer - Consig.Procesng |
| CRMC_ACT_PRSTA | Activity Journal : Product Status |
| CRMC_ACT_MSA | Activity Journals: Table for place holder fields for MSA |
| CRMC_ACT_SURVEY | Transaction Type - Activity Survey Template |
| CRMC_ACT_POSQL_T | Activity Journal:Qualification shelf position Text Table |
| CRMC_ACT_MSA_T | Activity: Text table for MSA place holders |
| CRMC_ACT_SDPMT | Activity Journal:Second Placement Available |
| CRMC_ACT_MERGE | Display all Product Proposals in Activity Journal |
| CRMC_ACT_JRNL_T | Activity: Journal Definition Customizing Table - Text |
| CRMC_ACT_POSVR_T | Activity Journal:vertical position in shelf Text Table |
| CRMC_ACT_PRPRI | Activity Journal: Product Priority |
| CRMC_ACT_PRAVA | Activity Journal:Product available after visit at checkout |
| CRMC_ACT_TMPLATE | Assign Template to Activity Type |
| CRMC_ACT_POSVR | Activity Journal:vertical position in shelf |
| CRMC_ACT_OBJ_T | Goal of an Activity: Text |
| CRMC_ACTIVITY_I | Activity Settings at Item Level |
| CRMC_ACT_CURES | Activity Journal : Shelf Optimization |
| CRMC_ACT_JRNL | Activity: Journal Definition Customizing Table |
| CRMC_ACT_PRSTA_T | Activity Journal : Product Status Text Table |
| CRMC_ACT_DECOT_T | Decoration Type : Text Table |
| CRMC_ACT_OBJ | Activity: Goal |
| CRMC_ACT_MPLCT_T | Activity Journal: Main location of placement Text Table |
| CRMC_TASK_OD | Customizing for Tasks in OData services |
| CRMC_ACT_RESRS | Activity Journal: Reason for Result |
| CRMC_ACT_CATEGOR | Activity Category |
| CRMC_ACT_SBJTA_T | Activity Journal:Free Text Subject A Text Table |
| CRMC_ACT_RESRS_T | Activity Journal: Reason for Result Text Table |
| CRMC_ACTIVITY_H | Transaction Type - Activity Control Parameter |
| CRMC_ACT_PRAVB | Activity Journal:Product available before visit at checkout |
| CRMC_ACT_SBJTB_T | Activity Journal:Free Text Subject B Free Text |
| CRMC_ACT_PRAVB_T | Activity Journal:Product available before visit Text Table |
| CRMD_ACTIVITY_I | Activity Reporting : Activity Line Item Extension |
| CRMC_ACT_RSLT_T | Activity Journal: Result Text Table |
| CRMD_ACTIVITY_H | Activity |
| CRMC_ACT_DECOT | Decoration Type |
| CRMC_ACTJRNL_LST | Activity Journal - Calculation Schema Determination |
| CRMC_ACT_COMPLET | Default Values for Activity Completion Level |
| CRMC_ACT_FREQ_T | Template Frequency Texts |
| CRMC_ACT_CURES_T | Decoration Material : Text Table |
| CRMC_ACT_POSHR | Activity Journal:horizontal position in shelf |
| CRMC_ACT_CAT_T | Activity Categories: Text |
| CRMC_ACT_CALE | Activities-Specific Customer for the PC-UI Calendar |
| CRMC_ACT_FREQ | Template Frequency |
| CRMC_ACT_PDFAFS | Customising table for Activity Account Fact Sheet |
| CRMC_ACT_DECOM_T | Decoration Material : Text Table |
| CRMC_ACT_JRNLFLD | Activity Reporting : Fields to be documented for Type/Temp. |