CUAND_ME_ME_ROOT

Transparent Table Application Table
52 Fields 24 CDS Views

#GENERATED#

CUAND_ME_ME_ROOT is an SAP database table in S/4HANA. #GENERATED#. It contains 52 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
Cuan_Cont_Lib_Cm_Base view_entity from Campaign Messages
CUAN_CONT_LIB_ME_BASE view_entity from Communication: Messages Query Base View
CUAN_LI_ME_QR_LANG_BLCK_REUSE view_entity from Marketing Content Reusable Block
CUAN_ME_QR_CONDITIONS_FROM_ENG view_entity from Query to read conditions from engagement
CUAN_ME_QR_ENG_WITH_NAMES_BASE view_entity from Communication: Message Query Base View
CUAN_ME_QR_ENGAGEMENTS_COUNT view_entity from CUAN_ME_QR_ENGAGEMENTS_COUNT
CUAN_ME_QR_ENGAGMENTS_FOR_ORCH view_entity from Query engagements for orchestration
CUAN_ME_QR_LINK_HASH view_entity inner Query link hash
CUAN_ME_QR_LINKS_FROM_ENGMNT view_entity inner Query links of a given Engagement Id
CUAN_ME_QR_REUSE_BC_BASE view_entity from CUAN_ME_QR_REUSE_BC_BASE
CUAN_ME_QR_REUSE_BLOCK_CONTENT view_entity inner CUAN_ME_QR_REUSE_BLOCK_CONTENT
CUAN_ME_QR_REUSE_COND_EMD view_entity inner Messages that use reusable blocks
CUAN_ME_QR_REUSE_USED_IN view_entity inner Messages That Use Reusable Blocks
CUAN_ME_QR_TOOLBOX_BLOCKS view_entity inner Toolbox Blocks in Message Design View
I_IBCMessageContent view_entity from BASIC Message Content
I_IBCMessageReuseBlockUsedIn view_entity from BASIC Communication Messsage Content Used In
I_IBCMessageSearch view_entity from BASIC IBC Message Search
I_MKT_CampaignContent view_entity from BASIC Communication: Message Details
I_MKT_CampaignContentAll view_entity from BASIC Communication: Message Details
I_MKT_CmpgnCntntReuseBlkUsedIn view_entity from BASIC Messages That Use Reusable Blocks
I_MKT_CmpgnCntntReuseBlockUsed view_entity from BASIC Campaign Content: Reusable Block Used
ibc_me_qr_find_dupl_ref_tpl view_entity from Find Duplicates for Reference Template
IBC_ME_QR_VALIDITIES view_entity inner Validities of Content Revisions
IBC_MESSAGECNTNTREUSEBLKUSEDIN view_entity from Communication Messsage Content Used In

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
id CUAN_ME_ENGAGEMENT_ID Message ID
name CUAN_ME_ENGAGEMENT_NAME Message Name
description CUAN_ME_ENGAGEMENT_DESCRIPTION Description
type CUAN_CL_CONTENT_TYPE Message Type
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
send_date_time TIMESTAMPL Time Stamp
export_definition HPA_V_EXPORT_DEFINITION_ID Export Def. ID
initiative CUAN_INITIATIVE_ID Comm. Flow ID
initiative_version CUAN_INITIATIVE_VERSION Version
sending_profile CUAN_ME_SENDING_PROFILE Sender Profile ID
email_template_id CUAN_ME_TEMPLATE_ID Template ID
email_subject CUAN_ME_EMAIL_SUBJECT Email Subject
email_for_generate CUAN_ME_EMAIL_FOR_GENERATE Email Body for Gen.
email_for_send CUAN_ME_EMAIL_FOR_SEND Body for Sending
email_for_send_version CUAN_ME_EMAIL_FOR_SEND_VERSION JSON Version
no_of_contacts CUAN_ME_NO_OF_CONTACTS No. of Contacts
language LAISO Language Code
merge_attribute_table CUAN_ME_MERGE_ATTRIBUTE_TABLE Gen. Pers.Table Name
sender_name CUAN_ME_SENDER_NAME Sender Name
sender_name_pers CUAND_ME_DS_ATTRIBUTE_NAME Attribute Name
sender_email CUAN_ME_SENDER_EMAIL Sender Address
sender_email_pers CUAND_ME_DS_ATTRIBUTE_NAME Attribute Name
reply_to_name CUAN_ME_REPLY_TO_NAME Reply-To Name
reply_to_name_pers CUAND_ME_DS_ATTRIBUTE_NAME Attribute Name
reply_to_email CUAN_ME_REPLY_TO_EMAIL Reply-To Address
reply_to_email_pers CUAND_ME_DS_ATTRIBUTE_NAME Attribute Name
adv_sendonbehalf_active CUAN_ME_ADV_SOB_ACTIVE Advanced is Active
adv_sendonbehalf_tmbr_role CUAN_CE_TEAM_MEMBER_ROLE Team Member Role
do_not_send_wo_val_sender CUAN_ME_NO_SEND_WO_VAL_SENDER Dont Send w/o Sender
list_unsubscribe_url CUAN_ME_LIST_UNSUBSCRIBE_URL Follow-Up Unsubscr.
list_unsubscribe_email CUAN_ME_LIST_UNSUBSCRIBE_EMAIL Email Add. Unsubscr.
comm_area_id HPA_COMM_AREA_ID Comm. Area ID
ref_org_struc HPA_REF_ORG_STRUC Source Organization
comm_medium CUAN_CE_COMM_MEDIUM Communication Medium
status CUAN_ME_ENGAGEMENT_STATUS Status
category CUAN_ME_ENGAGEMENT_CATEGORY Message Category
campaign_content_type CUAN_ME_CAMPAIGN_CONTENT_TYPE Content Type
segmentation_object GSEG_V_OBJ_TYPE Segm. Object
segmentation_profile GSEG_V_PR_ID Segmentation Profile
is_template CUAN_ME_IS_TEMPLATE Template
blocks_are_movable CUAN_ME_BLOCKS_ARE_MOVABLE Structure Changeable
multi_part_email CUAN_ME_MULTI_PART_EMAIL Send Multipart Email
backup_reference_id CUAN_ME_ENGAGEMENT_ID Message ID
comm_pattern_id IBC_COMM_PATTERN_ID Communication Pattern
source_template_id CUAN_ME_REFERENCE_TPL_ID Ref. Template ID
source_template_release_date CUAN_MKT_CNT_CPG_TPL_REL_DT Released At
cuan_e_me_me_rt DUMMY Dummy function in length 1

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.

-- #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAND_ME_ME_ROOT (
    MANDT,                         -- Client [MANDT]
    DB_KEY,                        -- NodeID [/BOBF/CONF_KEY]
    ID,                            -- Message ID [CUAN_ME_ENGAGEMENT_ID]
    NAME,                          -- Message Name [CUAN_ME_ENGAGEMENT_NAME]
    DESCRIPTION,                   -- Description [CUAN_ME_ENGAGEMENT_DESCRIPTION]
    TYPE,                          -- Message Type [CUAN_CL_CONTENT_TYPE]
    CREA_DATE_TIME,                -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,                    -- User Name [UNAME]
    LCHG_DATE_TIME,                -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,                    -- User Name [UNAME]
    SEND_DATE_TIME,                -- Time Stamp [TIMESTAMPL]
    EXPORT_DEFINITION,             -- Export Def. ID [HPA_V_EXPORT_DEFINITION_ID]
    INITIATIVE,                    -- Comm. Flow ID [CUAN_INITIATIVE_ID]
    INITIATIVE_VERSION,            -- Version [CUAN_INITIATIVE_VERSION]
    SENDING_PROFILE,               -- Sender Profile ID [CUAN_ME_SENDING_PROFILE]
    EMAIL_TEMPLATE_ID,             -- Template ID [CUAN_ME_TEMPLATE_ID]
    EMAIL_SUBJECT,                 -- Email Subject [CUAN_ME_EMAIL_SUBJECT]
    EMAIL_FOR_GENERATE,            -- Email Body for Gen. [CUAN_ME_EMAIL_FOR_GENERATE]
    EMAIL_FOR_SEND,                -- Body for Sending [CUAN_ME_EMAIL_FOR_SEND]
    EMAIL_FOR_SEND_VERSION,        -- JSON Version [CUAN_ME_EMAIL_FOR_SEND_VERSION]
    NO_OF_CONTACTS,                -- No. of Contacts [CUAN_ME_NO_OF_CONTACTS]
    LANGUAGE,                      -- Language Code [LAISO]
    MERGE_ATTRIBUTE_TABLE,         -- Gen. Pers.Table Name [CUAN_ME_MERGE_ATTRIBUTE_TABLE]
    SENDER_NAME,                   -- Sender Name [CUAN_ME_SENDER_NAME]
    SENDER_NAME_PERS,              -- Attribute Name [CUAND_ME_DS_ATTRIBUTE_NAME]
    SENDER_EMAIL,                  -- Sender Address [CUAN_ME_SENDER_EMAIL]
    SENDER_EMAIL_PERS,             -- Attribute Name [CUAND_ME_DS_ATTRIBUTE_NAME]
    REPLY_TO_NAME,                 -- Reply-To Name [CUAN_ME_REPLY_TO_NAME]
    REPLY_TO_NAME_PERS,            -- Attribute Name [CUAND_ME_DS_ATTRIBUTE_NAME]
    REPLY_TO_EMAIL,                -- Reply-To Address [CUAN_ME_REPLY_TO_EMAIL]
    REPLY_TO_EMAIL_PERS,           -- Attribute Name [CUAND_ME_DS_ATTRIBUTE_NAME]
    ADV_SENDONBEHALF_ACTIVE,       -- Advanced is Active [CUAN_ME_ADV_SOB_ACTIVE]
    ADV_SENDONBEHALF_TMBR_ROLE,    -- Team Member Role [CUAN_CE_TEAM_MEMBER_ROLE]
    DO_NOT_SEND_WO_VAL_SENDER,     -- Dont Send w/o Sender [CUAN_ME_NO_SEND_WO_VAL_SENDER]
    LIST_UNSUBSCRIBE_URL,          -- Follow-Up Unsubscr. [CUAN_ME_LIST_UNSUBSCRIBE_URL]
    LIST_UNSUBSCRIBE_EMAIL,        -- Email Add. Unsubscr. [CUAN_ME_LIST_UNSUBSCRIBE_EMAIL]
    COMM_AREA_ID,                  -- Comm. Area ID [HPA_COMM_AREA_ID]
    REF_ORG_STRUC,                 -- Source Organization [HPA_REF_ORG_STRUC]
    COMM_MEDIUM,                   -- Communication Medium [CUAN_CE_COMM_MEDIUM]
    STATUS,                        -- Status [CUAN_ME_ENGAGEMENT_STATUS]
    CATEGORY,                      -- Message Category [CUAN_ME_ENGAGEMENT_CATEGORY]
    CAMPAIGN_CONTENT_TYPE,         -- Content Type [CUAN_ME_CAMPAIGN_CONTENT_TYPE]
    SEGMENTATION_OBJECT,           -- Segm. Object [GSEG_V_OBJ_TYPE]
    SEGMENTATION_PROFILE,          -- Segmentation Profile [GSEG_V_PR_ID]
    IS_TEMPLATE,                   -- Template [CUAN_ME_IS_TEMPLATE]
    BLOCKS_ARE_MOVABLE,            -- Structure Changeable [CUAN_ME_BLOCKS_ARE_MOVABLE]
    MULTI_PART_EMAIL,              -- Send Multipart Email [CUAN_ME_MULTI_PART_EMAIL]
    BACKUP_REFERENCE_ID,           -- Message ID [CUAN_ME_ENGAGEMENT_ID]
    COMM_PATTERN_ID,               -- Communication Pattern [IBC_COMM_PATTERN_ID]
    SOURCE_TEMPLATE_ID,            -- Ref. Template ID [CUAN_ME_REFERENCE_TPL_ID]
    SOURCE_TEMPLATE_RELEASE_DATE,  -- Released At [CUAN_MKT_CNT_CPG_TPL_REL_DT]
    CUAN_E_ME_ME_RT,               -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More