In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_ofr table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_MKTPL_OFR what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_MKTPL_OFR....Right lets get started!
Object Name: CRMD_MKTPL_OFR
Dictionary Type: Transparent table
Description: Offer Code Related Data for Coupon Assignment
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| OFRCODE | CRM_MKTPL_OFRCODE | CHAR | 16(0) | Coupon Code | CRM_MKTPL_OFRCODE | CRM | ||||||
| CLEARING_HOUSE | CRM_MKTPL_CLEARING_HOUSE | RAW | 16(0) | Clearing House for Coupon Assignment | SYSUUID | CRM | ||||||
| CHECK_DIGIT | CRM_MKTPL_CHECK_DIGIT | CHAR | 1(0) | Check Digit of Coupon Code for Coupon | CRM_MKTPL_CHECK_DIGIT | CRM | ||||||
| OFR_BRAND_ID | CRM_MKTPL_OFR_BRAND | CHAR | 20(0) | Coupon Product Category | COM_CATEGORY_ID | CRM | ||||||
| MKTEL_GUID | CRM_MKTPL_MKTEL_GUID | RAW | 16(0) | GUID of a Marketing Element for a Coupon | SYSUUID | CRM | ||||||
| CLEAR_HOUSE_NAME | CRM_MKTPL_CLEARING_HOUSE_NR | CHAR | 10(0) | * | Clearing House | BU_PARTNER | CRM | |||||
| HIERARCHY_ID | CRM_MKTPL_PRODH | CHAR | 10(0) | Category Hierarchy ID | COM_HIERARCHY_ID | COM_HIER | HIERARCHY_ID | CRM |