I_SASStatusText

DDL: I_SASSTATUSTEXT SQL: IMPESASST Type: view BASIC
4 Fields 1 Data Sources 1 Associations 2 OData Services 1 Fiori Apps

SAS Status Text

I_SASStatusText is a Basic CDS View that provides data about "SAS Status Text" in SAP S/4HANA. It reads from 1 data source (mpe_sas_status_t) and exposes 4 fields with key fields StatusAndActionSchemaStatus, Language. It has 1 association 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.

Data Sources (1)

SourceAliasJoin Type
mpe_sas_status_t stat from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMPESASST 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.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label SAS Status Text 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 (4)

KeyFieldSource TableSource FieldDescription
KEY StatusAndActionSchemaStatus mpe_sas_status_t status_name Status Name
KEY Language mpe_sas_status_t spras Off. Language
SASStatusName mpe_sas_status_t status_description Status Description
_Language _Language

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SASStatusText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMPESASST

CREATE VIEW I_SASStatusText AS
SELECT
  stat.status_name AS StatusAndActionSchemaStatus,
  stat.spras AS Language,
  stat.status_description AS SASStatusName
FROM mpe_sas_status_t AS stat
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More