CUAN_D_TG_ROOT

Transparent Table Application Table
32 Fields 11 CDS Views

Target Group Root

CUAN_D_TG_ROOT is an SAP database table in S/4HANA. Target Group Root. It contains 32 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
cuan_cpg_cust_search view_entity inner Comm flow Search by Customer ID
CUAN_CPG_TPL_ACTION view_entity left_outer Communication Flow Template Action
CUAN_EXP_DEF_SEARCH_UI view_entity left_outer Export Definitions
CUAN_TG_COUNT_MEMBERS view_entity union_all Count Members
CUAN_TG_OPERATION_SOURCE view_entity from AT_TG_OPERATION_SOURCE
CUAN_TG_OPERATION_SOURCE view_entity inner AT_TG_OPERATION_SOURCE
CUAN_TG_WITH_NAMES_SEARCH view_entity from AT_SEARCH_TARGET_GROUP_WITH_NAMES
I_IBCRecipientList view_entity from BASIC Recipient List
I_MKT_TargetGroup view_entity from BASIC Communication: Recipient List
I_MKT_TargetGroupControlGroup view_entity from BASIC Marketing: Control Group Id
I_MKT_TgtGrpIntactnCntctCount view_entity from BASIC Marketing: Target Group Member Count

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
id CUAN_TG_ID Recipient List
target_group_name CUAN_TG_NAME Recipient List Name
life_cycle_status CUAN_TG_STATUS Status
description CUAN_TG_DESCR Description
responsible CUAN_TG_RESPONSIBLE Owner
origin CUAN_TG_ORIGIN Origin
origin_db_key CUAN_TG_ORIGIN_DB_KEY Origin: DB Key
sm_segment_id GSEG_V_SEGMENT_ID Segment ID
dynamic CUAN_TG_DYNAMIC Dynamic
versioning CUAN_TG_VERSIONING Versioning
version CUAN_TG_VERSION Version
man_mbr_changes CUAN_TG_MAN_MBR_CHANGES Manual Changes
last_rebuild CUAN_TG_LAST_REBUILD Last Rebuild
definition_id HPA_V_EXPORT_DEFINITION_ID Export Def. ID
csv_export_date TIMESTAMPL Time Stamp
operation CUAN_TG_OPERATION Operation
comm_area_id HPA_COMM_AREA_ID Comm. Area ID
ref_org_struc HPA_REF_ORG_STRUC Source Organization
appl_id GSEG_V_APPL_ID Application ID
ot_id GSEG_V_OBJ_TYPE Segm. Object
ic_comp_name CUAN_V_TG_IC_COMP Contact Comp.
ia_comp_name CUAN_V_TG_IA_COMP Interaction Comp.
cp_comp_name CUAN_V_TG_CP_COMP Contact Proj.
gres_ref /BOBF/CONF_KEY NodeID
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
cuan_e_tg_root DUMMY Dummy function in length 1
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Target Group Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAN_D_TG_ROOT (
    MANDT,              -- Client [MANDT]
    DB_KEY,             -- NodeID [/BOBF/CONF_KEY]
    ID,                 -- Recipient List [CUAN_TG_ID]
    TARGET_GROUP_NAME,  -- Recipient List Name [CUAN_TG_NAME]
    LIFE_CYCLE_STATUS,  -- Status [CUAN_TG_STATUS]
    DESCRIPTION,        -- Description [CUAN_TG_DESCR]
    RESPONSIBLE,        -- Owner [CUAN_TG_RESPONSIBLE]
    ORIGIN,             -- Origin [CUAN_TG_ORIGIN]
    ORIGIN_DB_KEY,      -- Origin: DB Key [CUAN_TG_ORIGIN_DB_KEY]
    SM_SEGMENT_ID,      -- Segment ID [GSEG_V_SEGMENT_ID]
    DYNAMIC,            -- Dynamic [CUAN_TG_DYNAMIC]
    VERSIONING,         -- Versioning [CUAN_TG_VERSIONING]
    VERSION,            -- Version [CUAN_TG_VERSION]
    MAN_MBR_CHANGES,    -- Manual Changes [CUAN_TG_MAN_MBR_CHANGES]
    LAST_REBUILD,       -- Last Rebuild [CUAN_TG_LAST_REBUILD]
    DEFINITION_ID,      -- Export Def. ID [HPA_V_EXPORT_DEFINITION_ID]
    CSV_EXPORT_DATE,    -- Time Stamp [TIMESTAMPL]
    OPERATION,          -- Operation [CUAN_TG_OPERATION]
    COMM_AREA_ID,       -- Comm. Area ID [HPA_COMM_AREA_ID]
    REF_ORG_STRUC,      -- Source Organization [HPA_REF_ORG_STRUC]
    APPL_ID,            -- Application ID [GSEG_V_APPL_ID]
    OT_ID,              -- Segm. Object [GSEG_V_OBJ_TYPE]
    IC_COMP_NAME,       -- Contact Comp. [CUAN_V_TG_IC_COMP]
    IA_COMP_NAME,       -- Interaction Comp. [CUAN_V_TG_IA_COMP]
    CP_COMP_NAME,       -- Contact Proj. [CUAN_V_TG_CP_COMP]
    GRES_REF,           -- NodeID [/BOBF/CONF_KEY]
    CREA_DATE_TIME,     -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,         -- User Name [UNAME]
    LCHG_DATE_TIME,     -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,         -- User Name [UNAME]
    CUAN_E_TG_ROOT,     -- Dummy function in length 1 [DUMMY]
    _DATAAGING,         -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More