SAP table AUSP (Characteristic Values)

SAP table AUSP has 7 primary key fields being MANDT,OBJEK,ATINN,ATZHL,MAFID,KLART,ADZHL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OBJEK Key of Object to be Classified CHAR 90 0 CUOBN
ATINN Internal characteristic NUMC 10 0 ATINN
ATZHL Characteristic value counter NUMC 3 0 WZAEHL
MAFID Indicator: Object/Class CHAR 1 0 KLMAF
KLART Class Type CHAR 3 0 TCLA KLASSENART
ADZHL Internal Counter for Archiving Objects by ECM NUMC 4 0 ADZHL
ATWRT Characteristic Value CHAR 70 0 ATWRT
ATFLV Internal floating point from FLTP 16 16 ATFLV
ATAWE Unit of Measurement UNIT 3 0 T006 MSEHI
ATFLB Internal floating point value to FLTP 16 16 ATFLB
ATAW1 Unit of Measurement UNIT 3 0 T006 MSEHI
ATCOD Code for value dependency CHAR 1 0 ATCOD
No Values
1 Equal to Value 1
2 Greater Than or Equal to Value 1 and Smaller Than Value 2
3 Greater Than/Equal to Val. 1 and Smaller Than/Equal to Val.2
4 Greater Than Value 1 and Smaller Than Value 2
5 Greater Than Value 1 and Smaller Than or Equalt to Value 2
6 Smaller Than Value 1
7 Smaller Than or Equal to Value 1
8 Greater Than Value 1
9 Greater Than or Equal to Value 1
ATTLV Tolerance from FLTP 16 16 ATTLV
ATTLB Tolerance to FLTP 16 16 ATTLB
ATPRZ Indicator: Tolerance Shown as a Percentage CHAR 1 0 ATPRZ
ATINC Increment Within a Specified Interval FLTP 16 16 ATINC
ATAUT Classification: Author CHAR 1 0 ATAUT
User Input
1 Action
2 Selection Condition
3 Value Assigned by Classification
4 Constraint
5 Value Assigned Internally (DDB)
6 Value Assigned by Configuration
7 Procedure
8 Default Values
X External System
AENNR Change Number CHAR 12 0 AENNR
DATUV Valid-From Date DATS 8 0 DATUV
LKENZ Deletion Indicator CHAR 1 0 LKENZ
ATIMB Characteristic Number of User-Defined Data Type NUMC 10 0 * ATIMB
ATZIS Instance counter NUMC 3 0 ATZIS
ATSRT Sort field for AUSP char. values NUMC 4 0 ATSRT
ATVGLART Comparison Type for Char. Value: " " .. "7": Incl./Excl. CHAR 1 0 ATVGLART
Inclusive: found interval must contain at least 1 value
1 Inclusive: found interval is identical to search criteria
2 Inclusive: found interval is subset of search criteria
3 Inclusive: search criteria are subset of found interval
4 Exclusive: found interval must not contain these values
5 Exclusive: found interval is not identical to search crit.
6 Exclusive: found interval is not a subset of search crit.
7 Exclusive: search crit. are not a subset of found interval
DATUB Valid-to date DATS 8 0 DATUB
DEC_VALUE_FROM Lower Boundary for Numeric Field DEC 31 14 AUSPEXT_DEC_FROM
DEC_VALUE_TO Upper Boundary for Numeric Field DEC 31 14 AUSPEXT_DEC_TO
CURR_VALUE_FROM Lower Boundary for Currency Field CURR 23 2 AUSPEXT_CURR_FROM
CURR_VALUE_TO Upper Boundary for Currency Field CURR 23 2 AUSPEXT_CURR_TO
CURRENCY Currency Key CUKY 5 0 * WAERS_CURC
DATE_FROM Lower Boundary for Date-Interval DATS 8 0 AUSPEXT_DATE_FROM
DATE_TO Upper Boundary for Date-Interval DATS 8 0 AUSPEXT_DATE_TO
TIME_FROM Lower Boundary for Time-Interval TIMS 6 0 AUSPEXT_TIME_FROM
TIME_TO Upper Boundary for Time-Interval TIMS 6 0 AUSPEXT_TIME_TO
PARTNER_GUID Business Partner GUID RAW 16 0 BU_PARTNER_GUID
CHANGED_AT Marketing Object: Date of Last Change DEC 15 0 CRMT_MKT_CHANGED_AT
CHANGED_BY Marketing Object: Last Changed By CHAR 12 0 CRMT_MKT_CHANGED_BY
TYPE_BP_GUID Business Partner Category CHAR 1 0 BU_TYPE
1 Person
2 Organization
3 Group

AUSP foreign key relationships

Table Field Check Table Check Field
0 AUSP ATAW1 T006 Units of Measurement MANDT
1 AUSP ATAWE T006 Units of Measurement MANDT
0 AUSP KLART TCLA Class Types MANDT
1 AUSP MANDT T000 Clients MANDT