cuan_crp_pr_fltr_at_usage

DDL: CUAN_CRP_PR_FLTR_AT_USAGE SQL: CUANCRPPFLTATUSE Type: view Package: CUAN_SEG_CONTENT_CRP
5 Fields 1 Data Sources

Attribute Usage in Segm. Profile Filters

cuan_crp_pr_fltr_at_usage is a CDS View that provides data about "Attribute Usage in Segm. Profile Filters" in SAP S/4HANA. It reads from 1 data source (gseg_pr_filter) and exposes 5 fields. Part of development package CUAN_SEG_CONTENT_CRP.

Data Sources (1)

SourceAliasJoin Type
gseg_pr_filter f left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CUANCRPPFLTATUSE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Attribute Usage in Segm. Profile Filters view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (5)

KeyFieldSource TableSource FieldDescription
ApplicationId p appl_id Policy Key
SegProfileId p pr_id Purchase Req.
SegObjectId p ot_id
DataSource gseg_pr_filter data_src_alias
AttributeName gseg_pr_filter attr_name Attribute Name

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 cuan_crp_pr_fltr_at_usage.
-- 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: CUANCRPPFLTATUSE

CREATE VIEW cuan_crp_pr_fltr_at_usage AS
SELECT
  p.appl_id AS ApplicationId,
  p.pr_id AS SegProfileId,
  p.ot_id AS SegObjectId,
  f.data_src_alias AS DataSource,
  f.attr_name AS AttributeName
LEFT OUTER JOIN gseg_pr_filter AS f ON /* join condition not captured in parsed metadata */
;

Learn More