I_SASStatus

DDL: I_SASSTATUS SQL: IMPESASS Type: view BASIC

SAS Status

I_SASStatus is a Basic CDS View that provides data about "SAS Status" in SAP S/4HANA. It reads from 1 data source (mpe_sas_status) and exposes 7 fields with key field StatusAndActionSchemaStatus. It has 2 associations to related views. It is exposed through 2 OData services (UI_OPACTYSFIGROUP_EXECUTE, UI_OPACTYSFIGROUP_MANAGE). It is used in 1 Fiori application: Process Serial Number Groups.

1 data source(s) Exposed by 2 service(s) Used in 1 Fiori app(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
mpe_sas_status stat from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SASStatusText _Text $projection.StatusAndActionSchemaStatus = _Text.StatusAndActionSchemaStatus
[1..1] I_SASStatusCategory _SASStatusCategory $projection.SASStatusCategory = _SASStatusCategory.SASStatusCategory

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPESASS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.representativeKey StatusAndActionSchemaStatus view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label SAS Status view

OData Services (2)

ServiceBindingVersionContractRelease
UI_OPACTYSFIGROUP_EXECUTE UI_OPACTYSFIGROUP_EXECUTE V2 C1 NOT_RELEASED
UI_OPACTYSFIGROUP_MANAGE UI_OPACTYSFIGROUP_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6773 Process Serial Number Groups Transactional S/4HANA Manufacturing Production Engineering and Operations (PEO) 2022 FPS0 release offers a new functionality to collectively process any number of serial numbers as a group at an operation activity. The Process Serial Number Groups app allows production operators to create an maintain a group of serial numbers to be processed at an operation activity, execute SAS and some of the non-SAS actions (i.e. Start, Labor On, Complete, Pause, etc.) once for the complete group, view non-traceable components, PRTs and documents assigned to an operation activity as well as keep the activity log recorded for each serial number individually.

Process Serial Number Groups

Business Role: Production Operator - Discrete Manufacturing (Extended Production Operations)

With this app, you can collectively process any number of serial numbers as a group at an operation activity in the segment type Produce. This allows you, for example, to work on standardized serialized products that often need to undergo the same fabrication process. You perform the actions once for the serial number group and the system records the data individually for each serial number in that group. You access this app by executing a serial number group from the My Work Queue app.

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatusAndActionSchemaStatus mpe_sas_status status_name
SASStatusCategory mpe_sas_status status_category
SASStatusCriticality mpe_sas_status criticality
LastChangedByUser mpe_sas_status changed_by
LastChangeDateTime mpe_sas_status changed_at
_Text _Text
_SASStatusCategory _SASStatusCategory 
@AbapCatalog.sqlViewName: 'IMPESASS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'StatusAndActionSchemaStatus'
@ObjectModel.usageType:
{
  serviceQuality: #B,
  sizeCategory:   #S,
  dataClass:      #CUSTOMIZING
}
@EndUserText.label: 'SAS Status'
define view I_SASStatus
  as select from mpe_sas_status as stat
  association [0..*] to I_SASStatusText     as _Text              on $projection.StatusAndActionSchemaStatus = _Text.StatusAndActionSchemaStatus
  association [1..1] to I_SASStatusCategory as _SASStatusCategory on $projection.SASStatusCategory = _SASStatusCategory.SASStatusCategory
{
      @ObjectModel.text.association: '_Text'
  key stat.status_name     as StatusAndActionSchemaStatus,
      @ObjectModel.foreignKey.association: '_SASStatusCategory'
      stat.status_category as SASStatusCategory,
      stat.criticality     as SASStatusCriticality,
      @Semantics.user.lastChangedBy: true
      stat.changed_by      as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      stat.changed_at      as LastChangeDateTime,

      _Text,
      _SASStatusCategory
}

Learn More