P_SU2X_WBO

DDL: P_SU2X_WBO SQL: PSU2X_WBO Type: view
10 Fields 3 Data Sources

Objektkatalogdaten zu TADIR-Key

P_SU2X_WBO is a CDS View that provides data about "Objektkatalogdaten zu TADIR-Key" in SAP S/4HANA. It reads from 3 data sources (df14l, tdevc, tadir) and exposes 10 fields with key fields pgmid, object, obj_name.

Data Sources (3)

SourceAliasJoin Type
df14l df14l left_outer
tdevc tdevc left_outer
tadir wbo from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSU2X_WBO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Objektkatalogdaten zu TADIR-Key view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY pgmid tadir pgmid Program Name
KEY object tadir object TRFM Object
KEY obj_name tadir obj_name Object Name
devclass tadir devclass Package (Obsolete)
OBJSTABLTY tadir objstablty Deployment Target
dlvunit tdevc dlvunit Softw. Comp.
ps_posid df14l ps_posid WBS Element
srcsystem tadir srcsystem Source system
author tadir author User Name
masterlang tadir masterlang Single-Character Flag

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_SU2X_WBO.
-- 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: PSU2X_WBO

CREATE VIEW P_SU2X_WBO AS
SELECT
  wbo.pgmid AS pgmid,
  wbo.object AS object,
  wbo.obj_name AS obj_name,
  wbo.devclass AS devclass,
  wbo.objstablty AS OBJSTABLTY,
  tdevc.dlvunit AS dlvunit,
  df14l.ps_posid AS ps_posid,
  wbo.srcsystem AS srcsystem,
  wbo.author AS author,
  wbo.masterlang AS masterlang
FROM tadir AS wbo
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