KSML

Transparent Table Application Table
33 Fields 8 CDS Views

Class Characteristic

KSML is an SAP database table in S/4HANA. Class Characteristic. It contains 33 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
/merp/core_Class_Char view from CDS View: Classification Definition - Class Characteristics
Fclm_Bam_Doc_Chara view inner Characteristics of Bank Account Document
I_ClfnClassCharcBasic view from BASIC Clfn Class Characteristic Basic
I_MrchdsCatCharacteristic view_entity inner BASIC Assignment of Mrchdscat Charcteristic
I_MrchdsCatHierNodeCharc view_entity inner BASIC Merchandise Cat Hier Node Characteristic
I_Relstartcharinclass view from BASIC Characteristic of Class [Obsolete]
P_CLFNSDMDATUBKSML view from BASIC Classification Helper View for DATUB KSML SDM
VC_INTEGRATION_KSML view from Extraction for KSML

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY clint clint Int class no.
KEY posnr kposnr Item number
KEY adzhl adzhl Int. counter
abtei abteilung Org.area
dinkb dinkennbu Code letter
herku herkunft Charact. origin
imerk atinn Internal char.
omerk atino Object char.
klart klassenart Class Type
relev relevanzkz Relevancy Ind.
datuv datuv Valid From
techv kzeffe Effectivity
aennr aennr Change Number
lkenz lkenz Deletion Ind.
vmerk vmerk New charact.
dplen dpleng Output length
offst offset Offset
bllin blzeil Block line
dptxt anztext Display text
custr text40 Name
justr rechts Right-justified
color farbe Color
intsf intsf Highlighted
inver inver Inverse
ckbox ckbox Checkbox
input eingab Entry
amerk relevkz Relevancy ind.
mkenn dinkenn Std Code Letter
datub datub to
pprel pprel Prop./Prod. Unit Rel
ewm_rel ewm_rel EWM Relevant
prop_rel prop_rel Proposal Rel.

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.

-- Class Characteristic
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSML (
    MANDT,     -- Client [mandt]
    CLINT,     -- Int class no. [clint]
    POSNR,     -- Item number [kposnr]
    ADZHL,     -- Int. counter [adzhl]
    ABTEI,     -- Org.area [abteilung]
    DINKB,     -- Code letter [dinkennbu]
    HERKU,     -- Charact. origin [herkunft]
    IMERK,     -- Internal char. [atinn]
    OMERK,     -- Object char. [atino]
    KLART,     -- Class Type [klassenart]
    RELEV,     -- Relevancy Ind. [relevanzkz]
    DATUV,     -- Valid From [datuv]
    TECHV,     -- Effectivity [kzeffe]
    AENNR,     -- Change Number [aennr]
    LKENZ,     -- Deletion Ind. [lkenz]
    VMERK,     -- New charact. [vmerk]
    DPLEN,     -- Output length [dpleng]
    OFFST,     -- Offset [offset]
    BLLIN,     -- Block line [blzeil]
    DPTXT,     -- Display text [anztext]
    CUSTR,     -- Name [text40]
    JUSTR,     -- Right-justified [rechts]
    COLOR,     -- Color [farbe]
    INTSF,     -- Highlighted [intsf]
    INVER,     -- Inverse [inver]
    CKBOX,     -- Checkbox [ckbox]
    INPUT,     -- Entry [eingab]
    AMERK,     -- Relevancy ind. [relevkz]
    MKENN,     -- Std Code Letter [dinkenn]
    DATUB,     -- to [datub]
    PPREL,     -- Prop./Prod. Unit Rel [pprel]
    EWM_REL,   -- EWM Relevant [ewm_rel]
    PROP_REL,  -- Proposal Rel. [prop_rel]
    PRIMARY KEY (MANDT, CLINT, POSNR, ADZHL)
);

Learn More