CUAN_D_TG_MEMBER
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA