I_DevelopmentStatusObjectBasic

DDL: I_DEVELOPMENTSTATUSOBJECTBASIC SQL: IDEVSTATUSOBJBAS Type: view BASIC
6 Fields 1 Data Sources 1 Associations

Individual Status Object

I_DevelopmentStatusObjectBasic is a Basic CDS View that provides data about "Individual Status Object" in SAP S/4HANA. It reads from 1 data source (crm_jest) and exposes 6 fields with key fields StatusObjectUUID, StatusCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
crm_jest crm_jest from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DevStatusObjectInformation _DevStatusObjectInfo $projection.StatusObjectUUID = _DevStatusObjectInfo.StatusObjectUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDEVSTATUSOBJBAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Individual Status Object view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled false view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StatusObjectUUID crm_jest objnr Val. Obj. No.
KEY StatusCode crm_jest stat Status of Time-Dependent Document Linkage
StatusIsInactive crm_jest inact TRUE
StatusProfile _DevStatusObjectInfo StatusProfile Status Profile
_DevStatusObjectInfo _DevStatusObjectInfo
_StatusProfile _DevStatusObjectInfo _StatusProfile

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_DevelopmentStatusObjectBasic.
-- 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: IDEVSTATUSOBJBAS

CREATE VIEW I_DevelopmentStatusObjectBasic AS
SELECT
  crm_jest.objnr AS StatusObjectUUID,
  crm_jest.stat AS StatusCode,
  crm_jest.inact AS StatusIsInactive,
  _DevStatusObjectInfo.StatusProfile AS StatusProfile,
  _DevStatusObjectInfo._StatusProfile AS _StatusProfile
FROM crm_jest
LEFT OUTER JOIN I_DevStatusObjectInformation AS _DevStatusObjectInfo ON StatusObjectUUID = _DevStatusObjectInfo.StatusObjectUUID  -- association [0..1]
;

Learn More