In this post, I will try and describe everything you need to know about the SAP crmd_mktmsa_ch3 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_MKTMSA_CH3 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_MKTMSA_CH3....Right lets get started!
Object Name: CRMD_MKTMSA_CH3
Dictionary Type: Transparent table
Description: Ausp records without KSSK entry
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| OBJEK | OBJNUM | CHAR | 50(0) | Key of object to be classified | OBJEKT | OJK | CL | CRM | ||||
| ATINN | ATINN | NUMC | 10(0) | * | Internal characteristic | ATINN | CT | CRM | ||||
| ATZHL | WZAEHL | NUMC | 3(0) | Characteristic value counter | NUM3 | CL | CRM | |||||
| MAFID | KLMAF | CHAR | 1(0) | Indicator: Object/Class | KLMAF | CL | CRM | |||||
| KLART | KLASSENART | CHAR | 3(0) | TCLA | Class Type | KLASSENART | KAR | CL | CRM | |||
| ADZHL | ADZHL | NUMC | 4(0) | Internal counter for archiving objects via engin. chg. mgmt | NUMC4 | CRM | ||||||
| ATWRT | ATWRT | CHAR | 30(0) | Characteristic Value | ATWRT | CT | CRM | |||||
| ATFLV | ATFLV | FLTP | 16(16) | Internal floating point from | FLTP | CT | CRM | |||||
| ATAWE | MSEHI | UNIT | 3(0) | T006 | Unit of Measurement | MEINS | BZME | CRM | ||||
| ATFLB | ATFLB | FLTP | 16(16) | Internal floating point value to | FLTP | CT | CRM | |||||
| ATAW1 | MSEHI | UNIT | 3(0) | T006 | Unit of Measurement | MEINS | BZME | CRM | ||||
| ATCOD | ATCOD | CHAR | 1(0) | Code for value dependency | ATCOD | CT | CRM | |||||
| ATTLV | ATTLV | FLTP | 16(16) | Tolerance from | FLTP | CRM | ||||||
| ATTLB | ATTLB | FLTP | 16(16) | Tolerance to | FLTP | CRM | ||||||
| ATPRZ | ATPRZ | CHAR | 1(0) | Indicator: Tolerance Shown as a Percentage | ATXFE | CRM | ||||||
| ATINC | ATINC | FLTP | 16(16) | Increment Within a Specified Interval | FLTP | CRM | ||||||
| ATAUT | ATAUT | CHAR | 1(0) | Classification: Author | ATAUT | CRM | ||||||
| AENNR | AENNR | CHAR | 12(0) | * | Change Number | AENNR | AEN | CS | CRM | |||
| DATUV | DATUV | DATS | 8(0) | Valid-From Date | DATUM | CS | CRM | |||||
| LKENZ | LKENZ | CHAR | 1(0) | Deletion Indicator | XFELD | CS | CRM | |||||
| ATIMB | ATIMB | NUMC | 10(0) | * | Characteristic Number of User-Defined Data Type | ATINN | CRM | |||||
| ATZIS | ATZIS | NUMC | 3(0) | Instance counter | NUMC3 | CRM | ||||||
| ATSRT | ATSRT | NUMC | 4(0) | Sort field for AUSP char. values | ATSRT | CRM | ||||||
| ATVGLART | ATVGLART | CHAR | 1(0) | Comparison Type for Char. Value: ' ' .. '7': Incl./Excl. | ATVGLART | CRM | ||||||
| PARTNER_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM |