I_SpecIdentifierUsage

DDL: I_SPECIDENTIFIERUSAGE SQL: ISPECIDFGUSAGE Type: view BASIC

Specification Identifier Usage

I_SpecIdentifierUsage is a Basic CDS View that provides data about "Specification Identifier Usage" in SAP S/4HANA. It reads from 1 data source (P_SpecUsage) and exposes 14 fields with key fields SpecIdfgUsageInternalID, SpecIdfgUsageChangeState. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
P_SpecUsage P_SpecUsage from

Associations (2)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECIDFGUSAGE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
EndUserText.label Specification Identifier Usage view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SpecIdfgUsageInternalID SpecificationUsageInternalID
KEY SpecIdfgUsageChangeState SpecificationUsageChangeState
SpecificationInternalID SpecificationInternalID
SpecIdfgUsgeValdtyStrtDte SpecificationUsgeValdtyStrtDte
SpecIdfgUsgeValdtyEndDte SpecificationUsgeValdtyEndDte
MasterTableElementInternalID MasterTableElementInternalID
SpecificationRating SpecificationRating
SpecificationValidityArea SpecificationValidityArea
SpecIdfgUsageIsExcluded SpecificationUsageIsExcluded
SpecIdfgUsageIsActive SpecificationUsageIsActive
SpecIdfgUsageIsRelevant SpecificationUsageIsRelevant
SpecIdfgUsageIsDeleted SpecificationUsageIsDeleted
_Rating _Rating
_ValidityArea _ValidityArea 
@AbapCatalog.sqlViewName: 'ISPECIDFGUSAGE'
@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 Identifier Usage'
define view I_SpecIdentifierUsage
  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 SpecIdfgUsageInternalID,
  key SpecificationUsageChangeState                                                         as SpecIdfgUsageChangeState,

      SpecificationInternalID,

      SpecificationUsgeValdtyStrtDte                                                        as SpecIdfgUsgeValdtyStrtDte,
      SpecificationUsgeValdtyEndDte                                                         as SpecIdfgUsgeValdtyEndDte,

      MasterTableElementInternalID,

      SpecificationRating,
      SpecificationValidityArea,

      SpecificationUsageIsExcluded                                                          as SpecIdfgUsageIsExcluded,
      SpecificationUsageIsActive                                                            as SpecIdfgUsageIsActive,
      SpecificationUsageIsRelevant                                                          as SpecIdfgUsageIsRelevant,
      SpecificationUsageIsDeleted                                                           as SpecIdfgUsageIsDeleted,

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

Learn More