In this post, I will try and describe everything you need to know about the SAP crmd_ausp_hist 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_AUSP_HIST 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_AUSP_HIST....Right lets get started!
Object Name: CRMD_AUSP_HIST
Dictionary Type: Transparent table
Description: Characteristic Values
| 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 | |||
| CHANGED_AT | CRMT_MKT_CHANGED_AT | DEC | 15(0) | Marketing Object: Date of Last Change | BCOS_TSTMP | CRM | ||||||
| ADZHL | ADZHL | NUMC | 4(0) | Internal counter for archiving objects via engin. chg. mgmt | NUMC4 | CRM | ||||||
| CHANGED_BY | CRMT_MKT_CHANGED_BY | CHAR | 12(0) | Marketing Object: Last Changed By | UNAME | CRM | ||||||
| PARTNER_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| ATWRT | ATWRT | CHAR | 30(0) | Characteristic Value | ATWRT | CT | CRM | |||||
| ATFLV | ATFLV | FLTP | 16(16) | Internal floating point from | FLTP | CT | CRM | |||||
| ATFLB | ATFLB | FLTP | 16(16) | Internal floating point value to | FLTP | CT | CRM | |||||
| ATCOD | ATCOD | CHAR | 1(0) | Code for value dependency | ATCOD | CT | CRM | |||||
| ATWRT_OLD | ATWRT | CHAR | 30(0) | Characteristic Value | ATWRT | CT | CRM | |||||
| ATFLV_OLD | ATFLV | FLTP | 16(16) | Internal floating point from | FLTP | CT | CRM | |||||
| ATFLB_OLD | ATFLB | FLTP | 16(16) | Internal floating point value to | FLTP | CT | CRM | |||||
| ATCOD_OLD | ATCOD | CHAR | 1(0) | Code for value dependency | ATCOD | CT | CRM |