I_UserStatusText

DDL: I_USERSTATUSTEXT SQL: IUSERSTATUSTEXT Type: view BASIC Package: VDM_FND
8 Fields 1 Data Sources 3 Associations

User Status - Text

I_UserStatusText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_UserStatusText is a Basic CDS View that provides data about "User Status - Text" in SAP S/4HANA. It reads from 1 data source (tj30t) and exposes 8 fields with key fields UserStatus, StatusProfile, Language. It has 3 associations to related views. Part of development package VDM_FND.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentCA-GTF-VDM
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities,Language-Dependent Text
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tj30t tj30t from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UserStatus _UserStatus $projection.StatusProfile = _UserStatus.StatusProfile and $projection.UserStatus = _UserStatus.UserStatus
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey UserStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.sqlViewName IUSERSTATUSTEXT view
AbapCatalog.preserveKey true view
EndUserText.label User Status - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UserStatus tj30t estat User status
KEY StatusProfile tj30t stsma Status Profile
KEY Language tj30t spras Off. Language
UserStatusName tj30t txt30 Individual Status of an Object
UserStatusShortName tj30t txt04 Individual status of an object (short form)
_StatusProfile _StatusProfile
_UserStatus _UserStatus
_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_UserStatusText.
-- 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: IUSERSTATUSTEXT

CREATE VIEW I_UserStatusText AS
SELECT
  tj30t.estat AS UserStatus,
  tj30t.stsma AS StatusProfile,
  tj30t.spras AS Language,
  tj30t.txt30 AS UserStatusName,
  tj30t.txt04 AS UserStatusShortName
FROM tj30t
LEFT OUTER JOIN I_UserStatus AS _UserStatus ON StatusProfile = _UserStatus.StatusProfile AND UserStatus = _UserStatus.UserStatus  -- association [0..1]
LEFT OUTER JOIN I_StatusProfile AS _StatusProfile ON StatusProfile = _StatusProfile.StatusProfile  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More