KSML
Merkmale zu Klassen
KSML is an SAP database table in S/4HANA. Merkmale zu Klassen. It contains 33 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /DMBE/i_class_characteristics | view | from | Class characteristics | |
| /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 |
| P_CLFNSDMDATUBKSML | view | from | BASIC | |
| VC_INTEGRATION_KSML | view | from | Extraction for KSML |
Fields (33)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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.
-- Merkmale zu Klassen
-- 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA