CUAN_D_MKTORC_AC

Transparent Table Application Table

Marketing Orchestration Action - #GENERATED#

CUAN_D_MKTORC_AC is an SAP database table in S/4HANA. Marketing Orchestration Action - #GENERATED#. It contains 23 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CUAN_CPG_ACTION_SEARCH view_entity from Communication flow action search
CUAN_LI_COMPL_TMP_TARGET_GROUP view_entity inner Processed Interactions in the No Branch
I_IBCCommunicationFlowAction view_entity from BASIC Communication Flow Action

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
parent_action_key /BOBF/CONF_KEY NodeID
ordinal_number CUAN_MKTORC_ORDINAL_NUMBER Ordinal Number
action_id HPA_ACTION_ID Action
target_group_key /BOBF/CONF_KEY NodeID
delayed_start_duration CUAN_MKTORC_DURATION Duration
requested_start_time CUAN_MKTORC_START_TIME Start Time
filter_target_group CUAN_TG_ID Recipient List
status CUAN_MKTORC_EXEC_STATUS Execution Status
adv_schd_sunday_non BOOLE_D TRUE
adv_schd_monday_non BOOLE_D TRUE
adv_schd_tuesday_non BOOLE_D TRUE
adv_schd_wednesday_non BOOLE_D TRUE
adv_schd_thursday_non BOOLE_D TRUE
adv_schd_friday_non BOOLE_D TRUE
adv_schd_saturday_non BOOLE_D TRUE
absolute_start_datetime TIMESTAMP Time Stamp
estimated_restart_date_time TIMESTAMPL Time Stamp
repeat_every CUAN_MKTORC_REPEAT_EVERY Repeat Every
start_time_for_repeat CUAN_MKTORC_START_TIME Start Time

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.

-- Marketing Orchestration Action - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAN_D_MKTORC_AC (
    MANDT,                        -- Client [MANDT]
    DB_KEY,                       -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,                     -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,                   -- NodeID [/BOBF/CONF_KEY]
    PARENT_ACTION_KEY,            -- NodeID [/BOBF/CONF_KEY]
    ORDINAL_NUMBER,               -- Ordinal Number [CUAN_MKTORC_ORDINAL_NUMBER]
    ACTION_ID,                    -- Action [HPA_ACTION_ID]
    TARGET_GROUP_KEY,             -- NodeID [/BOBF/CONF_KEY]
    DELAYED_START_DURATION,       -- Duration [CUAN_MKTORC_DURATION]
    REQUESTED_START_TIME,         -- Start Time [CUAN_MKTORC_START_TIME]
    FILTER_TARGET_GROUP,          -- Recipient List [CUAN_TG_ID]
    STATUS,                       -- Execution Status [CUAN_MKTORC_EXEC_STATUS]
    ADV_SCHD_SUNDAY_NON,          -- TRUE [BOOLE_D]
    ADV_SCHD_MONDAY_NON,          -- TRUE [BOOLE_D]
    ADV_SCHD_TUESDAY_NON,         -- TRUE [BOOLE_D]
    ADV_SCHD_WEDNESDAY_NON,       -- TRUE [BOOLE_D]
    ADV_SCHD_THURSDAY_NON,        -- TRUE [BOOLE_D]
    ADV_SCHD_FRIDAY_NON,          -- TRUE [BOOLE_D]
    ADV_SCHD_SATURDAY_NON,        -- TRUE [BOOLE_D]
    ABSOLUTE_START_DATETIME,      -- Time Stamp [TIMESTAMP]
    ESTIMATED_RESTART_DATE_TIME,  -- Time Stamp [TIMESTAMPL]
    REPEAT_EVERY,                 -- Repeat Every [CUAN_MKTORC_REPEAT_EVERY]
    START_TIME_FOR_REPEAT,        -- Start Time [CUAN_MKTORC_START_TIME]
    PRIMARY KEY (MANDT, DB_KEY)
);