CABN
Merkmal
CABN is an SAP database table in S/4HANA. Merkmal. It contains 74 fields. 28 CDS views read from this table.
CDS Views using this table (28)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /DMBE/i_characteristic | view | from | CABN table, characteristic definition | |
| /merp/core_Class_Char | view | inner | CDS View: Classification Definition - Class Characteristics | |
| Fclm_Bam_Doc_Chara | view | inner | Characteristics of Bank Account Document | |
| I_ACMCharacteristic | view | from | BASIC | DPQS charectoristic value |
| I_ACMCharcsData | view | from | BASIC | Characteristics Data |
| I_Characteristic | view | from | BASIC | Characteristic |
| I_ClfnCharcBasic | view | from | BASIC | Classification Characteristic Basic |
| I_ClfnCharcReference | view | union | BASIC | Reference of Clfn Characteristic |
| I_DigitalVehClfnCharcBasic | view_entity | from | BASIC | Classification Characteristic Basic |
| I_GHOCharacteristic | view_entity | from | BASIC | Charcteristic Data |
| I_GHOCharacteristicName | view_entity | from | BASIC | Characteristic Data |
| I_MCHierNodeCVRstrn | view_entity | inner | BASIC | MCHN Characteristic Value Restriction |
| I_MrchdsCatCharacteristic | view_entity | inner | BASIC | Assignment of Mrchdscat Charcteristic |
| I_MrchdsCatCharcValRstrcn | view_entity | inner | BASIC | Charcteristic Value Restriction |
| I_MrchdsCatHierNodeCharc | view_entity | inner | BASIC | Merchandise Cat Hier Node Characteristic |
| I_Relstartchar | view | from | BASIC | Characteristic Basic View |
| P_ACMCharacteristic | view | from | BASIC | Private DPQS charectoristic |
| P_CLFNSDMDATUBCABN | view | from | BASIC | |
| P_CLFNSDMEXTCAWNBASE | view | from | BASIC | |
| P_CLFNSDMMSEHICABN | view | from | BASIC | |
| P_MDChgProcCustValnWthBusPart | view | inner | BASIC | |
| P_MDChgProcProdValnWthMatlNmbr | view | inner | BASIC | |
| P_MDChgProcSuplrValnWthBusPart | view | inner | BASIC | |
| P_SlsDocItmVarConfign | view_entity | inner | BASIC | |
| P_SpecCharacteristicValue | view | inner | BASIC | |
| UPOV_ME_MEDOC_IT_UOM | view | inner | Measurement document item (UOM) | |
| UPOV_WELLTEST_MEASUREDVAL | view | inner | Sample Readings of a Well / WC Test | |
| VC_INTEGRATION_CABN | view | from | Extraction for CABN |
Fields (74)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | atinn | atinn | Internal char. | |||
| KEY | adzhl | adzhl | Int. counter | |||
| atnam | atnam | Characteristic | ||||
| atidn | atidn | Charact ID | ||||
| atfor | atfor | Format | ||||
| anzst | anzst | Number of Chars | ||||
| anzdz | anzdz | Decimal Places | ||||
| atvor | atvor | +/- Sign | ||||
| atsch | atsch | Template | ||||
| atkle | atkle | Case Sensitive | ||||
| atkon | atkon | Conversion | ||||
| atend | atend | Aggreg. char. | ||||
| ataen | ataen | Balance char | ||||
| atkla | atkla | Char. Group | ||||
| aterf | aterf | Entry Required | ||||
| atein | atein | Single-value | ||||
| atame | atame | Multiling char | ||||
| atwme | atwme | Multiling vals | ||||
| msehi | msehi | Internal UoM | ||||
| atdim | atdim | Exponent | ||||
| atglo | atglo | Entry possible | ||||
| atgla | atgla | Restrictable | ||||
| atint | atint | Interval Values | ||||
| atuns | atuns | Entry reqd conf | ||||
| atson | atson | Addnl Values | ||||
| attab | attab | Table Name | ||||
| atfel | atfel | Field Name | ||||
| attei | attei | Unit Field Name | ||||
| atprt | atprt | Check table | ||||
| atprr | atprr | Check program | ||||
| atprf | atprf | Function | ||||
| atwrd | atwrd | Display Values | ||||
| atfod | atfod | Unformatted | ||||
| athie | athie | Expl. hierarchy | ||||
| atdex | atdex | Exponent Disp. | ||||
| atfga | atfga | Formatted | ||||
| atvsc | atvsc | With Template | ||||
| aname | ernam | Created By | ||||
| adatu | erdat | Created On | ||||
| vname | aenam | Changed By | ||||
| vdatu | aedat | Changed On | ||||
| atxac | atxac | Mult.assgmt | ||||
| atyac | atyac | Align right | ||||
| atmst | atmst | Status | ||||
| atwso | atwso | Sort | ||||
| atbso | atbso | Sort values | ||||
| datuv | datuv | Valid From | ||||
| techv | techv | Tech st from | ||||
| aennr | aennr | Change Number | ||||
| lkenz | lkenz | Deletion Ind. | ||||
| atwri | atwri | Keep Order | ||||
| dokar | dokar | Document Type | ||||
| doknr | doknr | Document | ||||
| dokvr | dokvr | Doc. Version | ||||
| doktl | doktl_d | Document Part | ||||
| knobj | knobj | Assgmt no. | ||||
| atinp | atinp | No input | ||||
| atvie | atvie | Hidden | ||||
| werks | werks_d | Plant | ||||
| katalogart | qkatart_cl | Catalog | ||||
| auswahlmge | qauswahlmg_cl | Selected Set | ||||
| athka | athka | Only node | ||||
| athko | athko | NodesSelectable | ||||
| clint | clint | Int class no. | ||||
| attol | attol | Tolerances | ||||
| atzus | atzus | Value assgmt | ||||
| atvpl | atvpl | Planning | ||||
| atauth | atauth | Auth.Group | ||||
| countrygrp | countrygrp | Ctry/Reg. Group | ||||
| datub | datub | to | ||||
| lastchangeddatetime | timestampl | Time Stamp | ||||
| unit | msehi | Internal UoM | ||||
| 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.
-- Merkmal
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CABN (
MANDT, -- Client [mandt]
ATINN, -- Internal char. [atinn]
ADZHL, -- Int. counter [adzhl]
ATNAM, -- Characteristic [atnam]
ATIDN, -- Charact ID [atidn]
ATFOR, -- Format [atfor]
ANZST, -- Number of Chars [anzst]
ANZDZ, -- Decimal Places [anzdz]
ATVOR, -- +/- Sign [atvor]
ATSCH, -- Template [atsch]
ATKLE, -- Case Sensitive [atkle]
ATKON, -- Conversion [atkon]
ATEND, -- Aggreg. char. [atend]
ATAEN, -- Balance char [ataen]
ATKLA, -- Char. Group [atkla]
ATERF, -- Entry Required [aterf]
ATEIN, -- Single-value [atein]
ATAME, -- Multiling char [atame]
ATWME, -- Multiling vals [atwme]
MSEHI, -- Internal UoM [msehi]
ATDIM, -- Exponent [atdim]
ATGLO, -- Entry possible [atglo]
ATGLA, -- Restrictable [atgla]
ATINT, -- Interval Values [atint]
ATUNS, -- Entry reqd conf [atuns]
ATSON, -- Addnl Values [atson]
ATTAB, -- Table Name [attab]
ATFEL, -- Field Name [atfel]
ATTEI, -- Unit Field Name [attei]
ATPRT, -- Check table [atprt]
ATPRR, -- Check program [atprr]
ATPRF, -- Function [atprf]
ATWRD, -- Display Values [atwrd]
ATFOD, -- Unformatted [atfod]
ATHIE, -- Expl. hierarchy [athie]
ATDEX, -- Exponent Disp. [atdex]
ATFGA, -- Formatted [atfga]
ATVSC, -- With Template [atvsc]
ANAME, -- Created By [ernam]
ADATU, -- Created On [erdat]
VNAME, -- Changed By [aenam]
VDATU, -- Changed On [aedat]
ATXAC, -- Mult.assgmt [atxac]
ATYAC, -- Align right [atyac]
ATMST, -- Status [atmst]
ATWSO, -- Sort [atwso]
ATBSO, -- Sort values [atbso]
DATUV, -- Valid From [datuv]
TECHV, -- Tech st from [techv]
AENNR, -- Change Number [aennr]
LKENZ, -- Deletion Ind. [lkenz]
ATWRI, -- Keep Order [atwri]
DOKAR, -- Document Type [dokar]
DOKNR, -- Document [doknr]
DOKVR, -- Doc. Version [dokvr]
DOKTL, -- Document Part [doktl_d]
KNOBJ, -- Assgmt no. [knobj]
ATINP, -- No input [atinp]
ATVIE, -- Hidden [atvie]
WERKS, -- Plant [werks_d]
KATALOGART, -- Catalog [qkatart_cl]
AUSWAHLMGE, -- Selected Set [qauswahlmg_cl]
ATHKA, -- Only node [athka]
ATHKO, -- NodesSelectable [athko]
CLINT, -- Int class no. [clint]
ATTOL, -- Tolerances [attol]
ATZUS, -- Value assgmt [atzus]
ATVPL, -- Planning [atvpl]
ATAUTH, -- Auth.Group [atauth]
COUNTRYGRP, -- Ctry/Reg. Group [countrygrp]
DATUB, -- to [datub]
LASTCHANGEDDATETIME, -- Time Stamp [timestampl]
UNIT, -- Internal UoM [msehi]
CURRENCY, -- Currency [waers_curc]
PRIMARY KEY (MANDT, ATINN, 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