I_SPECVALASSGMTUSAGE

CDS View

Specification Value Assignment Usage

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

Used by 4 CDS view(s) 10 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SpecValAssgmtInstance view left_outer COMPOSITE Specification Value Assignment Instance with Usages
I_SpecValAssgmtWithHeader view left_outer COMPOSITE Specification Value Assignment Instance with Header
R_ProdSpecCmpstnHdrWithUsage view inner COMPOSITE Product Spec. Comp. Header with Usage
R_SpecCompositionDateIndep view inner COMPOSITE Spec Value Assignment Instance with Comp Date Independent

Fields (10)

KeyField CDS FieldsUsed in Views
KEY SpecificationRating SpecificationRating 3
KEY SpecificationValidityArea SpecificationValidityArea 3
KEY SpecValAssgmtUsageChangeState SpecValAssgmtUsageChangeState 1
KEY SpecValAssgmtUsageInternalID SpecValAssgmtUsageInternalID 3
SpecValAssgmtUsageIsActive SpecValAssgmtUsageIsActive 3
SpecValAssgmtUsageIsDeleted SpecValAssgmtUsageIsDeleted 1
SpecValAssgmtUsageIsExcluded SpecValAssgmtUsageIsExcluded 3
SpecValAssgmtUsageIsRelevant SpecValAssgmtUsageIsRelevant 4
SpecValAssgmtUsgeValdtyEndDte SpecValAssgmtUsgeValdtyEndDte 1
SpecValAssgmtUsgeValdtyStrtDte SpecValAssgmtUsgeValdtyStrtDte 1 
@AbapCatalog.sqlViewName: 'ISPECVAUSAGE'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
// Access control authorization check not allowed, this view shall not be keydate dependent


@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

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


@EndUserText.label: 'Specification Value Assignment Usage'
define view I_SpecValAssgmtUsage
  as select from P_SpecUsage
  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
  

{
  key SpecificationUsageInternalID                                                          as SpecValAssgmtUsageInternalID,
  key SpecificationUsageChangeState                                                         as SpecValAssgmtUsageChangeState,

      SpecificationInternalID,

      SpecificationUsgeValdtyStrtDte                                                        as SpecValAssgmtUsgeValdtyStrtDte,
      SpecificationUsgeValdtyEndDte                                                         as SpecValAssgmtUsgeValdtyEndDte,

      MasterTableElementInternalID,

      SpecificationRating,
      SpecificationValidityArea,

      SpecificationUsageIsExcluded                                                          as SpecValAssgmtUsageIsExcluded,
      SpecificationUsageIsActive                                                            as SpecValAssgmtUsageIsActive,
      SpecificationUsageIsRelevant                                                          as SpecValAssgmtUsageIsRelevant,
      SpecificationUsageIsDeleted                                                           as SpecValAssgmtUsageIsDeleted,

      _Rating,
      _ValidityArea
}
where
  MasterTable = 'ESTVA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SPECUSAGE"
],
"ASSOCIATED":
[
"I_SPECRATING",
"I_SPECVALIDITYAREA"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More