SUIM_2X_DEV_OBJECTS

DDL: SUIM_2X_DEV_OBJECTS SQL: SUIM2X_DEVOBJ Type: view
22 Fields 4 Data Sources

Get data from SU22 (Auth. Objects)

SUIM_2X_DEV_OBJECTS is a CDS View that provides data about "Get data from SU22 (Auth. Objects)" in SAP S/4HANA. It reads from 4 data sources (SUIM_2X_HEAD, SUIM_2X_DEV_OKFLAG, SUIM_2X_DEV_SORT_ID, usobx) and exposes 22 fields with key fields ident, tech_name, name.

Data Sources (4)

SourceAliasJoin Type
SUIM_2X_HEAD head from
SUIM_2X_DEV_OKFLAG okflag_text left_outer
SUIM_2X_DEV_SORT_ID sort left_outer
usobx usobx left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SUIM2X_DEVOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get data from SU22 (Auth. Objects) view

Fields (22)

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

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_OBJECTS.
-- 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_DEVOBJ

CREATE VIEW SUIM_2X_DEV_OBJECTS AS
SELECT
  head.ident AS ident,
  head.tech_name AS tech_name,
  head.name AS name,
  head.ddtext AS ddtext,
  head.type AS type,
  head.description AS description,
  head.modifier AS modifier,
  head.moddate AS moddate,
  head.modtime AS modtime,
  head.okflag AS okflag,
  head.okflag_text AS okflag_text,
  head.source AS source,
  head.author AS author,
  head.devclass AS devclass,
  head.dlvunit AS dlvunit,
  head.ps_posid AS ps_posid,
  head.source_su2x AS source_su2x,
  head.author_su2x AS author_su2x,
  head.dlvunit_su2x AS dlvunit_su2x,
  usobx.object AS object,
  usobx.okflag AS okflag_obj,
  sort.sort_id AS sort_id
FROM SUIM_2X_HEAD AS head
LEFT OUTER JOIN usobx ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_DEV_OKFLAG AS okflag_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_DEV_SORT_ID AS sort ON /* join condition not captured in parsed metadata */
;

Learn More