CUAN_D_TG_MEMBER

Transparent Table Application Table

Customer Member

CUAN_D_TG_MEMBER is an SAP database table in S/4HANA. Customer Member. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CUAN_LI_COMPL_TMP_TARGET_GROUP view_entity inner Processed Interactions in the No Branch
CUAN_TG_BY_MEMBER_SEARCH view_entity from AT_SEARCH_TARGET_GROUP_BY_CUSTOMER
CUAN_TG_COUNT_MEMBERS view_entity from Count Members

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
cuan_e_tg_member DUMMY Dummy function in length 1
origin CUAN_TG_ORIGIN Origin
deletion_type CUAN_TG_DEL_TYPE Deletion Type
crea_date_time TIMESTAMPL Time Stamp
del_date_time TIMESTAMPL Time Stamp
version CUAN_TG_VERSION Version
deletion_version CUAN_TG_DEL_VERSION Del. Version
member_key /BOBF/CONF_KEY NodeID
member_key2 /BOBF/CONF_KEY NodeID
member_key3 CUAN_TG_MEMBER_KEY_CHAR Member Key
rand_rank CUAN_V_TG_RAND_RANK TG Memb. Rand. Rank

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.

-- Customer Member
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAN_D_TG_MEMBER (
    MANDT,             -- Client [MANDT]
    DB_KEY,            -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,        -- NodeID [/BOBF/CONF_KEY]
    CUAN_E_TG_MEMBER,  -- Dummy function in length 1 [DUMMY]
    ORIGIN,            -- Origin [CUAN_TG_ORIGIN]
    DELETION_TYPE,     -- Deletion Type [CUAN_TG_DEL_TYPE]
    CREA_DATE_TIME,    -- Time Stamp [TIMESTAMPL]
    DEL_DATE_TIME,     -- Time Stamp [TIMESTAMPL]
    VERSION,           -- Version [CUAN_TG_VERSION]
    DELETION_VERSION,  -- Del. Version [CUAN_TG_DEL_VERSION]
    MEMBER_KEY,        -- NodeID [/BOBF/CONF_KEY]
    MEMBER_KEY2,       -- NodeID [/BOBF/CONF_KEY]
    MEMBER_KEY3,       -- Member Key [CUAN_TG_MEMBER_KEY_CHAR]
    RAND_RANK,         -- TG Memb. Rand. Rank [CUAN_V_TG_RAND_RANK]
    PRIMARY KEY (MANDT, DB_KEY)
);