CUAN_D_INI_ROOT

Transparent Table Application Table
46 Fields 10 CDS Views

Initiative Root Data

CUAN_D_INI_ROOT is an SAP database table in S/4HANA. Initiative Root Data. It contains 46 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
cuan_cpg_cust_search view_entity from Comm flow Search by Customer ID
cuan_cpg_search view_entity from Communication Flow Search
cuan_cpg_tg_search view_entity from Comm Flow Search by Recipient List
CUAN_EXP_DEF_SEARCH_UI view_entity left_outer Export Definitions
cuan_ia_read view_entity left_outer Read Interaction
E_IBCCommunicationFlow view_entity from EXTENSION Communication Flow - Extension
I_IBCCommunicationFlowBasic view_entity from BASIC Communication Flow Basic
I_MKT_CampaignAsset view_entity inner BASIC Messages from Communication Flow
I_MKT_CampaignByCmpgnContent view_entity inner BASIC Comm Flow By Comm Flow Message
I_MKT_CmpgnAutomnTrggr view_entity inner BASIC Communication Flow Trigger

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
id CUAN_INITIATIVE_ID Comm. Flow ID
name CUAN_INITIATIVE_NAME Comm. Flow Name
description CUAN_INI_DESCRIPTION Comm Flow Descript.
start_date CUAN_INITIATIVE_START_DATE Start Date
end_date CUAN_INITIATIVE_END_DATE End Date
type CUAN_INITIATIVE_TYPE Category ID
release_status CUAN_INITIATIVE_REL_STAT_C Rel. Status
life_cycle_status CUAN_INITIATIVE_LC_STAT_C Status
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
period_start HPA_PERIOD_START_DATE Start Date
period_start_time HPA_PERIOD_START_TIME Start Time
period_distance HPA_PERIOD_DISTANCE Interval Value
period_unit HPA_PERIOD_UNIT Interval Unit
period_start_timestmp HPA_PERIOD_START_DATE_STMP Start Date
period_unit_t HPA_PERIOD_UNIT_DESCRIPTION Per. Unit Descr
actual_deliver_timestmp HPA_PERIOD_START_DATE_STMP Start Date
_dataaging DATA_TEMPERATURE Data Aging
cuan_e_ini_root DUMMY Dummy function in length 1
process_type CUAN_CAMPAIGN_PROCESS_TYPE Process Type
check_permission IBC_CF_CHECK_PERMISSION Check permission
adv_schd_enabled BOOLE_D TRUE
adv_schd_sunday BOOLE_D TRUE
adv_schd_monday BOOLE_D TRUE
adv_schd_tuesday BOOLE_D TRUE
adv_schd_wednesday BOOLE_D TRUE
adv_schd_thursday BOOLE_D TRUE
adv_schd_friday BOOLE_D TRUE
adv_schd_saturday BOOLE_D TRUE
adv_schd_time_enabled BOOLE_D TRUE
adv_schd_time_from TIMS Field of type TIMS
adv_schd_time_to TIMS Field of type TIMS
adv_schd_end_scenario CUAN_INITIATIVE_SCHDL_END_SCEN End Scenario
adv_schd_recurrence_count INT4 INT4
adv_schd_tzone TZNZONE Time Zone
cpg_timezone TZNZONE Time Zone
stop_date CUAN_INITIATIVE_STOP_DATE Stop Date
comm_area_id HPA_COMM_AREA_ID Comm. Area ID
ref_org_struc HPA_REF_ORG_STRUC Source Organization
is_auto_restart_allowed IBC_CF_IS_AUTO_RESTART_ALLOWED Is Auto restrt Allw
is_rl_rebuild_allowed IBC_CF_IS_RL_REBUILD_ALLOWED Is List Rebuild Allw
origin IBC_COMM_FLOW_ORIGIN Communication Flow Origin

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.

-- Initiative Root Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAN_D_INI_ROOT (
    MANDT,                      -- Client [MANDT]
    DB_KEY,                     -- NodeID [/BOBF/CONF_KEY]
    ID,                         -- Comm. Flow ID [CUAN_INITIATIVE_ID]
    NAME,                       -- Comm. Flow Name [CUAN_INITIATIVE_NAME]
    DESCRIPTION,                -- Comm Flow Descript. [CUAN_INI_DESCRIPTION]
    START_DATE,                 -- Start Date [CUAN_INITIATIVE_START_DATE]
    END_DATE,                   -- End Date [CUAN_INITIATIVE_END_DATE]
    TYPE,                       -- Category ID [CUAN_INITIATIVE_TYPE]
    RELEASE_STATUS,             -- Rel. Status [CUAN_INITIATIVE_REL_STAT_C]
    LIFE_CYCLE_STATUS,          -- Status [CUAN_INITIATIVE_LC_STAT_C]
    CREA_DATE_TIME,             -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,                 -- User Name [UNAME]
    LCHG_DATE_TIME,             -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,                 -- User Name [UNAME]
    PERIOD_START,               -- Start Date [HPA_PERIOD_START_DATE]
    PERIOD_START_TIME,          -- Start Time [HPA_PERIOD_START_TIME]
    PERIOD_DISTANCE,            -- Interval Value [HPA_PERIOD_DISTANCE]
    PERIOD_UNIT,                -- Interval Unit [HPA_PERIOD_UNIT]
    PERIOD_START_TIMESTMP,      -- Start Date [HPA_PERIOD_START_DATE_STMP]
    PERIOD_UNIT_T,              -- Per. Unit Descr [HPA_PERIOD_UNIT_DESCRIPTION]
    ACTUAL_DELIVER_TIMESTMP,    -- Start Date [HPA_PERIOD_START_DATE_STMP]
    _DATAAGING,                 -- Data Aging [DATA_TEMPERATURE]
    CUAN_E_INI_ROOT,            -- Dummy function in length 1 [DUMMY]
    PROCESS_TYPE,               -- Process Type [CUAN_CAMPAIGN_PROCESS_TYPE]
    CHECK_PERMISSION,           -- Check permission [IBC_CF_CHECK_PERMISSION]
    ADV_SCHD_ENABLED,           -- TRUE [BOOLE_D]
    ADV_SCHD_SUNDAY,            -- TRUE [BOOLE_D]
    ADV_SCHD_MONDAY,            -- TRUE [BOOLE_D]
    ADV_SCHD_TUESDAY,           -- TRUE [BOOLE_D]
    ADV_SCHD_WEDNESDAY,         -- TRUE [BOOLE_D]
    ADV_SCHD_THURSDAY,          -- TRUE [BOOLE_D]
    ADV_SCHD_FRIDAY,            -- TRUE [BOOLE_D]
    ADV_SCHD_SATURDAY,          -- TRUE [BOOLE_D]
    ADV_SCHD_TIME_ENABLED,      -- TRUE [BOOLE_D]
    ADV_SCHD_TIME_FROM,         -- Field of type TIMS [TIMS]
    ADV_SCHD_TIME_TO,           -- Field of type TIMS [TIMS]
    ADV_SCHD_END_SCENARIO,      -- End Scenario [CUAN_INITIATIVE_SCHDL_END_SCEN]
    ADV_SCHD_RECURRENCE_COUNT,  -- INT4 [INT4]
    ADV_SCHD_TZONE,             -- Time Zone [TZNZONE]
    CPG_TIMEZONE,               -- Time Zone [TZNZONE]
    STOP_DATE,                  -- Stop Date [CUAN_INITIATIVE_STOP_DATE]
    COMM_AREA_ID,               -- Comm. Area ID [HPA_COMM_AREA_ID]
    REF_ORG_STRUC,              -- Source Organization [HPA_REF_ORG_STRUC]
    IS_AUTO_RESTART_ALLOWED,    -- Is Auto restrt Allw [IBC_CF_IS_AUTO_RESTART_ALLOWED]
    IS_RL_REBUILD_ALLOWED,      -- Is List Rebuild Allw [IBC_CF_IS_RL_REBUILD_ALLOWED]
    ORIGIN,                     -- Communication Flow Origin [IBC_COMM_FLOW_ORIGIN]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More