I_StatusObjectUUIDStatus

DDL: I_STATUSOBJECTUUIDSTATUS SQL: ISTSOBJUUIDSTS Type: view BASIC
9 Fields 1 Data Sources 3 Associations

I_StatusObjectUUIDStatus

I_StatusObjectUUIDStatus is a Basic CDS View that provides data about "I_StatusObjectUUIDStatus" in SAP S/4HANA. It reads from 1 data source (P_StatusObjectStatusWithGUID) and exposes 9 fields with key fields StatusObjectUUID, StatusCode. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_StatusObjectStatusWithGUID P_StatusObjectStatusWithGUID from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_StatusCode _StatusCode $projection.StatusCode = _StatusCode.StatusCode and $projection.StatusProfile = _StatusCode.StatusProfile
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile
[0..1] I_StatusObjectUUID _StatusObjectUUID $projection.StatusObjectUUID = _StatusObjectUUID.StatusObjectUUID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey StatusCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName ISTSOBJUUIDSTS view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label I_StatusObjectUUIDStatus view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatusObjectUUID StatusObjectUUID Val. Obj. No.
KEY StatusCode StatusCode Statuscode
IsUserStatus IsUserStatus
StatusIsActive StatusIsActive
StatusIsInactive StatusIsInactive TRUE
StatusProfile StatusProfile Status Profile
_StatusCode _StatusCode
_StatusProfile _StatusProfile
_StatusObjectUUID _StatusObjectUUID

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_StatusObjectUUIDStatus.
-- 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: ISTSOBJUUIDSTS

CREATE VIEW I_StatusObjectUUIDStatus AS
SELECT
  StatusObjectUUID,
  StatusCode,
  IsUserStatus,
  StatusIsActive,
  StatusIsInactive,
  StatusProfile
FROM P_StatusObjectStatusWithGUID
LEFT OUTER JOIN I_StatusCode AS _StatusCode ON StatusCode = _StatusCode.StatusCode AND StatusProfile = _StatusCode.StatusProfile  -- association [0..1]
LEFT OUTER JOIN I_StatusProfile AS _StatusProfile ON StatusProfile = _StatusProfile.StatusProfile  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUID AS _StatusObjectUUID ON StatusObjectUUID = _StatusObjectUUID.StatusObjectUUID  -- association [0..1]
;

Learn More