CLASS

CLASS is an SAP database table in S/4HANA. It contains 31 fields.

Fields (31)

KeyField CDS FieldsUsed in Views
KEY ClassInternalID ClassInternalID 3
KEY Product Product 2
KEY TrdClassfctnNmbrSchm TrdClassfctnNmbrSchm 2
KEY TrdClassfctnNmbrSchmCntnt TrdClassfctnNmbrSchmCntnt 2
KEY ValidityStartDate ValidityStartDate 5
Class Class,MrchdsCategoryHierarchyNode,ParentMrchdsCatHierarchyNode 5
ClassClassfctnAuthGrp ClassClassfctnAuthGrp 3
ClassGroup ClassGroup 3
ClassGroupName ClassGroupName 2
ClassIsLocal ClassIsLocal 3
ClassLastChangedDateTime ClassLastChangedDateTime 3
ClassMaintAuthGrp ClassMaintAuthGrp 3
ClassSearchAuthGrp ClassSearchAuthGrp 3
ClassStandardCharcTable ClassStandardCharcTable 3
ClassStandardNumber ClassStandardNumber 3
ClassStandardOrgName ClassStandardOrgName 3
ClassStandardStartDate ClassStandardStartDate 3
ClassStandardVersion ClassStandardVersion 3
ClassStandardVersionStartDate ClassStandardVersionStartDate 3
ClassStatus ClassStatus 3
ClassStatusName ClassStatusName 2
ClassType ClassType 3
ClassTypeName ClassTypeName 2
CreationDate CreationDate 3
DocumentInfoRecordDocNumber DocNumber,DocumentInfoRecordDocNumber 3
DocumentInfoRecordDocPart DocumentInfoRecordDocPart,DocumentPart 3
DocumentInfoRecordDocType DocumentInfoRecordDocType,DocumentType 3
DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion,DocumentVersion 3
LastChangeDate LastChangeDate 3
SameClassfctnReaction SameClassfctnReaction 3
ValidityEndDate ValidityEndDate 5

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 CLASS (
    CLASSINTERNALID,
    PRODUCT,
    TRDCLASSFCTNNMBRSCHM,
    TRDCLASSFCTNNMBRSCHMCNTNT,
    VALIDITYSTARTDATE,
    CLASS,
    CLASSCLASSFCTNAUTHGRP,
    CLASSGROUP,
    CLASSGROUPNAME,
    CLASSISLOCAL,
    CLASSLASTCHANGEDDATETIME,
    CLASSMAINTAUTHGRP,
    CLASSSEARCHAUTHGRP,
    CLASSSTANDARDCHARCTABLE,
    CLASSSTANDARDNUMBER,
    CLASSSTANDARDORGNAME,
    CLASSSTANDARDSTARTDATE,
    CLASSSTANDARDVERSION,
    CLASSSTANDARDVERSIONSTARTDATE,
    CLASSSTATUS,
    CLASSSTATUSNAME,
    CLASSTYPE,
    CLASSTYPENAME,
    CREATIONDATE,
    DOCUMENTINFORECORDDOCNUMBER,
    DOCUMENTINFORECORDDOCPART,
    DOCUMENTINFORECORDDOCTYPE,
    DOCUMENTINFORECORDDOCVERSION,
    LASTCHANGEDATE,
    SAMECLASSFCTNREACTION,
    VALIDITYENDDATE,
    PRIMARY KEY (CLASSINTERNALID, PRODUCT, TRDCLASSFCTNNMBRSCHM, TRDCLASSFCTNNMBRSCHMCNTNT, VALIDITYSTARTDATE)
);