P_USOBX_SUSH

DDL: P_USOBX_SUSH SQL: PUSOBX_SUSH Type: view
8 Fields 4 Data Sources

Vorschlagswerten für alle SUSH Objekte

P_USOBX_SUSH is a CDS View that provides data about "Vorschlagswerten für alle SUSH Objekte" in SAP S/4HANA. It reads from 4 data sources (df14l, tadir, tdevc, usobx) and exposes 8 fields with key fields name, type.

Data Sources (4)

SourceAliasJoin Type
df14l df14l left_outer
tadir tadir left_outer
tdevc tdevc left_outer
usobx usobx from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PUSOBX_SUSH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Vorschlagswerten für alle SUSH Objekte view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY name usobx name Zone name
KEY type usobx type Worklist Type
object usobx object TRFM Object
okflag usobx okflag Maintenance Mode
devclass tadir devclass Package (Obsolete)
srcsystem tadir srcsystem Source system
author tadir author User Name
ps_posid df14l ps_posid WBS Element

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 P_USOBX_SUSH.
-- 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: PUSOBX_SUSH

CREATE VIEW P_USOBX_SUSH AS
SELECT
  usobx.name AS name,
  usobx.type AS type,
  usobx.object AS object,
  usobx.okflag AS okflag,
  tadir.devclass AS devclass,
  tadir.srcsystem AS srcsystem,
  tadir.author AS author,
  df14l.ps_posid AS ps_posid
FROM usobx
LEFT OUTER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
;

Learn More