I_SASActionAssignment

DDL: I_SASACTIONASSIGNMENT SQL: IMPESASAA Type: view BASIC
12 Fields 1 Data Sources 4 Associations

SAS Action Assignment

I_SASActionAssignment is a Basic CDS View that provides data about "SAS Action Assignment" in SAP S/4HANA. It reads from 1 data source (mpe_sas_as_act) and exposes 12 fields with key fields StatusAndActionSchema, StatusAndActionSchemaAction. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mpe_sas_as_act ass from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_SASSchema _SASSchema $projection.StatusAndActionSchema = _SASSchema.StatusAndActionSchema
[1..1] I_SASAction _SASAction $projection.StatusAndActionSchemaAction = _SASAction.StatusAndActionSchemaAction
[1..1] I_SASStatus _SASActionStartStatus $projection.SASActionStartStatus = _SASActionStartStatus.StatusAndActionSchemaStatus
[1..1] I_SASStatus _SASActionEndStatus $projection.SASActionEndStatus = _SASActionEndStatus.StatusAndActionSchemaStatus

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPESASAA 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.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label SAS Action Assignment view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY StatusAndActionSchema mpe_sas_as_act sas_name Status Action Schema
KEY StatusAndActionSchemaAction mpe_sas_as_act action_name Action
StatusAndActionSchemaType _SASSchema StatusAndActionSchemaType
SASActionStartStatus mpe_sas_as_act start_status_name Start Status
SASActionEndStatus mpe_sas_as_act end_status_name End Status
SASActionSequence mpe_sas_as_act action_icon_screen_sequence Action Sqnce
LastChangedByUser mpe_sas_as_act changed_by User Name
LastChangeDateTime mpe_sas_as_act changed_at Timestamp
_SASSchema _SASSchema
_SASAction _SASAction
_SASActionStartStatus _SASActionStartStatus
_SASActionEndStatus _SASActionEndStatus

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_SASActionAssignment.
-- 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: IMPESASAA

CREATE VIEW I_SASActionAssignment AS
SELECT
  ass.sas_name AS StatusAndActionSchema,
  ass.action_name AS StatusAndActionSchemaAction,
  _SASSchema.StatusAndActionSchemaType AS StatusAndActionSchemaType,
  ass.start_status_name AS SASActionStartStatus,
  ass.end_status_name AS SASActionEndStatus,
  ass.action_icon_screen_sequence AS SASActionSequence,
  ass.changed_by AS LastChangedByUser,
  ass.changed_at AS LastChangeDateTime
FROM mpe_sas_as_act AS ass
LEFT OUTER JOIN I_SASSchema AS _SASSchema ON StatusAndActionSchema = _SASSchema.StatusAndActionSchema  -- association [1..1]
LEFT OUTER JOIN I_SASAction AS _SASAction ON StatusAndActionSchemaAction = _SASAction.StatusAndActionSchemaAction  -- association [1..1]
LEFT OUTER JOIN I_SASStatus AS _SASActionStartStatus ON SASActionStartStatus = _SASActionStartStatus.StatusAndActionSchemaStatus  -- association [1..1]
LEFT OUTER JOIN I_SASStatus AS _SASActionEndStatus ON SASActionEndStatus = _SASActionEndStatus.StatusAndActionSchemaStatus  -- association [1..1]
;

Learn More