SOCIALDATA

Transparent Table Application Table
26 Fields 1 CDS Views

Social Data Definition

SOCIALDATA is an SAP database table in S/4HANA. Social Data Definition. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SocialPost view from BASIC View to fetch data from SOCIALDATA

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY socialdatauuid smi_socialdatauuid Social Data ID
socialpost smi_socialpost Social Media Data ID
language smi_language Language Description
socialmediachannel smi_socialmediachannel Channel Code
createdbyuser smi_createdbyuser Created By User ID
creationdatetime smi_creationdatetime Creation Timestamp
socialposttype smi_socialposttype Social Post Type
socialpostlink smi_socialpostlink Social Post Link
numberofpositivevotes smi_numberofpositivevotes Positive Votes Count
locationname smi_locationname Location
countryname smi_countryname Country
longitudemeasure smi_longitudemeasure Longitude
latitudemeasure smi_latitudemeasure Latitude
socialpostactionstatus smi_socialpostactionstatus Post Action Status
socialpostcategory smi_socialpostcategory Post Category
creationusername smi_creationusername Social User Name
socialpostretrivedbyuser smi_socialpostretrievedbyuser Retrieved By User
socialpostsearchtermtext smi_socialpostsearchtermtext Search Term Text
createdat smi_createdat Creation Date-Time
socialposttext smi_socialposttext Social Post Text
creationdatetime_utc smi_creationdatetime_utc Creation Date-Time
socialpostparent smi_socialpost Social Media Data ID
socialpostroot smi_socialpost Social Media Data ID
countrycode land1 Country/Reg.
socialdataretrievalmode smi_socialdataretrievalmode Retrieval Mode

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.

-- Social Data Definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SOCIALDATA (
    CLIENT,                    -- Client [mandt]
    SOCIALDATAUUID,            -- Social Data ID [smi_socialdatauuid]
    SOCIALPOST,                -- Social Media Data ID [smi_socialpost]
    LANGUAGE,                  -- Language Description [smi_language]
    SOCIALMEDIACHANNEL,        -- Channel Code [smi_socialmediachannel]
    CREATEDBYUSER,             -- Created By User ID [smi_createdbyuser]
    CREATIONDATETIME,          -- Creation Timestamp [smi_creationdatetime]
    SOCIALPOSTTYPE,            -- Social Post Type [smi_socialposttype]
    SOCIALPOSTLINK,            -- Social Post Link [smi_socialpostlink]
    NUMBEROFPOSITIVEVOTES,     -- Positive Votes Count [smi_numberofpositivevotes]
    LOCATIONNAME,              -- Location [smi_locationname]
    COUNTRYNAME,               -- Country [smi_countryname]
    LONGITUDEMEASURE,          -- Longitude [smi_longitudemeasure]
    LATITUDEMEASURE,           -- Latitude [smi_latitudemeasure]
    SOCIALPOSTACTIONSTATUS,    -- Post Action Status [smi_socialpostactionstatus]
    SOCIALPOSTCATEGORY,        -- Post Category [smi_socialpostcategory]
    CREATIONUSERNAME,          -- Social User Name [smi_creationusername]
    SOCIALPOSTRETRIVEDBYUSER,  -- Retrieved By User [smi_socialpostretrievedbyuser]
    SOCIALPOSTSEARCHTERMTEXT,  -- Search Term Text [smi_socialpostsearchtermtext]
    CREATEDAT,                 -- Creation Date-Time [smi_createdat]
    SOCIALPOSTTEXT,            -- Social Post Text [smi_socialposttext]
    CREATIONDATETIME_UTC,      -- Creation Date-Time [smi_creationdatetime_utc]
    SOCIALPOSTPARENT,          -- Social Media Data ID [smi_socialpost]
    SOCIALPOSTROOT,            -- Social Media Data ID [smi_socialpost]
    COUNTRYCODE,               -- Country/Reg. [land1]
    SOCIALDATARETRIEVALMODE,   -- Retrieval Mode [smi_socialdataretrievalmode]
    PRIMARY KEY (CLIENT, SOCIALDATAUUID)
);

Learn More