I_CLFNCHARACTERISTIC

CDS View
44 Fields 9 CDS Views

Classification Characteristic

I_CLFNCHARACTERISTIC is a CDS View in S/4HANA. Classification Characteristic. It contains 44 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_ConfignCharacteristic view inner CONSUMPTION OBSOLETE: Configuration Characteristic
C_VarCnfCharcVH view inner CONSUMPTION Variant Confign Characteristic
I_ClfnCharacteristicForKeyDate view from COMPOSITE Clfn Characteristic for Key Date
I_ProdSpecPrptyCharacterValue view inner COMPOSITE Product Specification Property Character Type Value (TP)
I_ProdSpecPrptyNumericValue view inner COMPOSITE Product Specification Property Numeric Type Value
I_SpecCharByValueAssgmtInst view inner COMPOSITE Specification Characteristic by VAI
I_SpecCstmPropertyCharcAssgmt view inner COMPOSITE Spec. (Custom) Property Charc. Assgmt.
P_CharcCtlgClfnCharcTimeIntRel view_entity from COMPOSITE Classification: Characterstics relevant for date
P_CharcCtlgClfnCharcTimeIntRel view_entity union_all COMPOSITE Classification: Characterstics relevant for date

Fields (44)

KeyField CDS FieldsUsed in Views
KEY CharcInternalID CharcInternalID 1
AdditionalValueIsAllowed AdditionalValueIsAllowed 1
ChangeNumber ChangeNumber 1
Characteristic Characteristic 4
CharcCatalogType CharcCatalogType 1
CharcCheckFunctionModule CharcCheckFunctionModule 1
CharcCheckTable CharcCheckTable 1
CharcConversionRoutine CharcConversionRoutine 1
CharcDataType CharacteristicFormat,CharcDataType 2
CharcDecimals CharcDecimals 1
CharcEntryIsNotFormatCtrld CharcEntryIsNotFormatCtrld 1
CharcExponentFormat CharcExponentFormat 1
CharcExponentValue CharcExponentValue 1
CharcGroup CharcGroup 1
CharcIsHidden CharcIsHidden 1
CharcIsReadOnly CharcIsReadOnly 1
CharcIsRestrictable CharcIsRestrictable 1
CharcLastChangedDateTime CharcLastChangedDateTime 1
CharcLength CharcLength 1
CharcMaintAuthGrp CharcMaintAuthGrp 1
CharcReferenceTable CharcReferenceTable 1
CharcReferenceTableField CharcReferenceTableField 1
CharcSelectedSet CharcSelectedSet 1
CharcStatus CharcStatus 1
CharcTemplate CharcTemplate 1
CharcTemplateIsDisplayed CharcTemplateIsDisplayed 1
CharcValueUnit CharcValueUnit 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Currency Currency 1
DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber 1
DocumentInfoRecordDocPart DocumentInfoRecordDocPart 1
DocumentInfoRecordDocType DocumentInfoRecordDocType 1
DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion 1
EntryIsRequired EntryIsRequired 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
MultipleValuesAreAllowed MultipleValuesAreAllowed 1
NegativeValueIsAllowed NegativeValueIsAllowed 1
Plant Plant 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1
ValueIntervalIsAllowed ValueIntervalIsAllowed 1
ValueIsCaseSensitive ValueIsCaseSensitive 1

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CLFNCHARACTERISTIC (
    CHARCINTERNALID,
    ADDITIONALVALUEISALLOWED,
    CHANGENUMBER,
    CHARACTERISTIC,
    CHARCCATALOGTYPE,
    CHARCCHECKFUNCTIONMODULE,
    CHARCCHECKTABLE,
    CHARCCONVERSIONROUTINE,
    CHARCDATATYPE,
    CHARCDECIMALS,
    CHARCENTRYISNOTFORMATCTRLD,
    CHARCEXPONENTFORMAT,
    CHARCEXPONENTVALUE,
    CHARCGROUP,
    CHARCISHIDDEN,
    CHARCISREADONLY,
    CHARCISRESTRICTABLE,
    CHARCLASTCHANGEDDATETIME,
    CHARCLENGTH,
    CHARCMAINTAUTHGRP,
    CHARCREFERENCETABLE,
    CHARCREFERENCETABLEFIELD,
    CHARCSELECTEDSET,
    CHARCSTATUS,
    CHARCTEMPLATE,
    CHARCTEMPLATEISDISPLAYED,
    CHARCVALUEUNIT,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    DOCUMENTINFORECORDDOCNUMBER,
    DOCUMENTINFORECORDDOCPART,
    DOCUMENTINFORECORDDOCTYPE,
    DOCUMENTINFORECORDDOCVERSION,
    ENTRYISREQUIRED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MULTIPLEVALUESAREALLOWED,
    NEGATIVEVALUEISALLOWED,
    PLANT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VALUEINTERVALISALLOWED,
    VALUEISCASESENSITIVE,
    PRIMARY KEY (CHARCINTERNALID)
);

Learn More