DHCDC_AUTH_CdsExtrctnBDCFltr

DDL: DHCDC_AUTH_CDSEXTRCTNBDCFLTR SQL: DHCDCVCDSEXTRB Type: view Package: SADI_CDC_AUTH

CDS Views enabled for BDC Subscriber

DHCDC_AUTH_CdsExtrctnBDCFltr is a CDS View that provides data about "CDS Views enabled for BDC Subscriber" in SAP S/4HANA. It reads from 2 data sources (DHCDC_AUTH_CdsExtrctnEnabled, DHCDC_AUTH_GROUP_user_views) and exposes 7 fields. Part of development package SADI_CDC_AUTH.

Data Sources (2)

SourceAliasJoin Type
DHCDC_AUTH_CdsExtrctnEnabled t0 from
DHCDC_AUTH_GROUP_user_views t1 inner

Parameters (1)

NameTypeDefault
pUserID uname

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName DHCDCVCDSEXTRB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS Views enabled for BDC Subscriber view

Fields (7)

KeyFieldSource TableSource FieldDescription
viewname DHCDC_AUTH_CdsExtrctnEnabled viewname View Name
sql_viewname DHCDC_AUTH_CdsExtrctnEnabled sql_viewname
ddlname DHCDC_AUTH_CdsExtrctnEnabled ddlname DDL Source Name
ddtext DHCDC_AUTH_CdsExtrctnEnabled ddtext Short text
ddlanguage DHCDC_AUTH_CdsExtrctnEnabled ddlanguage Lang.
isDeltaSupported DHCDC_AUTH_CdsExtrctnEnabled isDeltaSupported
viewname_raw DHCDC_AUTH_CdsExtrctnEnabled viewname_raw

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 DHCDC_AUTH_CdsExtrctnBDCFltr.
-- 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: DHCDCVCDSEXTRB
-- Parameters: pUserID : uname

CREATE VIEW DHCDC_AUTH_CdsExtrctnBDCFltr AS
SELECT
  t0.viewname AS viewname,
  t0.sql_viewname AS sql_viewname,
  t0.ddlname AS ddlname,
  t0.ddtext AS ddtext,
  t0.ddlanguage AS ddlanguage,
  t0.isDeltaSupported AS isDeltaSupported,
  t0.viewname_raw AS viewname_raw
FROM DHCDC_AUTH_CdsExtrctnEnabled AS t0
INNER JOIN DHCDC_AUTH_GROUP_user_views AS t1 ON /* join condition not captured in parsed metadata */
;