ROOT

60 Fields

ROOT is an SAP database table in S/4HANA. It contains 60 fields.

Fields (60)

KeyField CDS FieldsUsed in Views
KEY agr_name agr_name 3
KEY bname bname 1
KEY CommSyst CommSystID 1
KEY CompanyCode CompanyCode 1
KEY db_key CampaignContentUUID,CommSystDBKey 2
KEY dobj dobj 1
KEY filter filter 1
KEY FinancialTransaction FinancialTransaction 1
KEY id BusinessRoleID,CampaignContent 6
KEY InteractionContact contact_key,InteractionContact 2
KEY uuid BusinessRoleUUID 2
_MKT_Country _MKT_Country 1
_MKT_Industry _MKT_Industry 1
_MKT_Region _MKT_Region 1
_MKT_ValidationStatus _MKT_ValidationStatus 1
_Text _Text 1
AddressRegion AddressRegion 1
appl_name appl_name 1
appl_name_tx appl_name_tx 1
appl_type appl_type 1
appl_type_tx appl_type_tx 1
bname_tx bname_tx 1
brole_group BusinessRoleGroup 1
changed_at changed_at 1
changed_by changed_by 1
CityName CityName 1
class class 1
comm_medium CommunicationMedium 1
CommSystDescription CommSystDescription 1
CommSystHostName CommSystHostName 1
CommSystName CommSystName 1
CorpAcctIsRlvtForAcctBasedMktg CorpAcctIsRlvtForAcctBasedMktg 1
Country Country 1
created_at created_at 1
created_by created_by 1
email_for_send MarketingContentJSONString 1
FullName FullName 1
Industry Industry 1
last_change_user_name LastChangedBy 1
lchg_date_time LastChangeDateTime 1
Log_key log_key 1
Mandt mandt 1
Market Market 1
mkt_area_id MarketingArea 1
name CampaignContentName,name 2
NmbrOfContactsIndustryFilled NmbrOfContactsIndustryFilled 1
NmbrOfContactsMarketIsFilled NmbrOfContactsMarketIsFilled 1
NmbrOfFacetDataCountryFilled NmbrOfFacetDataCountryFilled 1
NmbrOfFacetDataNameFilled NmbrOfFacetDataNameFilled 1
ReferenceObject ReferenceObject 1
RelatObject RelatObject 1
segmentation_profile SegmentationProfile 1
status CampaignContentStatus 1
SyndicatedCounterparty SyndicatedCounterparty 1
TermEndDate TermEndDate 1
TermStartDate TermStartDate 1
total total 1
type CampaignContentType,type 2
Username cuname 1
ValidationStatus ValidationStatus 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ROOT (
    AGR_NAME,
    BNAME,
    COMMSYST,
    COMPANYCODE,
    DB_KEY,
    DOBJ,
    FILTER,
    FINANCIALTRANSACTION,
    ID,
    INTERACTIONCONTACT,
    UUID,
    _MKT_COUNTRY,
    _MKT_INDUSTRY,
    _MKT_REGION,
    _MKT_VALIDATIONSTATUS,
    _TEXT,
    ADDRESSREGION,
    APPL_NAME,
    APPL_NAME_TX,
    APPL_TYPE,
    APPL_TYPE_TX,
    BNAME_TX,
    BROLE_GROUP,
    CHANGED_AT,
    CHANGED_BY,
    CITYNAME,
    CLASS,
    COMM_MEDIUM,
    COMMSYSTDESCRIPTION,
    COMMSYSTHOSTNAME,
    COMMSYSTNAME,
    CORPACCTISRLVTFORACCTBASEDMKTG,
    COUNTRY,
    CREATED_AT,
    CREATED_BY,
    EMAIL_FOR_SEND,
    FULLNAME,
    INDUSTRY,
    LAST_CHANGE_USER_NAME,
    LCHG_DATE_TIME,
    LOG_KEY,
    MANDT,
    MARKET,
    MKT_AREA_ID,
    NAME,
    NMBROFCONTACTSINDUSTRYFILLED,
    NMBROFCONTACTSMARKETISFILLED,
    NMBROFFACETDATACOUNTRYFILLED,
    NMBROFFACETDATANAMEFILLED,
    REFERENCEOBJECT,
    RELATOBJECT,
    SEGMENTATION_PROFILE,
    STATUS,
    SYNDICATEDCOUNTERPARTY,
    TERMENDDATE,
    TERMSTARTDATE,
    TOTAL,
    TYPE,
    USERNAME,
    VALIDATIONSTATUS,
    PRIMARY KEY (AGR_NAME, BNAME, COMMSYST, COMPANYCODE, DB_KEY, DOBJ, FILTER, FINANCIALTRANSACTION, ID, INTERACTIONCONTACT, UUID)
);

Learn More