The CRMC_MKTPL_STFT table in SAP ERP or S/4HANA stores Defines expense type based on trade spend types data. There are total 6 fields in CRMC_MKTPL_STFT table. The Defines expense type based on trade spend types 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_MKTPL_STFT table. It is in Customizing for TPM Fund Integration (CRM_MKTPL_TPM_FM_CUST) ABAP package and is part of the Claims and Funds Integration for TPM (CRM-MKT-MPL-TPM-CFI) module.
SAP CRMC_MKTPL_STFT Table Fields
Following is the list of fields that are available in SAP CRMC_MKTPL_STFT table. The primary key fields of the table are CLIENT (Client), APPLICATION (Application in Project Planning), SPEND_TYPE (Spend Type), SPEND_CATEGORY (Spend Category), SPEND_METHOD (Spend Method for Key Figure Planning).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| APPLICATION | Application in Project Planning | CGPL_APPLICATION_TYPE | CGPL_APPLICATION | CHAR (3) |
| SPEND_TYPE | Spend Type | CRM_MKTPL_COST_TYPE | CRMC_MKTPL_COST | CHAR (4) |
| SPEND_CATEGORY | Spend Category | CRM_MKTPL_COST_CAT | CRMC_MKTPL_COS0 | CHAR (30) |
| SPEND_METHOD | Spend Method for Key Figure Planning | CRM_MKTPL_SPEND_METHOD | CRMC_MKTPL_COS1 | CHAR (10) |
| VOLUME_DEPENDENT | Volume Dependency for Trade Spends – Expense Type Mapping | CRM_VOLUME_DEPENDENT | CHAR (1) |
