SAP CRMT_ACC_1O_CUST Table – Account Overview: Customizing Activites, Opportunities

The CRMT_ACC_1O_CUST table in SAP ERP or S/4HANA stores Account Overview: Customizing Activites, Opportunities data. There are total 9 fields in CRMT_ACC_1O_CUST table. The Account Overview: Customizing Activites, Opportunities table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMT_ACC_1O_CUST table. It is in Model Implementation: Business Partner (CRM_BSP_MODEL_IL_BP) ABAP package and is part of the People-Centric UI (Business Partner) (CRM-MD-BP-PCU) module.

SAP CRMT_ACC_1O_CUST Table Fields

Following is the list of fields that are available in SAP CRMT_ACC_1O_CUST table. The primary key fields of the table are CLIENT (Client), US_ROLE (PFCG Role ID), APP_BEREICH (Account Overview: Application Areas (Customizing)).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT T000 CLNT (3)
US_ROLE PFCG Role ID CRMT_UI_PFCG_ROLE AGR_DEFINE CHAR (30)
APP_BEREICH Account Overview: Application Areas (Customizing) CRMT_ACC_APP_BEREICH CRMC_ACC_BT CHAR (2)
TIMEENTITY Time Entity (Hour, Week, Month, Year,…) SCTIMENT TSCTFGRT CHAR (2)
LENGTH Number of Time Entities SCTIMENO TSCTFGRT CHAR (3)
DATE_RANGE Time Frame CRMT_DAT_RANGE CHAR (5)
ONLY_OPEN_ACT Business Transactions: Display Open Documents CRMT_BSP_ACT_OPEN CHAR (1)
ONLY_CLOSED_INT Business Transactions: Display Completed Documents CRMT_BSP_IH_PAST CHAR (1)
ONLY_RELEASED Business Transactions: Status Released CRMT_BSP_STAT_RELEASED CHAR (1)