I_SASStatusVH

DDL: I_SASSTATUSVH SQL: IMPESASSVH Type: view COMPOSITE
2 Fields 1 Data Sources 1 Associations

SAS Status Value Help

I_SASStatusVH is a Composite CDS View that provides data about "SAS Status Value Help" in SAP S/4HANA. It reads from 1 data source (I_SASStatus) and exposes 2 fields with key field StatusAndActionSchemaStatus. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SASStatus I_SASStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SASStatusText _Text $projection.StatusAndActionSchemaStatus = _Text.StatusAndActionSchemaStatus

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMPESASSVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label SAS Status Value Help view
Search.searchable true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY StatusAndActionSchemaStatus StatusAndActionSchemaStatus Status Name
SASStatusName

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_SASStatusVH.
-- 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: IMPESASSVH

CREATE VIEW I_SASStatusVH AS
SELECT
  StatusAndActionSchemaStatus,
  cast(_Text[1: Language=$session.system_language].SASStatusName as mpe_object_description_type preserving type) AS SASStatusName
FROM I_SASStatus
LEFT OUTER JOIN I_SASStatusText AS _Text ON StatusAndActionSchemaStatus = _Text.StatusAndActionSchemaStatus  -- association [0..*]
;

Learn More