I_SpecValAssgmtInstance

DDL: I_SPECVALASSGMTINSTANCE SQL: ISPECVAINST Type: view COMPOSITE

Specification Value Assignment Instance with Usages

I_SpecValAssgmtInstance is a Composite CDS View that provides data about "Specification Value Assignment Instance with Usages" in SAP S/4HANA. It reads from 2 data sources (P_SpecValAssgmtInstanceNormal, I_SpecValAssgmtUsage) and exposes 28 fields with key fields SpecValAssgmtHdr, SpecValAssgmt, SpecValAssgmtUsageInternalID. It has 3 associations to related views.

2 data source(s) 28 fields

Data Sources (2)

SourceAliasJoin Type
P_SpecValAssgmtInstanceNormal P_SpecValAssgmtInstanceNormal from
I_SpecValAssgmtUsage usg left_outer

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SpecRating _Rating $projection.SpecificationRating = _Rating.SpecificationRating
[0..1] I_SpecValidityArea _ValidityArea $projection.SpecificationValidityArea = _ValidityArea.SpecificationValidityArea
[0..1] I_SpecificationForKeyDate _SpecificationForKeyDate $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECVAINST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Specification Value Assignment Instance with Usages view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SpecValAssgmtHdr norm SpecValAssgmtHdr
KEY SpecValAssgmt norm SpecValAssgmt
KEY SpecValAssgmtUsageInternalID I_SpecValAssgmtUsage SpecValAssgmtUsageInternalID
SpecValAssgmtIsInhtncSource norm SpecValAssgmtIsInhtncSource
SpecificationInternalID norm SpecificationInternalID
InhtdSpecValAssgmtIsTmpChgd norm InhtdSpecValAssgmtIsTmpChgd
InhtdSpecValAssgmtIsPermChgd norm InhtdSpecValAssgmtIsPermChgd
SpecInheritanceTemplate norm SpecInheritanceTemplate
SpecValAssgmtInheritanceParent norm SpecValAssgmtInheritanceParent
SpecValAssgmtInheritanceRoot norm SpecValAssgmtInheritanceRoot
SpecValAssgmtRootSpecIntID norm SpecValAssgmtRootSpecIntID
SpecValAssgmtType norm SpecValAssgmtType
SpecValAssgmtChangeState norm SpecValAssgmtChangeState
SpecValAssgmtSortSequence norm SpecValAssgmtSortSequence
SpecValAssgmtUnitRefDimension norm SpecValAssgmtUnitRefDimension
ValueAssignmentSource norm ValueAssignmentSource
SpecValAssgmtWithChangeState norm SpecValAssgmtWithChangeState
SpecValAssgmtHdrIsDeleted norm SpecValAssgmtHdrIsDeleted
SpecValAssgmtIsDeleted norm SpecValAssgmtIsDeleted
SpecificationRating I_SpecValAssgmtUsage SpecificationRating
SpecificationValidityArea I_SpecValAssgmtUsage SpecificationValidityArea
SpecValAssgmtUsageIsExcluded I_SpecValAssgmtUsage SpecValAssgmtUsageIsExcluded
SpecValAssgmtUsageIsActive I_SpecValAssgmtUsage SpecValAssgmtUsageIsActive
SpecValAssgmtUsageIsRelevant I_SpecValAssgmtUsage SpecValAssgmtUsageIsRelevant
_Rating _Rating
_ValidityArea _ValidityArea
_SpecificationForKeyDate _SpecificationForKeyDate
_ValueAssignmentType _ValueAssignmentType 
@AbapCatalog.sqlViewName: 'ISPECVAINST'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@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: #COMPOSITE


@EndUserText.label: 'Specification Value Assignment Instance with Usages'
define view I_SpecValAssgmtInstance
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from    P_SpecValAssgmtInstanceNormal( P_KeyDate : $parameters.P_KeyDate ) as norm
    left outer join I_SpecValAssgmtUsage                                               as usg on  norm.SpecValAssgmtRootSpecIntID    = usg.SpecificationInternalID
                                                                                              and norm.SpecValAssgmtInheritanceRoot  = usg.MasterTableElementInternalID
                                                                                              and usg.SpecValAssgmtUsgeValdtyStrtDte <= $parameters.P_KeyDate
                                                                                              and usg.SpecValAssgmtUsgeValdtyEndDte  >= $parameters.P_KeyDate
                                                                                              and usg.SpecValAssgmtUsageIsDeleted != 'X'
  association [0..1] to I_SpecRating              as _Rating                  on $projection.SpecificationRating = _Rating.SpecificationRating
  association [0..1] to I_SpecValidityArea        as _ValidityArea            on $projection.SpecificationValidityArea = _ValidityArea.SpecificationValidityArea
  association [0..1] to I_SpecificationForKeyDate as _SpecificationForKeyDate on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID
{
  key norm.SpecValAssgmtHdr,
  key norm.SpecValAssgmt,
  key usg.SpecValAssgmtUsageInternalID,
      norm.SpecValAssgmtIsInhtncSource,
      norm.SpecificationInternalID,
      norm.InhtdSpecValAssgmtIsTmpChgd,
      norm.InhtdSpecValAssgmtIsPermChgd,
      norm.SpecInheritanceTemplate,
      norm.SpecValAssgmtInheritanceParent,
      norm.SpecValAssgmtInheritanceRoot,
      norm.SpecValAssgmtRootSpecIntID,
      norm.SpecValAssgmtType,
      norm.SpecValAssgmtChangeState,
      norm.SpecValAssgmtSortSequence,
      //norm.SpecValAssgmtHdrChangeState,

      norm.SpecValAssgmtUnitRefDimension,
      norm.ValueAssignmentSource,
      norm.SpecValAssgmtWithChangeState,

      norm.SpecValAssgmtHdrIsDeleted,
      norm.SpecValAssgmtIsDeleted,

      usg.SpecificationRating,
      usg.SpecificationValidityArea,
      usg.SpecValAssgmtUsageIsExcluded,
      usg.SpecValAssgmtUsageIsActive,
      usg.SpecValAssgmtUsageIsRelevant,

      _Rating,
      _ValidityArea,
      _SpecificationForKeyDate,
      _ValueAssignmentType
}

Learn More