In this post, I will try and describe everything you need to know about the SAP crmd_mktbp_ausp 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_MKTBP_AUSP 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_MKTBP_AUSP....Right lets get started!
Object Name: CRMD_MKTBP_AUSP
Dictionary Type: Transparent table
Description: Values Attached to Attributes (for Target Group Selection)
| 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 | BU_PARTNER | CHAR | 10(0) | * | Business Partner Number | BU_PARTNER | BPA | BUPA | PARTNER | CRM | ||
| ATINN | ATINN | NUMC | 10(0) | * | Internal characteristic | ATINN | CT | 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 |