I_SASStatusVH

DDL: I_SASSTATUSVH Type: view_entity 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 (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey StatusAndActionSchemaStatus 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.

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