SAP table CAWN (Characteristic values)

SAP table CAWN has 4 primary key fields being MANDT,ATINN,ATZHL,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
ATINN Internal characteristic NUMC 10 0 ATINN
ATZHL Int counter NUMC 4 0 ATZHL
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
ATFLB Internal floating point value to FLTP 16 16 ATFLB
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
ATSTD Default value CHAR 1 0 ATSTD
ATAWE Unit of Measurement UNIT 3 0 T006 MSEHI
ATAW1 Unit of Measurement UNIT 3 0 T006 MSEHI
ATIDN Object identification CHAR 2 0 ATIDN
SPRAS Language Key LANG 1 0 T002 SPRAS
TXTNR Number of Related Text NUMC 4 0 ATLTN
DATUV Valid-From Date DATS 8 0 DATUV
TECHV Technical status from CHAR 12 0 TECHV
AENNR Change Number CHAR 12 0 AENR AENNR
LKENZ Deletion Indicator CHAR 1 0 LKENZ
DOKAR Document Type CHAR 3 0 DOKAR
DOKNR Document number CHAR 25 0 DOKNR
DOKVR Document Version CHAR 2 0 DOKVR
DOKTL Document Part CHAR 3 0 DOKTL_D
ATZHH Int. counter for value hierarchy NUMC 4 0 ATZHH
KNOBJ Number of Object with Assigned Dependencies NUMC 18 0 KNOBJ
ATWHI Indicator that Subordinate Values Exist CHAR 1 0 ATWHI
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
ATVPL Relevant to Planning CHAR 1 0 ATVPL
DATUB Valid-to date DATS 8 0 DATUB
DEC_FROM Lower Boundary for Numeric Field D34N 34 0 CAWN_DEC_FROM
DEC_TO Upper Boundary for Numeric Field D34N 34 0 CAWN_DEC_TO
DATE_FROM Lower Boundary for Date-Interval DATS 8 0 CAWN_DATE_FROM
DATE_TO Upper Boundary for Date-Interval DATS 8 0 CAWN_DATE_TO
TIME_FROM Lower Boundary for Time-Interval TIMS 6 0 CAWN_TIME_FROM
TIME_TO Upper Boundary for Time-Interval TIMS 6 0 CAWN_TIME_TO
CURR_FROM Lower Boundary for Currency Field CURR 23 2 CAWN_CURR_FROM
CURR_TO Upper Boundary for Currency Field CURR 23 2 CAWN_CURR_TO
CURRENCY Currency Key CUKY 5 0 WAERS_CURC

CAWN foreign key relationships

Table Field Check Table Check Field
0 CAWN AENNR AENR Change Master AENNR
1 CAWN ATAW1 T006 Units of Measurement MANDT
0 CAWN ATAWE T006 Units of Measurement MANDT
1 CAWN MANDT T000 Clients MANDT
0 CAWN SPRAS T002 Language Keys (Component BC-I18) SPRAS