The CRMD_MKTPL_OFR table in SAP ERP or S/4HANA stores Offer Code Related Data for Coupon Assignment data. There are total 8 fields in CRMD_MKTPL_OFR table. The Offer Code Related Data for Coupon Assignment 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 CRMD_MKTPL_OFR table. It is in CRM Marketing Planning – Assignments: Coupon (CRM_MKTPL_ASSIGN_COUPON) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.
SAP CRMD_MKTPL_OFR Table Fields
Following is the list of fields that are available in SAP CRMD_MKTPL_OFR table. The primary key fields of the table are CLIENT (Client), OFRCODE (Coupon Code), CLEARING_HOUSE (Clearing House for Coupon Assignment).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| OFRCODE | Coupon Code | CRM_MKTPL_OFRCODE | CHAR (16) | |
| CLEARING_HOUSE | Clearing House for Coupon Assignment | CRM_MKTPL_CLEARING_HOUSE | RAW (16) | |
| CHECK_DIGIT | Check Digit of Coupon Code for Coupon | CRM_MKTPL_CHECK_DIGIT | CHAR (1) | |
| OFR_BRAND_ID | Coupon Product Category | CRM_MKTPL_OFR_BRAND | CHAR (20) | |
| MKTEL_GUID | GUID of a Marketing Element for a Coupon | CRM_MKTPL_MKTEL_GUID | RAW (16) | |
| CLEAR_HOUSE_NAME | Clearing House | CRM_MKTPL_CLEARING_HOUSE_NR | CHAR (10) | |
| HIERARCHY_ID | Category Hierarchy ID | CRM_MKTPL_PRODH | CHAR (10) |
