USING_ROOT

28 Fields

USING_ROOT is an SAP database table in S/4HANA. It contains 28 fields.

Fields (28)

KeyField CDS FieldsUsed in Views
KEY CommunicationMessage CampaignContent 1
KEY id CampaignContent,CommunicationMessage 3
category CommunicationMessageCategory,MarketingContentCategory 2
comm_area_id CommunicationArea 2
comm_medium CommunicationMedium 2
CommMessageContentType InternalCampaignContentType 1
CommMessageIsMessageTemplate MktgAstIsCmpgnCntntTmpl 1
CommMessageJSONVersionString MktgCntntRevisionJSONVersStr 1
CommMsgLastChangedDateTime LastChangeDateTime 1
CommunicationArea CommunicationArea 1
CommunicationMedium CommunicationMedium 1
CommunicationMessageCategory MarketingContentCategory 1
CommunicationMessageJSONString MktgContentRevisionJSONString 1
CommunicationMessageLanguage CampaignContentDefaultLanguage 1
CommunicationMessageName CampaignContentName 1
CommunicationMessageUUID CampaignContentUUID 1
db_key CampaignContentUUID,CommunicationMessageUUID 2
email_for_send CommunicationMessageJSONString,MktgContentRevisionJSONString 2
email_for_send_version CommMessageJSONVersionString,MktgCntntRevisionJSONVersStr 2
is_template CommMessageIsMessageTemplate,MktgAstIsCmpgnCntntTmpl 2
language CampaignContentDefaultLanguage,CommMessageDefaultLanguage 2
lchg_date_time CommMsgLastChangedDateTime,LastChangeDateTime 2
name CampaignContentName 1
ref_org_struc ReferencedOrgStructure 2
ReferencedOrgStructure ReferencedOrgStructure 1
segmentation_profile SegmentationProfile 2
SegmentationProfile SegmentationProfile 1
type CommMessageContentType,InternalCampaignContentType 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USING_ROOT (
    COMMUNICATIONMESSAGE,
    ID,
    CATEGORY,
    COMM_AREA_ID,
    COMM_MEDIUM,
    COMMMESSAGECONTENTTYPE,
    COMMMESSAGEISMESSAGETEMPLATE,
    COMMMESSAGEJSONVERSIONSTRING,
    COMMMSGLASTCHANGEDDATETIME,
    COMMUNICATIONAREA,
    COMMUNICATIONMEDIUM,
    COMMUNICATIONMESSAGECATEGORY,
    COMMUNICATIONMESSAGEJSONSTRING,
    COMMUNICATIONMESSAGELANGUAGE,
    COMMUNICATIONMESSAGENAME,
    COMMUNICATIONMESSAGEUUID,
    DB_KEY,
    EMAIL_FOR_SEND,
    EMAIL_FOR_SEND_VERSION,
    IS_TEMPLATE,
    LANGUAGE,
    LCHG_DATE_TIME,
    NAME,
    REF_ORG_STRUC,
    REFERENCEDORGSTRUCTURE,
    SEGMENTATION_PROFILE,
    SEGMENTATIONPROFILE,
    TYPE,
    PRIMARY KEY (COMMUNICATIONMESSAGE, ID)
);

Learn More