P_SU2X_USOBX_CNT

DDL: P_SU2X_USOBX_CNT SQL: PSU2X_USOBX_CNT Type: view Package: SU2X
4 Fields 2 Data Sources

Anzahl der SU2X-Objekte zur Anwendung

P_SU2X_USOBX_CNT is a CDS View that provides data about "Anzahl der SU2X-Objekte zur Anwendung" in SAP S/4HANA. It reads from 2 data sources (usobx, usobx_c) and exposes 4 fields with key fields name, type. Part of development package SU2X.

Data Sources (2)

SourceAliasJoin Type
usobx x from
usobx_c x_c left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSU2X_USOBX_CNT 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 #CHECK view
EndUserText.label Anzahl der SU2X-Objekte zur Anwendung view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY name usobx name Zone name
KEY type usobx type Worklist Type
cnt
cnt_c

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_USOBX_CNT.
-- 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_USOBX_CNT

CREATE VIEW P_SU2X_USOBX_CNT AS
SELECT
  x.name AS name,
  x.type AS type,
  count(distinct x.object) AS cnt,
  count(distinct x_c.object) AS cnt_c
FROM usobx AS x
LEFT OUTER JOIN usobx_c AS x_c ON /* join condition not captured in parsed metadata */
;

Learn More