CHARACTERISTICVALUE

22 Fields

CHARACTERISTICVALUE is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CharcInternalID CharcInternalID 2
KEY CharcValuePositionNumber CharcValuePositionNumber 2
ChangeNumber ChangeNumber 2
CharcFromNumericValue CharcFromNumericValue 2
CharcFromNumericValueUnit CharcFromNumericValueUnit 2
CharcLastChangedDateTime CharcLastChangedDateTime 1
CharcToNumericValue CharcToNumericValue 2
CharcToNumericValueUnit CharcToNumericValueUnit 2
CharcValue CharcValue 2
CharcValueDependency CharcValueDependency 2
DocNumber DocNumber 1
DocumentInfoRecordDocNumber DocNumber 1
DocumentInfoRecordDocPart DocumentPart 1
DocumentInfoRecordDocType DocumentType 1
DocumentInfoRecordDocVersion DocumentVersion 1
DocumentPart DocumentPart 1
DocumentType DocumentType 1
DocumentVersion DocumentVersion 1
IsDefaultValue IsDefaultValue 2
LongTextID LongTextID 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

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 CHARACTERISTICVALUE (
    CHARCINTERNALID,
    CHARCVALUEPOSITIONNUMBER,
    CHANGENUMBER,
    CHARCFROMNUMERICVALUE,
    CHARCFROMNUMERICVALUEUNIT,
    CHARCLASTCHANGEDDATETIME,
    CHARCTONUMERICVALUE,
    CHARCTONUMERICVALUEUNIT,
    CHARCVALUE,
    CHARCVALUEDEPENDENCY,
    DOCNUMBER,
    DOCUMENTINFORECORDDOCNUMBER,
    DOCUMENTINFORECORDDOCPART,
    DOCUMENTINFORECORDDOCTYPE,
    DOCUMENTINFORECORDDOCVERSION,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    ISDEFAULTVALUE,
    LONGTEXTID,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARCINTERNALID, CHARCVALUEPOSITIONNUMBER)
);

Learn More