I_SpecAssignedStatus

@AbapCatalog.sqlViewName: 'ISPECASGST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Specification Assigned Status'

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

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

@Metadata.ignorePropagatedAnnotations:true
define view I_SpecAssignedStatus
  as select from ehsbt_appl_scope
{
  key recn     as SpecAssignedStatus,
  key actn     as SpecAssgdStatusChangeState,
      valfr    as SpecAssgdStsValidityStartDate,
      valto    as SpecAssgdStsValidityEndDate,
      aennr    as SpecAssgdStatusChangeNumber,
      delflg   as SpecAssgdStatusIsDeleted,
      crdat    as SpecAssgdStatusCreationDate,
      crnam    as SpecAssgdStatusCreatedByUser,
      upddat   as SpecAssgdStatusChangeDate,
      updnam   as SpecAssgdStsLastChangedByUser,
      recnroot as SpecificationInternalID,
      substat  as SpecAssgdStatusCode,
      vaclid   as SpecAssgdStatusRating,
      rvlid    as SpecAssgdStatusValidityArea
}