I_SPECVALASSGMT

CDS View

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.

Used by 4 CDS view(s) 21 fields

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 
@AbapCatalog.sqlViewName: 'ISPECVA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC

@EndUserText.label: 'Specification Value Assignment'
define view I_SpecValAssgmt
  as select from estva
  association [0..1] to I_SpecValAssgmtReferenceValue as _SpecValAssgmtReferenceValue on $projection.SpecValAssgmtRefValueCode = _SpecValAssgmtReferenceValue.SpecValAssgmtRefValueCode

{
  key recn          as SpecValAssgmt,
  key actn          as SpecValAssgmtChangeState,
      recnroot      as SpecificationInternalID,
      recntvh       as SpecValAssgmtHdr,

      @Semantics.businessDate.from: true
      valfr         as SpecValAssgmtValidityStartDate,
      @Semantics.businessDate.to: true
      valto         as SpecValAssgmtValidityEndDate,

      aennr         as SpecValAssgmtChangeNumber,

      crdat         as SpecValAssgmtCreationDate,
      @Semantics.user.createdBy: true
      crnam         as SpecValAssgmtCreatedByUser,

      upddat        as SpecValAssgmtLastChangeDate,
      @Semantics.user.lastChangedBy: true
      updnam        as SpecValAssgmtLastChangedByUser,

      ord           as SpecValAssgmtSortSequence,

      comprel       as SpecValAssgmtUnitRefDimension, // released in API, kept for compatibility

      comprel       as SpecValAssgmtRefValueCode,

      flg_inhsrc    as SpecValAssgmtIsInhtncSource,
      flg_inhovr    as InhtdSpecValAssgmtIsTmpChgd,
      flg_inhexcl   as InhtdSpecValAssgmtIsPermChgd,
      recn_tplh     as SpecInheritanceTemplate,
      recntva_src   as SpecValAssgmtInheritanceParent,
      recntva_orig  as SpecValAssgmtInheritanceRoot,
      recnroot_orig as SpecValAssgmtRootSpecIntID,
      tpl_ord       as SpecInheritanceTmplSortSeq,
      delflg        as SpecValAssgmtIsDeleted,

      _SpecValAssgmtReferenceValue
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ESTVA"
],
"ASSOCIATED":
[
"I_SPECVALASSGMTREFERENCEVALUE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More