I_CLFNCHARCBASIC

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);