The CRMC_MKTSC_BWURL table in SAP ERP or S/4HANA stores Access Parameters for BW Reports data. There are total 8 fields in CRMC_MKTSC_BWURL table. The Access Parameters for BW Reports 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 CRMC_MKTSC_BWURL table. It is in CRM Marketing Planner – Scenario Planning Customizing (CRMC_MKTSC) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.
SAP CRMC_MKTSC_BWURL Table Fields
Following is the list of fields that are available in SAP CRMC_MKTSC_BWURL table. The primary key fields of the table are MANDT (Client), EXT_ID (Analysis).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| EXT_ID | Analysis | CRM_MKTPL_BW_URL_ID_2 | CHAR (8) | |
| SERVER | Name of BW Server | CRM_MKTPL_BW_SERVER | CHAR (30) | |
| PORT | Port of a Server | CGPL_BW_PORT | CHAR (6) | |
| TEMPLATE_ID | Name of BW Web Template | CRM_MKTPL_BW_TEMPLATE | CHAR (40) | |
| BWVARIABLE | Name of Variable for Marketing Element in BW Reports | CRM_MKTPL_BW_NODEVAR | CHAR (20) | |
| BWHIERVAR | Name of Variable for Marketing Hierarchy in BW Reports | CRM_MKTPL_BW_HIERVAR | CHAR (20) | |
| USES_ACCRUALS | Logical Variable | CRMT_BOOLEAN | CHAR (1) |
