I_SPECVALASSGMT

CDS View
21 Fields 4 CDS Views

Specification Value Assignment

I_SPECVALASSGMT is a CDS View in S/4HANA. Specification Value Assignment. It contains 21 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_SpecValAssgmtWithHeader view inner COMPOSITE
R_ProdSpecCmpstnHdrWithUsage view inner COMPOSITE Product Spec. Comp. Header with Usage
R_SpecCompositionDateIndep view inner COMPOSITE Spec Value Assignment Instance with Comp Date Independent
R_SpecWithInheritanceOrRef view union COMPOSITE Specifications using inheritance or reference

Fields (21)

KeyField CDS FieldsUsed in Views
KEY SpecValAssgmt SpecValAssgmt 2
KEY SpecValAssgmtChangeState SpecValAssgmtChangeState 2
_SpecValAssgmtReferenceValue _SpecValAssgmtReferenceValue 1
InhtdSpecValAssgmtIsPermChgd InhtdSpecValAssgmtIsPermChgd 2
InhtdSpecValAssgmtIsTmpChgd InhtdSpecValAssgmtIsTmpChgd 2
SpecInheritanceTemplate SpecInheritanceTemplate 2
SpecValAssgmtChangeNumber SpecValAssgmtChangeNumber 2
SpecValAssgmtCreatedByUser SpecValAssgmtCreatedByUser 2
SpecValAssgmtCreationDate SpecValAssgmtCreationDate 2
SpecValAssgmtInheritanceParent SpecValAssgmtInheritanceParent 2
SpecValAssgmtInheritanceRoot SpecValAssgmtInheritanceRoot 2
SpecValAssgmtIsDeleted ProdSpecCmpstnHdrIsDeleted,SpecValAssgmtIsDeleted 3
SpecValAssgmtIsInhtncSource SpecValAssgmtIsInhtncSource 2
SpecValAssgmtLastChangeDate SpecValAssgmtLastChangeDate 2
SpecValAssgmtLastChangedByUser SpecValAssgmtLastChangedByUser 2
SpecValAssgmtRefValueCode SpecValAssgmtRefValueCode 1
SpecValAssgmtRootSpecIntID SpecValAssgmtRootSpecIntID 2
SpecValAssgmtSortSequence SpecValAssgmtSortSequence 2
SpecValAssgmtUnitRefDimension SpecValAssgmtUnitRefDimension 2
SpecValAssgmtValidityEndDate SpecValAssgmtValidityEndDate 2
SpecValAssgmtValidityStartDate SpecValAssgmtValidityStartDate 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.

-- Specification Value Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SPECVALASSGMT (
    SPECVALASSGMT,
    SPECVALASSGMTCHANGESTATE,
    _SPECVALASSGMTREFERENCEVALUE,
    INHTDSPECVALASSGMTISPERMCHGD,
    INHTDSPECVALASSGMTISTMPCHGD,
    SPECINHERITANCETEMPLATE,
    SPECVALASSGMTCHANGENUMBER,
    SPECVALASSGMTCREATEDBYUSER,
    SPECVALASSGMTCREATIONDATE,
    SPECVALASSGMTINHERITANCEPARENT,
    SPECVALASSGMTINHERITANCEROOT,
    SPECVALASSGMTISDELETED,
    SPECVALASSGMTISINHTNCSOURCE,
    SPECVALASSGMTLASTCHANGEDATE,
    SPECVALASSGMTLASTCHANGEDBYUSER,
    SPECVALASSGMTREFVALUECODE,
    SPECVALASSGMTROOTSPECINTID,
    SPECVALASSGMTSORTSEQUENCE,
    SPECVALASSGMTUNITREFDIMENSION,
    SPECVALASSGMTVALIDITYENDDATE,
    SPECVALASSGMTVALIDITYSTARTDATE,
    PRIMARY KEY (SPECVALASSGMT, SPECVALASSGMTCHANGESTATE)
);

Learn More