I_SpecificationVH

DDL: I_SPECIFICATIONVH SQL: ISPECVH Type: view COMPOSITE Package: VDM_PLMB_SPC_BAS

Value Help for Specification

I_SpecificationVH is a Composite CDS View that provides data about "Value Help for Specification" in SAP S/4HANA. It reads from 1 data source (I_SpecificationNonHistoric) and exposes 9 fields with key field SpecificationInternalID. It has 3 associations to related views. Part of development package VDM_PLMB_SPC_BAS.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_SpecificationNonHistoric hd from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SpecIdfrBscForKeyDate _Identifier $projection.SpecificationInternalID = _Identifier.SpecificationInternalID
[0..1] I_SpecificationForKeyDate _SpecificationForKeyDate $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID
[0..1] I_SpecAssignedHeaderStatus _AssignedHeaderStatus $projection.SpecificationInternalID = _AssignedHeaderStatus.SpecificationInternalID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ISPECVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey SpecificationInternalID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view
EndUserText.label Value Help for Specification view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SpecificationInternalID I_SpecificationNonHistoric SpecificationInternalID
Specification I_SpecificationNonHistoric Specification
SpecIdfgDescText
SpecificationType I_SpecificationNonHistoric SpecificationType
SpecificationAuthznGroup
SpecificationHeaderStatus _AssignedHeaderStatus SpecificationHeaderStatus
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt 
@AbapCatalog.sqlViewName: 'ISPECVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@Consumption.ranked: true

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'SpecificationInternalID'

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

@Search.searchable: true

@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #COMPOSITE

@EndUserText.label: 'Value Help for Specification'
define view I_SpecificationVH
  as select from I_SpecificationNonHistoric as hd
  association [0..1] to I_SpecIdfrBscForKeyDate    as _Identifier              on $projection.SpecificationInternalID = _Identifier.SpecificationInternalID
  association [0..1] to I_SpecificationForKeyDate  as _SpecificationForKeyDate on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID
  association [0..1] to I_SpecAssignedHeaderStatus as _AssignedHeaderStatus    on $projection.SpecificationInternalID = _AssignedHeaderStatus.SpecificationInternalID

{
      @UI.hidden: true
  key hd.SpecificationInternalID,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      hd.Specification,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @Semantics.text
      _Identifier(P_KeyDate : $session.system_date).SpecIdfgDescText,

      hd.SpecificationType,
      _SpecificationForKeyDate(P_KeyDate : $session.system_date).SpecificationAuthznGroup,
      _AssignedHeaderStatus.SpecificationHeaderStatus,

      @Consumption.hidden: true
      _LogAccMObjectTypeActive,

      @Consumption.hidden: true
      _LogAccMObjectUserAuthzn,

      @Consumption.hidden: true
      _LogAccMObjSecureIDAssgmt
}

Learn More