Fields (38)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CharcInternalID | CharcInternalID | 10 |
| AdditionalValueIsAllowed | AdditionalValueIsAllowed | 1 | |
| ChangeNumber | ChangeNumber | 3 | |
| Characteristic | Characteristic | 5 | |
| CharcDataType | CharcDataType | 4 | |
| CharcDecimals | CharcDecimals | 5 | |
| CharcEntryIsNotFormatCtrld | CharcEntryIsNotFormatCtrld | 1 | |
| CharcExponentFormat | CharcExponentFormat | 3 | |
| CharcExponentValue | CharcExponentValue | 3 | |
| CharcGroup | CharcGroup | 2 | |
| CharcGroupName | CharcGroupName | 1 | |
| CharcIsHidden | CharcIsHidden | 1 | |
| CharcIsReadOnly | CharcIsReadOnly | 1 | |
| CharcIsRestrictable | CharcIsRestrictable | 1 | |
| CharcLastChangedDateTime | CharcLastChangedDateTime | 2 | |
| CharcLength | CharcLength | 5 | |
| CharcMaintAuthGrp | CharcMaintAuthGrp | 2 | |
| CharcStatus | CharcStatus | 5 | |
| CharcStatusName | CharcStatusName | 1 | |
| CharcTemplate | CharcTemplate | 3 | |
| CharcTemplateIsDisplayed | CharcTemplateIsDisplayed | 1 | |
| CharcValueUnit | CharcValueUnit | 5 | |
| CreationDate | CreationDate | 2 | |
| Currency | Currency | 3 | |
| CurrencyISOCode | CurrencyISOCode | 1 | |
| DocumentInfoRecordDocNumber | DocNumber,DocumentInfoRecordDocNumber | 2 | |
| DocumentInfoRecordDocPart | DocumentInfoRecordDocPart,DocumentPart | 2 | |
| DocumentInfoRecordDocType | DocumentInfoRecordDocType,DocumentType | 2 | |
| DocumentInfoRecordDocVersion | DocumentInfoRecordDocVersion,DocumentVersion | 2 | |
| EntryIsRequired | EntryIsRequired | 1 | |
| LastChangeDate | LastChangeDate | 2 | |
| MultipleValuesAreAllowed | MultipleValuesAreAllowed | 1 | |
| NegativeValueIsAllowed | NegativeValueIsAllowed | 3 | |
| UnitOfMeasureISOCode | UnitOfMeasureISOCode | 1 | |
| ValidityEndDate | ValidityEndDate | 2 | |
| ValidityStartDate | ValidityStartDate | 5 | |
| ValueIntervalIsAllowed | ValueIntervalIsAllowed | 1 | |
| ValueIsCaseSensitive | ValueIsCaseSensitive | 3 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CHARACTERISTIC (
CHARCINTERNALID,
ADDITIONALVALUEISALLOWED,
CHANGENUMBER,
CHARACTERISTIC,
CHARCDATATYPE,
CHARCDECIMALS,
CHARCENTRYISNOTFORMATCTRLD,
CHARCEXPONENTFORMAT,
CHARCEXPONENTVALUE,
CHARCGROUP,
CHARCGROUPNAME,
CHARCISHIDDEN,
CHARCISREADONLY,
CHARCISRESTRICTABLE,
CHARCLASTCHANGEDDATETIME,
CHARCLENGTH,
CHARCMAINTAUTHGRP,
CHARCSTATUS,
CHARCSTATUSNAME,
CHARCTEMPLATE,
CHARCTEMPLATEISDISPLAYED,
CHARCVALUEUNIT,
CREATIONDATE,
CURRENCY,
CURRENCYISOCODE,
DOCUMENTINFORECORDDOCNUMBER,
DOCUMENTINFORECORDDOCPART,
DOCUMENTINFORECORDDOCTYPE,
DOCUMENTINFORECORDDOCVERSION,
ENTRYISREQUIRED,
LASTCHANGEDATE,
MULTIPLEVALUESAREALLOWED,
NEGATIVEVALUEISALLOWED,
UNITOFMEASUREISOCODE,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
VALUEINTERVALISALLOWED,
VALUEISCASESENSITIVE,
PRIMARY KEY (CHARCINTERNALID)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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