SUIM_2X_DEV_OBJECT_VALUES

DDL: SUIM_2X_DEV_OBJECT_VALUES SQL: SUIM2X_DEVOBJVAL Type: view

Get data SU22 (Objects and Values)

SUIM_2X_DEV_OBJECT_VALUES is a CDS View that provides data about "Get data SU22 (Objects and Values)" in SAP S/4HANA. It reads from 2 data sources (SUIM_2X_DEV_OBJECTS, usobt) and exposes 25 fields with key fields ident, tech_name, name.

Data Sources (2)

SourceAliasJoin Type
SUIM_2X_DEV_OBJECTS objects from
usobt usobt left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SUIM2X_DEVOBJVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get data SU22 (Objects and Values) view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ident SUIM_2X_DEV_OBJECTS ident Tree Structure
KEY tech_name SUIM_2X_DEV_OBJECTS tech_name Technical Name
KEY name SUIM_2X_DEV_OBJECTS name Zone name
ddtext SUIM_2X_DEV_OBJECTS ddtext Short text
type SUIM_2X_DEV_OBJECTS type Worklist Type
description SUIM_2X_DEV_OBJECTS description Well Code Des.
modifier SUIM_2X_DEV_OBJECTS modifier User Name
moddate SUIM_2X_DEV_OBJECTS moddate Modification date
modtime SUIM_2X_DEV_OBJECTS modtime Time
okflag SUIM_2X_DEV_OBJECTS okflag Maintenance Mode
okflag_text SUIM_2X_DEV_OBJECTS okflag_text
source SUIM_2X_DEV_OBJECTS source ViolationSource
author SUIM_2X_DEV_OBJECTS author User Name
devclass SUIM_2X_DEV_OBJECTS devclass Package (Obsolete)
dlvunit SUIM_2X_DEV_OBJECTS dlvunit Softw. Comp.
ps_posid SUIM_2X_DEV_OBJECTS ps_posid WBS Element
source_su2x SUIM_2X_DEV_OBJECTS source_su2x
author_su2x SUIM_2X_DEV_OBJECTS author_su2x
dlvunit_su2x SUIM_2X_DEV_OBJECTS dlvunit_su2x
object SUIM_2X_DEV_OBJECTS object TRFM Object
okflag_obj SUIM_2X_DEV_OBJECTS okflag_obj Maintenance Mode
sort_id SUIM_2X_DEV_OBJECTS sort_id Supply Sort Rule
field usobt field Logical Field
low usobt low Value from
high usobt high Value up to

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 SUIM_2X_DEV_OBJECT_VALUES.
-- 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: SUIM2X_DEVOBJVAL

CREATE VIEW SUIM_2X_DEV_OBJECT_VALUES AS
SELECT
  objects.ident AS ident,
  objects.tech_name AS tech_name,
  objects.name AS name,
  objects.ddtext AS ddtext,
  objects.type AS type,
  objects.description AS description,
  objects.modifier AS modifier,
  objects.moddate AS moddate,
  objects.modtime AS modtime,
  objects.okflag AS okflag,
  objects.okflag_text AS okflag_text,
  objects.source AS source,
  objects.author AS author,
  objects.devclass AS devclass,
  objects.dlvunit AS dlvunit,
  objects.ps_posid AS ps_posid,
  objects.source_su2x AS source_su2x,
  objects.author_su2x AS author_su2x,
  objects.dlvunit_su2x AS dlvunit_su2x,
  objects.object AS object,
  objects.okflag_obj AS okflag_obj,
  objects.sort_id AS sort_id,
  usobt.field AS field,
  usobt.low AS low,
  usobt.high AS high
FROM SUIM_2X_DEV_OBJECTS AS objects
LEFT OUTER JOIN usobt ON /* join condition not captured in parsed metadata */
;