SAP AUSP Characteristic Values Table
Overview
AUSP is a standard SAP S/4HANA table that stores Characteristic Values data. There are total 31 fields in the AUSP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUSP belongs to Classes (CA-CL-CLS) module and is located in the package R/3 Application development: PP Classification System (CL).
In addition, following links provide an overview of foreign key relationships, if any, that link AUSP to other SAP tables and standard CDS views available based on AUSP table in S/4HANA 2020.
Techincal Settings of AUSP
Below are technical details of the table AUSP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUSP Fields
The following table gives you an overview of the fields available in AUSP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| OBJEK | Key of Object to be Classified | CUOBN | CHAR | 90 | |
| ATINN | Internal characteristic | ATINN | NUMC | 10 | |
| ATZHL | Characteristic value counter | WZAEHL | NUMC | 3 | |
| MAFID | Indicator: Object/Class | KLMAF | CHAR | 1 | |
| KLART | Class Type | KLASSENART | TCLA | CHAR | 3 |
| ADZHL | Internal Counter for Archiving Objects by ECM | ADZHL | NUMC | 4 | |
| ATWRT | Characteristic Value | ATWRT | CHAR | 70 | |
| ATFLV | Internal floating point from | ATFLV | FLTP | 16 | |
| ATAWE | Unit of Measurement | MSEHI | T006 | UNIT | 3 |
| ATFLB | Internal floating point value to | ATFLB | FLTP | 16 | |
| ATAW1 | Unit of Measurement | MSEHI | T006 | UNIT | 3 |
| ATCOD | Code for value dependency | ATCOD | CHAR | 1 | |
| ATTLV | Tolerance from | ATTLV | FLTP | 16 | |
| ATTLB | Tolerance to | ATTLB | FLTP | 16 | |
| ATPRZ | Indicator: Tolerance Shown as a Percentage | ATPRZ | CHAR | 1 | |
| ATINC | Increment Within a Specified Interval | ATINC | FLTP | 16 | |
| ATAUT | Classification: Author | ATAUT | CHAR | 1 | |
| AENNR | Change Number | AENNR | CHAR | 12 | |
| DATUV | Valid-From Date | DATUV | DATS | 8 | |
| LKENZ | Deletion Indicator | LKENZ | CHAR | 1 | |
| ATIMB | Characteristic Number of User-Defined Data Type | ATIMB | * | NUMC | 10 |
| ATZIS | Instance counter | ATZIS | NUMC | 3 | |
| ATSRT | Sort field for AUSP char. values | ATSRT | NUMC | 4 | |
| ATVGLART | Comparison Type for Char. Value: " " .. "7": Incl./Excl. | ATVGLART | CHAR | 1 | |
| DATUB | Valid-to date | DATUB | DATS | 8 | |
| CURRENCY | Currency Key | WAERS_CURC | * | CUKY | 5 |
| PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | |
| CHANGED_AT | Marketing Object: Date of Last Change | CRMT_MKT_CHANGED_AT | DEC | 15 | |
| CHANGED_BY | Marketing Object: Last Changed By | CRMT_MKT_CHANGED_BY | CHAR | 12 | |
| TYPE_BP_GUID | Business Partner Category | BU_TYPE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AUSP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUSP | ATAW1 | C: CN | T006 |
| AUSP | ATAWE | C: CN | T006 |
| AUSP | KLART | 1: C | TCLA |
| AUSP | MANDT | 1: CN | T000 |