MDC_D_CNFMTCIMF
IM in HANA firm settings for the Match - #GENERATED#
MDC_D_CNFMTCIMF is an SAP database table in S/4HANA. IM in HANA firm settings for the Match - #GENERATED#. It contains 11 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MDChgProcConfignMtchgFirm | view | from | BASIC | Master Data Change Process Configuration Matching Firm |
| I_MDChgProcConfignMtchgFirmTP | view | from | TRANSACTIONAL | Master Data Change Process Configuration Matching Firm |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | db_key | /BOBF/CONF_KEY | NodeID | |||
| parent_key | /BOBF/CONF_KEY | NodeID | ||||
| threshold | SIMDQ_HANA_MATCH_THRESH_DTEL | Match Threshold | ||||
| firminitials | SIMDQ_HANA_MTCFIRMINITIAL_DTEL | Match Firm Initials | ||||
| shortenfirmnames | SIMDQ_HANA_MTCSHRTFIRMNAM_DTEL | Match Shortened Firm | ||||
| abbreviatedwords | SIMDQ_HANA_MTCABBREVWORDS_DTEL | Match Abbrev Words | ||||
| numbers | SIMDQ_HANA_MTCFIRMNUMBERS_DTEL | Match Numbers | ||||
| typematching | SIMDQ_HANA_MTCTYPEMATCH_DTEL | Tye Matching Enabled | ||||
| domain_cleanse | SIMDQ_HANA_CLEANSE_DOMAIN_DTEL | Domain | ||||
| conf_id | MDC_PROCESS_CONFIG_UUID | Config. UUID |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- IM in HANA firm settings for the Match - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDC_D_CNFMTCIMF (
MANDT, -- Client [MANDT]
DB_KEY, -- NodeID [/BOBF/CONF_KEY]
PARENT_KEY, -- NodeID [/BOBF/CONF_KEY]
THRESHOLD, -- Match Threshold [SIMDQ_HANA_MATCH_THRESH_DTEL]
FIRMINITIALS, -- Match Firm Initials [SIMDQ_HANA_MTCFIRMINITIAL_DTEL]
SHORTENFIRMNAMES, -- Match Shortened Firm [SIMDQ_HANA_MTCSHRTFIRMNAM_DTEL]
ABBREVIATEDWORDS, -- Match Abbrev Words [SIMDQ_HANA_MTCABBREVWORDS_DTEL]
NUMBERS, -- Match Numbers [SIMDQ_HANA_MTCFIRMNUMBERS_DTEL]
TYPEMATCHING, -- Tye Matching Enabled [SIMDQ_HANA_MTCTYPEMATCH_DTEL]
DOMAIN_CLEANSE, -- Domain [SIMDQ_HANA_CLEANSE_DOMAIN_DTEL]
CONF_ID, -- Config. UUID [MDC_PROCESS_CONFIG_UUID]
PRIMARY KEY (MANDT, DB_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA