I_CLFNCHARCBASIC
Classification Characteristic Basic
I_CLFNCHARCBASIC is a CDS View in S/4HANA. Classification Characteristic Basic. It contains 47 fields. 16 CDS views read from this table.
CDS Views using this table (16)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ChangeRecordCharcVH | view | from | CONSUMPTION | Characteristic |
| C_ChangeRecordClassCharc | view | from | CONSUMPTION | Change Record Class Characteristics |
| CRMS4_IU_C_PRDC | view_entity | inner | Product Characteristic | |
| CRMS4_IU_C_PRDCV | view_entity | inner | Product Characteristic Value | |
| I_ClfnCharacteristic | view | from | COMPOSITE | Classification Characteristic |
| I_ClfnCharacteristicDEX | view_entity | from | BASIC | Classification Characteristic DEX |
| I_ClfnCharcValueDescDEX | view_entity | inner | BASIC | Clfn Charc Value Description DEX |
| I_ClfnClassHierCharcForKeyDate | view | inner | COMPOSITE | Clfn Cl Hier Characteristic For Key Date |
| I_ConfignOvwPgCharacteristic | view | from | BASIC | Overview - Characteristics |
| I_DCBQualityNameForMaterial | view | inner | COMPOSITE | Quality name parameters per material |
| I_MasterWarrantyCounterVH | view | inner | BASIC | F4 help for Master Warranty Counter |
| I_SettlementUnitAmountsData | view | left_outer | COMPOSITE | Interface layer for Unit Amounts Data |
| I_UtilsProdAttributes | view | left_outer | COMPOSITE | IS-U Product Attributes |
| I_VMSVehicleCharacteristic | view | inner | BASIC | View for vehicle Characteristics |
| P_ClfnCharcOverwrite | view | from | COMPOSITE | |
| R_VarConfignCharcGroupAlloc | view_entity | left_outer | COMPOSITE | OBSOLETE: Confign Charc Grp Cstic Alloc |
Fields (47)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Characteristic | Characteristic | 8 |
| KEY | CharcInternalID | CharcInternalID | 7 |
| KEY | TimeIntervalNumber | TimeIntervalNumber | 4 |
| KEY | ValidityEndDate | ValidityEndDate | 4 |
| AdditionalValueAllowedCode | AdditionalValueIsAllowed | 2 | |
| ChangeNumber | ChangeNumber | 3 | |
| CharcCatalogType | CharcCatalogType | 3 | |
| CharcCheckFunctionModule | CharcCheckFunctionModule | 3 | |
| CharcCheckTable | CharcCheckTable | 5 | |
| CharcConversionRoutine | CharcConversionRoutine | 5 | |
| CharcDataType | CharcDataType | 6 | |
| CharcDecimals | CharcDecimals | 6 | |
| CharcEntryNotFormatCtrldCode | CharcEntryNotFormatCtrldCode | 1 | |
| CharcExponentFormat | CharcExponentFormat | 4 | |
| CharcExponentValue | CharcExponentValue | 4 | |
| CharcGroup | CharcGroup | 3 | |
| CharcHiddenCode | CharcIsHidden | 2 | |
| CharcIdentificationCode | CharcIdentificationCode | 2 | |
| CharcLastChangedDateTime | CharcLastChangedDateTime | 3 | |
| CharcLength | CharcLength | 7 | |
| CharcMaintAuthGrp | CharcMaintAuthGrp | 4 | |
| CharcReadOnlyCode | CharcIsReadOnly | 2 | |
| CharcReferenceTable | CharcReferenceTable | 5 | |
| CharcReferenceTableField | CharcReferenceTableField | 5 | |
| CharcRestrictableCode | CharcIsRestrictable | 2 | |
| CharcSelectedSet | CharcSelectedSet | 3 | |
| CharcStatus | CharcStatus | 4 | |
| CharcTemplate | CharcTemplate | 4 | |
| CharcTemplateDisplayedCode | CharcTemplateDisplayedCode | 1 | |
| CharcValueUnit | CharcValueUnit | 6 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationDate | CreationDate | 3 | |
| Currency | Currency | 4 | |
| DocumentInfoRecordDocNumber | DocumentInfoRecordDocNumber | 3 | |
| DocumentInfoRecordDocPart | DocumentInfoRecordDocPart | 3 | |
| DocumentInfoRecordDocType | DocumentInfoRecordDocType | 3 | |
| DocumentInfoRecordDocVersion | DocumentInfoRecordDocVersion | 3 | |
| EntryRequiredCode | EntryIsRequired | 2 | |
| IsDeleted | IsDeleted | 3 | |
| LastChangeDate | LastChangeDate | 3 | |
| LastChangedByUser | LastChangedByUser | 3 | |
| MultipleValuesAllowedCode | MultipleValuesAreAllowed | 2 | |
| NegativeValueIsAllowed | NegativeValueIsAllowed | 4 | |
| Plant | Plant | 3 | |
| ValidityStartDate | ValidityStartDate | 4 | |
| ValueIntervalAllowedCode | ValueIntervalIsAllowed | 2 | |
| ValueIsCaseSensitive | ValueIsCaseSensitive | 4 |
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.
-- Classification Characteristic Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CLFNCHARCBASIC (
CHARACTERISTIC,
CHARCINTERNALID,
TIMEINTERVALNUMBER,
VALIDITYENDDATE,
ADDITIONALVALUEALLOWEDCODE,
CHANGENUMBER,
CHARCCATALOGTYPE,
CHARCCHECKFUNCTIONMODULE,
CHARCCHECKTABLE,
CHARCCONVERSIONROUTINE,
CHARCDATATYPE,
CHARCDECIMALS,
CHARCENTRYNOTFORMATCTRLDCODE,
CHARCEXPONENTFORMAT,
CHARCEXPONENTVALUE,
CHARCGROUP,
CHARCHIDDENCODE,
CHARCIDENTIFICATIONCODE,
CHARCLASTCHANGEDDATETIME,
CHARCLENGTH,
CHARCMAINTAUTHGRP,
CHARCREADONLYCODE,
CHARCREFERENCETABLE,
CHARCREFERENCETABLEFIELD,
CHARCRESTRICTABLECODE,
CHARCSELECTEDSET,
CHARCSTATUS,
CHARCTEMPLATE,
CHARCTEMPLATEDISPLAYEDCODE,
CHARCVALUEUNIT,
CREATEDBYUSER,
CREATIONDATE,
CURRENCY,
DOCUMENTINFORECORDDOCNUMBER,
DOCUMENTINFORECORDDOCPART,
DOCUMENTINFORECORDDOCTYPE,
DOCUMENTINFORECORDDOCVERSION,
ENTRYREQUIREDCODE,
ISDELETED,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
MULTIPLEVALUESALLOWEDCODE,
NEGATIVEVALUEISALLOWED,
PLANT,
VALIDITYSTARTDATE,
VALUEINTERVALALLOWEDCODE,
VALUEISCASESENSITIVE,
PRIMARY KEY (CHARACTERISTIC, CHARCINTERNALID, TIMEINTERVALNUMBER, VALIDITYENDDATE)
);
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