CAWN

Transparent Table Application Table
40 Fields 6 CDS Views

Characteristic values

CAWN is an SAP database table in S/4HANA. Characteristic values. It contains 40 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/merp/core_Class_Char_Val view from CDS View: Classification Definition - Characteristic Values
I_CharacteristicValue view from BASIC Characteristic Value
I_ChgRecdRefCharcValDpndcy view from BASIC Characteristic Value Dependencies
I_ClfnCharcValue view from BASIC Value of Classification Characteristic
P_CLFNSDMDATUBCAWN view from BASIC
VC_INTEGRATION_CAWN view from Extraction for CAWN

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY atinn ATINN Internal char.
KEY atzhl ATZHL Int counter
KEY adzhl ADZHL Int. counter
atwrt ATWRT Char. Value
atflv ATFLV Value from
atflb ATFLB Value to
atcod ATCOD Code
atstd ATSTD Default
atawe MSEHI Internal UoM
ataw1 MSEHI Internal UoM
atidn ATIDN Charact ID
spras SPRAS Language
txtnr ATLTN Text number
datuv DATUV Valid From
techv TECHV Tech st from
aennr AENNR Change Number
lkenz LKENZ Deletion Ind.
dokar DOKAR Document Type
doknr DOKNR Document
dokvr DOKVR Doc. Version
doktl DOKTL_D Document Part
atzhh ATZHH Int counter
knobj KNOBJ Assgmt no.
atwhi ATWHI Sub. values
attlv ATTLV Tolerance from
attlb ATTLB Tolerance to
atprz ATPRZ Percentage
atinc ATINC Increment
atvpl ATVPL Planning
datub DATUB to
dec_from CAWN_DEC_FROM LowrBndry Nmrc
dec_to CAWN_DEC_TO UprBndry Nmrc
date_from CAWN_DATE_FROM LowrBndry Date
date_to CAWN_DATE_TO UprBndry Date
time_from CAWN_TIME_FROM LowrBndry Time
time_to CAWN_TIME_TO UprBndry Time
curr_from CAWN_CURR_FROM LowrBndry Crcy
curr_to CAWN_CURR_TO UprBndry Crcy
currency WAERS_CURC Currency

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Characteristic values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CAWN (
    MANDT,      -- Client [MANDT]
    ATINN,      -- Internal char. [ATINN]
    ATZHL,      -- Int counter [ATZHL]
    ADZHL,      -- Int. counter [ADZHL]
    ATWRT,      -- Char. Value [ATWRT]
    ATFLV,      -- Value from [ATFLV]
    ATFLB,      -- Value to [ATFLB]
    ATCOD,      -- Code [ATCOD]
    ATSTD,      -- Default [ATSTD]
    ATAWE,      -- Internal UoM [MSEHI]
    ATAW1,      -- Internal UoM [MSEHI]
    ATIDN,      -- Charact ID [ATIDN]
    SPRAS,      -- Language [SPRAS]
    TXTNR,      -- Text number [ATLTN]
    DATUV,      -- Valid From [DATUV]
    TECHV,      -- Tech st from [TECHV]
    AENNR,      -- Change Number [AENNR]
    LKENZ,      -- Deletion Ind. [LKENZ]
    DOKAR,      -- Document Type [DOKAR]
    DOKNR,      -- Document [DOKNR]
    DOKVR,      -- Doc. Version [DOKVR]
    DOKTL,      -- Document Part [DOKTL_D]
    ATZHH,      -- Int counter [ATZHH]
    KNOBJ,      -- Assgmt no. [KNOBJ]
    ATWHI,      -- Sub. values [ATWHI]
    ATTLV,      -- Tolerance from [ATTLV]
    ATTLB,      -- Tolerance to [ATTLB]
    ATPRZ,      -- Percentage [ATPRZ]
    ATINC,      -- Increment [ATINC]
    ATVPL,      -- Planning [ATVPL]
    DATUB,      -- to [DATUB]
    DEC_FROM,   -- LowrBndry Nmrc [CAWN_DEC_FROM]
    DEC_TO,     -- UprBndry Nmrc [CAWN_DEC_TO]
    DATE_FROM,  -- LowrBndry Date [CAWN_DATE_FROM]
    DATE_TO,    -- UprBndry Date [CAWN_DATE_TO]
    TIME_FROM,  -- LowrBndry Time [CAWN_TIME_FROM]
    TIME_TO,    -- UprBndry Time [CAWN_TIME_TO]
    CURR_FROM,  -- LowrBndry Crcy [CAWN_CURR_FROM]
    CURR_TO,    -- UprBndry Crcy [CAWN_CURR_TO]
    CURRENCY,   -- Currency [WAERS_CURC]
    PRIMARY KEY (MANDT, ATINN, ATZHL, ADZHL)
);

Learn More