CUAN_TG_BY_MEMBER_SEARCH

DDL: CUAN_TG_BY_MEMBER_SEARCH SQL: CUAN_TGBYMEM_SEA Type: view Package: CUAN_CDS_TARGET_GROUP_NO_TRANS
19 Fields 1 Data Sources

AT_SEARCH_TARGET_GROUP_BY_CUSTOMER

CUAN_TG_BY_MEMBER_SEARCH is a CDS View that provides data about "AT_SEARCH_TARGET_GROUP_BY_CUSTOMER" in SAP S/4HANA. It reads from 1 data source (cuan_d_tg_member) and exposes 19 fields with key fields MANDT, HPA_CLIENT. Part of development package CUAN_CDS_TARGET_GROUP_NO_TRANS.

Data Sources (1)

SourceAliasJoin Type
cuan_d_tg_member cuan_d_tg_member from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CUAN_TGBYMEM_SEA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label AT_SEARCH_TARGET_GROUP_BY_CUSTOMER view
ClientDependent true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MANDT cuan_d_tg_root mandt Editing Client
KEY HPA_CLIENT cuan_d_tg_root mandt Editing Client
KUNNR cuan_d_tg_member kunnr Stock customer
ID cuan_d_tg_root id WorklistID
MEMBER_KEY cuan_d_tg_member member_key NodeID
MEMBER_KEY2 cuan_d_tg_member member_key2 NodeID
MEMBER_KEY3 cuan_d_tg_member member_key3
LIFE_CYCLE_STATUS cuan_d_tg_root life_cycle_status Life Cycle
DB_KEY cuan_d_tg_member db_key UUID
VERSION cuan_d_tg_root version XML Vers.
DYNAMIC cuan_d_tg_root dynamic Dynamic
VERSIONING cuan_d_tg_root versioning Enable Snapshot
CREA_DATE_TIME cuan_d_tg_root crea_date_time Time Stamp
CREA_UNAME cuan_d_tg_root crea_uname User Name
PARENT_KEY cuan_d_tg_member parent_key UUID
DELETION_TYPE cuan_d_tg_member deletion_type
MEMBER_TYPE cuan_d_tg_root member_type
DEL_DATE_TIME cuan_d_tg_member del_date_time Time Stamp
MKT_AREA_ID cuan_d_tg_root mkt_area_id

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_TG_BY_MEMBER_SEARCH.
-- 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: CUAN_TGBYMEM_SEA

CREATE VIEW CUAN_TG_BY_MEMBER_SEARCH AS
SELECT
  cuan_d_tg_root.mandt AS MANDT,
  cuan_d_tg_root.mandt AS HPA_CLIENT,
  cuan_d_tg_member.kunnr AS KUNNR,
  cuan_d_tg_root.id AS ID,
  cuan_d_tg_member.member_key AS MEMBER_KEY,
  cuan_d_tg_member.member_key2 AS MEMBER_KEY2,
  cuan_d_tg_member.member_key3 AS MEMBER_KEY3,
  cuan_d_tg_root.life_cycle_status AS LIFE_CYCLE_STATUS,
  cuan_d_tg_member.db_key AS DB_KEY,
  cuan_d_tg_root.version AS VERSION,
  cuan_d_tg_root.dynamic AS DYNAMIC,
  cuan_d_tg_root.versioning AS VERSIONING,
  cuan_d_tg_root.crea_date_time AS CREA_DATE_TIME,
  cuan_d_tg_root.crea_uname AS CREA_UNAME,
  cuan_d_tg_member.parent_key AS PARENT_KEY,
  cuan_d_tg_member.deletion_type AS DELETION_TYPE,
  cuan_d_tg_root.member_type AS MEMBER_TYPE,
  cuan_d_tg_member.del_date_time AS DEL_DATE_TIME,
  cuan_d_tg_root.mkt_area_id AS MKT_AREA_ID
FROM cuan_d_tg_member
;

Learn More